Call the following API to retrieve user preference information. The API is defined in the PL/SQL package called WF_PREF.
function get_pref (p_user_name in varchar2, p_preference_name in varchar2) return varchar2;
Retrieves the value of the specified preference for the specified user.
| p_user_name | The internal name of the user. To retrieve the value for a global preference, specify the user as -WF_DEFAULT-. |
| p_preference_name | The name of the user preference whose value you wish to retrieve. Valid preference names are:
|