APPS.AMW_CTRL_APPROVAL_PVT dependencies on WF_ENGINE

Line 98: wf_engine.getitemattrtext (

94: - 1);
95: l_item_key := SUBSTR (document_id, l_hyphen_pos1
96: + 1);
97: l_OBJECT_type :=
98: wf_engine.getitemattrtext (
99: itemtype=> l_item_type,
100: itemkey=> l_item_key,
101: aname => 'AMW_OBJECT_TYPE'
102: );

Line 104: wf_engine.getitemattrtext (

100: itemkey=> l_item_key,
101: aname => 'AMW_OBJECT_TYPE'
102: );
103: l_OBJECT_meaning :=
104: wf_engine.getitemattrtext (
105: itemtype=> l_item_type,
106: itemkey=> l_item_key,
107: aname => 'AMW_APPROVAL_OBJECT_MEANING'
108: );

Line 111: wf_engine.getitemattrtext (

107: aname => 'AMW_APPROVAL_OBJECT_MEANING'
108: );
109:
110: l_CTRL_rev_id :=
111: wf_engine.getitemattrtext (
112: itemtype=> l_item_type,
113: itemkey=> l_item_key,
114: aname => 'AMW_OBJECT_ID'
115: );

Line 118: wf_engine.getitemattrtext (

114: aname => 'AMW_OBJECT_ID'
115: );
116: /*7/2/2003 mpande not required
117: l_note :=
118: wf_engine.getitemattrtext (
119: itemtype=> l_item_type,
120: itemkey=> l_item_key,
121: aname => 'AMW_NOTES_FROM_REQUESTOR'
122: );

Line 125: wf_engine.getitemattrtext (

121: aname => 'AMW_NOTES_FROM_REQUESTOR'
122: );
123: */
124: l_approver :=
125: wf_engine.getitemattrtext (
126: itemtype=> l_item_type,
127: itemkey=> l_item_key,
128: aname => 'AMW_APPROVER_DISPLAY_NAME'
129: );

Line 143: wf_engine.setitemattrtext (

139: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
140: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
141: l_string := SUBSTR(fnd_message.get,1,1000);
142: /*
143: wf_engine.setitemattrtext (
144: itemtype=> l_item_type,
145: itemkey=> l_item_key,
146: aname => 'FYI_SUBJECT',
147: avalue=> l_string

Line 157: l_note := wf_engine.getitemattrtext(

153: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
154: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
155:
156: /*
157: l_note := wf_engine.getitemattrtext(
158: itemtype => l_item_type
159: ,itemkey => l_item_key
160: ,aname => 'NOTE');
161:

Line 164: wf_engine.getitemattrtext(

160: ,aname => 'NOTE');
161:
162:
163: l_forwarder :=
164: wf_engine.getitemattrtext(
165: itemtype => l_item_type
166: ,itemkey => l_item_key
167: ,aname => 'AMW_FORWARD_FROM_USERNAME');
168: */

Line 279: wf_engine.getitemattrtext (

275: - 1);
276: l_item_key := SUBSTR (document_id, l_hyphen_pos1
277: + 1);
278: l_OBJECT_type :=
279: wf_engine.getitemattrtext (
280: itemtype=> l_item_type,
281: itemkey=> l_item_key,
282: aname => 'AMW_OBJECT_TYPE'
283: );

Line 285: wf_engine.getitemattrtext (

281: itemkey=> l_item_key,
282: aname => 'AMW_OBJECT_TYPE'
283: );
284: l_OBJECT_meaning :=
285: wf_engine.getitemattrtext (
286: itemtype=> l_item_type,
287: itemkey=> l_item_key,
288: aname => 'AMW_APPROVAL_OBJECT_MEANING'
289: );

Line 292: wf_engine.getitemattrtext (

288: aname => 'AMW_APPROVAL_OBJECT_MEANING'
289: );
290:
291: l_CTRL_rev_id :=
292: wf_engine.getitemattrtext (
293: itemtype=> l_item_type,
294: itemkey=> l_item_key,
295: aname => 'AMW_OBJECT_ID'
296: );

Line 298: wf_engine.getitemattrtext (

294: itemkey=> l_item_key,
295: aname => 'AMW_OBJECT_ID'
296: );
297: l_note :=
298: wf_engine.getitemattrtext (
299: itemtype=> l_item_type,
300: itemkey=> l_item_key,
301: aname => 'AMW_NOTES_FROM_REQUESTOR'
302: );

Line 304: wf_engine.getitemattrtext (

300: itemkey=> l_item_key,
301: aname => 'AMW_NOTES_FROM_REQUESTOR'
302: );
303: l_approver :=
304: wf_engine.getitemattrtext (
305: itemtype=> l_item_type,
306: itemkey=> l_item_key,
307: aname => 'AMW_APPROVER_DISPLAY_NAME'
308: );

Line 327: l_note := wf_engine.getitemattrtext(

323: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
324: l_string1 := Substr(FND_MESSAGE.Get,1,2500);
325:
326: /*
327: l_note := wf_engine.getitemattrtext(
328: itemtype => l_item_type
329: ,itemkey => l_item_key
330: ,aname => 'NOTE');
331:

Line 334: wf_engine.getitemattrtext(

330: ,aname => 'NOTE');
331:
332:
333: l_forwarder :=
334: wf_engine.getitemattrtext(
335: itemtype => l_item_type
336: ,itemkey => l_item_key
337: ,aname => 'AMW_FORWARD_FROM_USERNAME');
338: */

Line 342: wf_engine.getitemattrtext (

338: */
339:
340:
341: l_approver_note :=
342: wf_engine.getitemattrtext (
343: itemtype=> l_item_type,
344: itemkey=> l_item_key,
345: aname => 'APPROVAL_NOTE'
346: );

Line 466: wf_engine.getitemattrtext (

462: - 1);
463: l_item_key := SUBSTR (document_id, l_hyphen_pos1
464: + 1);
465: l_OBJECT_type :=
466: wf_engine.getitemattrtext (
467: itemtype=> l_item_type,
468: itemkey=> l_item_key,
469: aname => 'AMW_OBJECT_TYPE'
470: );

Line 472: wf_engine.getitemattrtext (

468: itemkey=> l_item_key,
469: aname => 'AMW_OBJECT_TYPE'
470: );
471: l_OBJECT_meaning :=
472: wf_engine.getitemattrtext (
473: itemtype=> l_item_type,
474: itemkey=> l_item_key,
475: aname => 'AMW_APPROVAL_OBJECT_MEANING'
476: );

Line 479: wf_engine.getitemattrtext (

475: aname => 'AMW_APPROVAL_OBJECT_MEANING'
476: );
477:
478: l_CTRL_rev_id :=
479: wf_engine.getitemattrtext (
480: itemtype=> l_item_type,
481: itemkey=> l_item_key,
482: aname => 'AMW_OBJECT_ID'
483: );

Line 485: wf_engine.getitemattrtext (

481: itemkey=> l_item_key,
482: aname => 'AMW_OBJECT_ID'
483: );
484: l_note :=
485: wf_engine.getitemattrtext (
486: itemtype=> l_item_type,
487: itemkey=> l_item_key,
488: aname => 'AMW_NOTES_FROM_REQUESTOR'
489: );

Line 491: wf_engine.getitemattrtext (

487: itemkey=> l_item_key,
488: aname => 'AMW_NOTES_FROM_REQUESTOR'
489: );
490: l_approver :=
491: wf_engine.getitemattrtext (
492: itemtype=> l_item_type,
493: itemkey=> l_item_key,
494: aname => 'AMW_APPROVER'
495: );

Line 498: wf_engine.getitemattrtext (

494: aname => 'AMW_APPROVER'
495: );
496: /*
497: l_requestor :=
498: wf_engine.getitemattrtext (
499: itemtype=> l_item_type,
500: itemkey=> l_item_key,
501: aname => 'AMW_REQUESTOR'
502: );

Line 515: wf_engine.setitemattrtext (

511: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
512: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
513: l_string := Substr(FND_MESSAGE.Get,1,1000);
514: /*
515: wf_engine.setitemattrtext (
516: itemtype=> l_item_type,
517: itemkey=> l_item_key,
518: aname => 'REJECT_SUBJECT',
519: avalue=> l_string

Line 532: l_note := wf_engine.getitemattrtext(

528: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
529: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
530: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
531: /*
532: l_note := wf_engine.getitemattrtext(
533: itemtype => l_item_type
534: ,itemkey => l_item_key
535: ,aname => 'NOTE');
536:

Line 539: wf_engine.getitemattrtext(

535: ,aname => 'NOTE');
536:
537:
538: l_forwarder :=
539: wf_engine.getitemattrtext(
540: itemtype => l_item_type
541: ,itemkey => l_item_key
542: ,aname => 'AMW_FORWARD_FROM_USERNAME');
543: */

Line 547: wf_engine.getitemattrtext (

543: */
544:
545:
546: l_note :=
547: wf_engine.getitemattrtext (
548: itemtype=> l_item_type,
549: itemkey=> l_item_key,
550: aname => 'APPROVAL_NOTE'
551: );

Line 654: wf_engine.getitemattrtext (

650: - 1);
651: l_item_key := SUBSTR (document_id, l_hyphen_pos1
652: + 1);
653: l_OBJECT_type :=
654: wf_engine.getitemattrtext (
655: itemtype=> l_item_type,
656: itemkey=> l_item_key,
657: aname => 'AMW_OBJECT_TYPE'
658: );

Line 660: wf_engine.getitemattrtext (

656: itemkey=> l_item_key,
657: aname => 'AMW_OBJECT_TYPE'
658: );
659: l_CTRL_rev_id :=
660: wf_engine.getitemattrtext (
661: itemtype=> l_item_type,
662: itemkey=> l_item_key,
663: aname => 'AMW_OBJECT_ID'
664: );

Line 666: wf_engine.getitemattrtext (

662: itemkey=> l_item_key,
663: aname => 'AMW_OBJECT_ID'
664: );
665: l_note :=
666: wf_engine.getitemattrtext (
667: itemtype=> l_item_type,
668: itemkey=> l_item_key,
669: aname => 'AMW_NOTES_FROM_REQUESTOR'
670: );

Line 672: wf_engine.getitemattrtext (

668: itemkey=> l_item_key,
669: aname => 'AMW_NOTES_FROM_REQUESTOR'
670: );
671: l_approver :=
672: wf_engine.getitemattrtext (
673: itemtype=> l_item_type,
674: itemkey=> l_item_key,
675: aname => 'AMW_APPROVER_DISPLAY_NAME'
676: );

Line 679: wf_engine.getitemattrtext (

675: aname => 'AMW_APPROVER_DISPLAY_NAME'
676: );
677: /*
678: l_requestor :=
679: wf_engine.getitemattrtext (
680: itemtype=> l_item_type,
681: itemkey=> l_item_key,
682: aname => 'AMW_REQUESTOR'
683: );

Line 697: wf_engine.setitemattrtext (

693: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
694: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
695: l_string := SUBSTR(fnd_message.get,1,1000);
696: /*
697: wf_engine.setitemattrtext (
698: itemtype=> l_item_type,
699: itemkey=> l_item_key,
700: aname => 'APP_SUBJECT',
701: avalue=> l_string

Line 712: NVL(wf_engine.getitemattrtext (

708: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
709: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
710: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
711: l_note :=
712: NVL(wf_engine.getitemattrtext (
713: itemtype=> l_item_type,
714: itemkey=> l_item_key,
715: aname => 'AMW_PREV_APPROVER_NOTE'
716: ),'-');

Line 718: NVL(wf_engine.getitemattrtext (

714: itemkey=> l_item_key,
715: aname => 'AMW_PREV_APPROVER_NOTE'
716: ),'-');
717: l_forwarder :=
718: NVL(wf_engine.getitemattrtext (
719: itemtype=> l_item_type,
720: itemkey=> l_item_key,
721: aname => 'AMW_PREV_APPROVER_DISP_NAME'
722: ),'-');

Line 723: l_approval_date := NVL(to_char(wf_engine.getitemattrdate (

719: itemtype=> l_item_type,
720: itemkey=> l_item_key,
721: aname => 'AMW_PREV_APPROVER_DISP_NAME'
722: ),'-');
723: l_approval_date := NVL(to_char(wf_engine.getitemattrdate (
724: itemtype => l_item_type,
725: itemkey => l_item_key,
726: aname => 'AMW_APPROVAL_DATE')),'-');
727:

Line 842: wf_engine.getitemattrtext (

838: - 1);
839: l_item_key := SUBSTR (document_id, l_hyphen_pos1
840: + 1);
841: l_OBJECT_type :=
842: wf_engine.getitemattrtext (
843: itemtype=> l_item_type,
844: itemkey=> l_item_key,
845: aname => 'AMW_OBJECT_TYPE'
846: );

Line 848: wf_engine.getitemattrtext (

844: itemkey=> l_item_key,
845: aname => 'AMW_OBJECT_TYPE'
846: );
847: l_OBJECT_meaning :=
848: wf_engine.getitemattrtext (
849: itemtype=> l_item_type,
850: itemkey=> l_item_key,
851: aname => 'AMW_APPROVAL_OBJECT_MEANING'
852: );

Line 854: wf_engine.getitemattrtext (

850: itemkey=> l_item_key,
851: aname => 'AMW_APPROVAL_OBJECT_MEANING'
852: );
853: l_CTRL_rev_id :=
854: wf_engine.getitemattrtext (
855: itemtype=> l_item_type,
856: itemkey=> l_item_key,
857: aname => 'AMW_OBJECT_ID'
858: );

Line 860: wf_engine.getitemattrtext (

856: itemkey=> l_item_key,
857: aname => 'AMW_OBJECT_ID'
858: );
859: l_note :=
860: wf_engine.getitemattrtext (
861: itemtype=> l_item_type,
862: itemkey=> l_item_key,
863: aname => 'AMW_NOTES_FROM_REQUESTOR'
864: );

Line 866: wf_engine.getitemattrtext (

862: itemkey=> l_item_key,
863: aname => 'AMW_NOTES_FROM_REQUESTOR'
864: );
865: l_approver :=
866: wf_engine.getitemattrtext (
867: itemtype=> l_item_type,
868: itemkey=> l_item_key,
869: aname => 'AMW_APPROVER_DISPLAY_NAME'
870: );

Line 872: wf_engine.getitemattrtext (

868: itemkey=> l_item_key,
869: aname => 'AMW_APPROVER_DISPLAY_NAME'
870: );
871: l_requestor :=
872: wf_engine.getitemattrtext (
873: itemtype=> l_item_type,
874: itemkey=> l_item_key,
875: aname => 'AMW_REQUESTOR'
876: );

Line 887: wf_engine.setitemattrtext (

883: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
884: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
885: l_string := SUBSTR(fnd_message.get,1,1000);
886: /*
887: wf_engine.setitemattrtext (
888: itemtype=> l_item_type,
889: itemkey=> l_item_key,
890: aname => 'APP_SUBJECT',
891: avalue=> l_string

Line 902: NVL(wf_engine.getitemattrtext (

898: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
899:
900:
901: l_note :=
902: NVL(wf_engine.getitemattrtext (
903: itemtype=> l_item_type,
904: itemkey=> l_item_key,
905: aname => 'AMW_PREV_APPROVER_NOTE'
906: ),'-');

Line 908: NVL(wf_engine.getitemattrtext (

904: itemkey=> l_item_key,
905: aname => 'AMW_PREV_APPROVER_NOTE'
906: ),'-');
907: l_forwarder :=
908: NVL(wf_engine.getitemattrtext (
909: itemtype=> l_item_type,
910: itemkey=> l_item_key,
911: aname => 'AMW_PREV_APPROVER_DISP_NAME'
912: ),'-');

Line 913: l_approval_date := NVL(to_char(wf_engine.getitemattrdate (

909: itemtype=> l_item_type,
910: itemkey=> l_item_key,
911: aname => 'AMW_PREV_APPROVER_DISP_NAME'
912: ),'-');
913: l_approval_date := NVL(to_char(wf_engine.getitemattrdate (
914: itemtype => l_item_type,
915: itemkey => l_item_key,
916: aname => 'AMW_APPROVAL_DATE')),'-');
917:

Line 925: l_note := wf_engine.getitemattrtext(

921: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
922: fnd_message.set_token ('COMMENTS', l_note, FALSE);
923: l_string2 := SUBSTR(fnd_message.get,1,2500);
924: /*
925: l_note := wf_engine.getitemattrtext(
926: itemtype => l_item_type
927: ,itemkey => l_item_key
928: ,aname => 'NOTE');
929:

Line 932: wf_engine.getitemattrtext(

928: ,aname => 'NOTE');
929:
930:
931: l_forwarder :=
932: wf_engine.getitemattrtext(
933: itemtype => l_item_type
934: ,itemkey => l_item_key
935: ,aname => 'AMW_FORWARD_FROM_USERNAME');
936: */

Line 1027: wf_engine.getitemattrnumber (

1023: WHERE control_rev_id = p_CTRL_rev_id;
1024: BEGIN
1025: fnd_msg_pub.initialize;
1026: l_OBJECT_id :=
1027: wf_engine.getitemattrnumber (
1028: itemtype=> itemtype,
1029: itemkey=> itemkey,
1030: aname => 'AMW_OBJECT_ID'
1031: );

Line 1055: wf_engine.setitemattrtext (

1051: FALSE
1052: );
1053:
1054: l_string := Substr(FND_MESSAGE.Get,1,1000);
1055: wf_engine.setitemattrtext (
1056: itemtype=> itemtype,
1057: itemkey=> itemkey,
1058: aname => 'FYI_SUBJECT',
1059: avalue=> l_string

Line 1071: wf_engine.setitemattrtext (

1067: FALSE
1068: );
1069:
1070: l_string := Substr(FND_MESSAGE.Get,1,1000);
1071: wf_engine.setitemattrtext (
1072: itemtype=> itemtype,
1073: itemkey=> itemkey,
1074: aname => 'APRV_SUBJECT',
1075: avalue=> l_string

Line 1090: wf_engine.setitemattrtext (

1086: FALSE
1087: );
1088:
1089: l_string := Substr(FND_MESSAGE.Get,1,1000);
1090: wf_engine.setitemattrtext (
1091: itemtype=> itemtype,
1092: itemkey=> itemkey,
1093: aname => 'REJECT_SUBJECT',
1094: avalue=> l_string

Line 1109: wf_engine.setitemattrtext (

1105: FALSE
1106: );
1107:
1108: l_string := Substr(FND_MESSAGE.Get,1,1000);
1109: wf_engine.setitemattrtext (
1110: itemtype=> itemtype,
1111: itemkey=> itemkey,
1112: aname => 'APP_SUBJECT',
1113: avalue=> l_string

Line 1116: wf_engine.setitemattrtext (

1112: aname => 'APP_SUBJECT',
1113: avalue=> l_string
1114: );
1115:
1116: wf_engine.setitemattrtext (
1117: itemtype=> itemtype,
1118: itemkey=> itemkey,
1119: aname => 'AMW_APPROVAL_OBJECT_MEANING',
1120: avalue=> l_lookup_meaning

Line 1122: wf_engine.setitemattrtext (

1118: itemkey=> itemkey,
1119: aname => 'AMW_APPROVAL_OBJECT_MEANING',
1120: avalue=> l_lookup_meaning
1121: );
1122: wf_engine.setitemattrtext (
1123: itemtype=> itemtype,
1124: itemkey=> itemkey,
1125: aname => 'AMW_APPROVAL_OBJECT_NAME',
1126: avalue=> l_CTRL_name

Line 1263: wf_engine.getitemattrtext (

1259: IF ( funcmode = 'RUN' ) THEN
1260: -- Item attribute UPDATE_GEN_STATUS will be'set to APPROVED'if the Object is approved
1261: -- and 'REJECTED' if the object is rejected.
1262: l_update_status :=
1263: wf_engine.getitemattrtext (
1264: itemtype=> itemtype,
1265: itemkey=> itemkey,
1266: aname => 'UPDATE_GEN_STATUS'
1267: );

Line 1269: wf_engine.getitemattrtext (

1265: itemkey=> itemkey,
1266: aname => 'UPDATE_GEN_STATUS'
1267: );
1268: l_approver :=
1269: wf_engine.getitemattrtext (
1270: itemtype=> itemtype,
1271: itemkey=> itemkey,
1272: aname => 'AMW_APPROVER'
1273: );

Line 1275: wf_engine.getitemattrtext (

1271: itemkey=> itemkey,
1272: aname => 'AMW_APPROVER'
1273: );
1274: l_approver_id :=
1275: wf_engine.getitemattrtext (
1276: itemtype=> itemtype,
1277: itemkey=> itemkey,
1278: aname => 'AMW_APPROVER_ID'
1279: );

Line 1281: wf_engine.getitemattrtext (

1277: itemkey=> itemkey,
1278: aname => 'AMW_APPROVER_ID'
1279: );
1280: l_requestor_id :=
1281: wf_engine.getitemattrtext (
1282: itemtype=> itemtype,
1283: itemkey=> itemkey,
1284: aname => 'AMW_REQUESTOR_ID'
1285: );

Line 1288: wf_engine.getitemattrnumber (

1284: aname => 'AMW_REQUESTOR_ID'
1285: );
1286:
1287: l_object_version_number :=
1288: wf_engine.getitemattrnumber (
1289: itemtype=> itemtype,
1290: itemkey=> itemkey,
1291: aname => 'AMW_OBJECT_VERSION_NUMBER'
1292: );

Line 1294: wf_engine.getitemattrnumber (

1290: itemkey=> itemkey,
1291: aname => 'AMW_OBJECT_VERSION_NUMBER'
1292: );
1293: l_CTRL_rev_id :=
1294: wf_engine.getitemattrnumber (
1295: itemtype=> itemtype,
1296: itemkey=> itemkey,
1297: aname => 'AMW_OBJECT_ID'
1298: );