[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.
57: 26-Apr-07 vvjoshi Bug#5962401:Modified set_workflow_attributes procedure to set expiration date for adhoc role.
58: 25-Jun-07 rballamu Bug#6053648:Modified change_status_approved to initialize the application context.
59: =============================================================================*/
60:
61: G_USER_ID CONSTANT NUMBER := FND_GLOBAL.user_id;
62:
63:
64: /********************************************************************
65: * Procedure : start_workflow
504: , itemkey
505: , 'CI_APPROVER_NAME');
506:
507: -- Added for Bug 6053648
508: l_user_id := fnd_global.user_id;
509: -- If approved via E-Mail we need to set the application context explicitly
510: if (l_user_id is null or
511: l_user_id = 0 or
512: l_user_id = -1) then
513: begin
514: open c_user_id(l_name);
515: fetch c_user_id into l_user_id;
516: close c_user_id;
517: fnd_global.apps_initialize(
518: user_id=>l_user_id,
519: resp_id=>fnd_global.resp_id,
520: resp_appl_id=>275);
521: end;
515: fetch c_user_id into l_user_id;
516: close c_user_id;
517: fnd_global.apps_initialize(
518: user_id=>l_user_id,
519: resp_id=>fnd_global.resp_id,
520: resp_appl_id=>275);
521: end;
522: end if;
523: -- End for Bug 6053648
611: CURSOR get_user_name
612: IS
613: SELECT user_name
614: FROM fnd_user
615: WHERE user_id = FND_GLOBAL.user_id;
616:
617: BEGIN
618:
619: l_proj_mgr_id := wf_engine.GetItemAttrNumber
769: --(
770: select hp.party_name
771: from fnd_user fu,
772: hz_parties hp
773: where fu.user_name = l_forward_to --fnd_global.user_id
774: and fu.employee_id is null
775: and fu.person_party_id = hp.party_id -- Bug 4527617. Replaced customer_id with person_party_id.
776: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
777: union
777: union
778: select hp.party_name
779: from fnd_user fu,
780: hz_parties hp
781: where fu.user_name = l_forward_to--fnd_global.user_id
782: and fu.employee_id is not null
783: and trunc(sysdate) between fu.start_date and nvl(fu.end_date, sysdate) /* Bug#3838957 */
784: and 'PER:' || fu.employee_id = hp.orig_system_reference;
785: --);
2521: else
2522: wf_notification.setAttrText(p_nid, 'RESULT', 'AAA_KEEP_OPEN');
2523: end if;
2524:
2525: wf_notification.respond(p_nid, null, fnd_global.user_name);
2526:
2527:
2528: EXCEPTION
2529: