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 118: wf_engine.getitemattrtext (

114: - 1);
115: l_item_key := SUBSTR (document_id, l_hyphen_pos1
116: + 1);
117: l_activity_type :=
118: wf_engine.getitemattrtext (
119: itemtype=> l_item_type,
120: itemkey=> l_item_key,
121: aname => 'AMS_ACTIVITY_TYPE'
122: );

Line 124: wf_engine.getitemattrtext (

120: itemkey=> l_item_key,
121: aname => 'AMS_ACTIVITY_TYPE'
122: );
123: l_fund_id :=
124: wf_engine.getitemattrtext (
125: itemtype=> l_item_type,
126: itemkey=> l_item_key,
127: aname => 'AMS_ACTIVITY_ID'
128: );

Line 130: wf_engine.getitemattrtext (

126: itemkey=> l_item_key,
127: aname => 'AMS_ACTIVITY_ID'
128: );
129: l_requested_amt :=
130: wf_engine.getitemattrtext (
131: itemtype=> l_item_type,
132: itemkey=> l_item_key,
133: aname => 'AMS_REQUESTED_AMOUNT'
134: );

Line 136: wf_engine.getitemattrtext (

132: itemkey=> l_item_key,
133: aname => 'AMS_REQUESTED_AMOUNT'
134: );
135: l_note :=
136: wf_engine.getitemattrtext (
137: itemtype=> l_item_type,
138: itemkey=> l_item_key,
139: aname => 'AMS_NOTES_FROM_REQUESTOR'
140: );

Line 142: wf_engine.getitemattrtext (

138: itemkey=> l_item_key,
139: aname => 'AMS_NOTES_FROM_REQUESTOR'
140: );
141: l_approver :=
142: wf_engine.getitemattrtext (
143: itemtype=> l_item_type,
144: itemkey=> l_item_key,
145: aname => 'AMS_APPROVER_DISPLAY_NAME'
146: );

Line 174: wf_engine.setitemattrtext (

170: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
171: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
172: l_string := SUBSTR(fnd_message.get,1,1000);
173: /*
174: wf_engine.setitemattrtext (
175: itemtype=> l_item_type,
176: itemkey=> l_item_key,
177: aname => 'FYI_SUBJECT',
178: avalue=> l_string

Line 194: l_note := wf_engine.getitemattrtext(

190: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
191: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
192: --l_string1 := fnd_message.get;
193: /*
194: l_note := wf_engine.getitemattrtext(
195: itemtype => l_item_type
196: ,itemkey => l_item_key
197: ,aname => 'NOTE');
198: l_forwarder :=

Line 199: wf_engine.getitemattrtext(

195: itemtype => l_item_type
196: ,itemkey => l_item_key
197: ,aname => 'NOTE');
198: l_forwarder :=
199: wf_engine.getitemattrtext(
200: itemtype => l_item_type
201: ,itemkey => l_item_key
202: ,aname => 'AMS_FORWARD_FROM_USERNAME');
203: */

Line 329: wf_engine.getitemattrtext (

325: - 1);
326: l_item_key := SUBSTR (document_id, l_hyphen_pos1
327: + 1);
328: l_activity_type :=
329: wf_engine.getitemattrtext (
330: itemtype=> l_item_type,
331: itemkey=> l_item_key,
332: aname => 'AMS_ACTIVITY_TYPE'
333: );

Line 335: wf_engine.getitemattrtext (

331: itemkey=> l_item_key,
332: aname => 'AMS_ACTIVITY_TYPE'
333: );
334: l_fund_id :=
335: wf_engine.getitemattrtext (
336: itemtype=> l_item_type,
337: itemkey=> l_item_key,
338: aname => 'AMS_ACTIVITY_ID'
339: );

Line 341: wf_engine.getitemattrtext (

337: itemkey=> l_item_key,
338: aname => 'AMS_ACTIVITY_ID'
339: );
340: l_approved_amt :=
341: wf_engine.getitemattrtext (
342: itemtype=> l_item_type,
343: itemkey=> l_item_key,
344: aname => 'AMS_AMOUNT'
345: );

Line 347: wf_engine.getitemattrtext (

343: itemkey=> l_item_key,
344: aname => 'AMS_AMOUNT'
345: );
346: l_note :=
347: wf_engine.getitemattrtext (
348: itemtype=> l_item_type,
349: itemkey=> l_item_key,
350: aname => 'AMS_NOTES_FROM_REQUESTOR'
351: );

Line 353: wf_engine.getitemattrtext (

349: itemkey=> l_item_key,
350: aname => 'AMS_NOTES_FROM_REQUESTOR'
351: );
352: l_approver :=
353: wf_engine.getitemattrtext (
354: itemtype=> l_item_type,
355: itemkey=> l_item_key,
356: aname => 'AMS_APPROVER'
357: );

Line 360: wf_engine.getitemattrtext (

356: aname => 'AMS_APPROVER'
357: );
358: -- yzhao: 01/28/2003 get requested amount from workflow. After approval, requested_amount may not equal orignal_budget
359: l_requested_amt :=
360: wf_engine.getitemattrtext (
361: itemtype=> l_item_type,
362: itemkey=> l_item_key,
363: aname => 'AMS_REQUESTED_AMOUNT'
364: );

Line 406: l_note := wf_engine.getitemattrtext(

402: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
403: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
404: --l_string1 := fnd_message.get;
405: /*
406: l_note := wf_engine.getitemattrtext(
407: itemtype => l_item_type
408: ,itemkey => l_item_key
409: ,aname => 'NOTE');
410: l_forwarder :=

Line 411: wf_engine.getitemattrtext(

407: itemtype => l_item_type
408: ,itemkey => l_item_key
409: ,aname => 'NOTE');
410: l_forwarder :=
411: wf_engine.getitemattrtext(
412: itemtype => l_item_type
413: ,itemkey => l_item_key
414: ,aname => 'AMS_FORWARD_FROM_USERNAME');
415: */

Line 418: wf_engine.getitemattrtext (

414: ,aname => 'AMS_FORWARD_FROM_USERNAME');
415: */
416: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL */
417: l_approver_note :=
418: wf_engine.getitemattrtext (
419: itemtype=> l_item_type,
420: itemkey=> l_item_key,
421: aname => 'APPROVAL_NOTE'
422: );

Line 536: wf_engine.getitemattrtext (

532: - 1);
533: l_item_key := SUBSTR (document_id, l_hyphen_pos1
534: + 1);
535: l_activity_type :=
536: wf_engine.getitemattrtext (
537: itemtype=> l_item_type,
538: itemkey=> l_item_key,
539: aname => 'AMS_ACTIVITY_TYPE'
540: );

Line 542: wf_engine.getitemattrtext (

538: itemkey=> l_item_key,
539: aname => 'AMS_ACTIVITY_TYPE'
540: );
541: l_fund_id :=
542: wf_engine.getitemattrtext (
543: itemtype=> l_item_type,
544: itemkey=> l_item_key,
545: aname => 'AMS_ACTIVITY_ID'
546: );

Line 548: wf_engine.getitemattrtext (

544: itemkey=> l_item_key,
545: aname => 'AMS_ACTIVITY_ID'
546: );
547: l_note :=
548: wf_engine.getitemattrtext (
549: itemtype=> l_item_type,
550: itemkey=> l_item_key,
551: aname => 'AMS_NOTES_FROM_REQUESTOR'
552: );

Line 554: wf_engine.getitemattrtext (

550: itemkey=> l_item_key,
551: aname => 'AMS_NOTES_FROM_REQUESTOR'
552: );
553: l_approver :=
554: wf_engine.getitemattrtext (
555: itemtype=> l_item_type,
556: itemkey=> l_item_key,
557: aname => 'AMS_APPROVER'
558: );

Line 561: wf_engine.getitemattrtext (

557: aname => 'AMS_APPROVER'
558: );
559: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608): request_amount, owner not shown in reject notification */
560: l_requested_amt :=
561: wf_engine.getitemattrtext (
562: itemtype=> l_item_type,
563: itemkey=> l_item_key,
564: aname => 'AMS_REQUESTED_AMOUNT'
565: );

Line 567: wf_engine.getitemattrtext (

563: itemkey=> l_item_key,
564: aname => 'AMS_REQUESTED_AMOUNT'
565: );
566: l_requester :=
567: wf_engine.getitemattrtext (
568: itemtype=> l_item_type,
569: itemkey=> l_item_key,
570: aname => 'AMS_REQUESTER'
571: );

Line 601: wf_engine.setitemattrtext (

597: --fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
598: l_string := Substr(FND_MESSAGE.Get,1,1000);
599: --l_string := fnd_message.get;
600: /*
601: wf_engine.setitemattrtext (
602: itemtype=> l_item_type,
603: itemkey=> l_item_key,
604: aname => 'REJECT_SUBJECT',
605: avalue=> l_string

Line 620: l_note := wf_engine.getitemattrtext(

616: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
617: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
618: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
619: /*
620: l_note := wf_engine.getitemattrtext(
621: itemtype => l_item_type
622: ,itemkey => l_item_key
623: ,aname => 'NOTE');
624: l_forwarder :=

Line 625: wf_engine.getitemattrtext(

621: itemtype => l_item_type
622: ,itemkey => l_item_key
623: ,aname => 'NOTE');
624: l_forwarder :=
625: wf_engine.getitemattrtext(
626: itemtype => l_item_type
627: ,itemkey => l_item_key
628: ,aname => 'AMS_FORWARD_FROM_USERNAME');
629: */

Line 632: wf_engine.getitemattrtext (

628: ,aname => 'AMS_FORWARD_FROM_USERNAME');
629: */
630: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) APPROVer's NOTE NOT SHOWING IN rejection EMAIL */
631: l_note :=
632: wf_engine.getitemattrtext (
633: itemtype=> l_item_type,
634: itemkey=> l_item_key,
635: aname => 'APPROVAL_NOTE'
636: );

Line 752: wf_engine.getitemattrtext (

748: - 1);
749: l_item_key := SUBSTR (document_id, l_hyphen_pos1
750: + 1);
751: l_activity_type :=
752: wf_engine.getitemattrtext (
753: itemtype=> l_item_type,
754: itemkey=> l_item_key,
755: aname => 'AMS_ACTIVITY_TYPE'
756: );

Line 758: wf_engine.getitemattrtext (

754: itemkey=> l_item_key,
755: aname => 'AMS_ACTIVITY_TYPE'
756: );
757: l_fund_id :=
758: wf_engine.getitemattrtext (
759: itemtype=> l_item_type,
760: itemkey=> l_item_key,
761: aname => 'AMS_ACTIVITY_ID'
762: );

Line 764: wf_engine.getitemattrtext (

760: itemkey=> l_item_key,
761: aname => 'AMS_ACTIVITY_ID'
762: );
763: l_note :=
764: wf_engine.getitemattrtext (
765: itemtype=> l_item_type,
766: itemkey=> l_item_key,
767: aname => 'AMS_NOTES_FROM_REQUESTOR'
768: );

Line 770: wf_engine.getitemattrtext (

766: itemkey=> l_item_key,
767: aname => 'AMS_NOTES_FROM_REQUESTOR'
768: );
769: l_approver :=
770: wf_engine.getitemattrtext (
771: itemtype=> l_item_type,
772: itemkey=> l_item_key,
773: aname => 'AMS_APPROVER_DISPLAY_NAME'
774: );

Line 776: wf_engine.getitemattrtext (

772: itemkey=> l_item_key,
773: aname => 'AMS_APPROVER_DISPLAY_NAME'
774: );
775: l_requested_amt :=
776: wf_engine.getitemattrtext (
777: itemtype=> l_item_type,
778: itemkey=> l_item_key,
779: aname => 'AMS_REQUESTED_AMOUNT'
780: );

Line 782: wf_engine.getitemattrtext (

778: itemkey=> l_item_key,
779: aname => 'AMS_REQUESTED_AMOUNT'
780: );
781: l_requester :=
782: wf_engine.getitemattrtext (
783: itemtype=> l_item_type,
784: itemkey=> l_item_key,
785: aname => 'AMS_REQUESTER'
786: );

Line 815: wf_engine.setitemattrtext (

811: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
812: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
813: l_string := SUBSTR(fnd_message.get,1,1000);
814: /*
815: wf_engine.setitemattrtext (
816: itemtype=> l_item_type,
817: itemkey=> l_item_key,
818: aname => 'APP_SUBJECT',
819: avalue=> l_string

Line 834: NVL(wf_engine.getitemattrtext (

830: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
831: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
832: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
833: l_note :=
834: NVL(wf_engine.getitemattrtext (
835: itemtype=> l_item_type,
836: itemkey=> l_item_key,
837: aname => 'AMS_PREV_APPROVER_NOTE'
838: ),'-');

Line 840: NVL(wf_engine.getitemattrtext (

836: itemkey=> l_item_key,
837: aname => 'AMS_PREV_APPROVER_NOTE'
838: ),'-');
839: l_forwarder :=
840: NVL(wf_engine.getitemattrtext (
841: itemtype=> l_item_type,
842: itemkey=> l_item_key,
843: aname => 'AMS_PREV_APPROVER_DISP_NAME'
844: ),'-');

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

841: itemtype=> l_item_type,
842: itemkey=> l_item_key,
843: aname => 'AMS_PREV_APPROVER_DISP_NAME'
844: ),'-');
845: l_approval_date := NVL(to_char(wf_engine.getitemattrdate (
846: itemtype => l_item_type,
847: itemkey => l_item_key,
848: aname => 'AMS_APPROVAL_DATE')),'-');
849: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');

Line 967: wf_engine.getitemattrtext (

963: - 1);
964: l_item_key := SUBSTR (document_id, l_hyphen_pos1
965: + 1);
966: l_activity_type :=
967: wf_engine.getitemattrtext (
968: itemtype=> l_item_type,
969: itemkey=> l_item_key,
970: aname => 'AMS_ACTIVITY_TYPE'
971: );

Line 973: wf_engine.getitemattrtext (

969: itemkey=> l_item_key,
970: aname => 'AMS_ACTIVITY_TYPE'
971: );
972: l_fund_id :=
973: wf_engine.getitemattrtext (
974: itemtype=> l_item_type,
975: itemkey=> l_item_key,
976: aname => 'AMS_ACTIVITY_ID'
977: );

Line 979: wf_engine.getitemattrtext (

975: itemkey=> l_item_key,
976: aname => 'AMS_ACTIVITY_ID'
977: );
978: l_note :=
979: wf_engine.getitemattrtext (
980: itemtype=> l_item_type,
981: itemkey=> l_item_key,
982: aname => 'AMS_NOTES_FROM_REQUESTOR'
983: );

Line 985: wf_engine.getitemattrtext (

981: itemkey=> l_item_key,
982: aname => 'AMS_NOTES_FROM_REQUESTOR'
983: );
984: l_approver :=
985: wf_engine.getitemattrtext (
986: itemtype=> l_item_type,
987: itemkey=> l_item_key,
988: aname => 'AMS_APPROVER'
989: );

Line 991: wf_engine.getitemattrtext (

987: itemkey=> l_item_key,
988: aname => 'AMS_APPROVER'
989: );
990: l_requested_amt :=
991: wf_engine.getitemattrtext (
992: itemtype=> l_item_type,
993: itemkey=> l_item_key,
994: aname => 'AMS_REQUESTED_AMOUNT'
995: );

Line 997: wf_engine.getitemattrtext (

993: itemkey=> l_item_key,
994: aname => 'AMS_REQUESTED_AMOUNT'
995: );
996: l_requester :=
997: wf_engine.getitemattrtext (
998: itemtype=> l_item_type,
999: itemkey=> l_item_key,
1000: aname => 'AMS_REQUESTER'
1001: );

Line 1029: wf_engine.setitemattrtext (

1025: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1026: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1027: l_string := SUBSTR(fnd_message.get,1,1000);
1028: /*
1029: wf_engine.setitemattrtext (
1030: itemtype=> l_item_type,
1031: itemkey=> l_item_key,
1032: aname => 'APP_SUBJECT',
1033: avalue=> l_string

Line 1048: NVL(wf_engine.getitemattrtext (

1044: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
1045: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1046: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1047: l_note :=
1048: NVL(wf_engine.getitemattrtext (
1049: itemtype=> l_item_type,
1050: itemkey=> l_item_key,
1051: aname => 'AMS_PREV_APPROVER_NOTE'
1052: ),'-');

Line 1054: NVL(wf_engine.getitemattrtext (

1050: itemkey=> l_item_key,
1051: aname => 'AMS_PREV_APPROVER_NOTE'
1052: ),'-');
1053: l_forwarder :=
1054: NVL(wf_engine.getitemattrtext (
1055: itemtype=> l_item_type,
1056: itemkey=> l_item_key,
1057: aname => 'AMS_PREV_APPROVER_DISP_NAME'
1058: ),'-');

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

1055: itemtype=> l_item_type,
1056: itemkey=> l_item_key,
1057: aname => 'AMS_PREV_APPROVER_DISP_NAME'
1058: ),'-');
1059: l_approval_date := NVL(to_char(wf_engine.getitemattrdate (
1060: itemtype => l_item_type,
1061: itemkey => l_item_key,
1062: aname => 'AMS_APPROVAL_DATE')),'-');
1063: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

Line 1075: l_note := wf_engine.getitemattrtext(

1071: */
1072: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
1073: l_string2 := SUBSTR(fnd_message.get,1,2500);
1074: /*
1075: l_note := wf_engine.getitemattrtext(
1076: itemtype => l_item_type
1077: ,itemkey => l_item_key
1078: ,aname => 'NOTE');
1079: l_forwarder :=

Line 1080: wf_engine.getitemattrtext(

1076: itemtype => l_item_type
1077: ,itemkey => l_item_key
1078: ,aname => 'NOTE');
1079: l_forwarder :=
1080: wf_engine.getitemattrtext(
1081: itemtype => l_item_type
1082: ,itemkey => l_item_key
1083: ,aname => 'AMS_FORWARD_FROM_USERNAME');
1084: */

Line 1183: wf_engine.getitemattrnumber (

1179: WHERE fund_id = p_act_id;
1180: BEGIN
1181: fnd_msg_pub.initialize;
1182: l_activity_id :=
1183: wf_engine.getitemattrnumber (
1184: itemtype=> itemtype,
1185: itemkey=> itemkey,
1186: aname => 'AMS_ACTIVITY_ID'
1187: );

Line 1231: wf_engine.setitemattrnumber (

1227: ( p_user_id => l_object_details.owner_id,
1228: x_full_name => l_full_name,
1229: x_return_status => l_return_status );
1230: */
1231: wf_engine.setitemattrnumber (
1232: itemtype=> itemtype,
1233: itemkey=> itemkey,
1234: aname => 'AMS_APPROVAL_DETAIL_ID',
1235: avalue=> l_approval_detail_id

Line 1237: wf_engine.setitemattrnumber (

1233: itemkey=> itemkey,
1234: aname => 'AMS_APPROVAL_DETAIL_ID',
1235: avalue=> l_approval_detail_id
1236: );
1237: wf_engine.setitemattrnumber (
1238: itemtype=> itemtype,
1239: itemkey=> itemkey,
1240: aname => 'AMS_APPROVER_SEQ',
1241: avalue=> l_approver_seq

Line 1243: wf_engine.setitemattrnumber (

1239: itemkey=> itemkey,
1240: aname => 'AMS_APPROVER_SEQ',
1241: avalue=> l_approver_seq
1242: );
1243: wf_engine.setitemattrnumber (
1244: itemtype=> itemtype,
1245: itemkey=> itemkey,
1246: aname => 'AMS_REQUESTED_AMOUNT',
1247: avalue=> l_object_details.total_header_amount

Line 1269: wf_engine.setitemattrtext (

1265: );
1266: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1267: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE); -- ##
1268: l_string := fnd_message.get;
1269: wf_engine.setitemattrtext (
1270: itemtype=> itemtype,
1271: itemkey=> itemkey,
1272: aname => 'FYI_SUBJECT',
1273: avalue=> l_string

Line 1283: wf_engine.setitemattrtext (

1279: --fnd_message.set_token ('AMOUNT',l_object_details.total_header_amount, FALSE);
1280: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1281: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1282: l_string := fnd_message.get;
1283: wf_engine.setitemattrtext (
1284: itemtype=> itemtype,
1285: itemkey=> itemkey,
1286: aname => 'APRV_SUBJECT',
1287: avalue=> l_string

Line 1309: wf_engine.setitemattrtext (

1305: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1306: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1307: -- yzhao: not a token in message fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE); -- ##
1308: l_string := fnd_message.get;
1309: wf_engine.setitemattrtext (
1310: itemtype=> itemtype,
1311: itemkey=> itemkey,
1312: aname => 'REJECT_SUBJECT',
1313: avalue=> l_string

Line 1335: wf_engine.setitemattrtext (

1331: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1332: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1333: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1334: l_string := fnd_message.get;
1335: wf_engine.setitemattrtext (
1336: itemtype=> itemtype,
1337: itemkey=> itemkey,
1338: aname => 'APP_SUBJECT',
1339: avalue=> l_string

Line 1343: wf_engine.setitemattrtext (

1339: avalue=> l_string
1340: );
1341: /* mpande added for implementation of BUG#2352621*/
1342: l_lookup_meaning := ozf_utility_pvt.get_lookup_meaning('AMS_SYS_ARC_QUALIFIER','RFRQ');
1343: wf_engine.setitemattrtext (
1344: itemtype=> itemtype,
1345: itemkey=> itemkey,
1346: aname => 'AMS_APPROVAL_OBJECT_MEANING',
1347: avalue=> l_lookup_meaning

Line 1349: wf_engine.setitemattrtext (

1345: itemkey=> itemkey,
1346: aname => 'AMS_APPROVAL_OBJECT_MEANING',
1347: avalue=> l_lookup_meaning
1348: );
1349: wf_engine.setitemattrtext (
1350: itemtype=> itemtype,
1351: itemkey=> itemkey,
1352: aname => 'AMS_APPROVAL_OBJECT_NAME',
1353: avalue=> l_object_details.name

Line 1537: wf_engine.getitemattrtext (

1533: BEGIN
1534: SAVEPOINT update_parbudget_status ;
1535: IF funcmode = 'RUN' THEN
1536: l_update_status :=
1537: wf_engine.getitemattrtext (
1538: itemtype=> itemtype,
1539: itemkey=> itemkey,
1540: aname => 'UPDATE_GEN_STATUS'
1541: );

Line 1543: wf_engine.getitemattrnumber (

1539: itemkey=> itemkey,
1540: aname => 'UPDATE_GEN_STATUS'
1541: );
1542: l_approved_amount :=
1543: wf_engine.getitemattrnumber (
1544: itemtype=> itemtype,
1545: itemkey=> itemkey,
1546: aname => 'AMS_AMOUNT'
1547: );

Line 1549: wf_engine.getitemattrtext (

1545: itemkey=> itemkey,
1546: aname => 'AMS_AMOUNT'
1547: );
1548: l_approver :=
1549: wf_engine.getitemattrtext (
1550: itemtype=> itemtype,
1551: itemkey=> itemkey,
1552: aname => 'AMS_APPROVER'
1553: );

Line 1555: wf_engine.getitemattrtext (

1551: itemkey=> itemkey,
1552: aname => 'AMS_APPROVER'
1553: );
1554: l_approver_id :=
1555: wf_engine.getitemattrtext (
1556: itemtype=> itemtype,
1557: itemkey=> itemkey,
1558: aname => 'AMS_APPROVER_ID'
1559: );

Line 1561: wf_engine.getitemattrtext (

1557: itemkey=> itemkey,
1558: aname => 'AMS_APPROVER_ID'
1559: );
1560: l_requester_id :=
1561: wf_engine.getitemattrtext (
1562: itemtype=> itemtype,
1563: itemkey=> itemkey,
1564: aname => 'AMS_REQUESTER_ID'
1565: );

Line 1567: wf_engine.getitemattrnumber (

1563: itemkey=> itemkey,
1564: aname => 'AMS_REQUESTER_ID'
1565: );
1566: l_requested_amt :=
1567: wf_engine.getitemattrnumber (
1568: itemtype=> itemtype,
1569: itemkey=> itemkey,
1570: aname => 'AMS_REQUESTED_AMOUNT'
1571: );

Line 1573: wf_engine.getitemattrnumber (

1569: itemkey=> itemkey,
1570: aname => 'AMS_REQUESTED_AMOUNT'
1571: );
1572: l_object_version_number :=
1573: wf_engine.getitemattrnumber (
1574: itemtype=> itemtype,
1575: itemkey=> itemkey,
1576: aname => 'AMS_OBJECT_VERSION_NUMBER'
1577: );

Line 1579: wf_engine.getitemattrnumber (

1575: itemkey=> itemkey,
1576: aname => 'AMS_OBJECT_VERSION_NUMBER'
1577: );
1578: l_fund_id :=
1579: wf_engine.getitemattrnumber (
1580: itemtype=> itemtype,
1581: itemkey=> itemkey,
1582: aname => 'AMS_ACTIVITY_ID'
1583: );

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

1588: l_resp_id := FND_GLOBAL.resp_id;
1589: l_appl_id := FND_GLOBAL.resp_appl_id;
1590: l_security_group_id := FND_GLOBAL.security_group_id;
1591: IF (l_appl_id IS NULL OR l_appl_id = 0) THEN
1592: l_appl_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
1593: , itemkey => itemkey
1594: , aname => 'APPLICATION_ID'
1595: );
1596: FND_GLOBAL.apps_initialize( user_id => l_user_id

Line 1606: wf_engine.getitemattrnumber (

1602: -- [END OF BUG 2916480 FIXING by yzhao 23-APR-2003]
1603: ozf_funds_pvt.init_fund_rec (x_fund_rec => l_fund_rec);
1604: IF l_update_status = 'APPROVED' THEN
1605: l_next_status_id :=
1606: wf_engine.getitemattrnumber (
1607: itemtype=> itemtype,
1608: itemkey=> itemkey,
1609: aname => 'AMS_NEW_STAT_ID'
1610: );

Line 1655: wf_engine.setitemattrnumber (

1651: l_fund_rec.original_budget := 0;
1652: END IF;
1653: -- niprakas: fix for bug#2950338 ends
1654: -- set approval amount to workflow so notificaiton gets the correct amount
1655: wf_engine.setitemattrnumber (
1656: itemtype=> itemtype,
1657: itemkey=> itemkey,
1658: aname => 'AMS_AMOUNT',
1659: avalue=> l_fund_rec.original_budget

Line 1667: wf_engine.getitemattrnumber (

1663: END IF;
1664: -- mpande 6/11/2002 bug#2352621
1665: ELSIF l_update_status = 'REJECTED' THEN
1666: l_next_status_id :=
1667: wf_engine.getitemattrnumber (
1668: itemtype=> itemtype,
1669: itemkey=> itemkey,
1670: aname => 'AMS_REJECT_STAT_ID'
1671: );

Line 1678: l_next_status_id := wf_engine.GetItemAttrNumber(

1674: ELSE
1675: --l_next_status_id :=
1676: -- ozf_utility_pvt.get_default_user_status ( 'OZF_FUND_STATUS' ,'DRAFT');
1677: -- 06/28/2002 yzhao: no valiation for update so status always revert to 'DRAFT' when error occurs
1678: l_next_status_id := wf_engine.GetItemAttrNumber(
1679: itemtype => itemtype,
1680: itemkey => itemkey,
1681: aname => 'AMS_ORIG_STAT_ID' );
1682: l_validation_level := fnd_api.g_valid_level_none;

Line 1801: wf_engine.getitemattrnumber (

1797: l_fund_id NUMBER;
1798: BEGIN
1799: IF funcmode = 'RUN' THEN
1800: l_object_version_number :=
1801: wf_engine.getitemattrnumber (
1802: itemtype=> itemtype,
1803: itemkey=> itemkey,
1804: aname => 'AMS_OBJECT_VERSION_NUMBER'
1805: );

Line 1807: wf_engine.getitemattrnumber (

1803: itemkey=> itemkey,
1804: aname => 'AMS_OBJECT_VERSION_NUMBER'
1805: );
1806: l_fund_id :=
1807: wf_engine.getitemattrnumber (
1808: itemtype=> itemtype,
1809: itemkey=> itemkey,
1810: aname => 'AMS_ACTIVITY_ID'
1811: );

Line 1925: wf_engine.getitemattrnumber (

1921: l_fund_owner_id NUMBER;
1922: BEGIN
1923: x_return_status := fnd_api.g_ret_sts_success;
1924: l_fund_id :=
1925: wf_engine.getitemattrnumber (
1926: itemtype=> itemtype,
1927: itemkey=> itemkey,
1928: aname => 'AMS_ACTIVITY_ID'
1929: );