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.

[Home] [Help]

APPS.PO_COMMUNICATION_PVT dependencies on PO_WF_UTIL_PKG

Line 195: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

191: IF (g_po_wf_debug = 'Y') THEN
192: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
193: END IF;
194:
195: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
196: itemkey => itemkey,
197: aname => 'DOCUMENT_ID');
198:
199: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 199: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

195: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
196: itemkey => itemkey,
197: aname => 'DOCUMENT_ID');
198:
199: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
200: itemkey => itemkey,
201: aname => 'DOCUMENT_SUBTYPE');
202:
203: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 203: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

199: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
200: itemkey => itemkey,
201: aname => 'DOCUMENT_SUBTYPE');
202:
203: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
204: itemkey => itemkey,
205: aname => 'REVISION_NUMBER');
206:
207: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,

Line 207: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,

203: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
204: itemkey => itemkey,
205: aname => 'REVISION_NUMBER');
206:
207: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,
208: itemkey => itemkey,
209: aname => 'AUTHORIZATION_STATUS');
210:
211: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,

Line 211: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,

207: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,
208: itemkey => itemkey,
209: aname => 'AUTHORIZATION_STATUS');
210:
211: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,
212: itemkey => itemkey,
213: aname => 'WITH_TERMS');
214:
215: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF :launching the java concurrent program ';

Line 276: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,

272: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
273: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
274: NULL, NULL);
275:
276: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,
277: itemkey => itemkey,
278: aname => 'REQUEST_ID',
279: avalue => l_request_id);
280:

Line 330: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

326:
327:
328: --Get the document type
329:
330: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
331: itemkey => itemkey,
332: aname => 'DOCUMENT_TYPE');
333:
334:

Line 335: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

331: itemkey => itemkey,
332: aname => 'DOCUMENT_TYPE');
333:
334:
335: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
336: itemkey => itemkey,
337: aname => 'DOCUMENT_SUBTYPE');
338:
339: x_progress := 'PO_COMMUNICATION_PVT.PO_NEW_COMMUNICATION: Verify whether XDO Product is installed or not';

Line 400: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype =>itemtype,

396: END IF;
397: --
398:
399:
400: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype =>itemtype,
401: itemkey => itemkey,
402: aname => 'DOCUMENT_ID');
403:
404: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype =>itemtype,

Line 404: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype =>itemtype,

400: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype =>itemtype,
401: itemkey => itemkey,
402: aname => 'DOCUMENT_ID');
403:
404: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype =>itemtype,
405: itemkey => itemkey,
406: aname =>'REVISION_NUMBER');
407:
408: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 408: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

404: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype =>itemtype,
405: itemkey => itemkey,
406: aname =>'REVISION_NUMBER');
407:
408: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
409: itemkey => itemkey,
410: aname => 'DOCUMENT_TYPE');
411:
412:

Line 413: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,

409: itemkey => itemkey,
410: aname => 'DOCUMENT_TYPE');
411:
412:
413: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,
414: itemkey =>itemkey,
415: aname =>'DOCUMENT_SUBTYPE');
416:
417: IF l_document_type in ('PO','PA') and l_document_subtype in ( 'STANDARD','BLANKET','CONTRACT') THEN

Line 439: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,

435: X_delete_document_flag=>'Y',
436: X_automatically_added_flag=>'N');
437:
438: -- Bug 4088074 Set the REQUEST_ID item attribute to Null after deleting pdf
439: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,
440: itemkey => itemkey,
441: aname => 'REQUEST_ID',
442: avalue => NULL);
443:

Line 485: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

481: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,x_progress);
482: END IF;
483:
484:
485: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
486: itemkey => itemkey,
487: aname => 'DOCUMENT_ID');
488:
489: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 489: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

485: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
486: itemkey => itemkey,
487: aname => 'DOCUMENT_ID');
488:
489: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
490: itemkey => itemkey,
491: aname => 'REVISION_NUMBER');
492:
493: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 493: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

489: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
490: itemkey => itemkey,
491: aname => 'REVISION_NUMBER');
492:
493: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
494: itemkey => itemkey,
495: aname => 'DOCUMENT_TYPE');
496:
497:

Line 498: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

494: itemkey => itemkey,
495: aname => 'DOCUMENT_TYPE');
496:
497:
498: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
499: itemkey => itemkey,
500: aname => 'DOCUMENT_SUBTYPE');
501:
502: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 502: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

498: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
499: itemkey => itemkey,
500: aname => 'DOCUMENT_SUBTYPE');
501:
502: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
503: itemkey => itemkey,
504: aname => 'ORG_ID');
505:
506: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

Line 506: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

502: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
503: itemkey => itemkey,
504: aname => 'ORG_ID');
505:
506: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
507: itemkey => itemkey,
508: aname =>'LANGUAGE_CODE');
509:
510: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,

Line 510: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,

506: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
507: itemkey => itemkey,
508: aname =>'LANGUAGE_CODE');
509:
510: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,
511: itemkey => itemkey,
512: aname => 'WITH_TERMS');
513: IF l_with_terms = 'Y' THEN
514: l_terms := '_TERMS_';

Line 661: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype,

657: ItemKey => l_itemkey,
658: process => l_workflow_process );
659:
660:
661: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype,
662: itemkey => l_itemkey,
663: aname => 'DOCUMENT_ID',
664: avalue => p_document_id);
665:

Line 666: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype,

662: itemkey => l_itemkey,
663: aname => 'DOCUMENT_ID',
664: avalue => p_document_id);
665:
666: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype,
667: itemkey => l_itemkey,
668: aname => 'REVISION_NUMBER',
669: avalue => p_revision_num);
670:

Line 671: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,

667: itemkey => l_itemkey,
668: aname => 'REVISION_NUMBER',
669: avalue => p_revision_num);
670:
671: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
672: itemkey => l_itemkey,
673: aname => 'DOCUMENT_TYPE',
674: avalue => p_document_type);
675:

Line 676: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,

672: itemkey => l_itemkey,
673: aname => 'DOCUMENT_TYPE',
674: avalue => p_document_type);
675:
676: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
677: itemkey => l_itemkey,
678: aname => 'DOCUMENT_SUBTYPE',
679: avalue => p_document_subtype);
680:

Line 681: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,

677: itemkey => l_itemkey,
678: aname => 'DOCUMENT_SUBTYPE',
679: avalue => p_document_subtype);
680:
681: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
682: itemkey => l_itemkey,
683: aname => 'EMAIL_ADDRESS',
684: avalue => p_email_address);
685:

Line 686: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,

682: itemkey => l_itemkey,
683: aname => 'EMAIL_ADDRESS',
684: avalue => p_email_address);
685:
686: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
687: itemkey => l_itemkey,
688: aname => 'WITH_TERMS',
689: avalue => p_with_terms);
690:

Line 691: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,

687: itemkey => l_itemkey,
688: aname => 'WITH_TERMS',
689: avalue => p_with_terms);
690:
691: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
692: itemkey => l_itemkey,
693: aname => 'LANGUAGE_CODE',
694: avalue => p_language_code);
695:

Line 696: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,

692: itemkey => l_itemkey,
693: aname => 'LANGUAGE_CODE',
694: avalue => p_language_code);
695:
696: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,
697: itemkey => l_itemkey,
698: aname => 'EMAIL_TEXT_WITH_PDF',
699: avalue=>FND_MESSAGE.GET_STRING('PO','PO_PDF_EMAIL_TEXT'));
700:

Line 719: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype,

715: l_operating_unit:=null;
716: END;
717: END IF;
718:
719: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => l_itemtype,
720: itemkey => l_itemkey,
721: aname => 'ORG_ID',
722: avalue =>l_orgid );
723: --bug#3682458 replaced legal_entity_name with operating_unit_name

Line 724: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,

720: itemkey => l_itemkey,
721: aname => 'ORG_ID',
722: avalue =>l_orgid );
723: --bug#3682458 replaced legal_entity_name with operating_unit_name
724: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,
725: itemkey => l_itemkey,
726: aname => 'OPERATING_UNIT_NAME',
727: avalue=>l_operating_unit);
728:

Line 845: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype,

841: WF_DIRECTORY.SETADHOCUSERATTR(l_po_email_performer, l_display_name, l_notification_preference, l_adhocuser_lang, l_adhocuser_territory, p_email_address,null);
842:
843: end if;
844:
845: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype,
846: itemkey => l_itemkey,
847: aname => 'PO_PDF_EMAIL_PERFORMER',
848: avalue => l_po_email_performer);
849: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,

Line 849: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,

845: PO_WF_UTIL_PKG.SetItemAttrText ( itemtype => l_itemtype,
846: itemkey => l_itemkey,
847: aname => 'PO_PDF_EMAIL_PERFORMER',
848: avalue => l_po_email_performer);
849: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
850: itemkey => l_itemkey,
851: aname => 'PDF_ATTACHMENT',
852: avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH_SUPP/'||l_itemtype||':'||l_itemkey);
853:

Line 870: PO_WF_UTIL_PKG.SetItemAttrText

866: ( p_document_type => l_okc_doc_type
867: , p_document_id => p_document_id))
868: ) THEN
869:
870: PO_WF_UTIL_PKG.SetItemAttrText
871: ( itemtype => l_itemtype,
872: itemkey => l_itemkey,
873: aname => 'OKC_DOC_ATTACHMENT',
874: avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.OKC_DOC_ATTACH/'||

Line 894: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,

890: null; -- Do not show the Zip attachment link if there are no attachments
891: -- or in case of any exceptions
892: END;
893: IF l_attachments_exist = 'Y' THEN
894: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
895: itemkey => l_itemkey,
896: aname => 'ZIP_ATTACHMENT',
897: avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.ZIP_ATTACH/'||l_itemtype||':'||l_itemkey);
898: END IF;

Line 958: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

954: IF (g_po_wf_debug = 'Y') THEN
955: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
956: END IF;
957:
958: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
959: itemkey => itemkey,
960: aname => 'DOCUMENT_TYPE');
961:
962: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 962: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

958: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
959: itemkey => itemkey,
960: aname => 'DOCUMENT_TYPE');
961:
962: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
963: itemkey => itemkey,
964: aname => 'DOCUMENT_SUBTYPE');
965:
966: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 966: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

962: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
963: itemkey => itemkey,
964: aname => 'DOCUMENT_SUBTYPE');
965:
966: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
967: itemkey => itemkey,
968: aname => 'DOCUMENT_ID');
969:
970: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 970: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

966: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
967: itemkey => itemkey,
968: aname => 'DOCUMENT_ID');
969:
970: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
971: itemkey => itemkey,
972: aname => 'REVISION_NUMBER');
973:
974: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 974: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

970: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
971: itemkey => itemkey,
972: aname => 'REVISION_NUMBER');
973:
974: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
975: itemkey => itemkey,
976: aname =>'LANGUAGE_CODE');
977:
978: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,

Line 978: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,

974: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
975: itemkey => itemkey,
976: aname =>'LANGUAGE_CODE');
977:
978: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,
979: itemkey => itemkey,
980: aname => 'WITH_TERMS');
981:
982: --Bug# 5498523: We need the correct Authurization status so the logic in PoGenerateDocument.StorePDF

Line 984: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

980: aname => 'WITH_TERMS');
981:
982: --Bug# 5498523: We need the correct Authurization status so the logic in PoGenerateDocument.StorePDF
983: --will store the PDF in the contracts repository.
984: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
985: itemkey => itemkey,
986: aname => 'AUTHORIZATION_STATUS');
987:
988: IF l_document_type in ('PO','PA') and

Line 1079: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,

1075:
1076: -- Bug 7299381
1077: /* Changed the order of calling 4 PDF generation CPs for different cases.
1078: Setting the REQUEST_ID attribute (w/o any condition) in all 4 procedures */
1079: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,
1080: itemkey => itemkey,
1081: aname => 'REQUEST_ID',
1082: avalue => l_request_id);
1083: -- End Bug 7299381

Line 1256: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

1252: END IF;
1253: --
1254:
1255:
1256: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1257: itemkey => itemkey,
1258: aname => 'DOCUMENT_TYPE');
1259:
1260: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 1260: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

1256: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1257: itemkey => itemkey,
1258: aname => 'DOCUMENT_TYPE');
1259:
1260: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1261: itemkey => itemkey,
1262: aname => 'DOCUMENT_SUBTYPE');
1263:
1264: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 1264: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

1260: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1261: itemkey => itemkey,
1262: aname => 'DOCUMENT_SUBTYPE');
1263:
1264: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1265: itemkey => itemkey,
1266: aname => 'DOCUMENT_ID');
1267:
1268: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 1268: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

1264: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1265: itemkey => itemkey,
1266: aname => 'DOCUMENT_ID');
1267:
1268: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1269: itemkey => itemkey,
1270: aname => 'REVISION_NUMBER');
1271:
1272: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

Line 1272: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

1268: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1269: itemkey => itemkey,
1270: aname => 'REVISION_NUMBER');
1271:
1272: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
1273: itemkey => itemkey,
1274: aname => 'AUTHORIZATION_STATUS');
1275: /*Bug#3583910 Modified the name of the attribute to WITH_TERMS from WITHTERMS */
1276: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 1276: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

1272: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
1273: itemkey => itemkey,
1274: aname => 'AUTHORIZATION_STATUS');
1275: /*Bug#3583910 Modified the name of the attribute to WITH_TERMS from WITHTERMS */
1276: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1277: itemkey => itemkey,
1278: aname => 'WITH_TERMS');
1279:
1280: --Bug 7299381

Line 1282: l_old_request_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,

1278: aname => 'WITH_TERMS');
1279:
1280: --Bug 7299381
1281: /*
1282: l_old_request_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
1283: itemkey => itemkey,
1284: aname=>'REQUEST_ID');
1285: */
1286:

Line 1352: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,

1348: End;
1349:
1350: IF l_attachments_exist = 'Y' THEN
1351: l_progress := 'PO_COMMUNICATION_PVT.generate_pdf_buyer: Setting workflow attribute to display Zip Attachment';
1352: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,
1353: itemkey => itemkey,
1354: aname => 'ZIP_ATTACHMENT',
1355: avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.ZIP_ATTACH/'||itemtype||':'||itemkey);
1356:

Line 1616: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,

1612: IF (g_po_wf_debug = 'Y') THEN
1613: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,l_progress);
1614: END IF;
1615:
1616: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,
1617: itemkey => itemkey,
1618: aname => 'REQUEST_ID',
1619: avalue => l_request_id);
1620:

Line 1665: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

1661: IF (g_po_wf_debug = 'Y') THEN
1662: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
1663: END IF;
1664:
1665: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1666: itemkey => itemkey,
1667: aname => 'DOCUMENT_TYPE');
1668:
1669: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 1669: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

1665: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1666: itemkey => itemkey,
1667: aname => 'DOCUMENT_TYPE');
1668:
1669: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1670: itemkey => itemkey,
1671: aname => 'DOCUMENT_SUBTYPE');
1672:
1673: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 1673: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

1669: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1670: itemkey => itemkey,
1671: aname => 'DOCUMENT_SUBTYPE');
1672:
1673: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1674: itemkey => itemkey,
1675: aname => 'DOCUMENT_ID');
1676:
1677: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 1677: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

1673: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1674: itemkey => itemkey,
1675: aname => 'DOCUMENT_ID');
1676:
1677: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1678: itemkey => itemkey,
1679: aname => 'REVISION_NUMBER');
1680:
1681: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 1681: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

1677: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1678: itemkey => itemkey,
1679: aname => 'REVISION_NUMBER');
1680:
1681: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1682: itemkey => itemkey,
1683: aname =>'LANGUAGE_CODE');
1684: --Bug6841986/6528046 Added
1685: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,

Line 1685: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,

1681: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1682: itemkey => itemkey,
1683: aname =>'LANGUAGE_CODE');
1684: --Bug6841986/6528046 Added
1685: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText ( itemtype => itemtype,
1686: itemkey => itemkey,
1687: aname => 'WITH_TERMS');
1688:
1689: --Bug 7299381

Line 1690: /*l_old_request_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,

1686: itemkey => itemkey,
1687: aname => 'WITH_TERMS');
1688:
1689: --Bug 7299381
1690: /*l_old_request_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
1691: itemkey => itemkey,
1692: aname=>'REQUEST_ID');
1693: */
1694: --End Bug6841986/6528046

Line 1793: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,

1789: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
1790: END IF;
1791:
1792: -- Bug 7299381
1793: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,
1794: itemkey => itemkey,
1795: aname => 'REQUEST_ID',
1796: avalue => l_request_id);
1797: -- End Bug 7299381

Line 1839: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

1835: IF (g_po_wf_debug = 'Y') THEN
1836: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
1837: END IF;
1838:
1839: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1840: itemkey => itemkey,
1841: aname =>'LANGUAGE_CODE');
1842:
1843: --set the suppliers language before launching the concurrent request

Line 1849: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

1845: select nls_territory into l_territory from fnd_languages where
1846: language_code = l_language_code;
1847:
1848:
1849: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1850: itemkey => itemkey,
1851: aname => 'DOCUMENT_SUBTYPE');
1852:
1853: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 1853: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

1849: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1850: itemkey => itemkey,
1851: aname => 'DOCUMENT_SUBTYPE');
1852:
1853: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1854: itemkey => itemkey,
1855: aname => 'DOCUMENT_ID');
1856:
1857: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

Line 1857: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

1853: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1854: itemkey => itemkey,
1855: aname => 'DOCUMENT_ID');
1856:
1857: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1858: itemkey => itemkey,
1859: aname => 'WITH_TERMS');
1860:
1861: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 1861: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

1857: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1858: itemkey => itemkey,
1859: aname => 'WITH_TERMS');
1860:
1861: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1862: itemkey => itemkey,
1863: aname => 'REVISION_NUMBER');
1864:
1865: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,

Line 1865: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,

1861: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1862: itemkey => itemkey,
1863: aname => 'REVISION_NUMBER');
1864:
1865: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText (itemtype =>itemtype,
1866: itemkey => itemkey,
1867: aname => 'AUTHORIZATION_STATUS');
1868:
1869: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF_EMAIL_PROCESS:launching the Dispatch Purchase Order concurrent program ';

Line 1937: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,

1933: NULL, NULL, NULL, NULL, NULL, NULL, NULL,
1934: NULL, NULL);
1935:
1936:
1937: PO_WF_UTIL_PKG.SetItemAttrNumber ( itemtype => itemtype,
1938: itemkey => itemkey,
1939: aname => 'REQUEST_ID',
1940: avalue => l_request_id);
1941:

Line 3540: l_po_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

3536: IF (g_po_wf_debug = 'Y') THEN
3537: PO_WF_DEBUG_PKG.insert_debug(l_itemtype, l_itemkey, x_progress);
3538: END IF;
3539:
3540: l_po_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
3541: itemtype => l_itemtype,
3542: itemkey => l_itemkey,
3543: aname => 'DOCUMENT_ID');
3544:

Line 3545: l_po_org_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

3541: itemtype => l_itemtype,
3542: itemkey => l_itemkey,
3543: aname => 'DOCUMENT_ID');
3544:
3545: l_po_org_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
3546: itemtype => l_itemtype,
3547: itemkey => l_itemkey,
3548: aname => 'ORG_ID');
3549:

Line 3550: l_po_document_type := PO_WF_UTIL_PKG.GetItemAttrText (

3546: itemtype => l_itemtype,
3547: itemkey => l_itemkey,
3548: aname => 'ORG_ID');
3549:
3550: l_po_document_type := PO_WF_UTIL_PKG.GetItemAttrText (
3551: itemtype => l_itemtype,
3552: itemkey => l_itemkey,
3553: aname => 'DOCUMENT_TYPE');
3554:

Line 3555: l_po_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText(

3551: itemtype => l_itemtype,
3552: itemkey => l_itemkey,
3553: aname => 'DOCUMENT_TYPE');
3554:
3555: l_po_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText(
3556: itemtype => l_itemtype,
3557: itemkey => l_itemkey,
3558: aname => 'DOCUMENT_SUBTYPE');
3559:

Line 3560: l_language := PO_WF_UTIL_PKG.GetItemAttrText (

3556: itemtype => l_itemtype,
3557: itemkey => l_itemkey,
3558: aname => 'DOCUMENT_SUBTYPE');
3559:
3560: l_language := PO_WF_UTIL_PKG.GetItemAttrText (
3561: itemtype => l_itemtype,
3562: itemkey => l_itemkey,
3563: aname => 'LANGUAGE_CODE');
3564:

Line 3565: l_po_revision_number := PO_WF_UTIL_PKG.GetItemAttrNumber (

3561: itemtype => l_itemtype,
3562: itemkey => l_itemkey,
3563: aname => 'LANGUAGE_CODE');
3564:
3565: l_po_revision_number := PO_WF_UTIL_PKG.GetItemAttrNumber (
3566: itemtype => l_itemtype,
3567: itemkey => l_itemkey,
3568: aname => 'REVISION_NUMBER');
3569:

Line 3570: l_withTerms := PO_WF_UTIL_PKG.GetItemAttrText (

3566: itemtype => l_itemtype,
3567: itemkey => l_itemkey,
3568: aname => 'REVISION_NUMBER');
3569:
3570: l_withTerms := PO_WF_UTIL_PKG.GetItemAttrText (
3571: itemtype => l_itemtype,
3572: itemkey => l_itemkey,
3573: aname => 'WITH_TERMS');
3574:

Line 3821: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => p_itemtype,

3817: p_itemkey IN VARCHAR2,
3818: p_zip_error_code IN VARCHAR2) IS
3819: BEGIN
3820: -- Set the value of the workflow attribute zip_error_code
3821: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => p_itemtype,
3822: itemkey => p_itemkey,
3823: aname => 'ZIP_ERROR_CODE',
3824: avalue => p_zip_error_code);
3825: END set_zip_error_code;

Line 3867: resultout := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

3863: l_progress varchar2(200);
3864: BEGIN
3865: -- Get the value of the workflow attribute zip_error_code
3866: l_progress := 'PO_COMMUNICATION_PVT.get_zip_error_code: 01';
3867: resultout := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
3868: itemkey => itemkey,
3869: aname => 'ZIP_ERROR_CODE');
3870: l_progress := 'PO_COMMUNICATION_PVT.get_zip_error_code: 02';
3871: resultout := wf_engine.eng_completed || ':' ||resultout;

Line 7132: l_preparer_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber

7128: x_item_key IS NOT NULL AND
7129: PO_APPROVAL_REMINDER_SV.is_active(x_item_type, x_item_key)
7130: THEN
7131: l_progress := '004';
7132: l_preparer_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber
7133: (itemtype => x_item_type,
7134: itemkey => x_item_key,
7135: aname => 'USER_ID');
7136:

Line 7138: l_preparer_resp_id := PO_WF_UTIL_PKG.GetItemAttrNumber

7134: itemkey => x_item_key,
7135: aname => 'USER_ID');
7136:
7137: l_progress := '005';
7138: l_preparer_resp_id := PO_WF_UTIL_PKG.GetItemAttrNumber
7139: (itemtype => x_item_type,
7140: itemkey => x_item_key,
7141: aname => 'RESPONSIBILITY_ID');
7142:

Line 7144: l_preparer_resp_appl_id := PO_WF_UTIL_PKG.GetItemAttrNumber

7140: itemkey => x_item_key,
7141: aname => 'RESPONSIBILITY_ID');
7142:
7143: l_progress := '006';
7144: l_preparer_resp_appl_id := PO_WF_UTIL_PKG.GetItemAttrNumber
7145: (itemtype => x_item_type,
7146: itemkey => x_item_key,
7147: aname => 'APPLICATION_ID');
7148: