| get_manager function

Related topics
Contained in package wwsec_api. Call this function to return the user name of a specified user's manager. If there is no manager, this function returns null. function get_manager ( p_user_name in varchar2 ) return varchar2;

Version: Oracle Portal 3.0.6.6.5 or later
Parameters:
p_user_name | The name of the user whose manager is being queried. Datatype: in varchar2
Returns: This function returns the manager's user name for the specified user, or null if the user has no manager. Exceptions: If the person_id specified for the p_user_name parameter is not found, a USER_NOT_FOUND_EXCEPTION is raised. Example: l_manager wwsec_person.user_name%type; l_manager := wwsec_api.get_manager ( p_user_name => 'user1’ );

Related topics
Security API packages | PDK PL/SQL API Reference - Home

Back to top
The PL/SQL API Reference is part of the Portal Developer Kit on Portal Studio