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

procedure disable_user_style(
    p_application_id  IN NUMBER           DEFAULT {current application id}, 
    p_theme_number    IN NUMBER           DEFAULT {current theme number} 
);

Parameters

Table 33-3 DISABLE_USER_STYLE Procedure

Parameter Description

p_application_id

The Application ID.

p_theme_number

Number of User Interface's Current Theme.

The following example disable end user theme style selection for the Desktop user interface of application 100.

declare
  l_theme_id apex_themes.theme_number%type;
begin
select theme_number into l_theme_id
  from apex_appl_user_interfaces
where application_id = 100
  and display_name   = 'Desktop';

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