DBA Data[Home] [Help]

APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on WF_DIRECTORY

Line 181: WF_DIRECTORY.GetRoleInfo(v_submitter.user_name,

177: IF (l_submitter_role_users IS NOT NULL) THEN
178: l_submitter_role_users := l_submitter_role_users||',';
179: END IF;
180:
181: WF_DIRECTORY.GetRoleInfo(v_submitter.user_name,
182: display_name,
183: email_address,
184: notification_preference,
185: language,

Line 189: WF_DIRECTORY.CreateAdHocUser(name => v_submitter.user_name

185: language,
186: territory);
187: IF display_name is NULL then
188:
189: WF_DIRECTORY.CreateAdHocUser(name => v_submitter.user_name
190: ,display_name => v_submitter.person_name
191: ,email_address => v_submitter.email_address);
192: END IF;
193: -- Bug 6826760

Line 199: WF_DIRECTORY.CreateAdHocRole(role_name => l_submitter_role

195: l_submitter_name := v_submitter.person_name; -- Added for bug# 7368606
196:
197: END LOOP;
198:
199: WF_DIRECTORY.CreateAdHocRole(role_name => l_submitter_role
200: ,role_display_name => l_submitter_name -- added for Bug: 4537865
201: ,expiration_date => sysdate+15); -- Set an expiration date for bug#5962410
202: -- added for Bug: 4537865
203: l_submitter_role := l_new_submitter_role;

Line 207: wf_directory.addUsersToAdHocRole(l_submitter_role,

203: l_submitter_role := l_new_submitter_role;
204: -- added for Bug: 4537865
205:
206: IF (l_submitter_role_users IS NOT NULL) THEN
207: wf_directory.addUsersToAdHocRole(l_submitter_role,
208: l_submitter_role_users);
209: wf_engine.setItemAttrText(p_item_type
210: ,p_item_key
211: ,'WORKPLAN_SUBMITTER'

Line 376: wf_directory.CreateAdHocRole(role_name => l_approval_role

372: l_approval_role := 'APVR_'||p_item_type||p_item_key;
373:
374: /* Create role */
375: /* Commented the following call to CreateAdHocRole and moved down with modifications for bug# 3732090
376: wf_directory.CreateAdHocRole(role_name => l_approval_role
377: ,role_display_name => l_approval_role
378: ,expiration_date => NULL);
379: */
380:

Line 398: WF_DIRECTORY.GetRoleInfo(v_approvers.user_name,

394: For v_approvers in getProjectManagerHR LOOP
395: IF (l_approval_role_users IS NOT NULL) THEN
396: l_approval_role_users := l_approval_role_users || ',';
397: END IF;
398: WF_DIRECTORY.GetRoleInfo(v_approvers.user_name,
399: display_name,
400: email_address,
401: notification_preference,
402: language,

Line 406: WF_DIRECTORY.createAdHocUser(name => v_approvers.user_name

402: language,
403: territory);
404: IF display_name is NULL THEN
405: --Add user to directory
406: WF_DIRECTORY.createAdHocUser(name => v_approvers.user_name
407: ,display_name => v_approvers.person_name
408: ,email_address => v_approvers.email_address);
409: END IF;
410: l_approval_role_users := l_approval_role_users ||v_approvers.user_name;

Line 423: WF_DIRECTORY.GetRoleInfo(v_approvers.user_name,

419: FOR v_approvers IN l_approver_csr_person LOOP
420: IF (l_approval_role_users IS NOT NULL) THEN
421: l_approval_role_users := l_approval_role_users || ',';
422: END IF;
423: WF_DIRECTORY.GetRoleInfo(v_approvers.user_name,
424: display_name,
425: email_address,
426: notification_preference,
427: language,

Line 432: WF_DIRECTORY.createAdHocUser(name => v_approvers.user_name

428: territory);
429:
430: IF display_name IS NULL THEN
431: --Add user to directory
432: WF_DIRECTORY.createAdHocUser(name => v_approvers.user_name
433: ,display_name => v_approvers.person_name
434: ,email_address => v_approvers.email_address);
435: END IF;
436: l_approval_role_users := l_approval_role_users ||v_approvers.user_name;

Line 444: WF_DIRECTORY.GetRoleInfo(v_approvers.user_name,

440: FOR v_approvers IN l_approver_csr_party LOOP
441: IF (l_approval_role_users IS NOT NULL) THEN
442: l_approval_role_users := l_approval_role_users || ',';
443: END IF;
444: WF_DIRECTORY.GetRoleInfo(v_approvers.user_name,
445: display_name,
446: email_address,
447: notification_preference,
448: language,

Line 452: WF_DIRECTORY.createAdHocUser(name => v_approvers.user_name

448: language,
449: territory);
450: IF display_name IS NULL THEN
451: --Add user to directory
452: WF_DIRECTORY.createAdHocUser(name => v_approvers.user_name
453: ,display_name => v_approvers.person_name
454: ,email_address => v_approvers.email_address);
455: END IF;
456: l_approval_role_users := l_approval_role_users ||v_approvers.user_name;

Line 462: wf_directory.CreateAdHocRole(role_name => l_approval_role

458: END IF;
459: END IF;
460: CLOSE getApprover;
461: /* Added the following call to CreateAdHocRole for bug# 3732090 */
462: wf_directory.CreateAdHocRole(role_name => l_approval_role
463: ,role_display_name => l_approver_name -- Modifed the parameter from l_approval_role to l_approver_name bug#3732090
464: ,expiration_date => sysdate+15); -- Set an expiration date for bug#5962410
465:
466: /* wf_engine.SetItemAttrText

Line 475: WF_DIRECTORY.ADDUSERSTOADHOCROLE(l_approval_role,

471:
472:
473: IF (l_approval_role_users IS NOT NULL) THEN
474: --Add the selected user(s) to the role
475: WF_DIRECTORY.ADDUSERSTOADHOCROLE(l_approval_role,
476: l_approval_role_users);
477: WF_engine.setItemAttrText(p_item_type,
478: p_item_key,
479: 'WORKPLAN_APPROVER',

Line 796: WF_DIRECTORY.CREATEADHOCROLE(role_name => l_appr_rej_role

792: itemkey => p_item_key,
793: aname => 'STRUCTURE_VER_ID');
794:
795: l_appr_rej_role := 'APRJ_'||p_item_type||p_item_key;
796: WF_DIRECTORY.CREATEADHOCROLE(role_name => l_appr_rej_role
797: ,role_display_name => l_appr_rej_role
798: ,expiration_date => sysdate+15); -- Set an expiration date for bug#5962410
799:
800: --For approved_rejected_receiver

Line 808: WF_DIRECTORY.GetRoleInfo(v_appr_rej.user_name,

804: FOR v_appr_rej IN getApprovedRejectedPerson LOOP
805: IF (l_appr_rej_role_usr IS NOT NULL) THEN
806: l_appr_rej_role_usr := l_appr_rej_role_usr||',';
807: END IF;
808: WF_DIRECTORY.GetRoleInfo(v_appr_rej.user_name,
809: display_name,
810: email_address,
811: notification_preference,
812: language,

Line 817: wf_directory.createadhocuser( name => v_appr_rej.user_name

813: territory);
814:
815: IF display_name IS NULL THEN
816: --Add user to directory
817: wf_directory.createadhocuser( name => v_appr_rej.user_name
818: ,display_name => v_appr_rej.person_name
819: ,email_address => v_appr_rej.email_address);
820: END IF;
821: l_appr_rej_role_usr := l_appr_rej_role_usr||v_appr_rej.user_name;

Line 829: WF_DIRECTORY.GetRoleInfo(v_appr_rej.user_name,

825: FOR v_appr_rej IN getApprovedRejectedParty LOOP
826: IF (l_appr_rej_role_usr IS NOT NULL) THEN
827: l_appr_rej_role_usr := l_appr_rej_role_usr||',';
828: END IF;
829: WF_DIRECTORY.GetRoleInfo(v_appr_rej.user_name,
830: display_name,
831: email_address,
832: notification_preference,
833: language,

Line 838: wf_directory.createadhocuser( name => v_appr_rej.user_name

834: territory);
835:
836: IF display_name IS NULL THEN
837: --Add user to directory
838: wf_directory.createadhocuser( name => v_appr_rej.user_name
839: ,display_name => v_appr_rej.person_name
840: ,email_address => v_appr_rej.email_address);
841: END IF;
842: l_appr_rej_role_usr := l_appr_rej_role_usr||v_appr_rej.user_name;

Line 847: wf_directory.adduserstoadhocRole(l_appr_rej_role

843: END LOOP;
844:
845: IF (l_appr_rej_role_usr IS NOT NULL) THEN
846: --Add the selected user(s) to the role
847: wf_directory.adduserstoadhocRole(l_appr_rej_role
848: ,l_appr_rej_role_usr);
849: wf_engine.setitemattrtext(p_item_type
850: ,p_item_key
851: ,'APPROVED_REJECTED_RECEIVER'

Line 858: WF_DIRECTORY.CREATEADHOCROLE(role_name => l_wp_viewer_role

854:
855: --For workplan_viewer
856: --Get internal user
857: l_wp_viewer_role := 'WPVR_'||p_item_type||p_item_key;
858: WF_DIRECTORY.CREATEADHOCROLE(role_name => l_wp_viewer_role
859: ,role_display_name => l_wp_viewer_role
860: ,expiration_date => sysdate+15); -- Set an expiration date for bug#5962410
861:
862: l_wp_viewer_role_usr := NULL;

Line 867: WF_DIRECTORY.GetRoleInfo(v_wp_vr.user_name,

863: FOR v_wp_vr IN getWorkplanViewerPerson LOOP
864: IF (l_wp_viewer_role_usr IS NOT NULL) THEN
865: l_wp_viewer_role_usr := l_wp_viewer_role_usr||',';
866: END IF;
867: WF_DIRECTORY.GetRoleInfo(v_wp_vr.user_name,
868: display_name,
869: email_address,
870: notification_preference,
871: language,

Line 876: wf_directory.createadhocuser( name => v_wp_vr.user_name

872: territory);
873:
874: IF display_name IS NULL THEN
875: --Add user to directory
876: wf_directory.createadhocuser( name => v_wp_vr.user_name
877: ,display_name => v_wp_vr.person_name
878: ,email_address => v_wp_vr.email_address);
879: END IF;
880: l_wp_viewer_role_usr := l_wp_viewer_role_usr||v_wp_vr.user_name;

Line 888: WF_DIRECTORY.GetRoleInfo(v_wp_vr.user_name,

884: FOR v_wp_vr IN getWorkplanViewerParty LOOP
885: IF (l_wp_viewer_role_usr IS NOT NULL) THEN
886: l_wp_viewer_role_usr := l_wp_viewer_role_usr||',';
887: END IF;
888: WF_DIRECTORY.GetRoleInfo(v_wp_vr.user_name,
889: display_name,
890: email_address,
891: notification_preference,
892: language,

Line 897: wf_directory.createadhocuser( name => v_wp_vr.user_name

893: territory);
894:
895: IF display_name IS NULL THEN
896: --Add user to directory
897: wf_directory.createadhocuser( name => v_wp_vr.user_name
898: ,display_name => v_wp_vr.person_name
899: ,email_address => v_wp_vr.email_address);
900: END IF;
901: l_wp_viewer_role_usr := l_wp_viewer_role_usr||v_wp_vr.user_name;

Line 906: wf_directory.adduserstoadhocRole(l_wp_viewer_role

902: END LOOP;
903:
904: IF (l_wp_viewer_role_usr IS NOT NULL) THEN
905: --Add the selected user(s) to the role
906: wf_directory.adduserstoadhocRole(l_wp_viewer_role
907: ,l_wp_viewer_role_usr);
908: wf_engine.setitemattrtext(p_item_type
909: ,p_item_key
910: ,'WORKPLAN_VIEWER'