GET_USER_STYLE Function

56.5 GET_USER_STYLE Function

This function returns the theme style user preference for the user and application. If no user preference is present, it returns NULL.

Syntax

APEX_THEME.GET_USER_STYLE (
  p_application_id  IN NUMBER   DEFAULT {current application id},
  p_user            IN VARCHAR2 DEFAULT {current user},
  p_theme_number    IN NUMBER   DEFAULT {current theme number} )
RETURN NUMBER;

Parameters

Parameter	Description
`p_application_id`	The application to set the user style preference.
`p_user`	The user name to the user style preference.
`p_theme_number`	The theme number to set the session style.
`RETURN`	The theme style ID which is set as a user preference.

Example

The query returns the theme style user preference for the ADMIN user in application 100 and theme 42.

select apex_theme.get_user_style( 100, 'ADMIN', 42 ) from dual;

Parent topic: APEX_THEME