SET_CURRENT_STYLE Procedure

This procedure sets current theme style for the current application.

Note:

This is a persistent change. The "Modify this Application" setting has to be activated in Shared Components, Security, Runtime API usage.

Syntax

APEX_THEME.SET_CURRENT_STYLE (
    p_application_id IN NUMBER DEFAULT {current application ID},
    p_theme_number   IN NUMBER,
    p_id             IN VARCHAR2 );

Parameters

Parameter	Description
`p_application_id`	The application ID. Default current application.
`p_theme_number`	The theme number for which to set the default style.
`p_id`	The ID of the theme style to set as a user preference.

Examples

The following example gets available theme styles from APEX Dictionary View.

select s.theme_style_id,
       t.theme_number
  from apex_application_theme_styles s,
       apex_application_themes t
 where s.application_id = :APP_ID
   and s.is_current     = 'Yes'
   and t.application_id = s.application_id
   and t.theme_number   = s.theme_number

The following example sets the current theme style to one of values returned by the above query.

apex_theme.set_current_style (
     p_theme_number => {query.theme_number},
     p_id => {query.theme_style_id}
);