ENABLE_USER_STYLE Procedure

This procedure enables theme style selection by end users. When enabled and there is at least one theme style marked as Public, end users will see a Customize link which allows to choose the theme style. End user theme style selection is enabled or disabled at the User Interface level. When providing a theme number, the theme must be the Current Theme for a user interface. Note that this only affects the Customization link for end users. APEX_THEME API calls are independent.

Syntax

APEX_THEME.ENABLE_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 example enables 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.enable_user_style(
        p_application_id => 100,
        p_theme_number   => l_theme_id
    );
END;