DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION_R11 dependencies on WF_ENGINE

Line 66: l_document_id := wf_engine.GetItemAttrNumber

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:

Line 71: l_org_id := wf_engine.GetItemAttrNumber

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:

Line 78: l_document_subtype := wf_engine.GetItemAttrText

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:

Line 83: l_document_type := wf_engine.GetItemAttrText

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:

Line 88: l_document_number := wf_engine.GetItemAttrText

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:

Line 93: l_currency_code := wf_engine.GetItemAttrText

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:

Line 98: l_req_amount := wf_engine.GetItemAttrText

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:

Line 106: l_description := wf_engine.GetItemAttrText

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:

Line 111: l_approver := wf_engine.GetItemAttrText

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:

Line 116: l_preparer := wf_engine.GetItemAttrText

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:

Line 121: l_note := wf_engine.GetItemAttrText

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:

Line 243: l_document_id := wf_engine.GetItemAttrNumber

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:

Line 248: l_org_id := wf_engine.GetItemAttrNumber

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:

Line 255: l_document_subtype := wf_engine.GetItemAttrText

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:

Line 260: l_document_type := wf_engine.GetItemAttrText

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:

Line 265: l_document_number := wf_engine.GetItemAttrText

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:

Line 270: l_currency_code := wf_engine.GetItemAttrText

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:

Line 275: l_req_amount := wf_engine.GetItemAttrText

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:

Line 283: l_description := wf_engine.GetItemAttrText

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:

Line 288: l_approver := wf_engine.GetItemAttrText

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:

Line 293: l_preparer := wf_engine.GetItemAttrText

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:

Line 298: l_note := wf_engine.GetItemAttrText

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:

Line 422: l_document_id := wf_engine.GetItemAttrNumber

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:

Line 427: l_org_id := wf_engine.GetItemAttrNumber

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:

Line 434: l_document_subtype := wf_engine.GetItemAttrText

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:

Line 439: l_document_type := wf_engine.GetItemAttrText

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:

Line 444: l_document_number := wf_engine.GetItemAttrText

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:

Line 449: l_currency_code := wf_engine.GetItemAttrText

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:

Line 454: l_req_amount := wf_engine.GetItemAttrText

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:

Line 461: l_req_amount := wf_engine.GetItemAttrText

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:

Line 466: l_description := wf_engine.GetItemAttrText

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:

Line 471: l_approver := wf_engine.GetItemAttrText

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:

Line 476: l_preparer := wf_engine.GetItemAttrText

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:

Line 481: l_note := wf_engine.GetItemAttrText

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:

Line 603: l_document_id := wf_engine.GetItemAttrNumber

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:

Line 608: l_org_id := wf_engine.GetItemAttrNumber

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:

Line 615: l_document_subtype := wf_engine.GetItemAttrText

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:

Line 620: l_document_type := wf_engine.GetItemAttrText

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:

Line 625: l_document_number := wf_engine.GetItemAttrText

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:

Line 630: l_currency_code := wf_engine.GetItemAttrText

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:

Line 635: l_req_amount := wf_engine.GetItemAttrText

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:

Line 642: l_req_amount := wf_engine.GetItemAttrText

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:

Line 647: l_description := wf_engine.GetItemAttrText

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:

Line 652: l_rejected_by := wf_engine.GetItemAttrText

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:

Line 657: l_preparer := wf_engine.GetItemAttrText

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:

Line 662: l_note := wf_engine.GetItemAttrText

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:

Line 835: l_document_id := wf_engine.GetItemAttrNumber

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:

Line 840: l_org_id := wf_engine.GetItemAttrNumber

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:

Line 845: l_req_details_url := wf_engine.GetItemAttrText

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:

Line 850: l_req_updates_url := wf_engine.GetItemAttrText

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:

Line 1103: l_document_id := wf_engine.GetItemAttrNumber

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:

Line 1108: l_org_id := wf_engine.GetItemAttrNumber

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:

Line 1113: l_req_details_url := wf_engine.GetItemAttrText

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:

Line 1334: l_document_id := wf_engine.GetItemAttrNumber

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:

Line 1339: l_org_id := wf_engine.GetItemAttrNumber

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:

Line 1430: resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;

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: