DBA Data[Home] [Help]

APPS.PO_WF_DOCUMENT dependencies on WF_ENGINE

Line 63: l_document_id := wf_engine.GetItemAttrNumber

59: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
60: l_item_key := substr(document_id, instr(document_id, ':') + 1,
61: length(document_id) - 2);
62:
63: l_document_id := wf_engine.GetItemAttrNumber
64: (itemtype => l_item_type,
65: itemkey => l_item_key,
66: aname => 'DOCUMENT_ID');
67:

Line 68: l_org_id := wf_engine.GetItemAttrNumber

64: (itemtype => l_item_type,
65: itemkey => l_item_key,
66: aname => 'DOCUMENT_ID');
67:
68: l_org_id := wf_engine.GetItemAttrNumber
69: (itemtype => l_item_type,
70: itemkey => l_item_key,
71: aname => 'ORG_ID');
72:

Line 75: l_document_subtype := wf_engine.GetItemAttrText

71: aname => 'ORG_ID');
72:
73: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
74:
75: l_document_subtype := wf_engine.GetItemAttrText
76: (itemtype => l_item_type,
77: itemkey => l_item_key,
78: aname => 'DOCUMENT_SUBTYPE_DISP');
79:

Line 80: l_document_type := wf_engine.GetItemAttrText

76: (itemtype => l_item_type,
77: itemkey => l_item_key,
78: aname => 'DOCUMENT_SUBTYPE_DISP');
79:
80: l_document_type := wf_engine.GetItemAttrText
81: (itemtype => l_item_type,
82: itemkey => l_item_key,
83: aname => 'DOCUMENT_TYPE_DISP');
84:

Line 85: l_document_number := wf_engine.GetItemAttrText

81: (itemtype => l_item_type,
82: itemkey => l_item_key,
83: aname => 'DOCUMENT_TYPE_DISP');
84:
85: l_document_number := wf_engine.GetItemAttrText
86: (itemtype => l_item_type,
87: itemkey => l_item_key,
88: aname => 'DOCUMENT_NUMBER');
89:

Line 90: l_currency_code := wf_engine.GetItemAttrText

86: (itemtype => l_item_type,
87: itemkey => l_item_key,
88: aname => 'DOCUMENT_NUMBER');
89:
90: l_currency_code := wf_engine.GetItemAttrText
91: (itemtype => l_item_type,
92: itemkey => l_item_key,
93: aname => 'FUNCTIONAL_CURRENCY');
94:

Line 95: l_total_amount := wf_engine.GetItemAttrText

91: (itemtype => l_item_type,
92: itemkey => l_item_key,
93: aname => 'FUNCTIONAL_CURRENCY');
94:
95: l_total_amount := wf_engine.GetItemAttrText
96: (itemtype => l_item_type,
97: itemkey => l_item_key,
98: aname => 'TOTAL_AMOUNT_DSP');
99:

Line 100: if wf_engine.GetItemAttrText(itemtype => l_item_type,

96: (itemtype => l_item_type,
97: itemkey => l_item_key,
98: aname => 'TOTAL_AMOUNT_DSP');
99:
100: if wf_engine.GetItemAttrText(itemtype => l_item_type,
101: itemkey => l_item_key,
102: aname => 'REQUIRES_APPROVAL_MSG') is not null then
103:
104: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVAL_MSG');

Line 112: l_req_amount := wf_engine.GetItemAttrText

108: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_INVALID_PERSON_MSG');
109:
110: end if;
111:
112: l_req_amount := wf_engine.GetItemAttrText
113: (itemtype => l_item_type,
114: itemkey => l_item_key,
115: aname => 'REQ_AMOUNT_DSP');
116:

Line 117: l_tax_amount := wf_engine.GetItemAttrText

113: (itemtype => l_item_type,
114: itemkey => l_item_key,
115: aname => 'REQ_AMOUNT_DSP');
116:
117: l_tax_amount := wf_engine.GetItemAttrText
118: (itemtype => l_item_type,
119: itemkey => l_item_key,
120: aname => 'TAX_AMOUNT_DSP');
121:

Line 122: l_description := wf_engine.GetItemAttrText

118: (itemtype => l_item_type,
119: itemkey => l_item_key,
120: aname => 'TAX_AMOUNT_DSP');
121:
122: l_description := wf_engine.GetItemAttrText
123: (itemtype => l_item_type,
124: itemkey => l_item_key,
125: aname => 'REQ_DESCRIPTION');
126:

Line 127: l_forwarded_from := wf_engine.GetItemAttrText

123: (itemtype => l_item_type,
124: itemkey => l_item_key,
125: aname => 'REQ_DESCRIPTION');
126:
127: l_forwarded_from := wf_engine.GetItemAttrText
128: (itemtype => l_item_type,
129: itemkey => l_item_key,
130: aname => 'FORWARD_FROM_DISP_NAME');
131:

Line 132: l_preparer := wf_engine.GetItemAttrText

128: (itemtype => l_item_type,
129: itemkey => l_item_key,
130: aname => 'FORWARD_FROM_DISP_NAME');
131:
132: l_preparer := wf_engine.GetItemAttrText
133: (itemtype => l_item_type,
134: itemkey => l_item_key,
135: aname => 'PREPARER_DISPLAY_NAME');
136:

Line 137: l_note := wf_engine.GetItemAttrText

133: (itemtype => l_item_type,
134: itemkey => l_item_key,
135: aname => 'PREPARER_DISPLAY_NAME');
136:
137: l_note := wf_engine.GetItemAttrText
138: (itemtype => l_item_type,
139: itemkey => l_item_key,
140: aname => 'NOTE');
141:

Line 278: l_document_id := wf_engine.GetItemAttrNumber

274: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
275: l_item_key := substr(document_id, instr(document_id, ':') + 1,
276: length(document_id) - 2);
277:
278: l_document_id := wf_engine.GetItemAttrNumber
279: (itemtype => l_item_type,
280: itemkey => l_item_key,
281: aname => 'DOCUMENT_ID');
282:

Line 283: l_org_id := wf_engine.GetItemAttrNumber

279: (itemtype => l_item_type,
280: itemkey => l_item_key,
281: aname => 'DOCUMENT_ID');
282:
283: l_org_id := wf_engine.GetItemAttrNumber
284: (itemtype => l_item_type,
285: itemkey => l_item_key,
286: aname => 'ORG_ID');
287:

Line 290: l_document_subtype := wf_engine.GetItemAttrText

286: aname => 'ORG_ID');
287:
288: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
289:
290: l_document_subtype := wf_engine.GetItemAttrText
291: (itemtype => l_item_type,
292: itemkey => l_item_key,
293: aname => 'DOCUMENT_SUBTYPE_DISP');
294:

Line 295: l_document_type := wf_engine.GetItemAttrText

291: (itemtype => l_item_type,
292: itemkey => l_item_key,
293: aname => 'DOCUMENT_SUBTYPE_DISP');
294:
295: l_document_type := wf_engine.GetItemAttrText
296: (itemtype => l_item_type,
297: itemkey => l_item_key,
298: aname => 'DOCUMENT_TYPE_DISP');
299:

Line 300: l_document_number := wf_engine.GetItemAttrText

296: (itemtype => l_item_type,
297: itemkey => l_item_key,
298: aname => 'DOCUMENT_TYPE_DISP');
299:
300: l_document_number := wf_engine.GetItemAttrText
301: (itemtype => l_item_type,
302: itemkey => l_item_key,
303: aname => 'DOCUMENT_NUMBER');
304:

Line 305: l_currency_code := wf_engine.GetItemAttrText

301: (itemtype => l_item_type,
302: itemkey => l_item_key,
303: aname => 'DOCUMENT_NUMBER');
304:
305: l_currency_code := wf_engine.GetItemAttrText
306: (itemtype => l_item_type,
307: itemkey => l_item_key,
308: aname => 'FUNCTIONAL_CURRENCY');
309:

Line 310: l_total_amount := wf_engine.GetItemAttrText

306: (itemtype => l_item_type,
307: itemkey => l_item_key,
308: aname => 'FUNCTIONAL_CURRENCY');
309:
310: l_total_amount := wf_engine.GetItemAttrText
311: (itemtype => l_item_type,
312: itemkey => l_item_key,
313: aname => 'TOTAL_AMOUNT_DSP');
314:

Line 317: l_req_amount := wf_engine.GetItemAttrText

313: aname => 'TOTAL_AMOUNT_DSP');
314:
315: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVED');
316:
317: l_req_amount := wf_engine.GetItemAttrText
318: (itemtype => l_item_type,
319: itemkey => l_item_key,
320: aname => 'REQ_AMOUNT_DSP');
321:

Line 322: l_tax_amount := wf_engine.GetItemAttrText

318: (itemtype => l_item_type,
319: itemkey => l_item_key,
320: aname => 'REQ_AMOUNT_DSP');
321:
322: l_tax_amount := wf_engine.GetItemAttrText
323: (itemtype => l_item_type,
324: itemkey => l_item_key,
325: aname => 'TAX_AMOUNT_DSP');
326:

Line 327: l_description := wf_engine.GetItemAttrText

323: (itemtype => l_item_type,
324: itemkey => l_item_key,
325: aname => 'TAX_AMOUNT_DSP');
326:
327: l_description := wf_engine.GetItemAttrText
328: (itemtype => l_item_type,
329: itemkey => l_item_key,
330: aname => 'REQ_DESCRIPTION');
331:

Line 332: l_approver := wf_engine.GetItemAttrText

328: (itemtype => l_item_type,
329: itemkey => l_item_key,
330: aname => 'REQ_DESCRIPTION');
331:
332: l_approver := wf_engine.GetItemAttrText
333: (itemtype => l_item_type,
334: itemkey => l_item_key,
335: aname => 'APPROVER_DISPLAY_NAME');
336:

Line 337: l_preparer := wf_engine.GetItemAttrText

333: (itemtype => l_item_type,
334: itemkey => l_item_key,
335: aname => 'APPROVER_DISPLAY_NAME');
336:
337: l_preparer := wf_engine.GetItemAttrText
338: (itemtype => l_item_type,
339: itemkey => l_item_key,
340: aname => 'PREPARER_DISPLAY_NAME');
341:

Line 342: l_note := wf_engine.GetItemAttrText

338: (itemtype => l_item_type,
339: itemkey => l_item_key,
340: aname => 'PREPARER_DISPLAY_NAME');
341:
342: l_note := wf_engine.GetItemAttrText
343: (itemtype => l_item_type,
344: itemkey => l_item_key,
345: aname => 'NOTE');
346:

Line 483: l_document_id := wf_engine.GetItemAttrNumber

479: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
480: l_item_key := substr(document_id, instr(document_id, ':') + 1,
481: length(document_id) - 2);
482:
483: l_document_id := wf_engine.GetItemAttrNumber
484: (itemtype => l_item_type,
485: itemkey => l_item_key,
486: aname => 'DOCUMENT_ID');
487:

Line 488: l_org_id := wf_engine.GetItemAttrNumber

484: (itemtype => l_item_type,
485: itemkey => l_item_key,
486: aname => 'DOCUMENT_ID');
487:
488: l_org_id := wf_engine.GetItemAttrNumber
489: (itemtype => l_item_type,
490: itemkey => l_item_key,
491: aname => 'ORG_ID');
492:

Line 495: l_document_subtype := wf_engine.GetItemAttrText

491: aname => 'ORG_ID');
492:
493: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
494:
495: l_document_subtype := wf_engine.GetItemAttrText
496: (itemtype => l_item_type,
497: itemkey => l_item_key,
498: aname => 'DOCUMENT_SUBTYPE_DISP');
499:

Line 500: l_document_type := wf_engine.GetItemAttrText

496: (itemtype => l_item_type,
497: itemkey => l_item_key,
498: aname => 'DOCUMENT_SUBTYPE_DISP');
499:
500: l_document_type := wf_engine.GetItemAttrText
501: (itemtype => l_item_type,
502: itemkey => l_item_key,
503: aname => 'DOCUMENT_TYPE_DISP');
504:

Line 505: l_document_number := wf_engine.GetItemAttrText

501: (itemtype => l_item_type,
502: itemkey => l_item_key,
503: aname => 'DOCUMENT_TYPE_DISP');
504:
505: l_document_number := wf_engine.GetItemAttrText
506: (itemtype => l_item_type,
507: itemkey => l_item_key,
508: aname => 'DOCUMENT_NUMBER');
509:

Line 510: l_currency_code := wf_engine.GetItemAttrText

506: (itemtype => l_item_type,
507: itemkey => l_item_key,
508: aname => 'DOCUMENT_NUMBER');
509:
510: l_currency_code := wf_engine.GetItemAttrText
511: (itemtype => l_item_type,
512: itemkey => l_item_key,
513: aname => 'FUNCTIONAL_CURRENCY');
514:

Line 515: l_total_amount := wf_engine.GetItemAttrText

511: (itemtype => l_item_type,
512: itemkey => l_item_key,
513: aname => 'FUNCTIONAL_CURRENCY');
514:
515: l_total_amount := wf_engine.GetItemAttrText
516: (itemtype => l_item_type,
517: itemkey => l_item_key,
518: aname => 'TOTAL_AMOUNT_DSP');
519:

Line 522: l_req_amount := wf_engine.GetItemAttrText

518: aname => 'TOTAL_AMOUNT_DSP');
519:
520: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NO_APPROVER');
521:
522: l_req_amount := wf_engine.GetItemAttrText
523: (itemtype => l_item_type,
524: itemkey => l_item_key,
525: aname => 'REQ_AMOUNT_DSP');
526:

Line 527: l_tax_amount := wf_engine.GetItemAttrText

523: (itemtype => l_item_type,
524: itemkey => l_item_key,
525: aname => 'REQ_AMOUNT_DSP');
526:
527: l_tax_amount := wf_engine.GetItemAttrText
528: (itemtype => l_item_type,
529: itemkey => l_item_key,
530: aname => 'TAX_AMOUNT_DSP');
531:

Line 532: l_description := wf_engine.GetItemAttrText

528: (itemtype => l_item_type,
529: itemkey => l_item_key,
530: aname => 'TAX_AMOUNT_DSP');
531:
532: l_description := wf_engine.GetItemAttrText
533: (itemtype => l_item_type,
534: itemkey => l_item_key,
535: aname => 'REQ_DESCRIPTION');
536:

Line 537: l_approver := wf_engine.GetItemAttrText

533: (itemtype => l_item_type,
534: itemkey => l_item_key,
535: aname => 'REQ_DESCRIPTION');
536:
537: l_approver := wf_engine.GetItemAttrText
538: (itemtype => l_item_type,
539: itemkey => l_item_key,
540: aname => 'APPROVER_DISPLAY_NAME');
541:

Line 542: l_preparer := wf_engine.GetItemAttrText

538: (itemtype => l_item_type,
539: itemkey => l_item_key,
540: aname => 'APPROVER_DISPLAY_NAME');
541:
542: l_preparer := wf_engine.GetItemAttrText
543: (itemtype => l_item_type,
544: itemkey => l_item_key,
545: aname => 'PREPARER_DISPLAY_NAME');
546:

Line 547: l_note := wf_engine.GetItemAttrText

543: (itemtype => l_item_type,
544: itemkey => l_item_key,
545: aname => 'PREPARER_DISPLAY_NAME');
546:
547: l_note := wf_engine.GetItemAttrText
548: (itemtype => l_item_type,
549: itemkey => l_item_key,
550: aname => 'NOTE');
551:

Line 688: l_document_id := wf_engine.GetItemAttrNumber

684: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
685: l_item_key := substr(document_id, instr(document_id, ':') + 1,
686: length(document_id) - 2);
687:
688: l_document_id := wf_engine.GetItemAttrNumber
689: (itemtype => l_item_type,
690: itemkey => l_item_key,
691: aname => 'DOCUMENT_ID');
692:

Line 693: l_org_id := wf_engine.GetItemAttrNumber

689: (itemtype => l_item_type,
690: itemkey => l_item_key,
691: aname => 'DOCUMENT_ID');
692:
693: l_org_id := wf_engine.GetItemAttrNumber
694: (itemtype => l_item_type,
695: itemkey => l_item_key,
696: aname => 'ORG_ID');
697:

Line 700: l_document_subtype := wf_engine.GetItemAttrText

696: aname => 'ORG_ID');
697:
698: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
699:
700: l_document_subtype := wf_engine.GetItemAttrText
701: (itemtype => l_item_type,
702: itemkey => l_item_key,
703: aname => 'DOCUMENT_SUBTYPE_DISP');
704:

Line 705: l_document_type := wf_engine.GetItemAttrText

701: (itemtype => l_item_type,
702: itemkey => l_item_key,
703: aname => 'DOCUMENT_SUBTYPE_DISP');
704:
705: l_document_type := wf_engine.GetItemAttrText
706: (itemtype => l_item_type,
707: itemkey => l_item_key,
708: aname => 'DOCUMENT_TYPE_DISP');
709:

Line 710: l_document_number := wf_engine.GetItemAttrText

706: (itemtype => l_item_type,
707: itemkey => l_item_key,
708: aname => 'DOCUMENT_TYPE_DISP');
709:
710: l_document_number := wf_engine.GetItemAttrText
711: (itemtype => l_item_type,
712: itemkey => l_item_key,
713: aname => 'DOCUMENT_NUMBER');
714:

Line 715: l_currency_code := wf_engine.GetItemAttrText

711: (itemtype => l_item_type,
712: itemkey => l_item_key,
713: aname => 'DOCUMENT_NUMBER');
714:
715: l_currency_code := wf_engine.GetItemAttrText
716: (itemtype => l_item_type,
717: itemkey => l_item_key,
718: aname => 'FUNCTIONAL_CURRENCY');
719:

Line 720: l_total_amount := wf_engine.GetItemAttrText

716: (itemtype => l_item_type,
717: itemkey => l_item_key,
718: aname => 'FUNCTIONAL_CURRENCY');
719:
720: l_total_amount := wf_engine.GetItemAttrText
721: (itemtype => l_item_type,
722: itemkey => l_item_key,
723: aname => 'TOTAL_AMOUNT_DSP');
724:

Line 727: l_req_amount := wf_engine.GetItemAttrText

723: aname => 'TOTAL_AMOUNT_DSP');
724:
725: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_NO_APPROVER');
726:
727: l_req_amount := wf_engine.GetItemAttrText
728: (itemtype => l_item_type,
729: itemkey => l_item_key,
730: aname => 'REQ_AMOUNT_DSP');
731:

Line 732: l_tax_amount := wf_engine.GetItemAttrText

728: (itemtype => l_item_type,
729: itemkey => l_item_key,
730: aname => 'REQ_AMOUNT_DSP');
731:
732: l_tax_amount := wf_engine.GetItemAttrText
733: (itemtype => l_item_type,
734: itemkey => l_item_key,
735: aname => 'TAX_AMOUNT_DSP');
736:

Line 737: l_description := wf_engine.GetItemAttrText

733: (itemtype => l_item_type,
734: itemkey => l_item_key,
735: aname => 'TAX_AMOUNT_DSP');
736:
737: l_description := wf_engine.GetItemAttrText
738: (itemtype => l_item_type,
739: itemkey => l_item_key,
740: aname => 'REQ_DESCRIPTION');
741:

Line 742: l_rejected_by := wf_engine.GetItemAttrText

738: (itemtype => l_item_type,
739: itemkey => l_item_key,
740: aname => 'REQ_DESCRIPTION');
741:
742: l_rejected_by := wf_engine.GetItemAttrText
743: (itemtype => l_item_type,
744: itemkey => l_item_key,
745: aname => 'APPROVER_DISPLAY_NAME');
746:

Line 747: l_preparer := wf_engine.GetItemAttrText

743: (itemtype => l_item_type,
744: itemkey => l_item_key,
745: aname => 'APPROVER_DISPLAY_NAME');
746:
747: l_preparer := wf_engine.GetItemAttrText
748: (itemtype => l_item_type,
749: itemkey => l_item_key,
750: aname => 'PREPARER_DISPLAY_NAME');
751:

Line 752: l_note := wf_engine.GetItemAttrText

748: (itemtype => l_item_type,
749: itemkey => l_item_key,
750: aname => 'PREPARER_DISPLAY_NAME');
751:
752: l_note := wf_engine.GetItemAttrText
753: (itemtype => l_item_type,
754: itemkey => l_item_key,
755: aname => 'NOTE');
756:

Line 912: l_document_id := wf_engine.GetItemAttrNumber

908: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
909: l_item_key := substr(document_id, instr(document_id, ':') + 1,
910: length(document_id) - 2);
911:
912: l_document_id := wf_engine.GetItemAttrNumber
913: (itemtype => l_item_type,
914: itemkey => l_item_key,
915: aname => 'DOCUMENT_ID');
916:

Line 917: l_org_id := wf_engine.GetItemAttrNumber

913: (itemtype => l_item_type,
914: itemkey => l_item_key,
915: aname => 'DOCUMENT_ID');
916:
917: l_org_id := wf_engine.GetItemAttrNumber
918: (itemtype => l_item_type,
919: itemkey => l_item_key,
920: aname => 'ORG_ID');
921:

Line 1074: l_document_id := wf_engine.GetItemAttrNumber

1070: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
1071: l_item_key := substr(document_id, instr(document_id, ':') + 1,
1072: length(document_id) - 2);
1073:
1074: l_document_id := wf_engine.GetItemAttrNumber
1075: (itemtype => l_item_type,
1076: itemkey => l_item_key,
1077: aname => 'DOCUMENT_ID');
1078:

Line 1079: l_org_id := wf_engine.GetItemAttrNumber

1075: (itemtype => l_item_type,
1076: itemkey => l_item_key,
1077: aname => 'DOCUMENT_ID');
1078:
1079: l_org_id := wf_engine.GetItemAttrNumber
1080: (itemtype => l_item_type,
1081: itemkey => l_item_key,
1082: aname => 'ORG_ID');
1083: