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.

APPS.PO_COMMUNICATION_PVT dependencies on PO_WF_UTIL_PKG

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

217: return;
218: END IF;
219: --End of code changes for the bug 12403413
220:
221: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
222: itemkey => itemkey,
223: aname => 'DOCUMENT_ID');
224:
225: --Bug13774287

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

222: itemkey => itemkey,
223: aname => 'DOCUMENT_ID');
224:
225: --Bug13774287
226: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
227: itemkey => itemkey,
228: aname => 'DOCUMENT_TYPE');
229: --End Bug13774287
230:

Line 232: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

228: aname => 'DOCUMENT_TYPE');
229: --End Bug13774287
230:
231: -- CLM
232: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
233: itemkey => itemkey,
234: aname => 'DRAFT_ID');
235:
236: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

232: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
233: itemkey => itemkey,
234: aname => 'DRAFT_ID');
235:
236: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
237: itemkey => itemkey,
238: aname => 'DOCUMENT_SUBTYPE');
239:
240: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

236: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
237: itemkey => itemkey,
238: aname => 'DOCUMENT_SUBTYPE');
239:
240: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
241: itemkey => itemkey,
242: aname => 'REVISION_NUMBER');
243:
244: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

240: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
241: itemkey => itemkey,
242: aname => 'REVISION_NUMBER');
243:
244: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
245: itemkey => itemkey,
246: aname => 'AUTHORIZATION_STATUS');
247:
248: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

244: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
245: itemkey => itemkey,
246: aname => 'AUTHORIZATION_STATUS');
247:
248: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
249: itemkey => itemkey,
250: aname => 'WITH_TERMS');
251:
252: --

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

249: itemkey => itemkey,
250: aname => 'WITH_TERMS');
251:
252: --
253: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
254: itemkey => itemkey,
255: aname=>'LANGUAGE_CODE');
256:
257: --Bug 13069700 - Adding exception block.

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

347: if (l_request_id <= 0 or l_request_id is null) then
348: raise submission_error;
349: end if;
350: /*End Changes by Akyanama Bug # 12969112*/
351: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype,
352: itemkey => itemkey,
353: aname => 'REQUEST_ID',
354: avalue => l_request_id);
355:

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

412:
413:
414: --Get the document type
415:
416: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
417: itemkey => itemkey,
418: aname => 'DOCUMENT_TYPE');
419:
420:

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

417: itemkey => itemkey,
418: aname => 'DOCUMENT_TYPE');
419:
420:
421: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
422: itemkey => itemkey,
423: aname => 'DOCUMENT_SUBTYPE');
424:
425: x_progress := 'PO_COMMUNICATION_PVT.PO_NEW_COMMUNICATION: Verify whether XDO Product is installed or not';

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

484: END IF;
485: --
486:
487:
488: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
489: itemkey => itemkey,
490: aname => 'DOCUMENT_ID');
491:
492: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

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

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

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

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

497: itemkey => itemkey,
498: aname => 'DOCUMENT_TYPE');
499:
500:
501: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
502: itemkey => itemkey,
503: aname => 'DOCUMENT_SUBTYPE');
504:
505: --CLM

Line 506: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

502: itemkey => itemkey,
503: aname => 'DOCUMENT_SUBTYPE');
504:
505: --CLM
506: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
507: itemkey => itemkey,
508: aname => 'DRAFT_ID');
509: IF l_draft_id is NULL then
510: l_draft_id := -1;

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

537: X_delete_document_flag => 'Y',
538: X_automatically_added_flag => 'N');
539:
540: -- Bug 4088074 Set the REQUEST_ID item attribute to Null after deleting pdf
541: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype,
542: itemkey => itemkey,
543: aname => 'REQUEST_ID',
544: avalue => NULL);
545:

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

583: /* DEBUG */ PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey, x_progress);
584: END IF;
585:
586:
587: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
588: itemkey => itemkey,
589: aname => 'DOCUMENT_ID');
590:
591: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

587: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
588: itemkey => itemkey,
589: aname => 'DOCUMENT_ID');
590:
591: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
592: itemkey => itemkey,
593: aname => 'REVISION_NUMBER');
594:
595: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

591: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
592: itemkey => itemkey,
593: aname => 'REVISION_NUMBER');
594:
595: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
596: itemkey => itemkey,
597: aname => 'DOCUMENT_TYPE');
598:
599:

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

596: itemkey => itemkey,
597: aname => 'DOCUMENT_TYPE');
598:
599:
600: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
601: itemkey => itemkey,
602: aname => 'DOCUMENT_SUBTYPE');
603:
604: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

600: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
601: itemkey => itemkey,
602: aname => 'DOCUMENT_SUBTYPE');
603:
604: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
605: itemkey => itemkey,
606: aname => 'ORG_ID');
607:
608: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

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

604: l_orgid := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
605: itemkey => itemkey,
606: aname => 'ORG_ID');
607:
608: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
609: itemkey => itemkey,
610: aname => 'LANGUAGE_CODE');
611:
612: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

608: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
609: itemkey => itemkey,
610: aname => 'LANGUAGE_CODE');
611:
612: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
613: itemkey => itemkey,
614: aname => 'WITH_TERMS');
615: IF l_with_terms = 'Y' THEN
616: l_terms := '_TERMS_';

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

766: ItemKey => l_itemkey,
767: process => l_workflow_process );
768:
769:
770: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => l_itemtype,
771: itemkey => l_itemkey,
772: aname => 'DOCUMENT_ID',
773: avalue => p_document_id);
774:

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

771: itemkey => l_itemkey,
772: aname => 'DOCUMENT_ID',
773: avalue => p_document_id);
774:
775: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => l_itemtype,
776: itemkey => l_itemkey,
777: aname => 'REVISION_NUMBER',
778: avalue => p_revision_num);
779:

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

776: itemkey => l_itemkey,
777: aname => 'REVISION_NUMBER',
778: avalue => p_revision_num);
779:
780: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
781: itemkey => l_itemkey,
782: aname => 'DOCUMENT_TYPE',
783: avalue => p_document_type);
784:

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

781: itemkey => l_itemkey,
782: aname => 'DOCUMENT_TYPE',
783: avalue => p_document_type);
784:
785: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
786: itemkey => l_itemkey,
787: aname => 'DOCUMENT_SUBTYPE',
788: avalue => p_document_subtype);
789:

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

786: itemkey => l_itemkey,
787: aname => 'DOCUMENT_SUBTYPE',
788: avalue => p_document_subtype);
789:
790: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
791: itemkey => l_itemkey,
792: aname => 'EMAIL_ADDRESS',
793: avalue => p_email_address);
794:

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

791: itemkey => l_itemkey,
792: aname => 'EMAIL_ADDRESS',
793: avalue => p_email_address);
794:
795: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
796: itemkey => l_itemkey,
797: aname => 'WITH_TERMS',
798: avalue => p_with_terms);
799:

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

796: itemkey => l_itemkey,
797: aname => 'WITH_TERMS',
798: avalue => p_with_terms);
799:
800: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
801: itemkey => l_itemkey,
802: aname => 'LANGUAGE_CODE',
803: avalue => p_language_code);
804:

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

801: itemkey => l_itemkey,
802: aname => 'LANGUAGE_CODE',
803: avalue => p_language_code);
804:
805: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,
806: itemkey => l_itemkey,
807: aname => 'EMAIL_TEXT_WITH_PDF',
808: avalue => FND_MESSAGE.GET_STRING('PO', 'PO_PDF_EMAIL_TEXT'));
809:

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

824: l_operating_unit := null;
825: END;
826: END IF;
827:
828: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => l_itemtype,
829: itemkey => l_itemkey,
830: aname => 'ORG_ID',
831: avalue => l_orgid );
832: --bug#3682458 replaced legal_entity_name with operating_unit_name

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

829: itemkey => l_itemkey,
830: aname => 'ORG_ID',
831: avalue => l_orgid );
832: --bug#3682458 replaced legal_entity_name with operating_unit_name
833: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => l_itemtype,
834: itemkey => l_itemkey,
835: aname => 'OPERATING_UNIT_NAME',
836: avalue => l_operating_unit);
837:

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

950: WF_DIRECTORY.SETADHOCUSERATTR(l_po_email_performer, l_display_name, l_notification_preference, l_adhocuser_lang, l_adhocuser_territory, p_email_address, null);
951:
952: end if;
953:
954: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
955: itemkey => l_itemkey,
956: aname => 'PO_PDF_EMAIL_PERFORMER',
957: avalue => l_po_email_performer);
958: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,

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

954: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
955: itemkey => l_itemkey,
956: aname => 'PO_PDF_EMAIL_PERFORMER',
957: avalue => l_po_email_performer);
958: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
959: itemkey => l_itemkey,
960: aname => 'PDF_ATTACHMENT',
961: avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH_SUPP/' || l_itemtype || ':' || l_itemkey);
962:

Line 979: PO_WF_UTIL_PKG.SetItemAttrText

975: (p_document_type => l_okc_doc_type
976: , p_document_id => p_document_id))
977: ) THEN
978:
979: PO_WF_UTIL_PKG.SetItemAttrText
980: (itemtype => l_itemtype,
981: itemkey => l_itemkey,
982: aname => 'OKC_DOC_ATTACHMENT',
983: avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.OKC_DOC_ATTACH/' ||

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

1035: End;
1036:
1037: IF l_zip_exists > 0 THEN
1038: -- bug 16475213 end
1039: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => l_itemtype,
1040: itemkey => l_itemkey,
1041: aname => 'ZIP_ATTACHMENT',
1042: avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.ZIP_ATTACH/' || l_itemtype || ':' || l_itemkey);
1043: END IF;

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

1111: return;
1112: END IF;
1113: --End of code changes for the bug 12403413
1114:
1115: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1116: itemkey => itemkey,
1117: aname => 'DOCUMENT_TYPE');
1118:
1119: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

1115: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1116: itemkey => itemkey,
1117: aname => 'DOCUMENT_TYPE');
1118:
1119: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1120: itemkey => itemkey,
1121: aname => 'DOCUMENT_SUBTYPE');
1122:
1123: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

1119: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1120: itemkey => itemkey,
1121: aname => 'DOCUMENT_SUBTYPE');
1122:
1123: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1124: itemkey => itemkey,
1125: aname => 'DOCUMENT_ID');
1126:
1127: -- CLM

Line 1128: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

1124: itemkey => itemkey,
1125: aname => 'DOCUMENT_ID');
1126:
1127: -- CLM
1128: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1129: itemkey => itemkey,
1130: aname => 'DRAFT_ID');
1131:
1132: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

1128: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1129: itemkey => itemkey,
1130: aname => 'DRAFT_ID');
1131:
1132: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1133: itemkey => itemkey,
1134: aname => 'REVISION_NUMBER');
1135:
1136: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

1132: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1133: itemkey => itemkey,
1134: aname => 'REVISION_NUMBER');
1135:
1136: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1137: itemkey => itemkey,
1138: aname => 'LANGUAGE_CODE');
1139:
1140: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

1136: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1137: itemkey => itemkey,
1138: aname => 'LANGUAGE_CODE');
1139:
1140: l_with_terms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1141: itemkey => itemkey,
1142: aname => 'WITH_TERMS');
1143:
1144: --Bug# 5498523: We need the correct Authurization status so the logic in PoGenerateDocument.StorePDF

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

1142: aname => 'WITH_TERMS');
1143:
1144: --Bug# 5498523: We need the correct Authurization status so the logic in PoGenerateDocument.StorePDF
1145: --will store the PDF in the contracts repository.
1146: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
1147: itemkey => itemkey,
1148: aname => 'AUTHORIZATION_STATUS');
1149:
1150: IF l_document_type in ('PO', 'PA') and

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

1276: /*End Changes by Akyanama Bug # 12969112*/
1277: -- Bug 7299381
1278: /*Changed the order of calling 4 PDF generation CPs for different cases.
1279: Setting the REQUEST_ID attribute (w/o any condition) in all 4 procedures */
1280: PO_WF_UTIL_PKG.SetItemAttrNumber(itemtype => itemtype,
1281: itemkey => itemkey,
1282: aname => 'REQUEST_ID',
1283: avalue => l_request_id);
1284: -- End Bug 7299381

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

1472: END IF;
1473: --
1474:
1475:
1476: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1477: itemkey => itemkey,
1478: aname => 'DOCUMENT_TYPE');
1479:
1480: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

1476: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1477: itemkey => itemkey,
1478: aname => 'DOCUMENT_TYPE');
1479:
1480: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1481: itemkey => itemkey,
1482: aname => 'DOCUMENT_SUBTYPE');
1483:
1484: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

1480: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1481: itemkey => itemkey,
1482: aname => 'DOCUMENT_SUBTYPE');
1483:
1484: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1485: itemkey => itemkey,
1486: aname => 'DOCUMENT_ID');
1487:
1488: -- CLM

Line 1489: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

1485: itemkey => itemkey,
1486: aname => 'DOCUMENT_ID');
1487:
1488: -- CLM
1489: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1490: itemkey => itemkey,
1491: aname => 'DRAFT_ID');
1492:
1493: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

1489: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1490: itemkey => itemkey,
1491: aname => 'DRAFT_ID');
1492:
1493: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1494: itemkey => itemkey,
1495: aname => 'REVISION_NUMBER');
1496:
1497: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

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

1493: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1494: itemkey => itemkey,
1495: aname => 'REVISION_NUMBER');
1496:
1497: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
1498: itemkey => itemkey,
1499: aname => 'AUTHORIZATION_STATUS');
1500: /*Bug#3583910 Modified the name of the attribute to WITH_TERMS from WITHTERMS */
1501: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

1497: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
1498: itemkey => itemkey,
1499: aname => 'AUTHORIZATION_STATUS');
1500: /*Bug#3583910 Modified the name of the attribute to WITH_TERMS from WITHTERMS */
1501: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1502: itemkey => itemkey,
1503: aname => 'WITH_TERMS');
1504:
1505: --

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

1502: itemkey => itemkey,
1503: aname => 'WITH_TERMS');
1504:
1505: --
1506: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
1507: itemkey => itemkey,
1508: aname=>'LANGUAGE_CODE');
1509:
1510: --Bug 13069700 - Adding exception block.

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

1523: --
1524:
1525: --Bug 7299381
1526: /*
1527: l_old_request_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
1528: itemkey => itemkey,
1529: aname=>'REQUEST_ID');
1530: */
1531:

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

1594: End;
1595:
1596: IF l_attachments_exist = 'Y' THEN
1597: l_progress := 'PO_COMMUNICATION_PVT.generate_pdf_buyer: Setting workflow attribute to display Zip Attachment';
1598: PO_WF_UTIL_PKG.SetItemAttrText (itemtype => itemtype,
1599: itemkey => itemkey,
1600: aname => 'ZIP_ATTACHMENT',
1601: avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.ZIP_ATTACH/' || itemtype || ':' || itemkey);
1602:

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

1865: IF (g_po_wf_debug = 'Y') THEN
1866: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, l_progress);
1867: END IF;
1868:
1869: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype,
1870: itemkey => itemkey,
1871: aname => 'REQUEST_ID',
1872: avalue => l_request_id);
1873:

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

1934: return;
1935: END IF;
1936: --End of code changes for the bug 12403413
1937:
1938: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1939: itemkey => itemkey,
1940: aname => 'DOCUMENT_TYPE');
1941:
1942: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

1938: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1939: itemkey => itemkey,
1940: aname => 'DOCUMENT_TYPE');
1941:
1942: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1943: itemkey => itemkey,
1944: aname => 'DOCUMENT_SUBTYPE');
1945:
1946: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

1942: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1943: itemkey => itemkey,
1944: aname => 'DOCUMENT_SUBTYPE');
1945:
1946: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1947: itemkey => itemkey,
1948: aname => 'DOCUMENT_ID');
1949:
1950: -- CLM

Line 1951: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

1947: itemkey => itemkey,
1948: aname => 'DOCUMENT_ID');
1949:
1950: -- CLM
1951: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1952: itemkey => itemkey,
1953: aname => 'DRAFT_ID');
1954:
1955: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

1951: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1952: itemkey => itemkey,
1953: aname => 'DRAFT_ID');
1954:
1955: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1956: itemkey => itemkey,
1957: aname => 'REVISION_NUMBER');
1958:
1959: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

1955: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
1956: itemkey => itemkey,
1957: aname => 'REVISION_NUMBER');
1958:
1959: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1960: itemkey => itemkey,
1961: aname => 'LANGUAGE_CODE');
1962:
1963: --Bug6841986/6528046 Added

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

1960: itemkey => itemkey,
1961: aname => 'LANGUAGE_CODE');
1962:
1963: --Bug6841986/6528046 Added
1964: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1965: itemkey => itemkey,
1966: aname => 'WITH_TERMS');
1967:
1968: --Bug 7299381

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

1965: itemkey => itemkey,
1966: aname => 'WITH_TERMS');
1967:
1968: --Bug 7299381
1969: /*l_old_request_id := PO_WF_UTIL_PKG.GetItemAttrNumber(itemtype => itemtype,
1970: itemkey => itemkey,
1971: aname=>'REQUEST_ID');
1972: */
1973: --End Bug6841986/6528046

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

2104: raise submission_error;
2105: end if;
2106: /*End Changes by Akyanama Bug # 12969112*/
2107: -- Bug 7299381
2108: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype,
2109: itemkey => itemkey,
2110: aname => 'REQUEST_ID',
2111: avalue => l_request_id);
2112: -- End Bug 7299381

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

2172: IF (g_po_wf_debug = 'Y') THEN
2173: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY, x_progress);
2174: END IF;
2175:
2176: l_language_code := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
2177: itemkey => itemkey,
2178: aname => 'LANGUAGE_CODE');
2179:
2180: --set the suppliers language before launching the concurrent request

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

2190: PO_WF_DEBUG_PKG.INSERT_DEBUG(ITEMTYPE, ITEMKEY,x_progress);
2191: END IF;
2192: END;
2193: --Bug13774287
2194: l_document_type := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
2195: itemkey => itemkey,
2196: aname => 'DOCUMENT_TYPE');
2197: --End Bug13774287
2198:

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

2197: --End Bug13774287
2198:
2199:
2200:
2201: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
2202: itemkey => itemkey,
2203: aname => 'DOCUMENT_SUBTYPE');
2204:
2205: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

2201: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
2202: itemkey => itemkey,
2203: aname => 'DOCUMENT_SUBTYPE');
2204:
2205: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
2206: itemkey => itemkey,
2207: aname => 'DOCUMENT_ID');
2208:
2209: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

Line 2209: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

2205: l_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
2206: itemkey => itemkey,
2207: aname => 'DOCUMENT_ID');
2208:
2209: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
2210: itemkey => itemkey,
2211: aname => 'DRAFT_ID');
2212:
2213: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

2209: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
2210: itemkey => itemkey,
2211: aname => 'DRAFT_ID');
2212:
2213: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
2214: itemkey => itemkey,
2215: aname => 'WITH_TERMS');
2216:
2217: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,

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

2213: l_withterms := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
2214: itemkey => itemkey,
2215: aname => 'WITH_TERMS');
2216:
2217: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
2218: itemkey => itemkey,
2219: aname => 'REVISION_NUMBER');
2220:
2221: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

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

2217: l_revision_num := PO_WF_UTIL_PKG.GetItemAttrNumber (itemtype => itemtype,
2218: itemkey => itemkey,
2219: aname => 'REVISION_NUMBER');
2220:
2221: l_authorization_status := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
2222: itemkey => itemkey,
2223: aname => 'AUTHORIZATION_STATUS');
2224:
2225: x_progress := 'PO_COMMUNICATION_PVT.GENERATE_PDF_EMAIL_PROCESS:launching the Dispatch Purchase Order concurrent program ';

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

2312: if (l_request_id <= 0 or l_request_id is null) then
2313: raise submission_error;
2314: end if;
2315: /*End Changes by Akyanama Bug # 12969112*/
2316: PO_WF_UTIL_PKG.SetItemAttrNumber (itemtype => itemtype,
2317: itemkey => itemkey,
2318: aname => 'REQUEST_ID',
2319: avalue => l_request_id);
2320:

Line 4077: l_po_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

4073: IF (g_po_wf_debug = 'Y') THEN
4074: PO_WF_DEBUG_PKG.insert_debug(l_itemtype, l_itemkey, x_progress);
4075: END IF;
4076:
4077: l_po_document_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
4078: itemtype => l_itemtype,
4079: itemkey => l_itemkey,
4080: aname => 'DOCUMENT_ID');
4081:

Line 4082: l_po_org_id := PO_WF_UTIL_PKG.GetItemAttrNumber(

4078: itemtype => l_itemtype,
4079: itemkey => l_itemkey,
4080: aname => 'DOCUMENT_ID');
4081:
4082: l_po_org_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
4083: itemtype => l_itemtype,
4084: itemkey => l_itemkey,
4085: aname => 'ORG_ID');
4086:

Line 4087: l_po_document_type := PO_WF_UTIL_PKG.GetItemAttrText (

4083: itemtype => l_itemtype,
4084: itemkey => l_itemkey,
4085: aname => 'ORG_ID');
4086:
4087: l_po_document_type := PO_WF_UTIL_PKG.GetItemAttrText (
4088: itemtype => l_itemtype,
4089: itemkey => l_itemkey,
4090: aname => 'DOCUMENT_TYPE');
4091:

Line 4092: l_po_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText(

4088: itemtype => l_itemtype,
4089: itemkey => l_itemkey,
4090: aname => 'DOCUMENT_TYPE');
4091:
4092: l_po_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText(
4093: itemtype => l_itemtype,
4094: itemkey => l_itemkey,
4095: aname => 'DOCUMENT_SUBTYPE');
4096:

Line 4097: l_language := PO_WF_UTIL_PKG.GetItemAttrText (

4093: itemtype => l_itemtype,
4094: itemkey => l_itemkey,
4095: aname => 'DOCUMENT_SUBTYPE');
4096:
4097: l_language := PO_WF_UTIL_PKG.GetItemAttrText (
4098: itemtype => l_itemtype,
4099: itemkey => l_itemkey,
4100: aname => 'LANGUAGE_CODE');
4101:

Line 4102: l_po_revision_number := PO_WF_UTIL_PKG.GetItemAttrNumber (

4098: itemtype => l_itemtype,
4099: itemkey => l_itemkey,
4100: aname => 'LANGUAGE_CODE');
4101:
4102: l_po_revision_number := PO_WF_UTIL_PKG.GetItemAttrNumber (
4103: itemtype => l_itemtype,
4104: itemkey => l_itemkey,
4105: aname => 'REVISION_NUMBER');
4106:

Line 4107: l_withTerms := PO_WF_UTIL_PKG.GetItemAttrText (

4103: itemtype => l_itemtype,
4104: itemkey => l_itemkey,
4105: aname => 'REVISION_NUMBER');
4106:
4107: l_withTerms := PO_WF_UTIL_PKG.GetItemAttrText (
4108: itemtype => l_itemtype,
4109: itemkey => l_itemkey,
4110: aname => 'WITH_TERMS');
4111:

Line 4113: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (

4109: itemkey => l_itemkey,
4110: aname => 'WITH_TERMS');
4111:
4112: --Mod Project
4113: l_draft_id := PO_WF_UTIL_PKG.GetItemAttrNumber (
4114: itemtype => l_itemtype,
4115: itemkey => l_itemkey,
4116: aname => 'DRAFT_ID');
4117: if l_draft_id is null then

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

4371: p_itemkey IN VARCHAR2,
4372: p_zip_error_code IN VARCHAR2) IS
4373: BEGIN
4374: -- Set the value of the workflow attribute zip_error_code
4375: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => p_itemtype,
4376: itemkey => p_itemkey,
4377: aname => 'ZIP_ERROR_CODE',
4378: avalue => p_zip_error_code);
4379: END set_zip_error_code;

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

4417: l_progress varchar2(200);
4418: BEGIN
4419: -- Get the value of the workflow attribute zip_error_code
4420: l_progress := 'PO_COMMUNICATION_PVT.get_zip_error_code: 01';
4421: resultout := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
4422: itemkey => itemkey,
4423: aname => 'ZIP_ERROR_CODE');
4424: l_progress := 'PO_COMMUNICATION_PVT.get_zip_error_code: 02';
4425: resultout := wf_engine.eng_completed || ':' || resultout;

Line 8327: l_preparer_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber

8323: x_item_key IS NOT NULL AND
8324: PO_APPROVAL_REMINDER_SV.is_active(x_item_type, x_item_key)
8325: THEN
8326: l_progress := '004';
8327: l_preparer_user_id := PO_WF_UTIL_PKG.GetItemAttrNumber
8328: (itemtype => x_item_type,
8329: itemkey => x_item_key,
8330: aname => 'USER_ID');
8331:

Line 8333: l_preparer_resp_id := PO_WF_UTIL_PKG.GetItemAttrNumber

8329: itemkey => x_item_key,
8330: aname => 'USER_ID');
8331:
8332: l_progress := '005';
8333: l_preparer_resp_id := PO_WF_UTIL_PKG.GetItemAttrNumber
8334: (itemtype => x_item_type,
8335: itemkey => x_item_key,
8336: aname => 'RESPONSIBILITY_ID');
8337:

Line 8339: l_preparer_resp_appl_id := PO_WF_UTIL_PKG.GetItemAttrNumber

8335: itemkey => x_item_key,
8336: aname => 'RESPONSIBILITY_ID');
8337:
8338: l_progress := '006';
8339: l_preparer_resp_appl_id := PO_WF_UTIL_PKG.GetItemAttrNumber
8340: (itemtype => x_item_type,
8341: itemkey => x_item_key,
8342: aname => 'APPLICATION_ID');
8343: