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.

[Home] [Help]

APPS.BEN_CWB_RSGN_EMP dependencies on WF_ENGINE

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

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

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

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

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

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

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

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

Line 136: wf_engine.SetItemAttrNumber( itemtype => itemtype

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

Line 149: wf_engine.SetItemAttrText( itemtype => itemtype

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

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

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

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

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

Line 211: wf_engine.SetItemAttrText(itemtype => itemtype

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 391: wf_engine.SetItemAttrText(itemtype => itemtype

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

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

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

Line 422: wf_engine.SetItemAttrText( itemtype => itemtype

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

Line 496: wf_engine.SetItemAttrText( itemtype => itemtype

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

Line 607: wf_engine.SetItemAttrText( itemtype => itemtype

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

Line 612: wf_engine.SetItemAttrText( itemtype => itemtype

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

Line 617: wf_engine.SetItemAttrText( itemtype => itemtype

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

Line 630: wf_engine.SetItemAttrText( itemtype => itemtype

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

Line 634: wf_engine.SetItemAttrText( itemtype => itemtype

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

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

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

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

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

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

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

Line 770: wf_engine.SetItemAttrText( itemtype => l_itemtype

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

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

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

Line 782: wf_engine.SetItemAttrText( itemtype => l_itemtype

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

Line 793: wf_engine.SetItemAttrText( itemtype => l_itemtype

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

Line 806: wf_engine.SetItemAttrText( itemtype => l_itemtype

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

Line 810: wf_engine.SetItemAttrText( itemtype => l_itemtype

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

Line 814: wf_engine.SetItemAttrText( itemtype => l_itemtype

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

Line 822: wf_engine.SetItemAttrText(itemtype => l_itemtype

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1013: wf_engine.SetItemAttrNumber( itemtype => l_itemtype

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

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

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

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

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

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

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

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

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

Line 1107: wf_engine.SetItemAttrText( itemtype => l_itemtype

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

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

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

Line 1118: wf_engine.SetItemAttrText( itemtype => l_itemtype

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

Line 1125: wf_engine.SetItemAttrText( itemtype => l_itemtype

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

Line 1133: wf_engine.SetItemAttrText( itemtype => l_itemtype

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

Line 1137: wf_engine.SetItemAttrText( itemtype => l_itemtype

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

Line 1143: wf_engine.SetItemAttrText(itemtype => l_itemtype

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

Line 1148: wf_engine.SetItemAttrText( itemtype => l_itemtype

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

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

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

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

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

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

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

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

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

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

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