DISABLE_USER_STYLE Procedure

57.3 DISABLE_USER_STYLE Procedure

This procedure disables theme style selection by end users. End users will not be able to customize the theme style on their own. Note that this only affects the Customization link for end users. APEX_THEME API calls are independent.

Syntax

APEX_THEME.DISABLE_USER_STYLE (
    p_application_id  IN NUMBER           DEFAULT {current application id}, 
    p_theme_number    IN NUMBER           DEFAULT {current theme number} 
);

Parameters

Parameter	Description
`p_application_id`	The application ID. Default is the current application.
`p_theme_number`	Number of user interface's Current Theme.

The following query disables end user theme style selection for application 100.

DECLARE
    l_theme_id apex_themes.theme_number%type;
BEGIN
    SELECT theme_number
      INTO l_theme_id
      FROM apex_applications
     WHERE application_id = 100;

    apex_theme.disable_user_style(
        p_application_id => 100,
        p_theme_number   => l_theme_id
    );
END;