eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CWB_RSGN_EMP dependencies on WF_ENGINE

Line 106: l_requestorId:=wf_engine.GetItemAttrNumber(itemtype => itemtype,

102: --hr_utility.trace_on (null, 'ORACLE');
103:
104: hr_utility.set_location('Entering '||l_package ,30);
105:
106: l_requestorId:=wf_engine.GetItemAttrNumber(itemtype => itemtype,
107: itemkey => itemkey,
108: aname => 'REQUESTOR_ID');
109: hr_utility.set_location('in Find approver : 2',20);
110:

Line 111: l_flag :=wf_engine.GetItemAttrNumber(itemtype => itemtype,

107: itemkey => itemkey,
108: aname => 'REQUESTOR_ID');
109: hr_utility.set_location('in Find approver : 2',20);
110:
111: l_flag :=wf_engine.GetItemAttrNumber(itemtype => itemtype,
112: itemkey => itemkey,
113: aname => 'REQUESTOR_FLAG');
114:
115:

Line 118: hr_utility.set_location('From workflow : ' || wf_engine.GetItemAttrNumber(itemtype => itemtype,

114:
115:
116: hr_utility.set_location('flag '||l_flag ,90);
117:
118: hr_utility.set_location('From workflow : ' || wf_engine.GetItemAttrNumber(itemtype => itemtype,
119: itemkey => itemkey,
120: aname => 'REQUESTOR_FLAG'),90);
121: -- if l_flag = 1 then
122:

Line 123: if (wf_engine.GetItemAttrNumber(itemtype => itemtype,

119: itemkey => itemkey,
120: aname => 'REQUESTOR_FLAG'),90);
121: -- if l_flag = 1 then
122:
123: if (wf_engine.GetItemAttrNumber(itemtype => itemtype,
124: itemkey => itemkey,
125: aname => 'REQUESTOR_FLAG')) = 1 then
126: hr_utility.set_location('true condition ' ,100);
127: result:='COMPLETE:' ||'NOT FOUND';

Line 137: wf_engine.SetItemAttrNumber( itemtype => itemtype

133: nextApproverOut => c_next_approver_out);
134: hr_utility.set_location('false condition ' ,100);
135:
136: if(c_next_approver_out.person_id is not null) then
137: wf_engine.SetItemAttrNumber( itemtype => itemtype
138: , itemkey => itemkey
139: , aname => 'RECEIVER_USER_ID'
140: , avalue => c_next_approver_out.person_id);
141: open get_curr_approver_name(c_next_approver_out.person_id);

Line 150: wf_engine.SetItemAttrText( itemtype => itemtype

146: Else
147: hr_utility.set_location ('No Data Found'||l_approver_user || ' , ' || c_next_approver_out.person_id || ' , ' ||l_approver_name,100);
148:
149: End If;
150: wf_engine.SetItemAttrText( itemtype => itemtype
151: , itemkey => itemkey
152: , aname => 'RECEIVER_USER_NAME'
153: , avalue => l_approver_user);
154: hr_utility.set_location('Approver name is: '|| l_approver_name,200);

Line 203: l_approver_id:= wf_engine.GetItemAttrNumber(itemtype => itemtype,

199: --hr_utility.trace_on (null, 'ORACLE');
200:
201: hr_utility.set_location('Entering '||l_package ,30);
202:
203: l_approver_id:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
204: itemkey => itemkey,
205: aname => 'RECEIVER_USER_ID');
206: l_approver_user := wf_engine.GetItemAttrText(itemtype => itemtype,
207: itemkey => itemkey,

Line 206: l_approver_user := wf_engine.GetItemAttrText(itemtype => itemtype,

202:
203: l_approver_id:= wf_engine.GetItemAttrNumber(itemtype => itemtype,
204: itemkey => itemkey,
205: aname => 'RECEIVER_USER_ID');
206: l_approver_user := wf_engine.GetItemAttrText(itemtype => itemtype,
207: itemkey => itemkey,
208: aname => 'RECEIVER_USER_NAME');
209:
210: hr_utility.set_location('store approver details : Reveiver user id : '|| l_approver_id,10);

Line 212: wf_engine.SetItemAttrText(itemtype => itemtype

208: aname => 'RECEIVER_USER_NAME');
209:
210: hr_utility.set_location('store approver details : Reveiver user id : '|| l_approver_id,10);
211:
212: wf_engine.SetItemAttrText(itemtype => itemtype
213: , itemkey => itemkey
214: , aname => 'FROM_ROLE'
215: , avalue =>
216: wf_engine.GetItemAttrText(itemtype => itemtype,

Line 216: wf_engine.GetItemAttrText(itemtype => itemtype,

212: wf_engine.SetItemAttrText(itemtype => itemtype
213: , itemkey => itemkey
214: , aname => 'FROM_ROLE'
215: , avalue =>
216: wf_engine.GetItemAttrText(itemtype => itemtype,
217: itemkey => itemkey,
218: aname => 'RECEIVER_USER_NAME')
219: );
220:

Line 276: l_curr_manager_name:= wf_engine.GetItemAttrText(itemtype => itemtype,

272: l_package varchar2(80) := g_package||'.curr_ws_mgr_check';
273: l_error varchar2(5000);
274: begin
275: hr_utility.set_location('Entering '||l_package ,30);
276: l_curr_manager_name:= wf_engine.GetItemAttrText(itemtype => itemtype,
277: itemkey => itemkey,
278: aname => 'CURRENT_WS_MANAGER');
279: l_requestor:= wf_engine.GetItemAttrText(itemtype => itemtype,
280: itemkey => itemkey,

Line 279: l_requestor:= wf_engine.GetItemAttrText(itemtype => itemtype,

275: hr_utility.set_location('Entering '||l_package ,30);
276: l_curr_manager_name:= wf_engine.GetItemAttrText(itemtype => itemtype,
277: itemkey => itemkey,
278: aname => 'CURRENT_WS_MANAGER');
279: l_requestor:= wf_engine.GetItemAttrText(itemtype => itemtype,
280: itemkey => itemkey,
281: aname => 'REQUESTOR');
282: if ( l_curr_manager_name = l_requestor) then
283: result:= 'COMPLETE:' ||'YES';

Line 311: l_prop_manager_name:= wf_engine.GetItemAttrText(itemtype => itemtype,

307: l_package varchar2(80) := g_package||'.prop_ws_mgr_check';
308: l_error varchar2(5000);
309: begin
310: hr_utility.set_location('Entering '||l_package ,30);
311: l_prop_manager_name:= wf_engine.GetItemAttrText(itemtype => itemtype,
312: itemkey => itemkey,
313: aname => 'PROPOSED_WS_MANAGER');
314: l_requestor:= wf_engine.GetItemAttrText(itemtype => itemtype,
315: itemkey => itemkey,

Line 314: l_requestor:= wf_engine.GetItemAttrText(itemtype => itemtype,

310: hr_utility.set_location('Entering '||l_package ,30);
311: l_prop_manager_name:= wf_engine.GetItemAttrText(itemtype => itemtype,
312: itemkey => itemkey,
313: aname => 'PROPOSED_WS_MANAGER');
314: l_requestor:= wf_engine.GetItemAttrText(itemtype => itemtype,
315: itemkey => itemkey,
316: aname => 'REQUESTOR');
317: if ( l_prop_manager_name = l_requestor) then
318: result:= 'COMPLETE:' ||'YES';

Line 345: l_message_type:= wf_engine.GetItemAttrText(itemtype => itemtype,

341: l_package varchar2(80) := g_package||'.which_message';
342: l_error varchar2(5000);
343: begin
344: hr_utility.set_location('Entering '||l_package ,30);
345: l_message_type:= wf_engine.GetItemAttrText(itemtype => itemtype,
346: itemkey => itemkey,
347: aname => 'MESSAGE_TYPE');
348: if( l_message_type='COMPLETED') then
349: l_error_message := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 349: l_error_message := wf_engine.GetItemAttrText(itemtype => itemtype,

345: l_message_type:= wf_engine.GetItemAttrText(itemtype => itemtype,
346: itemkey => itemkey,
347: aname => 'MESSAGE_TYPE');
348: if( l_message_type='COMPLETED') then
349: l_error_message := wf_engine.GetItemAttrText(itemtype => itemtype,
350: itemkey => itemkey,
351: aname => 'ERROR_MESSAGE');
352: UPDATE ben_transaction
353: SET attribute40 = l_error_message

Line 388: l_approver_user := wf_engine.GetItemAttrText(itemtype => itemtype,

384: l_error varchar2(5000);
385: begin
386: hr_utility.set_location('Entering '||l_package ,30);
387:
388: l_approver_user := wf_engine.GetItemAttrText(itemtype => itemtype,
389: itemkey => itemkey,
390: aname => 'RECEIVER_USER_NAME');
391:
392: wf_engine.SetItemAttrText(itemtype => itemtype

Line 392: wf_engine.SetItemAttrText(itemtype => itemtype

388: l_approver_user := wf_engine.GetItemAttrText(itemtype => itemtype,
389: itemkey => itemkey,
390: aname => 'RECEIVER_USER_NAME');
391:
392: wf_engine.SetItemAttrText(itemtype => itemtype
393: , itemkey => itemkey
394: , aname => 'FROM_ROLE'
395: , avalue =>
396: wf_engine.GetItemAttrText(itemtype => itemtype,

Line 396: wf_engine.GetItemAttrText(itemtype => itemtype,

392: wf_engine.SetItemAttrText(itemtype => itemtype
393: , itemkey => itemkey
394: , aname => 'FROM_ROLE'
395: , avalue =>
396: wf_engine.GetItemAttrText(itemtype => itemtype,
397: itemkey => itemkey,
398: aname => 'RECEIVER_USER_NAME')
399: );
400:

Line 423: wf_engine.SetItemAttrText( itemtype => itemtype

419: and attribute21 is null;
420:
421: -- End..
422:
423: wf_engine.SetItemAttrText( itemtype => itemtype
424: , itemkey => itemkey
425: , aname => 'MESSAGE_TYPE'
426: , avalue => 'REJECTED');
427: result:='COMPLETE:';

Line 497: wf_engine.SetItemAttrText( itemtype => itemtype

493: --hr_utility.trace_on (null, 'ORACLE');
494:
495: hr_utility.set_location('Entering '||l_package ,30);
496:
497: wf_engine.SetItemAttrText( itemtype => itemtype
498: , itemkey => itemkey
499: , aname => 'MESSAGE_TYPE'
500: , avalue => 'APPROVED');
501: open getEmpToReassign;

Line 608: wf_engine.SetItemAttrText( itemtype => itemtype

604:
605: end loop;
606: --ben_manage_life_events.rebuild_heirarchy(p_elig_per_elctbl_chc_id => l_ws_mgr_chc_id);
607:
608: wf_engine.SetItemAttrText( itemtype => itemtype
609: , itemkey => itemkey
610: , aname => 'MESSAGE_TYPE'
611: , avalue => 'APPROVED');
612: else

Line 613: wf_engine.SetItemAttrText( itemtype => itemtype

609: , itemkey => itemkey
610: , aname => 'MESSAGE_TYPE'
611: , avalue => 'APPROVED');
612: else
613: wf_engine.SetItemAttrText( itemtype => itemtype
614: , itemkey => itemkey
615: , aname => 'MESSAGE_TYPE'
616: , avalue => 'COMPLETED');
617:

Line 618: wf_engine.SetItemAttrText( itemtype => itemtype

614: , itemkey => itemkey
615: , aname => 'MESSAGE_TYPE'
616: , avalue => 'COMPLETED');
617:
618: wf_engine.SetItemAttrText( itemtype => itemtype
619: , itemkey => itemkey
620: , aname => 'ERROR_MESSAGE'
621: , avalue => l_message);
622:

Line 631: wf_engine.SetItemAttrText( itemtype => itemtype

627: EXCEPTION
628: when others then
629: hr_utility.set_location('Leaving '||sqlerrm ,30);
630: l_error:=fnd_message.get;
631: wf_engine.SetItemAttrText( itemtype => itemtype
632: , itemkey => itemkey
633: , aname => 'MESSAGE_TYPE'
634: , avalue => 'COMPLETED');
635: wf_engine.SetItemAttrText( itemtype => itemtype

Line 635: wf_engine.SetItemAttrText( itemtype => itemtype

631: wf_engine.SetItemAttrText( itemtype => itemtype
632: , itemkey => itemkey
633: , aname => 'MESSAGE_TYPE'
634: , avalue => 'COMPLETED');
635: wf_engine.SetItemAttrText( itemtype => itemtype
636: , itemkey => itemkey
637: , aname => 'ERROR_MESSAGE'
638: , avalue => l_error);
639:

Line 754: wf_engine.createProcess( ItemType => l_itemtype,

750: l_process_name := nvl(fnd_profile.value('BEN_CWB_EMP_RSGN_W_PROCESS'),'RSGNP');
751:
752: hr_utility.set_location ('Rsgn Process Name After reading profile'||l_process_name ,55);
753:
754: wf_engine.createProcess( ItemType => l_itemtype,
755: ItemKey => l_itemkey,
756: process => l_process_name );
757:
758: /*wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 758: /*wf_engine.SetItemAttrText( itemtype => l_itemtype

754: wf_engine.createProcess( ItemType => l_itemtype,
755: ItemKey => l_itemkey,
756: process => l_process_name );
757:
758: /*wf_engine.SetItemAttrText( itemtype => l_itemtype
759: , itemkey => l_itemkey
760: , aname => 'MANAGER_NAME'
761: , avalue => 'TY');*/
762:

Line 765: wf_engine.setitemattrtext (itemtype => l_itemtype,

761: , avalue => 'TY');*/
762:
763: -- Changed for embedded region
764:
765: wf_engine.setitemattrtext (itemtype => l_itemtype,
766: itemkey => l_itemkey,
767: aname => 'TRANSACTION_ID',
768: avalue => p_transaction_id
769: );

Line 771: wf_engine.SetItemAttrText( itemtype => l_itemtype

767: aname => 'TRANSACTION_ID',
768: avalue => p_transaction_id
769: );
770:
771: wf_engine.SetItemAttrText( itemtype => l_itemtype
772: , itemkey => l_itemkey
773: , aname => 'PLAN_NAME'
774: , avalue => p_plan_name );
775: /*wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 775: /*wf_engine.SetItemAttrText( itemtype => l_itemtype

771: wf_engine.SetItemAttrText( itemtype => l_itemtype
772: , itemkey => l_itemkey
773: , aname => 'PLAN_NAME'
774: , avalue => p_plan_name );
775: /*wf_engine.SetItemAttrText( itemtype => l_itemtype
776: , itemkey => l_itemkey
777: , aname => 'COMMENTS_CURR_WS_MANAGER'
778: , avalue => p_message ); */
779:

Line 783: wf_engine.SetItemAttrText( itemtype => l_itemtype

779:
780: open approver_name(p_curr_ws_manager_id);
781:
782: fetch approver_name into l_curr_ws_manager_user , l_curr_ws_manager_name , l_curr_ws_manager_last_name ;
783: wf_engine.SetItemAttrText( itemtype => l_itemtype
784: , itemkey => l_itemkey
785: , aname => 'CURRENT_WS_MANAGER'
786:
787: , avalue => l_curr_ws_manager_user );

Line 794: wf_engine.SetItemAttrText( itemtype => l_itemtype

790:
791: close approver_name;
792: open approver_name(p_prop_ws_manager_id);
793: fetch approver_name into l_prop_ws_manager_user , l_prop_ws_manager_name , l_prop_ws_manager_last_name;
794: wf_engine.SetItemAttrText( itemtype => l_itemtype
795: , itemkey => l_itemkey
796: , aname => 'PROPOSED_WS_MANAGER'
797:
798: , avalue => l_prop_ws_manager_user);

Line 807: wf_engine.SetItemAttrText( itemtype => l_itemtype

803: open approver_name(p_requestor_id);
804: fetch approver_name into l_requestor_user , l_requestor_name , l_requestor_last_name ;
805:
806:
807: wf_engine.SetItemAttrText( itemtype => l_itemtype
808: , itemkey => l_itemkey
809: , aname => 'REQUESTOR_ID'
810: , avalue => p_requestor_id);
811: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 811: wf_engine.SetItemAttrText( itemtype => l_itemtype

807: wf_engine.SetItemAttrText( itemtype => l_itemtype
808: , itemkey => l_itemkey
809: , aname => 'REQUESTOR_ID'
810: , avalue => p_requestor_id);
811: wf_engine.SetItemAttrText( itemtype => l_itemtype
812: , itemkey => l_itemkey
813: , aname => 'REQUESTOR_PERSON_NAME'
814: , avalue => l_requestor_name);
815: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 815: wf_engine.SetItemAttrText( itemtype => l_itemtype

811: wf_engine.SetItemAttrText( itemtype => l_itemtype
812: , itemkey => l_itemkey
813: , aname => 'REQUESTOR_PERSON_NAME'
814: , avalue => l_requestor_name);
815: wf_engine.SetItemAttrText( itemtype => l_itemtype
816: , itemkey => l_itemkey
817: , aname => 'REQUESTOR'
818: , avalue => l_requestor_user);
819:

Line 823: wf_engine.SetItemAttrText(itemtype => l_itemtype

819:
820: close approver_name;
821:
822:
823: wf_engine.SetItemAttrText(itemtype => l_itemtype
824: , itemkey => l_itemkey
825: , aname => 'FROM_ROLE'
826: , avalue => l_requestor_user);
827:

Line 829: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,

825: , aname => 'FROM_ROLE'
826: , avalue => l_requestor_user);
827:
828: -- No longer is use
829: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
830: -- itemkey => l_itemkey
831: -- ,aname => 'EMP_RSGN_SUMMARY'
832: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_detail_html/'||l_itemkey);
833: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,

Line 833: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,

829: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
830: -- itemkey => l_itemkey
831: -- ,aname => 'EMP_RSGN_SUMMARY'
832: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_detail_html/'||l_itemkey);
833: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
834: -- itemkey => l_itemkey
835: -- ,aname => 'EMP_RSGN_EMP'
836: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_employee_table_html/'||l_itemkey);
837: --

Line 838: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,

834: -- itemkey => l_itemkey
835: -- ,aname => 'EMP_RSGN_EMP'
836: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_employee_table_html/'||l_itemkey);
837: --
838: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
839: -- itemkey => l_itemkey
840: -- ,aname => 'EMP_RSGN_APPR'
841: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_approver_table_html/'||l_itemkey);
842: --

Line 843: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,

839: -- itemkey => l_itemkey
840: -- ,aname => 'EMP_RSGN_APPR'
841: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_approver_table_html/'||l_itemkey);
842: --
843: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
844: -- itemkey => l_itemkey
845: -- ,aname => 'EMP_RSGN_ERROR'
846: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_error_html/'||l_itemkey);
847: -- No longer is use

Line 853: wf_engine.setitemattrtext (itemtype => 'BENCWBFY',

849:
850: l_for_period := get_for_period (p_prop_ws_mgr_per_in_ler_id);
851: hr_utility.TRACE ('l_for_period ' || l_for_period);
852:
853: wf_engine.setitemattrtext (itemtype => 'BENCWBFY',
854: itemkey => l_itemkey,
855: aname => 'FOR_PERIOD',
856: avalue => l_for_period
857: );

Line 859: /*wf_engine.StartProcess ( ItemType => l_itemtype,

855: aname => 'FOR_PERIOD',
856: avalue => l_for_period
857: );
858:
859: /*wf_engine.StartProcess ( ItemType => l_itemtype,
860: ItemKey => l_itemkey ); */
861:
862: -- hr_utility.trace_on (null,'ORACLE');
863:

Line 1014: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

1010: end if;
1011:
1012: -- End Current and proposed ws manager check
1013:
1014: wf_engine.SetItemAttrNumber( itemtype => l_itemtype
1015: , itemkey => l_itemkey
1016: , aname => 'REQUESTOR_FLAG'
1017: , avalue => l_requestor_flag);
1018:

Line 1020: wf_engine.StartProcess ( ItemType => l_itemtype,

1016: , aname => 'REQUESTOR_FLAG'
1017: , avalue => l_requestor_flag);
1018:
1019:
1020: wf_engine.StartProcess ( ItemType => l_itemtype,
1021: ItemKey => l_itemkey );
1022:
1023: hr_utility.set_location('Leaving '||l_package ,30);
1024:

Line 1089: wf_engine.createProcess( ItemType => l_itemtype,

1085:
1086: Begin
1087: /*select BEN_CWB_WF_NTF_S.NEXTVAL into l_itemkey from dual;*/
1088: hr_utility.set_location('Entering '||l_package ,30);
1089: wf_engine.createProcess( ItemType => l_itemtype,
1090: ItemKey => l_itemkey,
1091:
1092: process => l_process_name );
1093: /*wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1093: /*wf_engine.SetItemAttrText( itemtype => l_itemtype

1089: wf_engine.createProcess( ItemType => l_itemtype,
1090: ItemKey => l_itemkey,
1091:
1092: process => l_process_name );
1093: /*wf_engine.SetItemAttrText( itemtype => l_itemtype
1094: , itemkey => l_itemkey
1095: , aname => 'HTML_TRY'
1096: , avalue => l_html );
1097: */

Line 1102: wf_engine.setitemattrtext (itemtype => l_itemtype,

1098:
1099:
1100: -- Changed for embedded region
1101:
1102: wf_engine.setitemattrtext (itemtype => l_itemtype,
1103: itemkey => l_itemkey,
1104: aname => 'TRANSACTION_ID',
1105: avalue => p_transaction_id
1106: );

Line 1108: wf_engine.SetItemAttrText( itemtype => l_itemtype

1104: aname => 'TRANSACTION_ID',
1105: avalue => p_transaction_id
1106: );
1107:
1108: wf_engine.SetItemAttrText( itemtype => l_itemtype
1109: , itemkey => l_itemkey
1110: , aname => 'PLAN_NAME'
1111: , avalue => p_plan_name );
1112: /*wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1112: /*wf_engine.SetItemAttrText( itemtype => l_itemtype

1108: wf_engine.SetItemAttrText( itemtype => l_itemtype
1109: , itemkey => l_itemkey
1110: , aname => 'PLAN_NAME'
1111: , avalue => p_plan_name );
1112: /*wf_engine.SetItemAttrText( itemtype => l_itemtype
1113: , itemkey => l_itemkey
1114: , aname => 'COMMENTS_CURR_WS_MANAGER'
1115: , avalue => p_message ); */
1116: open approver_name(p_curr_ws_manager_id);

Line 1119: wf_engine.SetItemAttrText( itemtype => l_itemtype

1115: , avalue => p_message ); */
1116: open approver_name(p_curr_ws_manager_id);
1117:
1118: fetch approver_name into l_curr_ws_manager_user , l_curr_ws_manager_name , l_curr_ws_manager_last_name ;
1119: wf_engine.SetItemAttrText( itemtype => l_itemtype
1120: , itemkey => l_itemkey
1121: , aname => 'CURRENT_WS_MANAGER'
1122: , avalue => l_curr_ws_manager_user );
1123: close approver_name;

Line 1126: wf_engine.SetItemAttrText( itemtype => l_itemtype

1122: , avalue => l_curr_ws_manager_user );
1123: close approver_name;
1124: open approver_name(p_prop_ws_manager_id);
1125: fetch approver_name into l_prop_ws_manager_user , l_prop_ws_manager_name , l_prop_ws_manager_last_name;
1126: wf_engine.SetItemAttrText( itemtype => l_itemtype
1127: , itemkey => l_itemkey
1128: , aname => 'PROPOSED_WS_MANAGER'
1129: , avalue => l_prop_ws_manager_user);
1130: close approver_name;

Line 1134: wf_engine.SetItemAttrText( itemtype => l_itemtype

1130: close approver_name;
1131:
1132: open approver_name(p_requestor_id);
1133: fetch approver_name into l_requestor_user , l_requestor_name , l_requestor_last_name ;
1134: wf_engine.SetItemAttrText( itemtype => l_itemtype
1135: , itemkey => l_itemkey
1136: , aname => 'REQUESTOR_PERSON_NAME'
1137: , avalue => l_requestor_name);
1138: wf_engine.SetItemAttrText( itemtype => l_itemtype

Line 1138: wf_engine.SetItemAttrText( itemtype => l_itemtype

1134: wf_engine.SetItemAttrText( itemtype => l_itemtype
1135: , itemkey => l_itemkey
1136: , aname => 'REQUESTOR_PERSON_NAME'
1137: , avalue => l_requestor_name);
1138: wf_engine.SetItemAttrText( itemtype => l_itemtype
1139: , itemkey => l_itemkey
1140: , aname => 'REQUESTOR'
1141: , avalue => l_requestor_user);
1142: close approver_name;

Line 1144: wf_engine.SetItemAttrText(itemtype => l_itemtype

1140: , aname => 'REQUESTOR'
1141: , avalue => l_requestor_user);
1142: close approver_name;
1143:
1144: wf_engine.SetItemAttrText(itemtype => l_itemtype
1145: , itemkey => l_itemkey
1146: , aname => 'FROM_ROLE'
1147: , avalue => l_requestor_user);
1148:

Line 1149: wf_engine.SetItemAttrText( itemtype => l_itemtype

1145: , itemkey => l_itemkey
1146: , aname => 'FROM_ROLE'
1147: , avalue => l_requestor_user);
1148:
1149: wf_engine.SetItemAttrText( itemtype => l_itemtype
1150: , itemkey => l_itemkey
1151: , aname => 'MESSAGE_TYPE'
1152: , avalue => 'FYI');
1153: -- No longer is use

Line 1154: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,

1150: , itemkey => l_itemkey
1151: , aname => 'MESSAGE_TYPE'
1152: , avalue => 'FYI');
1153: -- No longer is use
1154: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
1155: -- itemkey => l_itemkey
1156: -- ,aname => 'EMP_RSGN_SUMMARY'
1157: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_detail_html/'||l_itemkey);
1158: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,

Line 1158: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,

1154: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
1155: -- itemkey => l_itemkey
1156: -- ,aname => 'EMP_RSGN_SUMMARY'
1157: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_detail_html/'||l_itemkey);
1158: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
1159: -- itemkey => l_itemkey
1160: -- ,aname => 'EMP_RSGN_EMP'
1161: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_employee_table_html/'||l_itemkey);
1162: --

Line 1163: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,

1159: -- itemkey => l_itemkey
1160: -- ,aname => 'EMP_RSGN_EMP'
1161: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_employee_table_html/'||l_itemkey);
1162: --
1163: -- wf_engine.SetItemAttrText(itemtype => l_itemtype,
1164: -- itemkey => l_itemkey
1165: -- ,aname => 'EMP_RSGN_APPR'
1166: -- ,avalue => 'PLSQL:BEN_CWB_RSGN_EMP.generate_approver_table_html/'||l_itemkey);
1167: -- No longer is use

Line 1173: wf_engine.setItemattrText (itemtype => l_itemtype,

1169:
1170: l_for_period := get_for_period (p_prop_mgr_per_in_ler_id);
1171: hr_utility.TRACE ('l_for_period ' || l_for_period);
1172:
1173: wf_engine.setItemattrText (itemtype => l_itemtype,
1174: itemkey => l_itemkey ,
1175: aname => 'FOR_PERIOD',
1176: avalue => l_for_period
1177: );

Line 1217: wf_engine.StartProcess ( ItemType => l_itemtype,

1213: l_curr_ws_manager_last_name,
1214: l_prop_ws_manager_last_name);
1215:
1216:
1217: wf_engine.StartProcess ( ItemType => l_itemtype,
1218: ItemKey => l_itemkey );
1219:
1220:
1221: hr_utility.set_location('Leaving '||l_package ,30);