62: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
63: l_item_key := substr(document_id, instr(document_id, ':') + 1,
64: length(document_id) - 2);
65:
66: l_document_id := wf_engine.GetItemAttrNumber
67: (itemtype => l_item_type,
68: itemkey => l_item_key,
69: aname => 'DOCUMENT_ID');
70:
67: (itemtype => l_item_type,
68: itemkey => l_item_key,
69: aname => 'DOCUMENT_ID');
70:
71: l_org_id := wf_engine.GetItemAttrNumber
72: (itemtype => l_item_type,
73: itemkey => l_item_key,
74: aname => 'ORG_ID');
75:
74: aname => 'ORG_ID');
75:
76: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
77:
78: l_document_subtype := wf_engine.GetItemAttrText
79: (itemtype => l_item_type,
80: itemkey => l_item_key,
81: aname => 'DOCUMENT_SUBTYPE_DISP');
82:
79: (itemtype => l_item_type,
80: itemkey => l_item_key,
81: aname => 'DOCUMENT_SUBTYPE_DISP');
82:
83: l_document_type := wf_engine.GetItemAttrText
84: (itemtype => l_item_type,
85: itemkey => l_item_key,
86: aname => 'DOCUMENT_TYPE_DISP');
87:
84: (itemtype => l_item_type,
85: itemkey => l_item_key,
86: aname => 'DOCUMENT_TYPE_DISP');
87:
88: l_document_number := wf_engine.GetItemAttrText
89: (itemtype => l_item_type,
90: itemkey => l_item_key,
91: aname => 'DOCUMENT_NUMBER');
92:
89: (itemtype => l_item_type,
90: itemkey => l_item_key,
91: aname => 'DOCUMENT_NUMBER');
92:
93: l_currency_code := wf_engine.GetItemAttrText
94: (itemtype => l_item_type,
95: itemkey => l_item_key,
96: aname => 'FUNCTIONAL_CURRENCY');
97:
94: (itemtype => l_item_type,
95: itemkey => l_item_key,
96: aname => 'FUNCTIONAL_CURRENCY');
97:
98: l_req_amount := wf_engine.GetItemAttrText
99: (itemtype => l_item_type,
100: itemkey => l_item_key,
101: aname => 'REQ_AMOUNT_DSP');
102:
102:
103: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVED');
104:
105:
106: l_description := wf_engine.GetItemAttrText
107: (itemtype => l_item_type,
108: itemkey => l_item_key,
109: aname => 'REQ_DESCRIPTION');
110:
107: (itemtype => l_item_type,
108: itemkey => l_item_key,
109: aname => 'REQ_DESCRIPTION');
110:
111: l_approver := wf_engine.GetItemAttrText
112: (itemtype => l_item_type,
113: itemkey => l_item_key,
114: aname => 'APPROVER_DISPLAY_NAME');
115:
112: (itemtype => l_item_type,
113: itemkey => l_item_key,
114: aname => 'APPROVER_DISPLAY_NAME');
115:
116: l_preparer := wf_engine.GetItemAttrText
117: (itemtype => l_item_type,
118: itemkey => l_item_key,
119: aname => 'PREPARER_DISPLAY_NAME');
120:
117: (itemtype => l_item_type,
118: itemkey => l_item_key,
119: aname => 'PREPARER_DISPLAY_NAME');
120:
121: l_note := wf_engine.GetItemAttrText
122: (itemtype => l_item_type,
123: itemkey => l_item_key,
124: aname => 'NOTE');
125:
239: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
240: l_item_key := substr(document_id, instr(document_id, ':') + 1,
241: length(document_id) - 2);
242:
243: l_document_id := wf_engine.GetItemAttrNumber
244: (itemtype => l_item_type,
245: itemkey => l_item_key,
246: aname => 'DOCUMENT_ID');
247:
244: (itemtype => l_item_type,
245: itemkey => l_item_key,
246: aname => 'DOCUMENT_ID');
247:
248: l_org_id := wf_engine.GetItemAttrNumber
249: (itemtype => l_item_type,
250: itemkey => l_item_key,
251: aname => 'ORG_ID');
252:
251: aname => 'ORG_ID');
252:
253: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
254:
255: l_document_subtype := wf_engine.GetItemAttrText
256: (itemtype => l_item_type,
257: itemkey => l_item_key,
258: aname => 'DOCUMENT_SUBTYPE_DISP');
259:
256: (itemtype => l_item_type,
257: itemkey => l_item_key,
258: aname => 'DOCUMENT_SUBTYPE_DISP');
259:
260: l_document_type := wf_engine.GetItemAttrText
261: (itemtype => l_item_type,
262: itemkey => l_item_key,
263: aname => 'DOCUMENT_TYPE_DISP');
264:
261: (itemtype => l_item_type,
262: itemkey => l_item_key,
263: aname => 'DOCUMENT_TYPE_DISP');
264:
265: l_document_number := wf_engine.GetItemAttrText
266: (itemtype => l_item_type,
267: itemkey => l_item_key,
268: aname => 'DOCUMENT_NUMBER');
269:
266: (itemtype => l_item_type,
267: itemkey => l_item_key,
268: aname => 'DOCUMENT_NUMBER');
269:
270: l_currency_code := wf_engine.GetItemAttrText
271: (itemtype => l_item_type,
272: itemkey => l_item_key,
273: aname => 'FUNCTIONAL_CURRENCY');
274:
271: (itemtype => l_item_type,
272: itemkey => l_item_key,
273: aname => 'FUNCTIONAL_CURRENCY');
274:
275: l_req_amount := wf_engine.GetItemAttrText
276: (itemtype => l_item_type,
277: itemkey => l_item_key,
278: aname => 'REQ_AMOUNT_DSP');
279:
279:
280: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVED');
281:
282:
283: l_description := wf_engine.GetItemAttrText
284: (itemtype => l_item_type,
285: itemkey => l_item_key,
286: aname => 'REQ_DESCRIPTION');
287:
284: (itemtype => l_item_type,
285: itemkey => l_item_key,
286: aname => 'REQ_DESCRIPTION');
287:
288: l_approver := wf_engine.GetItemAttrText
289: (itemtype => l_item_type,
290: itemkey => l_item_key,
291: aname => 'APPROVER_DISPLAY_NAME');
292:
289: (itemtype => l_item_type,
290: itemkey => l_item_key,
291: aname => 'APPROVER_DISPLAY_NAME');
292:
293: l_preparer := wf_engine.GetItemAttrText
294: (itemtype => l_item_type,
295: itemkey => l_item_key,
296: aname => 'PREPARER_DISPLAY_NAME');
297:
294: (itemtype => l_item_type,
295: itemkey => l_item_key,
296: aname => 'PREPARER_DISPLAY_NAME');
297:
298: l_note := wf_engine.GetItemAttrText
299: (itemtype => l_item_type,
300: itemkey => l_item_key,
301: aname => 'NOTE');
302:
418: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
419: l_item_key := substr(document_id, instr(document_id, ':') + 1,
420: length(document_id) - 2);
421:
422: l_document_id := wf_engine.GetItemAttrNumber
423: (itemtype => l_item_type,
424: itemkey => l_item_key,
425: aname => 'DOCUMENT_ID');
426:
423: (itemtype => l_item_type,
424: itemkey => l_item_key,
425: aname => 'DOCUMENT_ID');
426:
427: l_org_id := wf_engine.GetItemAttrNumber
428: (itemtype => l_item_type,
429: itemkey => l_item_key,
430: aname => 'ORG_ID');
431:
430: aname => 'ORG_ID');
431:
432: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
433:
434: l_document_subtype := wf_engine.GetItemAttrText
435: (itemtype => l_item_type,
436: itemkey => l_item_key,
437: aname => 'DOCUMENT_SUBTYPE_DISP');
438:
435: (itemtype => l_item_type,
436: itemkey => l_item_key,
437: aname => 'DOCUMENT_SUBTYPE_DISP');
438:
439: l_document_type := wf_engine.GetItemAttrText
440: (itemtype => l_item_type,
441: itemkey => l_item_key,
442: aname => 'DOCUMENT_TYPE_DISP');
443:
440: (itemtype => l_item_type,
441: itemkey => l_item_key,
442: aname => 'DOCUMENT_TYPE_DISP');
443:
444: l_document_number := wf_engine.GetItemAttrText
445: (itemtype => l_item_type,
446: itemkey => l_item_key,
447: aname => 'DOCUMENT_NUMBER');
448:
445: (itemtype => l_item_type,
446: itemkey => l_item_key,
447: aname => 'DOCUMENT_NUMBER');
448:
449: l_currency_code := wf_engine.GetItemAttrText
450: (itemtype => l_item_type,
451: itemkey => l_item_key,
452: aname => 'FUNCTIONAL_CURRENCY');
453:
450: (itemtype => l_item_type,
451: itemkey => l_item_key,
452: aname => 'FUNCTIONAL_CURRENCY');
453:
454: l_req_amount := wf_engine.GetItemAttrText
455: (itemtype => l_item_type,
456: itemkey => l_item_key,
457: aname => 'REQ_AMOUNT_DSP');
458:
457: aname => 'REQ_AMOUNT_DSP');
458:
459: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NO_APPROVER');
460:
461: l_req_amount := wf_engine.GetItemAttrText
462: (itemtype => l_item_type,
463: itemkey => l_item_key,
464: aname => 'REQ_AMOUNT_DSP');
465:
462: (itemtype => l_item_type,
463: itemkey => l_item_key,
464: aname => 'REQ_AMOUNT_DSP');
465:
466: l_description := wf_engine.GetItemAttrText
467: (itemtype => l_item_type,
468: itemkey => l_item_key,
469: aname => 'REQ_DESCRIPTION');
470:
467: (itemtype => l_item_type,
468: itemkey => l_item_key,
469: aname => 'REQ_DESCRIPTION');
470:
471: l_approver := wf_engine.GetItemAttrText
472: (itemtype => l_item_type,
473: itemkey => l_item_key,
474: aname => 'APPROVER_DISPLAY_NAME');
475:
472: (itemtype => l_item_type,
473: itemkey => l_item_key,
474: aname => 'APPROVER_DISPLAY_NAME');
475:
476: l_preparer := wf_engine.GetItemAttrText
477: (itemtype => l_item_type,
478: itemkey => l_item_key,
479: aname => 'PREPARER_DISPLAY_NAME');
480:
477: (itemtype => l_item_type,
478: itemkey => l_item_key,
479: aname => 'PREPARER_DISPLAY_NAME');
480:
481: l_note := wf_engine.GetItemAttrText
482: (itemtype => l_item_type,
483: itemkey => l_item_key,
484: aname => 'NOTE');
485:
599: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
600: l_item_key := substr(document_id, instr(document_id, ':') + 1,
601: length(document_id) - 2);
602:
603: l_document_id := wf_engine.GetItemAttrNumber
604: (itemtype => l_item_type,
605: itemkey => l_item_key,
606: aname => 'DOCUMENT_ID');
607:
604: (itemtype => l_item_type,
605: itemkey => l_item_key,
606: aname => 'DOCUMENT_ID');
607:
608: l_org_id := wf_engine.GetItemAttrNumber
609: (itemtype => l_item_type,
610: itemkey => l_item_key,
611: aname => 'ORG_ID');
612:
611: aname => 'ORG_ID');
612:
613: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
614:
615: l_document_subtype := wf_engine.GetItemAttrText
616: (itemtype => l_item_type,
617: itemkey => l_item_key,
618: aname => 'DOCUMENT_SUBTYPE_DISP');
619:
616: (itemtype => l_item_type,
617: itemkey => l_item_key,
618: aname => 'DOCUMENT_SUBTYPE_DISP');
619:
620: l_document_type := wf_engine.GetItemAttrText
621: (itemtype => l_item_type,
622: itemkey => l_item_key,
623: aname => 'DOCUMENT_TYPE_DISP');
624:
621: (itemtype => l_item_type,
622: itemkey => l_item_key,
623: aname => 'DOCUMENT_TYPE_DISP');
624:
625: l_document_number := wf_engine.GetItemAttrText
626: (itemtype => l_item_type,
627: itemkey => l_item_key,
628: aname => 'DOCUMENT_NUMBER');
629:
626: (itemtype => l_item_type,
627: itemkey => l_item_key,
628: aname => 'DOCUMENT_NUMBER');
629:
630: l_currency_code := wf_engine.GetItemAttrText
631: (itemtype => l_item_type,
632: itemkey => l_item_key,
633: aname => 'FUNCTIONAL_CURRENCY');
634:
631: (itemtype => l_item_type,
632: itemkey => l_item_key,
633: aname => 'FUNCTIONAL_CURRENCY');
634:
635: l_req_amount := wf_engine.GetItemAttrText
636: (itemtype => l_item_type,
637: itemkey => l_item_key,
638: aname => 'REQ_AMOUNT_DSP');
639:
638: aname => 'REQ_AMOUNT_DSP');
639:
640: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_REJECTED_WEB');
641:
642: l_req_amount := wf_engine.GetItemAttrText
643: (itemtype => l_item_type,
644: itemkey => l_item_key,
645: aname => 'REQ_AMOUNT_DSP');
646:
643: (itemtype => l_item_type,
644: itemkey => l_item_key,
645: aname => 'REQ_AMOUNT_DSP');
646:
647: l_description := wf_engine.GetItemAttrText
648: (itemtype => l_item_type,
649: itemkey => l_item_key,
650: aname => 'REQ_DESCRIPTION');
651:
648: (itemtype => l_item_type,
649: itemkey => l_item_key,
650: aname => 'REQ_DESCRIPTION');
651:
652: l_rejected_by := wf_engine.GetItemAttrText
653: (itemtype => l_item_type,
654: itemkey => l_item_key,
655: aname => 'APPROVER_DISPLAY_NAME');
656:
653: (itemtype => l_item_type,
654: itemkey => l_item_key,
655: aname => 'APPROVER_DISPLAY_NAME');
656:
657: l_preparer := wf_engine.GetItemAttrText
658: (itemtype => l_item_type,
659: itemkey => l_item_key,
660: aname => 'PREPARER_DISPLAY_NAME');
661:
658: (itemtype => l_item_type,
659: itemkey => l_item_key,
660: aname => 'PREPARER_DISPLAY_NAME');
661:
662: l_note := wf_engine.GetItemAttrText
663: (itemtype => l_item_type,
664: itemkey => l_item_key,
665: aname => 'NOTE');
666:
831: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
832: l_item_key := substr(document_id, instr(document_id, ':') + 1,
833: length(document_id) - 2);
834:
835: l_document_id := wf_engine.GetItemAttrNumber
836: (itemtype => l_item_type,
837: itemkey => l_item_key,
838: aname => 'DOCUMENT_ID');
839:
836: (itemtype => l_item_type,
837: itemkey => l_item_key,
838: aname => 'DOCUMENT_ID');
839:
840: l_org_id := wf_engine.GetItemAttrNumber
841: (itemtype => l_item_type,
842: itemkey => l_item_key,
843: aname => 'ORG_ID');
844:
841: (itemtype => l_item_type,
842: itemkey => l_item_key,
843: aname => 'ORG_ID');
844:
845: l_req_details_url := wf_engine.GetItemAttrText
846: (itemtype => l_item_type,
847: itemkey => l_item_key,
848: aname => 'REQ_URL');
849:
846: (itemtype => l_item_type,
847: itemkey => l_item_key,
848: aname => 'REQ_URL');
849:
850: l_req_updates_url := wf_engine.GetItemAttrText
851: (itemtype => l_item_type,
852: itemkey => l_item_key,
853: aname => 'REQ_UPDATE_URL');
854:
1099: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
1100: l_item_key := substr(document_id, instr(document_id, ':') + 1,
1101: length(document_id) - 2);
1102:
1103: l_document_id := wf_engine.GetItemAttrNumber
1104: (itemtype => l_item_type,
1105: itemkey => l_item_key,
1106: aname => 'DOCUMENT_ID');
1107:
1104: (itemtype => l_item_type,
1105: itemkey => l_item_key,
1106: aname => 'DOCUMENT_ID');
1107:
1108: l_org_id := wf_engine.GetItemAttrNumber
1109: (itemtype => l_item_type,
1110: itemkey => l_item_key,
1111: aname => 'ORG_ID');
1112:
1109: (itemtype => l_item_type,
1110: itemkey => l_item_key,
1111: aname => 'ORG_ID');
1112:
1113: l_req_details_url := wf_engine.GetItemAttrText
1114: (itemtype => l_item_type,
1115: itemkey => l_item_key,
1116: aname => 'REQ_URL');
1117:
1330: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
1331: l_item_key := substr(document_id, instr(document_id, ':') + 1,
1332: length(document_id) - 2);
1333:
1334: l_document_id := wf_engine.GetItemAttrNumber
1335: (itemtype => l_item_type,
1336: itemkey => l_item_key,
1337: aname => 'DOCUMENT_ID');
1338:
1335: (itemtype => l_item_type,
1336: itemkey => l_item_key,
1337: aname => 'DOCUMENT_ID');
1338:
1339: l_org_id := wf_engine.GetItemAttrNumber
1340: (itemtype => l_item_type,
1341: itemkey => l_item_key,
1342: aname => 'ORG_ID');
1343:
1426: resultout in out NOCOPY varchar2) is
1427:
1428: begin
1429:
1430: resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;
1431:
1432: -- Don't allow transfer
1433: if (funcmode = 'TRANSFER') then
1434: