CLEAR_USER_STYLE Procedure

This procedure clears the theme style user preference for user and application.

Syntax

procedure clear_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} 
);

Parameters

Table 33-2 CLEAR_USER_STYLE Procedure

Parameter	Description
p_theme_number	The theme number to clear the theme style user preference.

Example

The following example clears the theme style user preference for the ADMIN user in application 100 and theme 42.

apex_theme.clear_user_style(
    p_application_id => 100,
    p_user           => 'ADMIN',
    p_theme_number   => 42
);