APPS.PO_WF_REQ_NOTIFICATION dependencies on WF_ENGINE

Line 241: l_document_id := wf_engine.GetItemAttrNumber

237: ** notification UI enhancement
238: */
239: get_item_info(document_id, l_item_type, l_item_key, l_notification_id);
240:
241: l_document_id := wf_engine.GetItemAttrNumber
242: (itemtype => l_item_type,
243: itemkey => l_item_key,
244: aname => 'DOCUMENT_ID');
245:

Line 246: l_org_id := wf_engine.GetItemAttrNumber

242: (itemtype => l_item_type,
243: itemkey => l_item_key,
244: aname => 'DOCUMENT_ID');
245:
246: l_org_id := wf_engine.GetItemAttrNumber
247: (itemtype => l_item_type,
248: itemkey => l_item_key,
249: aname => 'ORG_ID');
250:

Line 258: l_document_subtype := get_document_subtype_display(wf_engine.GetItemAttrText

254: -- Context setting Revamp
255: -- PO_REQAPPROVAL_INIT1.Set_doc_mgr_context (l_item_type,l_item_key);
256:
257: /*
258: l_document_subtype := get_document_subtype_display(wf_engine.GetItemAttrText
259: (itemtype => l_item_type,
260: itemkey => l_item_key,
261: aname => 'DOCUMENT_SUBTYPE'));
262: */

Line 268: l_document_type := wf_engine.GetItemAttrText (itemtype => l_item_type,

264: /* Bug# 2616355
265: ** Get directly from wf DOCUMENT_TYPE_DISP attribute
266: */
267:
268: l_document_type := wf_engine.GetItemAttrText (itemtype => l_item_type,
269: itemkey => l_item_key,
270: aname => 'DOCUMENT_TYPE_DISP');
271:
272: /*

Line 273: l_document_type := get_document_type_display(wf_engine.GetItemAttrText

269: itemkey => l_item_key,
270: aname => 'DOCUMENT_TYPE_DISP');
271:
272: /*
273: l_document_type := get_document_type_display(wf_engine.GetItemAttrText
274: (itemtype => l_item_type,
275: itemkey => l_item_key,
276: aname => 'DOCUMENT_TYPE'));
277:

Line 280: l_document_number := wf_engine.GetItemAttrText

276: aname => 'DOCUMENT_TYPE'));
277:
278: */
279:
280: l_document_number := wf_engine.GetItemAttrText
281: (itemtype => l_item_type,
282: itemkey => l_item_key,
283: aname => 'DOCUMENT_NUMBER');
284:

Line 285: l_currency_code := wf_engine.GetItemAttrText

281: (itemtype => l_item_type,
282: itemkey => l_item_key,
283: aname => 'DOCUMENT_NUMBER');
284:
285: l_currency_code := wf_engine.GetItemAttrText
286: (itemtype => l_item_type,
287: itemkey => l_item_key,
288: aname => 'FUNCTIONAL_CURRENCY');
289:

Line 290: l_total_amount := wf_engine.GetItemAttrText

286: (itemtype => l_item_type,
287: itemkey => l_item_key,
288: aname => 'FUNCTIONAL_CURRENCY');
289:
290: l_total_amount := wf_engine.GetItemAttrText
291: (itemtype => l_item_type,
292: itemkey => l_item_key,
293: aname => 'TOTAL_AMOUNT_DSP');
294:

Line 295: l_req_amount := wf_engine.GetItemAttrText

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

Line 300: l_tax_amount := wf_engine.GetItemAttrText

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

Line 305: l_description := wf_engine.GetItemAttrText

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

Line 310: l_forwarded_from := wf_engine.GetItemAttrText

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

Line 315: l_preparer := wf_engine.GetItemAttrText

311: (itemtype => l_item_type,
312: itemkey => l_item_key,
313: aname => 'FORWARD_FROM_DISP_NAME');
314:
315: l_preparer := wf_engine.GetItemAttrText
316: (itemtype => l_item_type,
317: itemkey => l_item_key,
318: aname => 'PREPARER_DISPLAY_NAME');
319:

Line 327: l_note := wf_engine.GetItemAttrText

323: aname => 'JUSTIFICATION');
324:
325: if l_note is null then
326:
327: l_note := wf_engine.GetItemAttrText
328: (itemtype => l_item_type,
329: itemkey => l_item_key,
330: aname => 'NOTE');
331:

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

375: itemkey => l_item_key,
376: p_document_id => l_document_id,
377: p_currency_code => l_currency_code);
378:
379: if wf_engine.GetItemAttrText(itemtype => l_item_type,
380: itemkey => l_item_key,
381: aname => 'REQUIRES_APPROVAL_MSG') is not null then
382:
383: l_header_msg := fnd_message.get_string('PO', 'PO_WF_NOTIF_APPROVAL_MSG');

Line 487: l_document_id := wf_engine.GetItemAttrNumber

483: ** notification UI enhancement
484: */
485: get_item_info(document_id, l_item_type, l_item_key, l_notification_id);
486:
487: l_document_id := wf_engine.GetItemAttrNumber
488: (itemtype => l_item_type,
489: itemkey => l_item_key,
490: aname => 'DOCUMENT_ID');
491:

Line 492: l_org_id := wf_engine.GetItemAttrNumber

488: (itemtype => l_item_type,
489: itemkey => l_item_key,
490: aname => 'DOCUMENT_ID');
491:
492: l_org_id := wf_engine.GetItemAttrNumber
493: (itemtype => l_item_type,
494: itemkey => l_item_key,
495: aname => 'ORG_ID');
496:

Line 500: l_document_subtype := get_document_subtype_display(wf_engine.GetItemAttrText

496:
497: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
498:
499: /*
500: l_document_subtype := get_document_subtype_display(wf_engine.GetItemAttrText
501: (itemtype => l_item_type,
502: itemkey => l_item_key,
503: aname => 'DOCUMENT_SUBTYPE'));
504: */

Line 510: l_document_type := wf_engine.GetItemAttrText (itemtype => l_item_type,

506: /* Bug# 2616355
507: ** Get directly from wf DOCUMENT_TYPE_DISP attribute
508: */
509:
510: l_document_type := wf_engine.GetItemAttrText (itemtype => l_item_type,
511: itemkey => l_item_key,
512: aname => 'DOCUMENT_TYPE_DISP');
513:
514: /*

Line 515: l_document_type := get_document_type_display(wf_engine.GetItemAttrText

511: itemkey => l_item_key,
512: aname => 'DOCUMENT_TYPE_DISP');
513:
514: /*
515: l_document_type := get_document_type_display(wf_engine.GetItemAttrText
516: (itemtype => l_item_type,
517: itemkey => l_item_key,
518: aname => 'DOCUMENT_TYPE'));
519: */

Line 521: l_document_number := wf_engine.GetItemAttrText

517: itemkey => l_item_key,
518: aname => 'DOCUMENT_TYPE'));
519: */
520:
521: l_document_number := wf_engine.GetItemAttrText
522: (itemtype => l_item_type,
523: itemkey => l_item_key,
524: aname => 'DOCUMENT_NUMBER');
525:

Line 526: l_currency_code := wf_engine.GetItemAttrText

522: (itemtype => l_item_type,
523: itemkey => l_item_key,
524: aname => 'DOCUMENT_NUMBER');
525:
526: l_currency_code := wf_engine.GetItemAttrText
527: (itemtype => l_item_type,
528: itemkey => l_item_key,
529: aname => 'FUNCTIONAL_CURRENCY');
530:

Line 531: l_total_amount := wf_engine.GetItemAttrText

527: (itemtype => l_item_type,
528: itemkey => l_item_key,
529: aname => 'FUNCTIONAL_CURRENCY');
530:
531: l_total_amount := wf_engine.GetItemAttrText
532: (itemtype => l_item_type,
533: itemkey => l_item_key,
534: aname => 'TOTAL_AMOUNT_DSP');
535:

Line 536: l_req_amount := wf_engine.GetItemAttrText

532: (itemtype => l_item_type,
533: itemkey => l_item_key,
534: aname => 'TOTAL_AMOUNT_DSP');
535:
536: l_req_amount := wf_engine.GetItemAttrText
537: (itemtype => l_item_type,
538: itemkey => l_item_key,
539: aname => 'REQ_AMOUNT_DSP');
540:

Line 541: l_tax_amount := wf_engine.GetItemAttrText

537: (itemtype => l_item_type,
538: itemkey => l_item_key,
539: aname => 'REQ_AMOUNT_DSP');
540:
541: l_tax_amount := wf_engine.GetItemAttrText
542: (itemtype => l_item_type,
543: itemkey => l_item_key,
544: aname => 'TAX_AMOUNT_DSP');
545:

Line 546: l_description := wf_engine.GetItemAttrText

542: (itemtype => l_item_type,
543: itemkey => l_item_key,
544: aname => 'TAX_AMOUNT_DSP');
545:
546: l_description := wf_engine.GetItemAttrText
547: (itemtype => l_item_type,
548: itemkey => l_item_key,
549: aname => 'REQ_DESCRIPTION');
550:

Line 551: l_approver := wf_engine.GetItemAttrText

547: (itemtype => l_item_type,
548: itemkey => l_item_key,
549: aname => 'REQ_DESCRIPTION');
550:
551: l_approver := wf_engine.GetItemAttrText
552: (itemtype => l_item_type,
553: itemkey => l_item_key,
554: aname => 'APPROVER_DISPLAY_NAME');
555:

Line 556: l_preparer := wf_engine.GetItemAttrText

552: (itemtype => l_item_type,
553: itemkey => l_item_key,
554: aname => 'APPROVER_DISPLAY_NAME');
555:
556: l_preparer := wf_engine.GetItemAttrText
557: (itemtype => l_item_type,
558: itemkey => l_item_key,
559: aname => 'PREPARER_DISPLAY_NAME');
560:

Line 568: l_note := wf_engine.GetItemAttrText

564: aname => 'JUSTIFICATION');
565:
566: if l_note is null then
567:
568: l_note := wf_engine.GetItemAttrText
569: (itemtype => l_item_type,
570: itemkey => l_item_key,
571: aname => 'NOTE');
572:

Line 593: l_warning_msg := wf_engine.GetItemAttrText

589: end;
590:
591: if l_attr_exist > 0 then
592:
593: l_warning_msg := wf_engine.GetItemAttrText
594: (itemtype => l_item_type,
595: itemkey => l_item_key,
596: aname => 'ADVISORY_WARNING');
597: end if;

Line 754: l_document_id := wf_engine.GetItemAttrNumber

750: ** notification UI enhancement
751: */
752: get_item_info(document_id, l_item_type, l_item_key, l_notification_id);
753:
754: l_document_id := wf_engine.GetItemAttrNumber
755: (itemtype => l_item_type,
756: itemkey => l_item_key,
757: aname => 'DOCUMENT_ID');
758:

Line 759: l_org_id := wf_engine.GetItemAttrNumber

755: (itemtype => l_item_type,
756: itemkey => l_item_key,
757: aname => 'DOCUMENT_ID');
758:
759: l_org_id := wf_engine.GetItemAttrNumber
760: (itemtype => l_item_type,
761: itemkey => l_item_key,
762: aname => 'ORG_ID');
763:

Line 767: l_document_subtype := get_document_subtype_display(wf_engine.GetItemAttrText

763:
764: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
765:
766: /*
767: l_document_subtype := get_document_subtype_display(wf_engine.GetItemAttrText
768: (itemtype => l_item_type,
769: itemkey => l_item_key,
770: aname => 'DOCUMENT_SUBTYPE'));
771: */

Line 776: l_document_type := wf_engine.GetItemAttrText (itemtype => l_item_type,

772: /* Bug# 2616355
773: ** Get directly from wf DOCUMENT_TYPE_DISP attribute
774: */
775:
776: l_document_type := wf_engine.GetItemAttrText (itemtype => l_item_type,
777: itemkey => l_item_key,
778: aname => 'DOCUMENT_TYPE_DISP');
779:
780: /*

Line 781: l_document_type := get_document_type_display(wf_engine.GetItemAttrText

777: itemkey => l_item_key,
778: aname => 'DOCUMENT_TYPE_DISP');
779:
780: /*
781: l_document_type := get_document_type_display(wf_engine.GetItemAttrText
782: (itemtype => l_item_type,
783: itemkey => l_item_key,
784: aname => 'DOCUMENT_TYPE'));
785: */

Line 787: l_document_number := wf_engine.GetItemAttrText

783: itemkey => l_item_key,
784: aname => 'DOCUMENT_TYPE'));
785: */
786:
787: l_document_number := wf_engine.GetItemAttrText
788: (itemtype => l_item_type,
789: itemkey => l_item_key,
790: aname => 'DOCUMENT_NUMBER');
791:

Line 792: l_currency_code := wf_engine.GetItemAttrText

788: (itemtype => l_item_type,
789: itemkey => l_item_key,
790: aname => 'DOCUMENT_NUMBER');
791:
792: l_currency_code := wf_engine.GetItemAttrText
793: (itemtype => l_item_type,
794: itemkey => l_item_key,
795: aname => 'FUNCTIONAL_CURRENCY');
796:

Line 797: l_total_amount := wf_engine.GetItemAttrText

793: (itemtype => l_item_type,
794: itemkey => l_item_key,
795: aname => 'FUNCTIONAL_CURRENCY');
796:
797: l_total_amount := wf_engine.GetItemAttrText
798: (itemtype => l_item_type,
799: itemkey => l_item_key,
800: aname => 'TOTAL_AMOUNT_DSP');
801:

Line 802: l_req_amount := wf_engine.GetItemAttrText

798: (itemtype => l_item_type,
799: itemkey => l_item_key,
800: aname => 'TOTAL_AMOUNT_DSP');
801:
802: l_req_amount := wf_engine.GetItemAttrText
803: (itemtype => l_item_type,
804: itemkey => l_item_key,
805: aname => 'REQ_AMOUNT_DSP');
806:

Line 807: l_tax_amount := wf_engine.GetItemAttrText

803: (itemtype => l_item_type,
804: itemkey => l_item_key,
805: aname => 'REQ_AMOUNT_DSP');
806:
807: l_tax_amount := wf_engine.GetItemAttrText
808: (itemtype => l_item_type,
809: itemkey => l_item_key,
810: aname => 'TAX_AMOUNT_DSP');
811:

Line 812: l_description := wf_engine.GetItemAttrText

808: (itemtype => l_item_type,
809: itemkey => l_item_key,
810: aname => 'TAX_AMOUNT_DSP');
811:
812: l_description := wf_engine.GetItemAttrText
813: (itemtype => l_item_type,
814: itemkey => l_item_key,
815: aname => 'REQ_DESCRIPTION');
816:

Line 817: l_approver := wf_engine.GetItemAttrText

813: (itemtype => l_item_type,
814: itemkey => l_item_key,
815: aname => 'REQ_DESCRIPTION');
816:
817: l_approver := wf_engine.GetItemAttrText
818: (itemtype => l_item_type,
819: itemkey => l_item_key,
820: aname => 'APPROVER_DISPLAY_NAME');
821:

Line 822: l_preparer := wf_engine.GetItemAttrText

818: (itemtype => l_item_type,
819: itemkey => l_item_key,
820: aname => 'APPROVER_DISPLAY_NAME');
821:
822: l_preparer := wf_engine.GetItemAttrText
823: (itemtype => l_item_type,
824: itemkey => l_item_key,
825: aname => 'PREPARER_DISPLAY_NAME');
826:

Line 834: l_note := wf_engine.GetItemAttrText

830: aname => 'JUSTIFICATION');
831:
832: if l_note is null then
833:
834: l_note := wf_engine.GetItemAttrText
835: (itemtype => l_item_type,
836: itemkey => l_item_key,
837: aname => 'NOTE');
838:

Line 979: l_document_id := wf_engine.GetItemAttrNumber

975: ** notification UI enhancement
976: */
977: get_item_info(document_id, l_item_type, l_item_key, l_notification_id);
978:
979: l_document_id := wf_engine.GetItemAttrNumber
980: (itemtype => l_item_type,
981: itemkey => l_item_key,
982: aname => 'DOCUMENT_ID');
983:

Line 984: l_org_id := wf_engine.GetItemAttrNumber

980: (itemtype => l_item_type,
981: itemkey => l_item_key,
982: aname => 'DOCUMENT_ID');
983:
984: l_org_id := wf_engine.GetItemAttrNumber
985: (itemtype => l_item_type,
986: itemkey => l_item_key,
987: aname => 'ORG_ID');
988:

Line 992: l_document_subtype := get_document_subtype_display(wf_engine.GetItemAttrText

988:
989: PO_MOAC_UTILS_PVT.set_org_context(l_org_id) ; --
990:
991: /*
992: l_document_subtype := get_document_subtype_display(wf_engine.GetItemAttrText
993: (itemtype => l_item_type,
994: itemkey => l_item_key,
995: aname => 'DOCUMENT_SUBTYPE'));
996: */

Line 1002: l_document_type := wf_engine.GetItemAttrText (itemtype => l_item_type,

998: /* Bug# 2616355
999: ** Get directly from wf DOCUMENT_TYPE_DISP attribute
1000: */
1001:
1002: l_document_type := wf_engine.GetItemAttrText (itemtype => l_item_type,
1003: itemkey => l_item_key,
1004: aname => 'DOCUMENT_TYPE_DISP');
1005:
1006: /*

Line 1007: l_document_type := get_document_type_display(wf_engine.GetItemAttrText

1003: itemkey => l_item_key,
1004: aname => 'DOCUMENT_TYPE_DISP');
1005:
1006: /*
1007: l_document_type := get_document_type_display(wf_engine.GetItemAttrText
1008: (itemtype => l_item_type,
1009: itemkey => l_item_key,
1010: aname => 'DOCUMENT_TYPE'));
1011: */

Line 1013: l_document_number := wf_engine.GetItemAttrText

1009: itemkey => l_item_key,
1010: aname => 'DOCUMENT_TYPE'));
1011: */
1012:
1013: l_document_number := wf_engine.GetItemAttrText
1014: (itemtype => l_item_type,
1015: itemkey => l_item_key,
1016: aname => 'DOCUMENT_NUMBER');
1017:

Line 1018: l_currency_code := wf_engine.GetItemAttrText

1014: (itemtype => l_item_type,
1015: itemkey => l_item_key,
1016: aname => 'DOCUMENT_NUMBER');
1017:
1018: l_currency_code := wf_engine.GetItemAttrText
1019: (itemtype => l_item_type,
1020: itemkey => l_item_key,
1021: aname => 'FUNCTIONAL_CURRENCY');
1022:

Line 1023: l_total_amount := wf_engine.GetItemAttrText

1019: (itemtype => l_item_type,
1020: itemkey => l_item_key,
1021: aname => 'FUNCTIONAL_CURRENCY');
1022:
1023: l_total_amount := wf_engine.GetItemAttrText
1024: (itemtype => l_item_type,
1025: itemkey => l_item_key,
1026: aname => 'TOTAL_AMOUNT_DSP');
1027:

Line 1028: l_req_amount := wf_engine.GetItemAttrText

1024: (itemtype => l_item_type,
1025: itemkey => l_item_key,
1026: aname => 'TOTAL_AMOUNT_DSP');
1027:
1028: l_req_amount := wf_engine.GetItemAttrText
1029: (itemtype => l_item_type,
1030: itemkey => l_item_key,
1031: aname => 'REQ_AMOUNT_DSP');
1032:

Line 1033: l_tax_amount := wf_engine.GetItemAttrText

1029: (itemtype => l_item_type,
1030: itemkey => l_item_key,
1031: aname => 'REQ_AMOUNT_DSP');
1032:
1033: l_tax_amount := wf_engine.GetItemAttrText
1034: (itemtype => l_item_type,
1035: itemkey => l_item_key,
1036: aname => 'TAX_AMOUNT_DSP');
1037:

Line 1038: l_description := wf_engine.GetItemAttrText

1034: (itemtype => l_item_type,
1035: itemkey => l_item_key,
1036: aname => 'TAX_AMOUNT_DSP');
1037:
1038: l_description := wf_engine.GetItemAttrText
1039: (itemtype => l_item_type,
1040: itemkey => l_item_key,
1041: aname => 'REQ_DESCRIPTION');
1042:

Line 1043: l_rejected_by := wf_engine.GetItemAttrText

1039: (itemtype => l_item_type,
1040: itemkey => l_item_key,
1041: aname => 'REQ_DESCRIPTION');
1042:
1043: l_rejected_by := wf_engine.GetItemAttrText
1044: (itemtype => l_item_type,
1045: itemkey => l_item_key,
1046: aname => 'APPROVER_DISPLAY_NAME');
1047:

Line 1048: l_preparer := wf_engine.GetItemAttrText

1044: (itemtype => l_item_type,
1045: itemkey => l_item_key,
1046: aname => 'APPROVER_DISPLAY_NAME');
1047:
1048: l_preparer := wf_engine.GetItemAttrText
1049: (itemtype => l_item_type,
1050: itemkey => l_item_key,
1051: aname => 'PREPARER_DISPLAY_NAME');
1052:

Line 1060: l_note := wf_engine.GetItemAttrText

1056: aname => 'JUSTIFICATION');
1057:
1058: if l_note is null then
1059:
1060: l_note := wf_engine.GetItemAttrText
1061: (itemtype => l_item_type,
1062: itemkey => l_item_key,
1063: aname => 'NOTE');
1064:

Line 1290: l_document_id := wf_engine.GetItemAttrNumber

1286: set_doc_mgr_context(l_item_type, l_item_key);
1287:
1288: END IF; */
1289:
1290: l_document_id := wf_engine.GetItemAttrNumber
1291: (itemtype => l_item_type,
1292: itemkey => l_item_key,
1293: aname => 'DOCUMENT_ID');
1294:

Line 1295: l_org_id := wf_engine.GetItemAttrNumber

1291: (itemtype => l_item_type,
1292: itemkey => l_item_key,
1293: aname => 'DOCUMENT_ID');
1294:
1295: l_org_id := wf_engine.GetItemAttrNumber
1296: (itemtype => l_item_type,
1297: itemkey => l_item_key,
1298: aname => 'ORG_ID');
1299:

Line 1514: l_document_id := wf_engine.GetItemAttrNumber

1510: ** notification UI enhancement
1511: */
1512: get_item_info(document_id, l_item_type, l_item_key, l_notification_id);
1513:
1514: l_document_id := wf_engine.GetItemAttrNumber
1515: (itemtype => l_item_type,
1516: itemkey => l_item_key,
1517: aname => 'DOCUMENT_ID');
1518:

Line 1519: l_org_id := wf_engine.GetItemAttrNumber

1515: (itemtype => l_item_type,
1516: itemkey => l_item_key,
1517: aname => 'DOCUMENT_ID');
1518:
1519: l_org_id := wf_engine.GetItemAttrNumber
1520: (itemtype => l_item_type,
1521: itemkey => l_item_key,
1522: aname => 'ORG_ID');
1523:

Line 1942: l_document_id := wf_engine.GetItemAttrNumber

1938: ** notification UI enhancement
1939: */
1940: get_item_info(document_id, l_item_type, l_item_key, l_notification_id);
1941:
1942: l_document_id := wf_engine.GetItemAttrNumber
1943: (itemtype => l_item_type,
1944: itemkey => l_item_key,
1945: aname => 'DOCUMENT_ID');
1946:

Line 1947: l_org_id := wf_engine.GetItemAttrNumber

1943: (itemtype => l_item_type,
1944: itemkey => l_item_key,
1945: aname => 'DOCUMENT_ID');
1946:
1947: l_org_id := wf_engine.GetItemAttrNumber
1948: (itemtype => l_item_type,
1949: itemkey => l_item_key,
1950: aname => 'ORG_ID');
1951:

Line 2141: l_document_id := wf_engine.GetItemAttrNumber

2137: ORDER BY 1 asc;
2138:
2139: BEGIN
2140:
2141: l_document_id := wf_engine.GetItemAttrNumber
2142: (itemtype => p_item_type,
2143: itemkey => p_item_key,
2144: aname => 'DOCUMENT_ID');
2145:

Line 2146: l_org_id := wf_engine.GetItemAttrNumber

2142: (itemtype => p_item_type,
2143: itemkey => p_item_key,
2144: aname => 'DOCUMENT_ID');
2145:
2146: l_org_id := wf_engine.GetItemAttrNumber
2147: (itemtype => p_item_type,
2148: itemkey => p_item_key,
2149: aname => 'ORG_ID');
2150:

Line 2613: l_req_header_id := wf_engine.GetItemAttrNumber

2609: elsif (funcmode = 'ANSWER') then
2610: l_action := 'ANSWER';
2611: end if;
2612:
2613: l_req_header_id := wf_engine.GetItemAttrNumber
2614: (itemtype => itemtype,
2615: itemkey => itemkey,
2616: aname => 'DOCUMENT_ID');
2617:

Line 2618: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_NEW_ROLE, l_origsys, l_new_recipient_id);

2614: (itemtype => itemtype,
2615: itemkey => itemkey,
2616: aname => 'DOCUMENT_ID');
2617:
2618: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_NEW_ROLE, l_origsys, l_new_recipient_id);
2619:
2620: /* bug 4667656 : We should not be allowing the delegation of a notication
2621: to a user who is not an employee. */
2622:

Line 2631: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_MORE_INFO_ROLE, l_origsys, l_current_recipient_id);

2627:
2628: l_progress := '002';
2629:
2630: if (funcmode = 'ANSWER') then
2631: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_MORE_INFO_ROLE, l_origsys, l_current_recipient_id);
2632:
2633: else
2634: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_RECIPIENT_ROLE, l_origsys, l_current_recipient_id);
2635:

Line 2634: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_RECIPIENT_ROLE, l_origsys, l_current_recipient_id);

2630: if (funcmode = 'ANSWER') then
2631: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_MORE_INFO_ROLE, l_origsys, l_current_recipient_id);
2632:
2633: else
2634: Wf_Directory.GetRoleOrigSysInfo(WF_ENGINE.CONTEXT_RECIPIENT_ROLE, l_origsys, l_current_recipient_id);
2635:
2636: end if;
2637:
2638: l_progress := '003';

Line 2657: p_note => WF_ENGINE.CONTEXT_USER_COMMENT,

2653: l_progress := '004';
2654:
2655: update_action_history(p_action_code => l_action,
2656: p_recipient_id => l_new_recipient_id,
2657: p_note => WF_ENGINE.CONTEXT_USER_COMMENT,
2658: p_req_header_id => l_req_header_id,
2659: p_current_id => l_current_recipient_id);
2660:
2661: l_progress := '005';

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

2659: p_current_id => l_current_recipient_id);
2660:
2661: l_progress := '005';
2662:
2663: resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;
2664:
2665: return;
2666: end if;
2667:

Line 2671: l_nid := WF_ENGINE.context_nid;

2667:
2668:
2669: if (funcmode = 'RESPOND') then
2670:
2671: l_nid := WF_ENGINE.context_nid;
2672:
2673: l_result := wf_notification.GetAttrText(l_nid, 'RESULT');
2674:
2675: l_progress := '006';

Line 2681: l_forward_to_username_response := wf_engine.GetItemAttrText (itemtype => itemtype,

2677: if((l_result = 'FORWARD') or (l_result = 'APPROVE_AND_FORWARD')) then
2678:
2679: l_forwardTo := wf_notification.GetAttrText(l_nid, 'FORWARD_TO_USERNAME_RESPONSE');
2680:
2681: l_forward_to_username_response := wf_engine.GetItemAttrText (itemtype => itemtype,
2682: itemkey => itemkey,
2683: aname => 'FORWARD_TO_USERNAME_RESPONSE');
2684:
2685: if(l_forwardTo is null) then

Line 2695: if (wf_engine.preserved_context = TRUE) then

2691: l_progress := '007';
2692:
2693: -- Context setting revamp
2694: --
2695: if (wf_engine.preserved_context = TRUE) then
2696: l_preserved_ctx := 'TRUE';
2697: else
2698: l_preserved_ctx := 'FALSE';
2699: end if;

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

2855:
2856:
2857:
2858:
2859: resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;
2860: return;
2861: end if;
2862:
2863: -- Don't allow transfer

Line 2867: resultout := wf_engine.eng_completed;

2863: -- Don't allow transfer
2864: if (funcmode = 'TRANSFER') then
2865: fnd_message.set_name('PO', 'PO_WF_NOTIF_NO_TRANSFER');
2866: app_exception.raise_exception;
2867: resultout := wf_engine.eng_completed;
2868: return;
2869: end if; -- end if for funcmode = 'TRANSFER'
2870:
2871: exception

Line 2888: l_user_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

2884: l_progress varchar2(200);
2885:
2886: BEGIN
2887:
2888: l_user_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
2889: itemkey => itemkey,
2890: aname => 'USER_ID');
2891: --
2892: l_application_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

Line 2892: l_application_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

2888: l_user_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
2889: itemkey => itemkey,
2890: aname => 'USER_ID');
2891: --
2892: l_application_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
2893: itemkey => itemkey,
2894: aname => 'APPLICATION_ID');
2895: --
2896: l_responsibility_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

Line 2896: l_responsibility_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,

2892: l_application_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
2893: itemkey => itemkey,
2894: aname => 'APPLICATION_ID');
2895: --
2896: l_responsibility_id := wf_engine.GetItemAttrNumber ( itemtype => itemtype,
2897: itemkey => itemkey,
2898: aname => 'RESPONSIBILITY_ID');
2899:
2900: /* Set the context for the doc manager */

Line 3102: if (funcmode <> wf_engine.eng_run) then

3098: BEGIN
3099:
3100: -- Do nothing in cancel or timeout mode
3101: --
3102: if (funcmode <> wf_engine.eng_run) then
3103:
3104: resultout := wf_engine.eng_null;
3105: return;
3106:

Line 3104: resultout := wf_engine.eng_null;

3100: -- Do nothing in cancel or timeout mode
3101: --
3102: if (funcmode <> wf_engine.eng_run) then
3103:
3104: resultout := wf_engine.eng_null;
3105: return;
3106:
3107: end if;
3108:

Line 3121: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

3117: /* Bug# 2616355: kagarwal
3118: ** Desc Need to set the org context
3119: */
3120:
3121: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
3122: itemkey => itemkey,
3123: aname => 'ORG_ID');
3124:
3125: IF l_orgid is NOT NULL THEN

Line 3136: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

3132: IF (g_po_wf_debug = 'Y') THEN
3133: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3134: END IF;
3135:
3136: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
3137:
3138:
3139: EXCEPTION
3140: WHEN OTHERS THEN

Line 3164: if (funcmode <> wf_engine.eng_run) then

3160: BEGIN
3161:
3162: -- Do nothing in cancel or timeout mode
3163: --
3164: if (funcmode <> wf_engine.eng_run) then
3165:
3166: resultout := wf_engine.eng_null;
3167: return;
3168:

Line 3166: resultout := wf_engine.eng_null;

3162: -- Do nothing in cancel or timeout mode
3163: --
3164: if (funcmode <> wf_engine.eng_run) then
3165:
3166: resultout := wf_engine.eng_null;
3167: return;
3168:
3169: end if;
3170:

Line 3184: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

3180: /* Bug# 2616355: kagarwal
3181: ** Desc Need to set the org context
3182: */
3183:
3184: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
3185: itemkey => itemkey,
3186: aname => 'ORG_ID');
3187:
3188: IF l_orgid is NOT NULL THEN

Line 3199: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

3195: IF (g_po_wf_debug = 'Y') THEN
3196: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3197: END IF;
3198:
3199: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
3200:
3201:
3202: EXCEPTION
3203: WHEN OTHERS THEN

Line 3225: resultout := wf_engine.eng_completed || ':' || l_allowed;

3221: begin
3222:
3223: FND_PROFILE.GET('PO_ALLOW_REQ_APPRV_FORWARD', l_allowed);
3224:
3225: resultout := wf_engine.eng_completed || ':' || l_allowed;
3226:
3227: exception
3228: when others then
3229: resultout := wf_engine.eng_completed || ':' || 'Y';

Line 3229: resultout := wf_engine.eng_completed || ':' || 'Y';

3225: resultout := wf_engine.eng_completed || ':' || l_allowed;
3226:
3227: exception
3228: when others then
3229: resultout := wf_engine.eng_completed || ':' || 'Y';
3230:
3231: end Is_Forward_Action_Allowed;
3232:
3233: /* Bug# 2616255: kagarwal

Line 3253: if (funcmode <> wf_engine.eng_run) then

3249: BEGIN
3250:
3251: -- Do nothing in cancel or timeout mode
3252: --
3253: if (funcmode <> wf_engine.eng_run) then
3254:
3255: resultout := wf_engine.eng_null;
3256: return;
3257:

Line 3255: resultout := wf_engine.eng_null;

3251: -- Do nothing in cancel or timeout mode
3252: --
3253: if (funcmode <> wf_engine.eng_run) then
3254:
3255: resultout := wf_engine.eng_null;
3256: return;
3257:
3258: end if;
3259:

Line 3269: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,

3265: l_fwdfrom_user_name := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3266: itemkey => itemkey,
3267: aname => 'FORWARD_FROM_USER_NAME');
3268:
3269: l_orgid := wf_engine.GetItemAttrNumber (itemtype => itemtype,
3270: itemkey => itemkey,
3271: aname => 'ORG_ID');
3272:
3273: IF l_orgid is NOT NULL THEN

Line 3284: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

3280: IF (g_po_wf_debug = 'Y') THEN
3281: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
3282: END IF;
3283:
3284: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
3285:
3286: EXCEPTION
3287: WHEN OTHERS THEN
3288: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);