DBA Data[Home] [Help]

APPS.PA_WORKPLAN_WORKFLOW_CLIENT dependencies on WF_DIRECTORY

Line 171: WF_DIRECTORY.CreateAdHocRole(role_name => l_submitter_role

167:
168: -- Bug 6826760 (Initialize l_new_submitter_role)
169: l_new_submitter_role := l_submitter_role;
170:
171: WF_DIRECTORY.CreateAdHocRole(role_name => l_submitter_role
172: --,role_display_name => l_submitter_role * commented for Bug Fix: 4537865
173: ,role_display_name => l_new_submitter_role -- added for Bug: 4537865
174: ,expiration_date => sysdate+1); -- Set an expiration date for bug#5962410
175: -- added for Bug: 4537865

Line 185: WF_DIRECTORY.GetRoleInfo(v_submitter.user_name,

181: IF (l_submitter_role_users IS NOT NULL) THEN
182: l_submitter_role_users := l_submitter_role_users||',';
183: END IF;
184:
185: WF_DIRECTORY.GetRoleInfo(v_submitter.user_name,
186: display_name,
187: email_address,
188: notification_preference,
189: language,

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

189: language,
190: territory);
191: IF display_name is NULL then
192:
193: WF_DIRECTORY.CreateAdHocUser(name => v_submitter.user_name
194: ,display_name => v_submitter.person_name
195: ,email_address => v_submitter.email_address);
196: END IF;
197: -- Bug 6826760

Line 203: wf_directory.addUsersToAdHocRole(l_submitter_role,

199:
200: END LOOP;
201:
202: IF (l_submitter_role_users IS NOT NULL) THEN
203: wf_directory.addUsersToAdHocRole(l_submitter_role,
204: l_submitter_role_users);
205: wf_engine.setItemAttrText(p_item_type
206: ,p_item_key
207: ,'WORKPLAN_SUBMITTER'

Line 365: wf_directory.CreateAdHocRole(role_name => l_approval_role

361: l_approval_role := 'APVR_'||p_item_type||p_item_key;
362:
363: /* Create role */
364: /* Commented the following call to CreateAdHocRole and moved down with modifications for bug# 3732090
365: wf_directory.CreateAdHocRole(role_name => l_approval_role
366: ,role_display_name => l_approval_role
367: ,expiration_date => NULL);
368: */
369:

Line 387: WF_DIRECTORY.GetRoleInfo(v_approvers.user_name,

383: For v_approvers in getProjectManagerHR LOOP
384: IF (l_approval_role_users IS NOT NULL) THEN
385: l_approval_role_users := l_approval_role_users || ',';
386: END IF;
387: WF_DIRECTORY.GetRoleInfo(v_approvers.user_name,
388: display_name,
389: email_address,
390: notification_preference,
391: language,

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

391: language,
392: territory);
393: IF display_name is NULL THEN
394: --Add user to directory
395: WF_DIRECTORY.createAdHocUser(name => v_approvers.user_name
396: ,display_name => v_approvers.person_name
397: ,email_address => v_approvers.email_address);
398: END IF;
399: l_approval_role_users := l_approval_role_users ||v_approvers.user_name;

Line 412: WF_DIRECTORY.GetRoleInfo(v_approvers.user_name,

408: FOR v_approvers IN l_approver_csr_person LOOP
409: IF (l_approval_role_users IS NOT NULL) THEN
410: l_approval_role_users := l_approval_role_users || ',';
411: END IF;
412: WF_DIRECTORY.GetRoleInfo(v_approvers.user_name,
413: display_name,
414: email_address,
415: notification_preference,
416: language,

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

417: territory);
418:
419: IF display_name IS NULL THEN
420: --Add user to directory
421: WF_DIRECTORY.createAdHocUser(name => v_approvers.user_name
422: ,display_name => v_approvers.person_name
423: ,email_address => v_approvers.email_address);
424: END IF;
425: l_approval_role_users := l_approval_role_users ||v_approvers.user_name;

Line 433: WF_DIRECTORY.GetRoleInfo(v_approvers.user_name,

429: FOR v_approvers IN l_approver_csr_party LOOP
430: IF (l_approval_role_users IS NOT NULL) THEN
431: l_approval_role_users := l_approval_role_users || ',';
432: END IF;
433: WF_DIRECTORY.GetRoleInfo(v_approvers.user_name,
434: display_name,
435: email_address,
436: notification_preference,
437: language,

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

437: language,
438: territory);
439: IF display_name IS NULL THEN
440: --Add user to directory
441: WF_DIRECTORY.createAdHocUser(name => v_approvers.user_name
442: ,display_name => v_approvers.person_name
443: ,email_address => v_approvers.email_address);
444: END IF;
445: l_approval_role_users := l_approval_role_users ||v_approvers.user_name;

Line 451: wf_directory.CreateAdHocRole(role_name => l_approval_role

447: END IF;
448: END IF;
449: CLOSE getApprover;
450: /* Added the following call to CreateAdHocRole for bug# 3732090 */
451: wf_directory.CreateAdHocRole(role_name => l_approval_role
452: ,role_display_name => l_approver_name -- Modifed the parameter from l_approval_role to l_approver_name bug#3732090
453: ,expiration_date => sysdate+1); -- Set an expiration date for bug#5962410
454:
455: IF (l_approval_role_users IS NOT NULL) THEN

Line 457: WF_DIRECTORY.ADDUSERSTOADHOCROLE(l_approval_role,

453: ,expiration_date => sysdate+1); -- Set an expiration date for bug#5962410
454:
455: IF (l_approval_role_users IS NOT NULL) THEN
456: --Add the selected user(s) to the role
457: WF_DIRECTORY.ADDUSERSTOADHOCROLE(l_approval_role,
458: l_approval_role_users);
459: WF_engine.setItemAttrText(p_item_type,
460: p_item_key,
461: 'WORKPLAN_APPROVER',

Line 778: WF_DIRECTORY.CREATEADHOCROLE(role_name => l_appr_rej_role

774: itemkey => p_item_key,
775: aname => 'STRUCTURE_VER_ID');
776:
777: l_appr_rej_role := 'APRJ_'||p_item_type||p_item_key;
778: WF_DIRECTORY.CREATEADHOCROLE(role_name => l_appr_rej_role
779: ,role_display_name => l_appr_rej_role
780: ,expiration_date => sysdate+1); -- Set an expiration date for bug#5962410
781:
782: --For approved_rejected_receiver

Line 790: WF_DIRECTORY.GetRoleInfo(v_appr_rej.user_name,

786: FOR v_appr_rej IN getApprovedRejectedPerson LOOP
787: IF (l_appr_rej_role_usr IS NOT NULL) THEN
788: l_appr_rej_role_usr := l_appr_rej_role_usr||',';
789: END IF;
790: WF_DIRECTORY.GetRoleInfo(v_appr_rej.user_name,
791: display_name,
792: email_address,
793: notification_preference,
794: language,

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

795: territory);
796:
797: IF display_name IS NULL THEN
798: --Add user to directory
799: wf_directory.createadhocuser( name => v_appr_rej.user_name
800: ,display_name => v_appr_rej.person_name
801: ,email_address => v_appr_rej.email_address);
802: END IF;
803: l_appr_rej_role_usr := l_appr_rej_role_usr||v_appr_rej.user_name;

Line 811: WF_DIRECTORY.GetRoleInfo(v_appr_rej.user_name,

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

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

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

Line 829: wf_directory.adduserstoadhocRole(l_appr_rej_role

825: END LOOP;
826:
827: IF (l_appr_rej_role_usr IS NOT NULL) THEN
828: --Add the selected user(s) to the role
829: wf_directory.adduserstoadhocRole(l_appr_rej_role
830: ,l_appr_rej_role_usr);
831: wf_engine.setitemattrtext(p_item_type
832: ,p_item_key
833: ,'APPROVED_REJECTED_RECEIVER'

Line 840: WF_DIRECTORY.CREATEADHOCROLE(role_name => l_wp_viewer_role

836:
837: --For workplan_viewer
838: --Get internal user
839: l_wp_viewer_role := 'WPVR_'||p_item_type||p_item_key;
840: WF_DIRECTORY.CREATEADHOCROLE(role_name => l_wp_viewer_role
841: ,role_display_name => l_wp_viewer_role
842: ,expiration_date => sysdate+1); -- Set an expiration date for bug#5962410
843:
844: l_wp_viewer_role_usr := NULL;

Line 849: WF_DIRECTORY.GetRoleInfo(v_wp_vr.user_name,

845: FOR v_wp_vr IN getWorkplanViewerPerson LOOP
846: IF (l_wp_viewer_role_usr IS NOT NULL) THEN
847: l_wp_viewer_role_usr := l_wp_viewer_role_usr||',';
848: END IF;
849: WF_DIRECTORY.GetRoleInfo(v_wp_vr.user_name,
850: display_name,
851: email_address,
852: notification_preference,
853: language,

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

854: territory);
855:
856: IF display_name IS NULL THEN
857: --Add user to directory
858: wf_directory.createadhocuser( name => v_wp_vr.user_name
859: ,display_name => v_wp_vr.person_name
860: ,email_address => v_wp_vr.email_address);
861: END IF;
862: l_wp_viewer_role_usr := l_wp_viewer_role_usr||v_wp_vr.user_name;

Line 870: WF_DIRECTORY.GetRoleInfo(v_wp_vr.user_name,

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

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

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

Line 888: wf_directory.adduserstoadhocRole(l_wp_viewer_role

884: END LOOP;
885:
886: IF (l_wp_viewer_role_usr IS NOT NULL) THEN
887: --Add the selected user(s) to the role
888: wf_directory.adduserstoadhocRole(l_wp_viewer_role
889: ,l_wp_viewer_role_usr);
890: wf_engine.setitemattrtext(p_item_type
891: ,p_item_key
892: ,'WORKPLAN_VIEWER'