SET_SESSION_STYLE_CSS Procedure

This procedure sets the theme style CSS urls dynamically for the current session. Theme style CSS URLs are being directly passed in; a persistent style definition is not needed. This is typically being called after successful authentication.

Syntax

procedure set_session_style_css (
    p_theme_number  IN NUMBER           DEFAULT {current theme number},
    p_css_file_urls IN VARCHAR2 
);

Parameters

Table 33-8 SET_SESSION_STYLE_CSS Procedure

Parameter	Description
p_theme_number	The theme number to set the session style.
p_css_urls	The URLs to CSS files with style directives.

Example

The following example gets available theme styles from Application Express Dictionary View for the DESKTOP user interface.

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

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

apex_theme.set_session_style_css(
    p_theme_number => {query.theme_number},
    p_css_urls => {URLs to theme style CSS files}
);