913: aname => 'REQUESTER_USER_NAME');
914:
915:
916: --bug 7524239 check to see if the user is active in wf_roles
917: --bug 14083201 using wf_directory.userActive instead of
918: --WF_DIRECTORY.IsPerformer
919: l_wf_roles := wf_directory.UserActive(l_requester_user_name);
920:
921: if not l_wf_roles then
914:
915:
916: --bug 7524239 check to see if the user is active in wf_roles
917: --bug 14083201 using wf_directory.userActive instead of
918: --WF_DIRECTORY.IsPerformer
919: l_wf_roles := wf_directory.UserActive(l_requester_user_name);
920:
921: if not l_wf_roles then
922: Open c_wf_adhoc_role(l_requester_user_name);
915:
916: --bug 7524239 check to see if the user is active in wf_roles
917: --bug 14083201 using wf_directory.userActive instead of
918: --WF_DIRECTORY.IsPerformer
919: l_wf_roles := wf_directory.UserActive(l_requester_user_name);
920:
921: if not l_wf_roles then
922: Open c_wf_adhoc_role(l_requester_user_name);
923: Fetch c_wf_adhoc_role into l_adhoc_role;