DBA Data[Home] [Help]

APPS.AMW_RISK_APPROVAL_PVT dependencies on WF_ENGINE

Line 87: wf_engine.getitemattrtext (itemtype => l_item_type,

83: l_hyphen_pos1 := INSTR (document_id, ':');
84: l_item_type := SUBSTR (document_id, 1, l_hyphen_pos1 - 1);
85: l_item_key := SUBSTR (document_id, l_hyphen_pos1 + 1);
86: l_object_type :=
87: wf_engine.getitemattrtext (itemtype => l_item_type,
88: itemkey => l_item_key,
89: aname => 'AMW_OBJECT_TYPE'
90: );
91: l_object_meaning :=

Line 92: wf_engine.getitemattrtext (itemtype => l_item_type,

88: itemkey => l_item_key,
89: aname => 'AMW_OBJECT_TYPE'
90: );
91: l_object_meaning :=
92: wf_engine.getitemattrtext (itemtype => l_item_type,
93: itemkey => l_item_key,
94: aname => 'AMW_APPROVAL_OBJECT_MEANING'
95: );
96: l_risk_rev_id :=

Line 97: wf_engine.getitemattrtext (itemtype => l_item_type,

93: itemkey => l_item_key,
94: aname => 'AMW_APPROVAL_OBJECT_MEANING'
95: );
96: l_risk_rev_id :=
97: wf_engine.getitemattrtext (itemtype => l_item_type,
98: itemkey => l_item_key,
99: aname => 'AMW_OBJECT_ID'
100: );
101: /*7/2/2003 mpande not required

Line 103: wf_engine.getitemattrtext (

99: aname => 'AMW_OBJECT_ID'
100: );
101: /*7/2/2003 mpande not required
102: l_note :=
103: wf_engine.getitemattrtext (
104: itemtype=> l_item_type,
105: itemkey=> l_item_key,
106: aname => 'AMW_NOTES_FROM_REQUESTOR'
107: );

Line 110: wf_engine.getitemattrtext (itemtype => l_item_type,

106: aname => 'AMW_NOTES_FROM_REQUESTOR'
107: );
108: */
109: l_approver :=
110: wf_engine.getitemattrtext (itemtype => l_item_type,
111: itemkey => l_item_key,
112: aname => 'AMW_APPROVER_DISPLAY_NAME'
113: );
114: OPEN c_risk_rec (l_risk_rev_id);

Line 125: wf_engine.setitemattrtext (

121: fnd_message.set_token ('NAME', l_risk_name, FALSE);
122: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
123: l_string := SUBSTR (fnd_message.get, 1, 1000);
124: /*
125: wf_engine.setitemattrtext (
126: itemtype=> l_item_type,
127: itemkey=> l_item_key,
128: aname => 'FYI_SUBJECT',
129: avalue=> l_string

Line 139: l_note := wf_engine.getitemattrtext(

135: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
136: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
137: l_string2 := '';
138: /*
139: l_note := wf_engine.getitemattrtext(
140: itemtype => l_item_type
141: ,itemkey => l_item_key
142: ,aname => 'NOTE');
143:

Line 146: wf_engine.getitemattrtext(

142: ,aname => 'NOTE');
143:
144:
145: l_forwarder :=
146: wf_engine.getitemattrtext(
147: itemtype => l_item_type
148: ,itemkey => l_item_key
149: ,aname => 'AMW_FORWARD_FROM_USERNAME');
150: */

Line 255: wf_engine.getitemattrtext (itemtype => l_item_type,

251: l_hyphen_pos1 := INSTR (document_id, ':');
252: l_item_type := SUBSTR (document_id, 1, l_hyphen_pos1 - 1);
253: l_item_key := SUBSTR (document_id, l_hyphen_pos1 + 1);
254: l_object_type :=
255: wf_engine.getitemattrtext (itemtype => l_item_type,
256: itemkey => l_item_key,
257: aname => 'AMW_OBJECT_TYPE'
258: );
259: l_object_meaning :=

Line 260: wf_engine.getitemattrtext (itemtype => l_item_type,

256: itemkey => l_item_key,
257: aname => 'AMW_OBJECT_TYPE'
258: );
259: l_object_meaning :=
260: wf_engine.getitemattrtext (itemtype => l_item_type,
261: itemkey => l_item_key,
262: aname => 'AMW_APPROVAL_OBJECT_MEANING'
263: );
264: l_risk_rev_id :=

Line 265: wf_engine.getitemattrtext (itemtype => l_item_type,

261: itemkey => l_item_key,
262: aname => 'AMW_APPROVAL_OBJECT_MEANING'
263: );
264: l_risk_rev_id :=
265: wf_engine.getitemattrtext (itemtype => l_item_type,
266: itemkey => l_item_key,
267: aname => 'AMW_OBJECT_ID'
268: );
269: l_note :=

Line 270: wf_engine.getitemattrtext (itemtype => l_item_type,

266: itemkey => l_item_key,
267: aname => 'AMW_OBJECT_ID'
268: );
269: l_note :=
270: wf_engine.getitemattrtext (itemtype => l_item_type,
271: itemkey => l_item_key,
272: aname => 'AMW_NOTES_FROM_REQUESTOR'
273: );
274: l_approver :=

Line 275: wf_engine.getitemattrtext (itemtype => l_item_type,

271: itemkey => l_item_key,
272: aname => 'AMW_NOTES_FROM_REQUESTOR'
273: );
274: l_approver :=
275: wf_engine.getitemattrtext (itemtype => l_item_type,
276: itemkey => l_item_key,
277: aname => 'AMW_APPROVER_DISPLAY_NAME'
278: );
279: OPEN c_risk_rec (l_risk_rev_id);

Line 295: l_note := wf_engine.getitemattrtext(

291: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
292: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
293: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
294: /*
295: l_note := wf_engine.getitemattrtext(
296: itemtype => l_item_type
297: ,itemkey => l_item_key
298: ,aname => 'NOTE');
299:

Line 302: wf_engine.getitemattrtext(

298: ,aname => 'NOTE');
299:
300:
301: l_forwarder :=
302: wf_engine.getitemattrtext(
303: itemtype => l_item_type
304: ,itemkey => l_item_key
305: ,aname => 'AMW_FORWARD_FROM_USERNAME');
306: */

Line 308: wf_engine.getitemattrtext (itemtype => l_item_type,

304: ,itemkey => l_item_key
305: ,aname => 'AMW_FORWARD_FROM_USERNAME');
306: */
307: l_approver_note :=
308: wf_engine.getitemattrtext (itemtype => l_item_type,
309: itemkey => l_item_key,
310: aname => 'APPROVAL_NOTE'
311: );
312: SELECT SYSDATE

Line 421: wf_engine.getitemattrtext (itemtype => l_item_type,

417: l_hyphen_pos1 := INSTR (document_id, ':');
418: l_item_type := SUBSTR (document_id, 1, l_hyphen_pos1 - 1);
419: l_item_key := SUBSTR (document_id, l_hyphen_pos1 + 1);
420: l_object_type :=
421: wf_engine.getitemattrtext (itemtype => l_item_type,
422: itemkey => l_item_key,
423: aname => 'AMW_OBJECT_TYPE'
424: );
425: l_object_meaning :=

Line 426: wf_engine.getitemattrtext (itemtype => l_item_type,

422: itemkey => l_item_key,
423: aname => 'AMW_OBJECT_TYPE'
424: );
425: l_object_meaning :=
426: wf_engine.getitemattrtext (itemtype => l_item_type,
427: itemkey => l_item_key,
428: aname => 'AMW_APPROVAL_OBJECT_MEANING'
429: );
430: l_risk_rev_id :=

Line 431: wf_engine.getitemattrtext (itemtype => l_item_type,

427: itemkey => l_item_key,
428: aname => 'AMW_APPROVAL_OBJECT_MEANING'
429: );
430: l_risk_rev_id :=
431: wf_engine.getitemattrtext (itemtype => l_item_type,
432: itemkey => l_item_key,
433: aname => 'AMW_OBJECT_ID'
434: );
435: l_note :=

Line 436: wf_engine.getitemattrtext (itemtype => l_item_type,

432: itemkey => l_item_key,
433: aname => 'AMW_OBJECT_ID'
434: );
435: l_note :=
436: wf_engine.getitemattrtext (itemtype => l_item_type,
437: itemkey => l_item_key,
438: aname => 'AMW_NOTES_FROM_REQUESTOR'
439: );
440: l_approver :=

Line 441: wf_engine.getitemattrtext (itemtype => l_item_type,

437: itemkey => l_item_key,
438: aname => 'AMW_NOTES_FROM_REQUESTOR'
439: );
440: l_approver :=
441: wf_engine.getitemattrtext (itemtype => l_item_type,
442: itemkey => l_item_key,
443: aname => 'AMW_APPROVER'
444: );
445: /*

Line 447: wf_engine.getitemattrtext (

443: aname => 'AMW_APPROVER'
444: );
445: /*
446: l_requestor :=
447: wf_engine.getitemattrtext (
448: itemtype=> l_item_type,
449: itemkey=> l_item_key,
450: aname => 'AMW_REQUESTOR'
451: );

Line 462: wf_engine.setitemattrtext (

458: fnd_message.set_token ('NAME', l_risk_name, FALSE);
459: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
460: l_string := SUBSTR (fnd_message.get, 1, 1000);
461: /*
462: wf_engine.setitemattrtext (
463: itemtype=> l_item_type,
464: itemkey=> l_item_key,
465: aname => 'REJECT_SUBJECT',
466: avalue=> l_string

Line 479: l_note := wf_engine.getitemattrtext(

475: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
476: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
477: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
478: /*
479: l_note := wf_engine.getitemattrtext(
480: itemtype => l_item_type
481: ,itemkey => l_item_key
482: ,aname => 'NOTE');
483:

Line 486: wf_engine.getitemattrtext(

482: ,aname => 'NOTE');
483:
484:
485: l_forwarder :=
486: wf_engine.getitemattrtext(
487: itemtype => l_item_type
488: ,itemkey => l_item_key
489: ,aname => 'AMW_FORWARD_FROM_USERNAME');
490: */

Line 492: wf_engine.getitemattrtext (itemtype => l_item_type,

488: ,itemkey => l_item_key
489: ,aname => 'AMW_FORWARD_FROM_USERNAME');
490: */
491: l_note :=
492: wf_engine.getitemattrtext (itemtype => l_item_type,
493: itemkey => l_item_key,
494: aname => 'APPROVAL_NOTE'
495: );
496: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_NOTE');

Line 587: wf_engine.getitemattrtext (itemtype => l_item_type,

583: l_hyphen_pos1 := INSTR (document_id, ':');
584: l_item_type := SUBSTR (document_id, 1, l_hyphen_pos1 - 1);
585: l_item_key := SUBSTR (document_id, l_hyphen_pos1 + 1);
586: l_object_type :=
587: wf_engine.getitemattrtext (itemtype => l_item_type,
588: itemkey => l_item_key,
589: aname => 'AMW_OBJECT_TYPE'
590: );
591: l_risk_rev_id :=

Line 592: wf_engine.getitemattrtext (itemtype => l_item_type,

588: itemkey => l_item_key,
589: aname => 'AMW_OBJECT_TYPE'
590: );
591: l_risk_rev_id :=
592: wf_engine.getitemattrtext (itemtype => l_item_type,
593: itemkey => l_item_key,
594: aname => 'AMW_OBJECT_ID'
595: );
596: l_note :=

Line 597: wf_engine.getitemattrtext (itemtype => l_item_type,

593: itemkey => l_item_key,
594: aname => 'AMW_OBJECT_ID'
595: );
596: l_note :=
597: wf_engine.getitemattrtext (itemtype => l_item_type,
598: itemkey => l_item_key,
599: aname => 'AMW_NOTES_FROM_REQUESTOR'
600: );
601: l_approver :=

Line 602: wf_engine.getitemattrtext (itemtype => l_item_type,

598: itemkey => l_item_key,
599: aname => 'AMW_NOTES_FROM_REQUESTOR'
600: );
601: l_approver :=
602: wf_engine.getitemattrtext (itemtype => l_item_type,
603: itemkey => l_item_key,
604: aname => 'AMW_APPROVER_DISPLAY_NAME'
605: );
606: /*

Line 608: wf_engine.getitemattrtext (

604: aname => 'AMW_APPROVER_DISPLAY_NAME'
605: );
606: /*
607: l_requestor :=
608: wf_engine.getitemattrtext (
609: itemtype=> l_item_type,
610: itemkey=> l_item_key,
611: aname => 'AMW_REQUESTOR'
612: );

Line 625: wf_engine.setitemattrtext (

621: fnd_message.set_token ('NAME', l_risk_name, FALSE);
622: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
623: l_string := SUBSTR (fnd_message.get, 1, 1000);
624: /*
625: wf_engine.setitemattrtext (
626: itemtype=> l_item_type,
627: itemkey=> l_item_key,
628: aname => 'APP_SUBJECT',
629: avalue=> l_string

Line 641: NVL (wf_engine.getitemattrtext (itemtype => l_item_type,

637: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
638: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
639: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
640: l_note :=
641: NVL (wf_engine.getitemattrtext (itemtype => l_item_type,
642: itemkey => l_item_key,
643: aname => 'AMW_PREV_APPROVER_NOTE'
644: ),
645: '-'

Line 648: NVL (wf_engine.getitemattrtext (itemtype => l_item_type,

644: ),
645: '-'
646: );
647: l_forwarder :=
648: NVL (wf_engine.getitemattrtext (itemtype => l_item_type,
649: itemkey => l_item_key,
650: aname => 'AMW_PREV_APPROVER_DISP_NAME'
651: ),
652: '-'

Line 655: NVL (TO_CHAR (wf_engine.getitemattrdate (itemtype => l_item_type,

651: ),
652: '-'
653: );
654: l_approval_date :=
655: NVL (TO_CHAR (wf_engine.getitemattrdate (itemtype => l_item_type,
656: itemkey => l_item_key,
657: aname => 'AMW_APPROVAL_DATE'
658: )
659: ),

Line 766: wf_engine.getitemattrtext (itemtype => l_item_type,

762: l_hyphen_pos1 := INSTR (document_id, ':');
763: l_item_type := SUBSTR (document_id, 1, l_hyphen_pos1 - 1);
764: l_item_key := SUBSTR (document_id, l_hyphen_pos1 + 1);
765: l_object_type :=
766: wf_engine.getitemattrtext (itemtype => l_item_type,
767: itemkey => l_item_key,
768: aname => 'AMW_OBJECT_TYPE'
769: );
770: l_object_meaning :=

Line 771: wf_engine.getitemattrtext (itemtype => l_item_type,

767: itemkey => l_item_key,
768: aname => 'AMW_OBJECT_TYPE'
769: );
770: l_object_meaning :=
771: wf_engine.getitemattrtext (itemtype => l_item_type,
772: itemkey => l_item_key,
773: aname => 'AMW_APPROVAL_OBJECT_MEANING'
774: );
775: l_risk_rev_id :=

Line 776: wf_engine.getitemattrtext (itemtype => l_item_type,

772: itemkey => l_item_key,
773: aname => 'AMW_APPROVAL_OBJECT_MEANING'
774: );
775: l_risk_rev_id :=
776: wf_engine.getitemattrtext (itemtype => l_item_type,
777: itemkey => l_item_key,
778: aname => 'AMW_OBJECT_ID'
779: );
780: l_note :=

Line 781: wf_engine.getitemattrtext (itemtype => l_item_type,

777: itemkey => l_item_key,
778: aname => 'AMW_OBJECT_ID'
779: );
780: l_note :=
781: wf_engine.getitemattrtext (itemtype => l_item_type,
782: itemkey => l_item_key,
783: aname => 'AMW_NOTES_FROM_REQUESTOR'
784: );
785: l_approver :=

Line 786: wf_engine.getitemattrtext (itemtype => l_item_type,

782: itemkey => l_item_key,
783: aname => 'AMW_NOTES_FROM_REQUESTOR'
784: );
785: l_approver :=
786: wf_engine.getitemattrtext (itemtype => l_item_type,
787: itemkey => l_item_key,
788: aname => 'AMW_APPROVER_DISPLAY_NAME'
789: );
790: l_requestor :=

Line 791: wf_engine.getitemattrtext (itemtype => l_item_type,

787: itemkey => l_item_key,
788: aname => 'AMW_APPROVER_DISPLAY_NAME'
789: );
790: l_requestor :=
791: wf_engine.getitemattrtext (itemtype => l_item_type,
792: itemkey => l_item_key,
793: aname => 'AMW_REQUESTOR'
794: );
795: OPEN c_risk_rec (l_risk_rev_id);

Line 804: wf_engine.setitemattrtext (

800: fnd_message.set_token ('RISK_NAME', l_risk_name, FALSE);
801: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
802: l_string := SUBSTR (fnd_message.get, 1, 1000);
803: /*
804: wf_engine.setitemattrtext (
805: itemtype=> l_item_type,
806: itemkey=> l_item_key,
807: aname => 'APP_SUBJECT',
808: avalue=> l_string

Line 818: NVL (wf_engine.getitemattrtext (itemtype => l_item_type,

814: fnd_message.set_token ('REQUESTOR_NAME', l_approver, FALSE);
815: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
816: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
817: l_note :=
818: NVL (wf_engine.getitemattrtext (itemtype => l_item_type,
819: itemkey => l_item_key,
820: aname => 'AMW_PREV_APPROVER_NOTE'
821: ),
822: '-'

Line 825: NVL (wf_engine.getitemattrtext (itemtype => l_item_type,

821: ),
822: '-'
823: );
824: l_forwarder :=
825: NVL (wf_engine.getitemattrtext (itemtype => l_item_type,
826: itemkey => l_item_key,
827: aname => 'AMW_PREV_APPROVER_DISP_NAME'
828: ),
829: '-'

Line 832: NVL (TO_CHAR (wf_engine.getitemattrdate (itemtype => l_item_type,

828: ),
829: '-'
830: );
831: l_approval_date :=
832: NVL (TO_CHAR (wf_engine.getitemattrdate (itemtype => l_item_type,
833: itemkey => l_item_key,
834: aname => 'AMW_APPROVAL_DATE'
835: )
836: ),

Line 845: l_note := wf_engine.getitemattrtext(

841: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
842: fnd_message.set_token ('COMMENTS', l_note, FALSE);
843: l_string2 := SUBSTR (fnd_message.get, 1, 2500);
844: /*
845: l_note := wf_engine.getitemattrtext(
846: itemtype => l_item_type
847: ,itemkey => l_item_key
848: ,aname => 'NOTE');
849:

Line 852: wf_engine.getitemattrtext(

848: ,aname => 'NOTE');
849:
850:
851: l_forwarder :=
852: wf_engine.getitemattrtext(
853: itemtype => l_item_type
854: ,itemkey => l_item_key
855: ,aname => 'AMW_FORWARD_FROM_USERNAME');
856: */

Line 942: wf_engine.getitemattrnumber (itemtype => itemtype,

938: WHERE risk_rev_id = p_risk_rev_id;
939: BEGIN
940: fnd_msg_pub.initialize;
941: l_object_id :=
942: wf_engine.getitemattrnumber (itemtype => itemtype,
943: itemkey => itemkey,
944: aname => 'AMW_OBJECT_ID'
945: );
946: IF (funcmode = 'RUN') THEN

Line 959: wf_engine.setitemattrtext (itemtype => itemtype,

955: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
956: fnd_message.set_token ('NAME', l_risk_name, FALSE);
957: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
958: l_string := SUBSTR (fnd_message.get, 1, 1000);
959: wf_engine.setitemattrtext (itemtype => itemtype,
960: itemkey => itemkey,
961: aname => 'FYI_SUBJECT',
962: avalue => l_string
963: );

Line 968: wf_engine.setitemattrtext (itemtype => itemtype,

964: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
965: fnd_message.set_token ('NAME', l_risk_name, FALSE);
966: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
967: l_string := SUBSTR (fnd_message.get, 1, 1000);
968: wf_engine.setitemattrtext (itemtype => itemtype,
969: itemkey => itemkey,
970: aname => 'APRV_SUBJECT',
971: avalue => l_string
972: );

Line 977: wf_engine.setitemattrtext (itemtype => itemtype,

973: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
974: fnd_message.set_token ('NAME', l_risk_name, FALSE);
975: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
976: l_string := SUBSTR (fnd_message.get, 1, 1000);
977: wf_engine.setitemattrtext (itemtype => itemtype,
978: itemkey => itemkey,
979: aname => 'REJECT_SUBJECT',
980: avalue => l_string
981: );

Line 986: wf_engine.setitemattrtext (itemtype => itemtype,

982: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
983: fnd_message.set_token ('NAME', l_risk_name, FALSE);
984: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
985: l_string := SUBSTR (fnd_message.get, 1, 1000);
986: wf_engine.setitemattrtext (itemtype => itemtype,
987: itemkey => itemkey,
988: aname => 'APP_SUBJECT',
989: avalue => l_string
990: );

Line 991: wf_engine.setitemattrtext (itemtype => itemtype,

987: itemkey => itemkey,
988: aname => 'APP_SUBJECT',
989: avalue => l_string
990: );
991: wf_engine.setitemattrtext (itemtype => itemtype,
992: itemkey => itemkey,
993: aname => 'AMW_APPROVAL_OBJECT_MEANING',
994: avalue => l_lookup_meaning
995: );

Line 996: wf_engine.setitemattrtext (itemtype => itemtype,

992: itemkey => itemkey,
993: aname => 'AMW_APPROVAL_OBJECT_MEANING',
994: avalue => l_lookup_meaning
995: );
996: wf_engine.setitemattrtext (itemtype => itemtype,
997: itemkey => itemkey,
998: aname => 'AMW_APPROVAL_OBJECT_NAME',
999: avalue => l_risk_name
1000: );

Line 1121: wf_engine.getitemattrtext (itemtype => itemtype,

1117: IF (funcmode = 'RUN') THEN
1118: -- Item attribute UPDATE_GEN_STATUS will be'set to APPROVED'if the Object is approved
1119: -- and 'REJECTED' if the object is rejected.
1120: l_update_status :=
1121: wf_engine.getitemattrtext (itemtype => itemtype,
1122: itemkey => itemkey,
1123: aname => 'UPDATE_GEN_STATUS'
1124: );
1125: l_approver :=

Line 1126: wf_engine.getitemattrtext (itemtype => itemtype,

1122: itemkey => itemkey,
1123: aname => 'UPDATE_GEN_STATUS'
1124: );
1125: l_approver :=
1126: wf_engine.getitemattrtext (itemtype => itemtype,
1127: itemkey => itemkey,
1128: aname => 'AMW_APPROVER'
1129: );
1130: l_approver_id :=

Line 1131: wf_engine.getitemattrtext (itemtype => itemtype,

1127: itemkey => itemkey,
1128: aname => 'AMW_APPROVER'
1129: );
1130: l_approver_id :=
1131: wf_engine.getitemattrtext (itemtype => itemtype,
1132: itemkey => itemkey,
1133: aname => 'AMW_APPROVER_ID'
1134: );
1135: l_requestor_id :=

Line 1136: wf_engine.getitemattrtext (itemtype => itemtype,

1132: itemkey => itemkey,
1133: aname => 'AMW_APPROVER_ID'
1134: );
1135: l_requestor_id :=
1136: wf_engine.getitemattrtext (itemtype => itemtype,
1137: itemkey => itemkey,
1138: aname => 'AMW_REQUESTOR_ID'
1139: );
1140: l_object_version_number :=

Line 1141: wf_engine.getitemattrnumber (itemtype => itemtype,

1137: itemkey => itemkey,
1138: aname => 'AMW_REQUESTOR_ID'
1139: );
1140: l_object_version_number :=
1141: wf_engine.getitemattrnumber (itemtype => itemtype,
1142: itemkey => itemkey,
1143: aname => 'AMW_OBJECT_VERSION_NUMBER'
1144: );
1145: l_risk_rev_id :=

Line 1146: wf_engine.getitemattrnumber (itemtype => itemtype,

1142: itemkey => itemkey,
1143: aname => 'AMW_OBJECT_VERSION_NUMBER'
1144: );
1145: l_risk_rev_id :=
1146: wf_engine.getitemattrnumber (itemtype => itemtype,
1147: itemkey => itemkey,
1148: aname => 'AMW_OBJECT_ID'
1149: );
1150: OPEN c_old_appr_risk (l_risk_rev_id);