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’

);

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