[Home] [Help]
36: get_notification_list, is_user_valid and get_name.
37: 27/08/04 sanantha Bug 3787169. call the api modify_wf_clob_content
38: before passing the clob to workflow
39: 24-09-04 rasinha Bug 3877985. Modified the file update the who columns in the procedure
40: CLOSE_CI_ACTION and KEEP_OPEN with action assignee and not by fnd_global.user_id.
41: 01-12-04 sukhanna Bug 3974641. Replacing PA_CI_CI_REVIEW_LAYOUT AK region name with the xml file name CiCiReviewPG.
42: 10-Dec-04 rasinha Bug 4049901. Modified the procedure to set the role_display_name for
43: Action Assignee notification to the full name of the action assignee.
44: 03-Aug-05 raluthra Bug 4527617. Replaced the usage of fnd_user.
78: d) Closure comments should bot be added
79: 21-Mar-2012 SVMOHAMM Bug#13683760 Added changes for approval process modification.
80: =============================================================================*/
81:
82: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
83:
84:
85: /********************************************************************
86: * Procedure : start_workflow
581: , itemkey
582: , 'CI_APPROVER_NAME');
583:
584: -- Added for Bug 6053648
585: l_user_id := fnd_global.user_id;
586: -- If approved via E-Mail we need to set the application context explicitly
587: if (l_user_id is null or
588: l_user_id = 0 or
589: l_user_id = -1) then
590: begin
591: open c_user_id(l_name);
592: fetch c_user_id into l_user_id;
593: close c_user_id;
594: fnd_global.apps_initialize(
595: user_id=>l_user_id,
596: resp_id=>fnd_global.resp_id,
597: resp_appl_id=>275);
598: end;
592: fetch c_user_id into l_user_id;
593: close c_user_id;
594: fnd_global.apps_initialize(
595: user_id=>l_user_id,
596: resp_id=>fnd_global.resp_id,
597: resp_appl_id=>275);
598: end;
599: end if;
600: -- End for Bug 6053648
714: CURSOR get_user_name
715: IS
716: SELECT user_name
717: FROM fnd_user
718: WHERE user_id = FND_GLOBAL.user_id;
719:
720: BEGIN
721:
722: l_proj_mgr_id := wf_engine.GetItemAttrNumber
869: --(
870: select hp.party_name
871: from fnd_user fu,
872: hz_parties hp
873: where fu.user_name = l_forward_to --fnd_global.user_id
874: and fu.employee_id is null
875: and fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
876: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
877: union
877: union
878: select hp.party_name
879: from fnd_user fu,
880: hz_parties hp
881: where fu.user_name = l_forward_to--fnd_global.user_id
882: and fu.employee_id is not null
883: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
884: and 'PER:' || fu.employee_id = hp.orig_system_reference;
885: --);
2764: else
2765: wf_notification.setAttrText(p_nid, 'RESULT', 'AAA_KEEP_OPEN');
2766: end if;
2767:
2768: wf_notification.respond(p_nid, null, fnd_global.user_name);
2769:
2770:
2771: EXCEPTION
2772: