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.OZF_FUND_APPROVAL_PVT dependencies on WF_ENGINE

Line 154: wf_engine.getitemattrtext (

150: - 1);
151: l_item_key := SUBSTR (document_id, l_hyphen_pos1
152: + 1);
153: l_activity_type :=
154: wf_engine.getitemattrtext (
155: itemtype=> l_item_type,
156: itemkey=> l_item_key,
157: aname => 'AMS_ACTIVITY_TYPE'
158: );

Line 160: wf_engine.getitemattrtext (

156: itemkey=> l_item_key,
157: aname => 'AMS_ACTIVITY_TYPE'
158: );
159: l_fund_id :=
160: wf_engine.getitemattrtext (
161: itemtype=> l_item_type,
162: itemkey=> l_item_key,
163: aname => 'AMS_ACTIVITY_ID'
164: );

Line 166: wf_engine.getitemattrtext (

162: itemkey=> l_item_key,
163: aname => 'AMS_ACTIVITY_ID'
164: );
165: l_requested_amt :=
166: wf_engine.getitemattrtext (
167: itemtype=> l_item_type,
168: itemkey=> l_item_key,
169: aname => 'AMS_REQUESTED_AMOUNT'
170: );

Line 172: wf_engine.getitemattrtext (

168: itemkey=> l_item_key,
169: aname => 'AMS_REQUESTED_AMOUNT'
170: );
171: l_note :=
172: wf_engine.getitemattrtext (
173: itemtype=> l_item_type,
174: itemkey=> l_item_key,
175: aname => 'AMS_NOTES_FROM_REQUESTOR'
176: );

Line 178: wf_engine.getitemattrtext (

174: itemkey=> l_item_key,
175: aname => 'AMS_NOTES_FROM_REQUESTOR'
176: );
177: l_approver :=
178: wf_engine.getitemattrtext (
179: itemtype=> l_item_type,
180: itemkey=> l_item_key,
181: aname => 'AMS_APPROVER_DISPLAY_NAME'
182: );

Line 210: wf_engine.setitemattrtext (

206: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
207: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
208: l_string := SUBSTR(fnd_message.get,1,1000);
209: /*
210: wf_engine.setitemattrtext (
211: itemtype=> l_item_type,
212: itemkey=> l_item_key,
213: aname => 'FYI_SUBJECT',
214: avalue=> l_string

Line 230: l_note := wf_engine.getitemattrtext(

226: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
227: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
228: --l_string1 := fnd_message.get;
229: /*
230: l_note := wf_engine.getitemattrtext(
231: itemtype => l_item_type
232: ,itemkey => l_item_key
233: ,aname => 'NOTE');
234: l_forwarder :=

Line 235: wf_engine.getitemattrtext(

231: itemtype => l_item_type
232: ,itemkey => l_item_key
233: ,aname => 'NOTE');
234: l_forwarder :=
235: wf_engine.getitemattrtext(
236: itemtype => l_item_type
237: ,itemkey => l_item_key
238: ,aname => 'AMS_FORWARD_FROM_USERNAME');
239: */

Line 365: wf_engine.getitemattrtext (

361: - 1);
362: l_item_key := SUBSTR (document_id, l_hyphen_pos1
363: + 1);
364: l_activity_type :=
365: wf_engine.getitemattrtext (
366: itemtype=> l_item_type,
367: itemkey=> l_item_key,
368: aname => 'AMS_ACTIVITY_TYPE'
369: );

Line 371: wf_engine.getitemattrtext (

367: itemkey=> l_item_key,
368: aname => 'AMS_ACTIVITY_TYPE'
369: );
370: l_fund_id :=
371: wf_engine.getitemattrtext (
372: itemtype=> l_item_type,
373: itemkey=> l_item_key,
374: aname => 'AMS_ACTIVITY_ID'
375: );

Line 377: wf_engine.getitemattrtext (

373: itemkey=> l_item_key,
374: aname => 'AMS_ACTIVITY_ID'
375: );
376: l_approved_amt :=
377: wf_engine.getitemattrtext (
378: itemtype=> l_item_type,
379: itemkey=> l_item_key,
380: aname => 'AMS_AMOUNT'
381: );

Line 383: wf_engine.getitemattrtext (

379: itemkey=> l_item_key,
380: aname => 'AMS_AMOUNT'
381: );
382: l_note :=
383: wf_engine.getitemattrtext (
384: itemtype=> l_item_type,
385: itemkey=> l_item_key,
386: aname => 'AMS_NOTES_FROM_REQUESTOR'
387: );

Line 389: wf_engine.getitemattrtext (

385: itemkey=> l_item_key,
386: aname => 'AMS_NOTES_FROM_REQUESTOR'
387: );
388: l_approver :=
389: wf_engine.getitemattrtext (
390: itemtype=> l_item_type,
391: itemkey=> l_item_key,
392: aname => 'AMS_APPROVER'
393: );

Line 396: wf_engine.getitemattrtext (

392: aname => 'AMS_APPROVER'
393: );
394: -- yzhao: 01/28/2003 get requested amount from workflow. After approval, requested_amount may not equal orignal_budget
395: l_requested_amt :=
396: wf_engine.getitemattrtext (
397: itemtype=> l_item_type,
398: itemkey=> l_item_key,
399: aname => 'AMS_REQUESTED_AMOUNT'
400: );

Line 442: l_note := wf_engine.getitemattrtext(

438: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
439: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
440: --l_string1 := fnd_message.get;
441: /*
442: l_note := wf_engine.getitemattrtext(
443: itemtype => l_item_type
444: ,itemkey => l_item_key
445: ,aname => 'NOTE');
446: l_forwarder :=

Line 447: wf_engine.getitemattrtext(

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

Line 454: wf_engine.getitemattrtext (

450: ,aname => 'AMS_FORWARD_FROM_USERNAME');
451: */
452: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL */
453: l_approver_note :=
454: wf_engine.getitemattrtext (
455: itemtype=> l_item_type,
456: itemkey=> l_item_key,
457: aname => 'APPROVAL_NOTE'
458: );

Line 572: wf_engine.getitemattrtext (

568: - 1);
569: l_item_key := SUBSTR (document_id, l_hyphen_pos1
570: + 1);
571: l_activity_type :=
572: wf_engine.getitemattrtext (
573: itemtype=> l_item_type,
574: itemkey=> l_item_key,
575: aname => 'AMS_ACTIVITY_TYPE'
576: );

Line 578: wf_engine.getitemattrtext (

574: itemkey=> l_item_key,
575: aname => 'AMS_ACTIVITY_TYPE'
576: );
577: l_fund_id :=
578: wf_engine.getitemattrtext (
579: itemtype=> l_item_type,
580: itemkey=> l_item_key,
581: aname => 'AMS_ACTIVITY_ID'
582: );

Line 584: wf_engine.getitemattrtext (

580: itemkey=> l_item_key,
581: aname => 'AMS_ACTIVITY_ID'
582: );
583: l_note :=
584: wf_engine.getitemattrtext (
585: itemtype=> l_item_type,
586: itemkey=> l_item_key,
587: aname => 'AMS_NOTES_FROM_REQUESTOR'
588: );

Line 590: wf_engine.getitemattrtext (

586: itemkey=> l_item_key,
587: aname => 'AMS_NOTES_FROM_REQUESTOR'
588: );
589: l_approver :=
590: wf_engine.getitemattrtext (
591: itemtype=> l_item_type,
592: itemkey=> l_item_key,
593: aname => 'AMS_APPROVER'
594: );

Line 597: wf_engine.getitemattrtext (

593: aname => 'AMS_APPROVER'
594: );
595: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608): request_amount, owner not shown in reject notification */
596: l_requested_amt :=
597: wf_engine.getitemattrtext (
598: itemtype=> l_item_type,
599: itemkey=> l_item_key,
600: aname => 'AMS_REQUESTED_AMOUNT'
601: );

Line 603: wf_engine.getitemattrtext (

599: itemkey=> l_item_key,
600: aname => 'AMS_REQUESTED_AMOUNT'
601: );
602: l_requester :=
603: wf_engine.getitemattrtext (
604: itemtype=> l_item_type,
605: itemkey=> l_item_key,
606: aname => 'AMS_REQUESTER'
607: );

Line 637: wf_engine.setitemattrtext (

633: --fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
634: l_string := Substr(FND_MESSAGE.Get,1,1000);
635: --l_string := fnd_message.get;
636: /*
637: wf_engine.setitemattrtext (
638: itemtype=> l_item_type,
639: itemkey=> l_item_key,
640: aname => 'REJECT_SUBJECT',
641: avalue=> l_string

Line 656: l_note := wf_engine.getitemattrtext(

652: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
653: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
654: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
655: /*
656: l_note := wf_engine.getitemattrtext(
657: itemtype => l_item_type
658: ,itemkey => l_item_key
659: ,aname => 'NOTE');
660: l_forwarder :=

Line 661: wf_engine.getitemattrtext(

657: itemtype => l_item_type
658: ,itemkey => l_item_key
659: ,aname => 'NOTE');
660: l_forwarder :=
661: wf_engine.getitemattrtext(
662: itemtype => l_item_type
663: ,itemkey => l_item_key
664: ,aname => 'AMS_FORWARD_FROM_USERNAME');
665: */

Line 668: wf_engine.getitemattrtext (

664: ,aname => 'AMS_FORWARD_FROM_USERNAME');
665: */
666: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVer's NOTE NOT SHOWING IN rejection EMAIL */
667: l_note :=
668: wf_engine.getitemattrtext (
669: itemtype=> l_item_type,
670: itemkey=> l_item_key,
671: aname => 'APPROVAL_NOTE'
672: );

Line 788: wf_engine.getitemattrtext (

784: - 1);
785: l_item_key := SUBSTR (document_id, l_hyphen_pos1
786: + 1);
787: l_activity_type :=
788: wf_engine.getitemattrtext (
789: itemtype=> l_item_type,
790: itemkey=> l_item_key,
791: aname => 'AMS_ACTIVITY_TYPE'
792: );

Line 794: wf_engine.getitemattrtext (

790: itemkey=> l_item_key,
791: aname => 'AMS_ACTIVITY_TYPE'
792: );
793: l_fund_id :=
794: wf_engine.getitemattrtext (
795: itemtype=> l_item_type,
796: itemkey=> l_item_key,
797: aname => 'AMS_ACTIVITY_ID'
798: );

Line 800: wf_engine.getitemattrtext (

796: itemkey=> l_item_key,
797: aname => 'AMS_ACTIVITY_ID'
798: );
799: l_note :=
800: wf_engine.getitemattrtext (
801: itemtype=> l_item_type,
802: itemkey=> l_item_key,
803: aname => 'AMS_NOTES_FROM_REQUESTOR'
804: );

Line 806: wf_engine.getitemattrtext (

802: itemkey=> l_item_key,
803: aname => 'AMS_NOTES_FROM_REQUESTOR'
804: );
805: l_approver :=
806: wf_engine.getitemattrtext (
807: itemtype=> l_item_type,
808: itemkey=> l_item_key,
809: aname => 'AMS_APPROVER_DISPLAY_NAME'
810: );

Line 812: wf_engine.getitemattrtext (

808: itemkey=> l_item_key,
809: aname => 'AMS_APPROVER_DISPLAY_NAME'
810: );
811: l_requested_amt :=
812: wf_engine.getitemattrtext (
813: itemtype=> l_item_type,
814: itemkey=> l_item_key,
815: aname => 'AMS_REQUESTED_AMOUNT'
816: );

Line 818: wf_engine.getitemattrtext (

814: itemkey=> l_item_key,
815: aname => 'AMS_REQUESTED_AMOUNT'
816: );
817: l_requester :=
818: wf_engine.getitemattrtext (
819: itemtype=> l_item_type,
820: itemkey=> l_item_key,
821: aname => 'AMS_REQUESTER'
822: );

Line 851: wf_engine.setitemattrtext (

847: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
848: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
849: l_string := SUBSTR(fnd_message.get,1,1000);
850: /*
851: wf_engine.setitemattrtext (
852: itemtype=> l_item_type,
853: itemkey=> l_item_key,
854: aname => 'APP_SUBJECT',
855: avalue=> l_string

Line 870: NVL(wf_engine.getitemattrtext (

866: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
867: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
868: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
869: l_note :=
870: NVL(wf_engine.getitemattrtext (
871: itemtype=> l_item_type,
872: itemkey=> l_item_key,
873: aname => 'AMS_PREV_APPROVER_NOTE'
874: ),'-');

Line 876: NVL(wf_engine.getitemattrtext (

872: itemkey=> l_item_key,
873: aname => 'AMS_PREV_APPROVER_NOTE'
874: ),'-');
875: l_forwarder :=
876: NVL(wf_engine.getitemattrtext (
877: itemtype=> l_item_type,
878: itemkey=> l_item_key,
879: aname => 'AMS_PREV_APPROVER_DISP_NAME'
880: ),'-');

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

877: itemtype=> l_item_type,
878: itemkey=> l_item_key,
879: aname => 'AMS_PREV_APPROVER_DISP_NAME'
880: ),'-');
881: l_approval_date := NVL(to_char(wf_engine.getitemattrdate (
882: itemtype => l_item_type,
883: itemkey => l_item_key,
884: aname => 'AMS_APPROVAL_DATE')),'-');
885: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');

Line 1003: wf_engine.getitemattrtext (

999: - 1);
1000: l_item_key := SUBSTR (document_id, l_hyphen_pos1
1001: + 1);
1002: l_activity_type :=
1003: wf_engine.getitemattrtext (
1004: itemtype=> l_item_type,
1005: itemkey=> l_item_key,
1006: aname => 'AMS_ACTIVITY_TYPE'
1007: );

Line 1009: wf_engine.getitemattrtext (

1005: itemkey=> l_item_key,
1006: aname => 'AMS_ACTIVITY_TYPE'
1007: );
1008: l_fund_id :=
1009: wf_engine.getitemattrtext (
1010: itemtype=> l_item_type,
1011: itemkey=> l_item_key,
1012: aname => 'AMS_ACTIVITY_ID'
1013: );

Line 1015: wf_engine.getitemattrtext (

1011: itemkey=> l_item_key,
1012: aname => 'AMS_ACTIVITY_ID'
1013: );
1014: l_note :=
1015: wf_engine.getitemattrtext (
1016: itemtype=> l_item_type,
1017: itemkey=> l_item_key,
1018: aname => 'AMS_NOTES_FROM_REQUESTOR'
1019: );

Line 1021: wf_engine.getitemattrtext (

1017: itemkey=> l_item_key,
1018: aname => 'AMS_NOTES_FROM_REQUESTOR'
1019: );
1020: l_approver :=
1021: wf_engine.getitemattrtext (
1022: itemtype=> l_item_type,
1023: itemkey=> l_item_key,
1024: aname => 'AMS_APPROVER'
1025: );

Line 1027: wf_engine.getitemattrtext (

1023: itemkey=> l_item_key,
1024: aname => 'AMS_APPROVER'
1025: );
1026: l_requested_amt :=
1027: wf_engine.getitemattrtext (
1028: itemtype=> l_item_type,
1029: itemkey=> l_item_key,
1030: aname => 'AMS_REQUESTED_AMOUNT'
1031: );

Line 1033: wf_engine.getitemattrtext (

1029: itemkey=> l_item_key,
1030: aname => 'AMS_REQUESTED_AMOUNT'
1031: );
1032: l_requester :=
1033: wf_engine.getitemattrtext (
1034: itemtype=> l_item_type,
1035: itemkey=> l_item_key,
1036: aname => 'AMS_REQUESTER'
1037: );

Line 1065: wf_engine.setitemattrtext (

1061: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1062: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1063: l_string := SUBSTR(fnd_message.get,1,1000);
1064: /*
1065: wf_engine.setitemattrtext (
1066: itemtype=> l_item_type,
1067: itemkey=> l_item_key,
1068: aname => 'APP_SUBJECT',
1069: avalue=> l_string

Line 1084: NVL(wf_engine.getitemattrtext (

1080: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
1081: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1082: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1083: l_note :=
1084: NVL(wf_engine.getitemattrtext (
1085: itemtype=> l_item_type,
1086: itemkey=> l_item_key,
1087: aname => 'AMS_PREV_APPROVER_NOTE'
1088: ),'-');

Line 1090: NVL(wf_engine.getitemattrtext (

1086: itemkey=> l_item_key,
1087: aname => 'AMS_PREV_APPROVER_NOTE'
1088: ),'-');
1089: l_forwarder :=
1090: NVL(wf_engine.getitemattrtext (
1091: itemtype=> l_item_type,
1092: itemkey=> l_item_key,
1093: aname => 'AMS_PREV_APPROVER_DISP_NAME'
1094: ),'-');

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

1091: itemtype=> l_item_type,
1092: itemkey=> l_item_key,
1093: aname => 'AMS_PREV_APPROVER_DISP_NAME'
1094: ),'-');
1095: l_approval_date := NVL(to_char(wf_engine.getitemattrdate (
1096: itemtype => l_item_type,
1097: itemkey => l_item_key,
1098: aname => 'AMS_APPROVAL_DATE')),'-');
1099: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

Line 1111: l_note := wf_engine.getitemattrtext(

1107: */
1108: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
1109: l_string2 := SUBSTR(fnd_message.get,1,2500);
1110: /*
1111: l_note := wf_engine.getitemattrtext(
1112: itemtype => l_item_type
1113: ,itemkey => l_item_key
1114: ,aname => 'NOTE');
1115: l_forwarder :=

Line 1116: wf_engine.getitemattrtext(

1112: itemtype => l_item_type
1113: ,itemkey => l_item_key
1114: ,aname => 'NOTE');
1115: l_forwarder :=
1116: wf_engine.getitemattrtext(
1117: itemtype => l_item_type
1118: ,itemkey => l_item_key
1119: ,aname => 'AMS_FORWARD_FROM_USERNAME');
1120: */

Line 1219: wf_engine.getitemattrnumber (

1215: WHERE fund_id = p_act_id;
1216: BEGIN
1217: fnd_msg_pub.initialize;
1218: l_activity_id :=
1219: wf_engine.getitemattrnumber (
1220: itemtype=> itemtype,
1221: itemkey=> itemkey,
1222: aname => 'AMS_ACTIVITY_ID'
1223: );

Line 1267: wf_engine.setitemattrnumber (

1263: ( p_user_id => l_object_details.owner_id,
1264: x_full_name => l_full_name,
1265: x_return_status => l_return_status );
1266: */
1267: wf_engine.setitemattrnumber (
1268: itemtype=> itemtype,
1269: itemkey=> itemkey,
1270: aname => 'AMS_APPROVAL_DETAIL_ID',
1271: avalue=> l_approval_detail_id

Line 1273: wf_engine.setitemattrnumber (

1269: itemkey=> itemkey,
1270: aname => 'AMS_APPROVAL_DETAIL_ID',
1271: avalue=> l_approval_detail_id
1272: );
1273: wf_engine.setitemattrnumber (
1274: itemtype=> itemtype,
1275: itemkey=> itemkey,
1276: aname => 'AMS_APPROVER_SEQ',
1277: avalue=> l_approver_seq

Line 1279: wf_engine.setitemattrnumber (

1275: itemkey=> itemkey,
1276: aname => 'AMS_APPROVER_SEQ',
1277: avalue=> l_approver_seq
1278: );
1279: wf_engine.setitemattrnumber (
1280: itemtype=> itemtype,
1281: itemkey=> itemkey,
1282: aname => 'AMS_REQUESTED_AMOUNT',
1283: avalue=> l_object_details.total_header_amount

Line 1305: wf_engine.setitemattrtext (

1301: );
1302: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1303: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE); -- ##
1304: l_string := fnd_message.get;
1305: wf_engine.setitemattrtext (
1306: itemtype=> itemtype,
1307: itemkey=> itemkey,
1308: aname => 'FYI_SUBJECT',
1309: avalue=> l_string

Line 1319: wf_engine.setitemattrtext (

1315: --fnd_message.set_token ('AMOUNT',l_object_details.total_header_amount, FALSE);
1316: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1317: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1318: l_string := fnd_message.get;
1319: wf_engine.setitemattrtext (
1320: itemtype=> itemtype,
1321: itemkey=> itemkey,
1322: aname => 'APRV_SUBJECT',
1323: avalue=> l_string

Line 1345: wf_engine.setitemattrtext (

1341: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1342: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1343: -- yzhao: not a token in message fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE); -- ##
1344: l_string := fnd_message.get;
1345: wf_engine.setitemattrtext (
1346: itemtype=> itemtype,
1347: itemkey=> itemkey,
1348: aname => 'REJECT_SUBJECT',
1349: avalue=> l_string

Line 1371: wf_engine.setitemattrtext (

1367: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1368: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1369: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1370: l_string := fnd_message.get;
1371: wf_engine.setitemattrtext (
1372: itemtype=> itemtype,
1373: itemkey=> itemkey,
1374: aname => 'APP_SUBJECT',
1375: avalue=> l_string

Line 1379: wf_engine.setitemattrtext (

1375: avalue=> l_string
1376: );
1377: /* mpande added for implementation of BUG#2352621*/
1378: l_lookup_meaning := ozf_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER','RFRQ');
1379: wf_engine.setitemattrtext (
1380: itemtype=> itemtype,
1381: itemkey=> itemkey,
1382: aname => 'AMS_APPROVAL_OBJECT_MEANING',
1383: avalue=> l_lookup_meaning

Line 1385: wf_engine.setitemattrtext (

1381: itemkey=> itemkey,
1382: aname => 'AMS_APPROVAL_OBJECT_MEANING',
1383: avalue=> l_lookup_meaning
1384: );
1385: wf_engine.setitemattrtext (
1386: itemtype=> itemtype,
1387: itemkey=> itemkey,
1388: aname => 'AMS_APPROVAL_OBJECT_NAME',
1389: avalue=> l_object_details.name

Line 1574: wf_engine.getitemattrtext (

1570: BEGIN
1571: SAVEPOINT update_parbudget_status ;
1572: IF funcmode = 'RUN' THEN
1573: l_update_status :=
1574: wf_engine.getitemattrtext (
1575: itemtype=> itemtype,
1576: itemkey=> itemkey,
1577: aname => 'UPDATE_GEN_STATUS'
1578: );

Line 1580: wf_engine.getitemattrnumber (

1576: itemkey=> itemkey,
1577: aname => 'UPDATE_GEN_STATUS'
1578: );
1579: l_approved_amount :=
1580: wf_engine.getitemattrnumber (
1581: itemtype=> itemtype,
1582: itemkey=> itemkey,
1583: aname => 'AMS_AMOUNT'
1584: );

Line 1586: wf_engine.getitemattrtext (

1582: itemkey=> itemkey,
1583: aname => 'AMS_AMOUNT'
1584: );
1585: l_approver :=
1586: wf_engine.getitemattrtext (
1587: itemtype=> itemtype,
1588: itemkey=> itemkey,
1589: aname => 'AMS_APPROVER'
1590: );

Line 1592: wf_engine.getitemattrtext (

1588: itemkey=> itemkey,
1589: aname => 'AMS_APPROVER'
1590: );
1591: l_approver_id :=
1592: wf_engine.getitemattrtext (
1593: itemtype=> itemtype,
1594: itemkey=> itemkey,
1595: aname => 'AMS_APPROVER_ID'
1596: );

Line 1598: wf_engine.getitemattrtext (

1594: itemkey=> itemkey,
1595: aname => 'AMS_APPROVER_ID'
1596: );
1597: l_requester_id :=
1598: wf_engine.getitemattrtext (
1599: itemtype=> itemtype,
1600: itemkey=> itemkey,
1601: aname => 'AMS_REQUESTER_ID'
1602: );

Line 1604: wf_engine.getitemattrnumber (

1600: itemkey=> itemkey,
1601: aname => 'AMS_REQUESTER_ID'
1602: );
1603: l_requested_amt :=
1604: wf_engine.getitemattrnumber (
1605: itemtype=> itemtype,
1606: itemkey=> itemkey,
1607: aname => 'AMS_REQUESTED_AMOUNT'
1608: );

Line 1610: wf_engine.getitemattrnumber (

1606: itemkey=> itemkey,
1607: aname => 'AMS_REQUESTED_AMOUNT'
1608: );
1609: l_object_version_number :=
1610: wf_engine.getitemattrnumber (
1611: itemtype=> itemtype,
1612: itemkey=> itemkey,
1613: aname => 'AMS_OBJECT_VERSION_NUMBER'
1614: );

Line 1616: wf_engine.getitemattrnumber (

1612: itemkey=> itemkey,
1613: aname => 'AMS_OBJECT_VERSION_NUMBER'
1614: );
1615: l_fund_id :=
1616: wf_engine.getitemattrnumber (
1617: itemtype=> itemtype,
1618: itemkey=> itemkey,
1619: aname => 'AMS_ACTIVITY_ID'
1620: );

Line 1634: l_user_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype

1630: l_resp_id := FND_GLOBAL.resp_id;
1631: l_appl_id := FND_GLOBAL.resp_appl_id;
1632: l_security_group_id := FND_GLOBAL.security_group_id;*/
1633:
1634: l_user_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
1635: , itemkey => itemkey
1636: , aname => 'USER_ID'
1637: );
1638:

Line 1639: l_resp_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype

1635: , itemkey => itemkey
1636: , aname => 'USER_ID'
1637: );
1638:
1639: l_resp_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
1640: , itemkey => itemkey
1641: , aname => 'RESPONSIBILITY_ID'
1642: );
1643:

Line 1644: l_appl_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype

1640: , itemkey => itemkey
1641: , aname => 'RESPONSIBILITY_ID'
1642: );
1643:
1644: l_appl_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
1645: , itemkey => itemkey
1646: , aname => 'APPLICATION_ID'
1647: );
1648:

Line 1649: l_security_group_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype

1645: , itemkey => itemkey
1646: , aname => 'APPLICATION_ID'
1647: );
1648:
1649: l_security_group_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
1650: , itemkey => itemkey
1651: , aname => 'SECURITY_GROUP_ID'
1652: );
1653:

Line 1659: WF_ENGINE.setitemattrnumber(

1655:
1656: IF l_update_status IN ('APPROVED', 'REJECTED') AND
1657: (l_user_id IS NULL OR l_resp_id IS NULL OR l_appl_id IS NULL) THEN
1658: l_update_status := NULL;
1659: WF_ENGINE.setitemattrnumber(
1660: itemtype => itemtype
1661: ,itemkey => itemkey
1662: ,aname => 'UPDATE_GEN_STATUS'
1663: ,avalue => l_update_status

Line 1712: wf_engine.getitemattrnumber (

1708: OZF_DEBUG_PVT.DEBUG_MO('OZF_Fund_Approval_PVT update_parbudget_status after setting context : fund_id '||l_fund_id);
1709:
1710: IF l_update_status = 'APPROVED' THEN
1711: l_next_status_id :=
1712: wf_engine.getitemattrnumber (
1713: itemtype=> itemtype,
1714: itemkey=> itemkey,
1715: aname => 'AMS_NEW_STAT_ID'
1716: );

Line 1761: wf_engine.setitemattrnumber (

1757: l_fund_rec.original_budget := 0;
1758: END IF;
1759: -- niprakas: fix for bug#2950338 ends
1760: -- set approval amount to workflow so notificaiton gets the correct amount
1761: wf_engine.setitemattrnumber (
1762: itemtype=> itemtype,
1763: itemkey=> itemkey,
1764: aname => 'AMS_AMOUNT',
1765: avalue=> l_fund_rec.original_budget

Line 1773: wf_engine.getitemattrnumber (

1769: END IF;
1770: -- mpande 6/11/2002 bug#2352621
1771: ELSIF l_update_status = 'REJECTED' THEN
1772: l_next_status_id :=
1773: wf_engine.getitemattrnumber (
1774: itemtype=> itemtype,
1775: itemkey=> itemkey,
1776: aname => 'AMS_REJECT_STAT_ID'
1777: );

Line 1784: l_next_status_id := wf_engine.GetItemAttrNumber(

1780: ELSE
1781: --l_next_status_id :=
1782: -- ozf_utility_pvt.get_default_user_status ( 'OZF_FUND_STATUS' ,'DRAFT');
1783: -- 06/28/2002 yzhao: no valiation for update so status always revert to 'DRAFT' when error occurs
1784: l_next_status_id := wf_engine.GetItemAttrNumber(
1785: itemtype => itemtype,
1786: itemkey => itemkey,
1787: aname => 'AMS_ORIG_STAT_ID' );
1788: l_validation_level := fnd_api.g_valid_level_none;

Line 1907: wf_engine.getitemattrnumber (

1903: l_fund_id NUMBER;
1904: BEGIN
1905: IF funcmode = 'RUN' THEN
1906: l_object_version_number :=
1907: wf_engine.getitemattrnumber (
1908: itemtype=> itemtype,
1909: itemkey=> itemkey,
1910: aname => 'AMS_OBJECT_VERSION_NUMBER'
1911: );

Line 1913: wf_engine.getitemattrnumber (

1909: itemkey=> itemkey,
1910: aname => 'AMS_OBJECT_VERSION_NUMBER'
1911: );
1912: l_fund_id :=
1913: wf_engine.getitemattrnumber (
1914: itemtype=> itemtype,
1915: itemkey=> itemkey,
1916: aname => 'AMS_ACTIVITY_ID'
1917: );

Line 2031: wf_engine.getitemattrnumber (

2027: l_fund_owner_id NUMBER;
2028: BEGIN
2029: x_return_status := fnd_api.g_ret_sts_success;
2030: l_fund_id :=
2031: wf_engine.getitemattrnumber (
2032: itemtype=> itemtype,
2033: itemkey=> itemkey,
2034: aname => 'AMS_ACTIVITY_ID'
2035: );