[Home] [Help]
2201: --dbms_output.put_line('l_resource_person_id :' || l_resource_person_id);
2202:
2203: -- get the resource's name
2204: IF l_resource_person_id IS NOT NULL THEN
2205: wf_directory.getusername
2206: (p_orig_system => 'PER',
2207: p_orig_system_id => l_resource_person_id,
2208: p_name => l_resource_user_name,
2209: p_display_name => l_resource_display_name);
2240: --dbms_output.put_line('l_return_status :' || l_return_status);
2241:
2242: -- Now get the resource's manager name. -- bug 7623859
2243: IF l_res_manager_id IS NOT NULL THEN
2244: wf_directory.getusername
2245: (p_orig_system => 'PER',
2246: p_orig_system_id => l_res_manager_id,
2247: p_name => l_res_manager_user_name,
2248: p_display_name => l_res_manager_display_name);
2269: -- as resource_manager
2270: IF l_primarycontactid IS NOT NULL AND
2271: l_primarycontactid <> l_resource_rec.manager_id AND
2272: l_primarycontactid <> l_resource_person_id THEN --Added for Bug 3959762
2273: wf_directory.getusername
2274: (p_orig_system => 'PER',
2275: p_orig_system_id => l_primarycontactid,
2276: p_name => l_primarycontact_user_name,
2277: p_display_name => l_primarycontact_display_name);
2304: IF l_staff_owner_person_id_tbl.COUNT > 0 THEN
2305:
2306: FOR i in 1..l_staff_owner_person_id_tbl.COUNT LOOP
2307:
2308: wf_directory.getusername
2309: (p_orig_system => 'PER',
2310: p_orig_system_id => l_staff_owner_person_id_tbl(i),
2311: p_name => l_staff_owner_user_name,
2312: p_display_name => l_staff_owner_display_name);
2385:
2386: -- Create an ad hoc role and assign the users, which has been populated with recipients list,
2387: -- to this role.
2388: --dbms_output.put_line('l_role_users: ' || l_role_users);
2389: WF_DIRECTORY.CreateAdHocRole
2390: (role_users => l_role_users
2391: ,role_name => l_role_name
2392: ,role_display_name => l_role_display_name
2393: ,expiration_date => sysdate+1); -- Expiration_date set for bug#5962410
3261: IS
3262:
3263: l_number_of_nf_rects NUMBER := 0;
3264: l_nf_loop_counter NUMBER := 0;
3265: user_table Wf_Directory.UserTable;
3266: l_role_name VARCHAR2(320);
3267: l_role_name_temp VARCHAR2(320);
3268:
3269: BEGIN
3314: RETURN;
3315: END IF;
3316:
3317: -- Get all users attached to Adhoc role
3318: WF_DIRECTORY.GETROLEUSERS(l_role_name, user_table);
3319:
3320: -- Get PER role for the 'nth' user from WF_USER_ROLES
3321: SELECT ROLE_NAME
3322: INTO l_role_name_temp