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.POR_AME_REQ_WF_PVT dependencies on PO_WF_UTIL_PKG

Line 106: l_ame_exception := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

102: END IF;
103:
104: /* Check if there is any AME exception.
105: If yes, then return 'invalid approver' */
106: l_ame_exception := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
107: itemkey => itemkey,
108: aname => 'AME_EXCEPTION');
109: IF l_ame_exception IS NOT NULL THEN
110: resultout:='COMPLETE:'||'INVALID_APPROVER';

Line 115: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

111: RETURN;
112: END IF;
113:
114:
115: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
116: itemkey => itemkey,
117: aname => 'DOCUMENT_TYPE');
118:
119: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 119: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

115: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
116: itemkey => itemkey,
117: aname => 'DOCUMENT_TYPE');
118:
119: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
120: itemkey => itemkey,
121: aname => 'DOCUMENT_SUBTYPE');
122:
123: -- CLM Apprvl

Line 125: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

121: aname => 'DOCUMENT_SUBTYPE');
122:
123: -- CLM Apprvl
124:
125: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
126: itemkey => itemkey,
127: aname => 'AME_TRANSACTION_TYPE');
128:
129: if l_document_type = 'REQUISITION' then

Line 130: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

126: itemkey => itemkey,
127: aname => 'AME_TRANSACTION_TYPE');
128:
129: if l_document_type = 'REQUISITION' then
130: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
131: itemkey => itemkey,
132: aname => 'DOCUMENT_ID');
133: else
134: l_document_id := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 134: l_document_id := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

130: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
131: itemkey => itemkey,
132: aname => 'DOCUMENT_ID');
133: else
134: l_document_id := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
135: itemkey => itemkey,
136: aname => 'AME_TRANSACTION_ID');
137: end if;
138:

Line 337: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,

333: END IF;
334:
335: /*Bug 11727653: BYPASSING MULTIPLE SUBMISSION CHECKS IN WORKFLOW
336: - setting the bypass flag to N if document is getting forwarded.*/
337: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,
338: itemkey => itemkey,
339: aname => 'BYPASS_CHECKS_FLAG',
340: avalue => 'N');
341:

Line 342: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

338: itemkey => itemkey,
339: aname => 'BYPASS_CHECKS_FLAG',
340: avalue => 'N');
341:
342: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
343: itemkey => itemkey,
344: aname => 'ORG_ID');
345:
346: l_document_type := po_wf_util_pkg.GetItemAttrText(itemtype => itemtype,

Line 346: l_document_type := po_wf_util_pkg.GetItemAttrText(itemtype => itemtype,

342: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
343: itemkey => itemkey,
344: aname => 'ORG_ID');
345:
346: l_document_type := po_wf_util_pkg.GetItemAttrText(itemtype => itemtype,
347: itemkey => itemkey,
348: aname => 'DOCUMENT_TYPE');
349: l_document_id := po_wf_util_pkg.GetItemAttrNumber(itemtype => itemtype,
350: itemkey => itemkey,

Line 349: l_document_id := po_wf_util_pkg.GetItemAttrNumber(itemtype => itemtype,

345:
346: l_document_type := po_wf_util_pkg.GetItemAttrText(itemtype => itemtype,
347: itemkey => itemkey,
348: aname => 'DOCUMENT_TYPE');
349: l_document_id := po_wf_util_pkg.GetItemAttrNumber(itemtype => itemtype,
350: itemkey => itemkey,
351: aname => 'DOCUMENT_ID');
352: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
353: itemkey => itemkey,

Line 352: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

348: aname => 'DOCUMENT_TYPE');
349: l_document_id := po_wf_util_pkg.GetItemAttrNumber(itemtype => itemtype,
350: itemkey => itemkey,
351: aname => 'DOCUMENT_ID');
352: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
353: itemkey => itemkey,
354: aname => 'AME_TRANSACTION_TYPE');
355:
356: -- CLM Apprvl

Line 358: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

354: aname => 'AME_TRANSACTION_TYPE');
355:
356: -- CLM Apprvl
357: if l_document_type <> 'REQUISITION' then
358: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
359: itemkey => itemkey,
360: aname => 'AME_TRANSACTION_ID');
361: end if;
362:

Line 403: t_req_varval(1) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

399:
400: -- CLM Apprvl
401: if l_document_type = 'REQUISITION' then
402: t_req_varname(1) := 'DOCUMENT_TYPE';
403: t_req_varval(1) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
404: itemkey => itemkey,
405: aname => 'DOCUMENT_TYPE');
406: t_req_varname(2) := 'DOCUMENT_SUBTYPE';
407: t_req_varval(2) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 407: t_req_varval(2) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

403: t_req_varval(1) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
404: itemkey => itemkey,
405: aname => 'DOCUMENT_TYPE');
406: t_req_varname(2) := 'DOCUMENT_SUBTYPE';
407: t_req_varval(2) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
408: itemkey => itemkey,
409: aname => 'DOCUMENT_SUBTYPE');
410: t_req_varname(3) := 'PREPARER_USER_NAME';
411: t_req_varval(3) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 411: t_req_varval(3) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

407: t_req_varval(2) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
408: itemkey => itemkey,
409: aname => 'DOCUMENT_SUBTYPE');
410: t_req_varname(3) := 'PREPARER_USER_NAME';
411: t_req_varval(3) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
412: itemkey => itemkey,
413: aname => 'PREPARER_USER_NAME');
414: t_req_varname(4) := 'PREPARER_DISPLAY_NAME';
415: t_req_varval(4) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 415: t_req_varval(4) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

411: t_req_varval(3) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
412: itemkey => itemkey,
413: aname => 'PREPARER_USER_NAME');
414: t_req_varname(4) := 'PREPARER_DISPLAY_NAME';
415: t_req_varval(4) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
416: itemkey => itemkey,
417: aname => 'PREPARER_DISPLAY_NAME');
418: t_req_varname(5) := 'FUNCTIONAL_CURRENCY';
419: t_req_varval(5) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 419: t_req_varval(5) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

415: t_req_varval(4) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
416: itemkey => itemkey,
417: aname => 'PREPARER_DISPLAY_NAME');
418: t_req_varname(5) := 'FUNCTIONAL_CURRENCY';
419: t_req_varval(5) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
420: itemkey => itemkey,
421: aname => 'FUNCTIONAL_CURRENCY');
422: t_req_varname(6) := 'IS_AME_APPROVAL';
423: t_req_varval(6) := 'Y';

Line 425: t_req_varval(7) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

421: aname => 'FUNCTIONAL_CURRENCY');
422: t_req_varname(6) := 'IS_AME_APPROVAL';
423: t_req_varval(6) := 'Y';
424: t_req_varname(7) := 'TOTAL_AMOUNT_DSP';
425: t_req_varval(7) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
426: itemkey => itemkey,
427: aname => 'TOTAL_AMOUNT_DSP');
428: t_req_varname(8) := 'FORWARD_FROM_DISP_NAME';
429: t_req_varval(8) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 429: t_req_varval(8) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

425: t_req_varval(7) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
426: itemkey => itemkey,
427: aname => 'TOTAL_AMOUNT_DSP');
428: t_req_varname(8) := 'FORWARD_FROM_DISP_NAME';
429: t_req_varval(8) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
430: itemkey => itemkey,
431: aname => 'FORWARD_FROM_DISP_NAME');
432: t_req_varname(9) := 'FORWARD_FROM_USER_NAME';
433: t_req_varval(9) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 433: t_req_varval(9) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

429: t_req_varval(8) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
430: itemkey => itemkey,
431: aname => 'FORWARD_FROM_DISP_NAME');
432: t_req_varname(9) := 'FORWARD_FROM_USER_NAME';
433: t_req_varval(9) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
434: itemkey => itemkey,
435: aname => 'FORWARD_FROM_USER_NAME');
436: t_req_varname(10) := 'TAX_AMOUNT_CURRENCY_DSP';
437: t_req_varval(10) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 437: t_req_varval(10) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

433: t_req_varval(9) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
434: itemkey => itemkey,
435: aname => 'FORWARD_FROM_USER_NAME');
436: t_req_varname(10) := 'TAX_AMOUNT_CURRENCY_DSP';
437: t_req_varval(10) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
438: itemkey => itemkey,
439: aname => 'TAX_AMOUNT_CURRENCY_DSP');
440: t_req_varname(11) := 'DOCUMENT_NUMBER';
441: t_req_varval(11) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 441: t_req_varval(11) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

437: t_req_varval(10) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
438: itemkey => itemkey,
439: aname => 'TAX_AMOUNT_CURRENCY_DSP');
440: t_req_varname(11) := 'DOCUMENT_NUMBER';
441: t_req_varval(11) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
442: itemkey => itemkey,
443: aname => 'DOCUMENT_NUMBER');
444: t_req_varname(12) := 'AME_TRANSACTION_TYPE';
445: t_req_varval(12) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 445: t_req_varval(12) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

441: t_req_varval(11) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
442: itemkey => itemkey,
443: aname => 'DOCUMENT_NUMBER');
444: t_req_varname(12) := 'AME_TRANSACTION_TYPE';
445: t_req_varval(12) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
446: itemkey => itemkey,
447: aname => 'AME_TRANSACTION_TYPE');
448: t_req_varname(13) := 'OPEN_FORM_COMMAND';
449: t_req_varval(13) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 449: t_req_varval(13) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

445: t_req_varval(12) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
446: itemkey => itemkey,
447: aname => 'AME_TRANSACTION_TYPE');
448: t_req_varname(13) := 'OPEN_FORM_COMMAND';
449: t_req_varval(13) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
450: itemkey => itemkey,
451: aname => 'OPEN_FORM_COMMAND');
452: t_req_varname(14) := 'REQ_DESCRIPTION';
453: t_req_varval(14) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 453: t_req_varval(14) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

449: t_req_varval(13) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
450: itemkey => itemkey,
451: aname => 'OPEN_FORM_COMMAND');
452: t_req_varname(14) := 'REQ_DESCRIPTION';
453: t_req_varval(14) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
454: itemkey => itemkey,
455: aname => 'REQ_DESCRIPTION');
456: t_req_varname(15) := 'REQ_AMOUNT_CURRENCY_DSP';
457: t_req_varval(15) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 457: t_req_varval(15) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

453: t_req_varval(14) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
454: itemkey => itemkey,
455: aname => 'REQ_DESCRIPTION');
456: t_req_varname(15) := 'REQ_AMOUNT_CURRENCY_DSP';
457: t_req_varval(15) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
458: itemkey => itemkey,
459: aname => 'REQ_AMOUNT_CURRENCY_DSP');
460: t_req_varname(16) := 'CONTRACTOR_REQUISITION_FLAG';
461: t_req_varval(16) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 461: t_req_varval(16) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

457: t_req_varval(15) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
458: itemkey => itemkey,
459: aname => 'REQ_AMOUNT_CURRENCY_DSP');
460: t_req_varname(16) := 'CONTRACTOR_REQUISITION_FLAG';
461: t_req_varval(16) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
462: itemkey => itemkey,
463: aname => 'CONTRACTOR_REQUISITION_FLAG');
464: t_req_varname(17) := 'CONTRACTOR_REQUISITION_FLAG';
465: t_req_varval(17) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 465: t_req_varval(17) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

461: t_req_varval(16) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
462: itemkey => itemkey,
463: aname => 'CONTRACTOR_REQUISITION_FLAG');
464: t_req_varname(17) := 'CONTRACTOR_REQUISITION_FLAG';
465: t_req_varval(17) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
466: itemkey => itemkey,
467: aname => 'CONTRACTOR_REQUISITION_FLAG');
468: t_req_varname(18) := 'VIEW_REQ_DTLS_URL';
469: t_req_varval(18) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 469: t_req_varval(18) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

465: t_req_varval(17) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
466: itemkey => itemkey,
467: aname => 'CONTRACTOR_REQUISITION_FLAG');
468: t_req_varname(18) := 'VIEW_REQ_DTLS_URL';
469: t_req_varval(18) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
470: itemkey => itemkey,
471: aname => 'VIEW_REQ_DTLS_URL');
472: t_req_varval (18) := t_req_varval(18) || '&' || 'item_key=' || l_item_key;
473: t_req_varname(19) := 'EDIT_REQ_URL';

Line 474: t_req_varval(19) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

470: itemkey => itemkey,
471: aname => 'VIEW_REQ_DTLS_URL');
472: t_req_varval (18) := t_req_varval(18) || '&' || 'item_key=' || l_item_key;
473: t_req_varname(19) := 'EDIT_REQ_URL';
474: t_req_varval(19) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
475: itemkey => itemkey,
476: aname => 'EDIT_REQ_URL');
477: t_req_varval (19) := t_req_varval(19) || '&' || 'item_key=' || l_item_key;
478: t_req_varname(20) := 'RESUBMIT_REQ_URL';

Line 479: t_req_varval(20) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

475: itemkey => itemkey,
476: aname => 'EDIT_REQ_URL');
477: t_req_varval (19) := t_req_varval(19) || '&' || 'item_key=' || l_item_key;
478: t_req_varname(20) := 'RESUBMIT_REQ_URL';
479: t_req_varval(20) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
480: itemkey => itemkey,
481: aname => 'RESUBMIT_REQ_URL');
482: t_req_varname(21) := 'JUSTIFICATION';
483: t_req_varval(21) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 483: t_req_varval(21) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

479: t_req_varval(20) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
480: itemkey => itemkey,
481: aname => 'RESUBMIT_REQ_URL');
482: t_req_varname(21) := 'JUSTIFICATION';
483: t_req_varval(21) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
484: itemkey => itemkey,
485: aname => 'JUSTIFICATION');
486: t_req_varname(22) := 'CONTRACTOR_STATUS';
487: t_req_varval(22) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 487: t_req_varval(22) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

483: t_req_varval(21) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
484: itemkey => itemkey,
485: aname => 'JUSTIFICATION');
486: t_req_varname(22) := 'CONTRACTOR_STATUS';
487: t_req_varval(22) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
488: itemkey => itemkey,
489: aname => 'CONTRACTOR_STATUS');
490: t_req_varname(23) := 'VENDOR_DISPLAY_NAME';
491: t_req_varval(23) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 491: t_req_varval(23) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

487: t_req_varval(22) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
488: itemkey => itemkey,
489: aname => 'CONTRACTOR_STATUS');
490: t_req_varname(23) := 'VENDOR_DISPLAY_NAME';
491: t_req_varval(23) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
492: itemkey => itemkey,
493: aname => 'VENDOR_DISPLAY_NAME');
494: t_req_varname(24) := 'IS_SUPPLIER_EMAIL_NOT_AVAIL';
495: t_req_varval(24) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 495: t_req_varval(24) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

491: t_req_varval(23) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
492: itemkey => itemkey,
493: aname => 'VENDOR_DISPLAY_NAME');
494: t_req_varname(24) := 'IS_SUPPLIER_EMAIL_NOT_AVAIL';
495: t_req_varval(24) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
496: itemkey => itemkey,
497: aname => 'IS_SUPPLIER_EMAIL_NOT_AVAIL');
498: t_req_varname(25) := 'CONTRACTOR_ASSIGNMENT_REQD';
499: t_req_varval(25) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 499: t_req_varval(25) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

495: t_req_varval(24) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
496: itemkey => itemkey,
497: aname => 'IS_SUPPLIER_EMAIL_NOT_AVAIL');
498: t_req_varname(25) := 'CONTRACTOR_ASSIGNMENT_REQD';
499: t_req_varval(25) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
500: itemkey => itemkey,
501: aname => 'CONTRACTOR_ASSIGNMENT_REQD');
502: else
503: t_po_varname(1) := 'DOCUMENT_TYPE';

Line 504: t_po_varval(1) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

500: itemkey => itemkey,
501: aname => 'CONTRACTOR_ASSIGNMENT_REQD');
502: else
503: t_po_varname(1) := 'DOCUMENT_TYPE';
504: t_po_varval(1) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
505: itemkey => itemkey,
506: aname => 'DOCUMENT_TYPE');
507: t_po_varname(2) := 'DOCUMENT_SUBTYPE';
508: t_po_varval(2) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 508: t_po_varval(2) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

504: t_po_varval(1) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
505: itemkey => itemkey,
506: aname => 'DOCUMENT_TYPE');
507: t_po_varname(2) := 'DOCUMENT_SUBTYPE';
508: t_po_varval(2) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
509: itemkey => itemkey,
510: aname => 'DOCUMENT_SUBTYPE');
511: t_po_varname(3) := 'PREPARER_USER_NAME';
512: t_po_varval(3) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 512: t_po_varval(3) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

508: t_po_varval(2) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
509: itemkey => itemkey,
510: aname => 'DOCUMENT_SUBTYPE');
511: t_po_varname(3) := 'PREPARER_USER_NAME';
512: t_po_varval(3) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
513: itemkey => itemkey,
514: aname => 'PREPARER_USER_NAME');
515: t_po_varname(4) := 'PREPARER_DISPLAY_NAME';
516: t_po_varval(4) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 516: t_po_varval(4) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

512: t_po_varval(3) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
513: itemkey => itemkey,
514: aname => 'PREPARER_USER_NAME');
515: t_po_varname(4) := 'PREPARER_DISPLAY_NAME';
516: t_po_varval(4) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
517: itemkey => itemkey,
518: aname => 'PREPARER_DISPLAY_NAME');
519: t_po_varname(5) := 'FUNCTIONAL_CURRENCY';
520: t_po_varval(5) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 520: t_po_varval(5) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

516: t_po_varval(4) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
517: itemkey => itemkey,
518: aname => 'PREPARER_DISPLAY_NAME');
519: t_po_varname(5) := 'FUNCTIONAL_CURRENCY';
520: t_po_varval(5) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
521: itemkey => itemkey,
522: aname => 'FUNCTIONAL_CURRENCY');
523: /*t_po_varname(6) := 'IS_AME_APPROVAL';
524: t_po_varval(6) := 'Y';*/

Line 526: t_po_varval(6) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

522: aname => 'FUNCTIONAL_CURRENCY');
523: /*t_po_varname(6) := 'IS_AME_APPROVAL';
524: t_po_varval(6) := 'Y';*/
525: t_po_varname(6) := 'RESUBMIT_DOC_URL';
526: t_po_varval(6) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
527: itemkey => itemkey,
528: aname => 'RESUBMIT_DOC_URL');
529: t_po_varname(7) := 'TOTAL_AMOUNT_DSP';
530: t_po_varval(7) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 530: t_po_varval(7) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

526: t_po_varval(6) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
527: itemkey => itemkey,
528: aname => 'RESUBMIT_DOC_URL');
529: t_po_varname(7) := 'TOTAL_AMOUNT_DSP';
530: t_po_varval(7) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
531: itemkey => itemkey,
532: aname => 'TOTAL_AMOUNT_DSP');
533: t_po_varname(8) := 'FORWARD_FROM_DISP_NAME';
534: t_po_varval(8) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 534: t_po_varval(8) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

530: t_po_varval(7) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
531: itemkey => itemkey,
532: aname => 'TOTAL_AMOUNT_DSP');
533: t_po_varname(8) := 'FORWARD_FROM_DISP_NAME';
534: t_po_varval(8) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
535: itemkey => itemkey,
536: aname => 'FORWARD_FROM_DISP_NAME');
537: t_po_varname(9) := 'FORWARD_FROM_USER_NAME';
538: t_po_varval(9) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 538: t_po_varval(9) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

534: t_po_varval(8) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
535: itemkey => itemkey,
536: aname => 'FORWARD_FROM_DISP_NAME');
537: t_po_varname(9) := 'FORWARD_FROM_USER_NAME';
538: t_po_varval(9) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
539: itemkey => itemkey,
540: aname => 'FORWARD_FROM_USER_NAME');
541: t_po_varname(10) := 'TAX_AMOUNT_CURRENCY_DSP';
542: t_po_varval(10) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 542: t_po_varval(10) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

538: t_po_varval(9) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
539: itemkey => itemkey,
540: aname => 'FORWARD_FROM_USER_NAME');
541: t_po_varname(10) := 'TAX_AMOUNT_CURRENCY_DSP';
542: t_po_varval(10) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
543: itemkey => itemkey,
544: aname => 'TAX_AMOUNT_CURRENCY_DSP');
545: t_po_varname(11) := 'DOCUMENT_NUMBER';
546: t_po_varval(11) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 546: t_po_varval(11) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

542: t_po_varval(10) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
543: itemkey => itemkey,
544: aname => 'TAX_AMOUNT_CURRENCY_DSP');
545: t_po_varname(11) := 'DOCUMENT_NUMBER';
546: t_po_varval(11) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
547: itemkey => itemkey,
548: aname => 'DOCUMENT_NUMBER');
549: t_po_varname(12) := 'AME_TRANSACTION_TYPE';
550: t_po_varval(12) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 550: t_po_varval(12) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

546: t_po_varval(11) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
547: itemkey => itemkey,
548: aname => 'DOCUMENT_NUMBER');
549: t_po_varname(12) := 'AME_TRANSACTION_TYPE';
550: t_po_varval(12) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
551: itemkey => itemkey,
552: aname => 'AME_TRANSACTION_TYPE');
553: t_po_varname(13) := 'OPEN_FORM_COMMAND';
554: t_po_varval(13) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 554: t_po_varval(13) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

550: t_po_varval(12) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
551: itemkey => itemkey,
552: aname => 'AME_TRANSACTION_TYPE');
553: t_po_varname(13) := 'OPEN_FORM_COMMAND';
554: t_po_varval(13) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
555: itemkey => itemkey,
556: aname => 'OPEN_FORM_COMMAND');
557: t_po_varname(14) := 'PO_DESCRIPTION';
558: t_po_varval(14) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 558: t_po_varval(14) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

554: t_po_varval(13) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
555: itemkey => itemkey,
556: aname => 'OPEN_FORM_COMMAND');
557: t_po_varname(14) := 'PO_DESCRIPTION';
558: t_po_varval(14) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
559: itemkey => itemkey,
560: aname => 'PO_DESCRIPTION');
561: t_po_varname(15) := 'PO_AMOUNT_DSP';
562: t_po_varval(15) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 562: t_po_varval(15) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

558: t_po_varval(14) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
559: itemkey => itemkey,
560: aname => 'PO_DESCRIPTION');
561: t_po_varname(15) := 'PO_AMOUNT_DSP';
562: t_po_varval(15) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
563: itemkey => itemkey,
564: aname => 'PO_AMOUNT_DSP');
565: t_po_varname(16) := 'VIEW_DOC_URL';
566: t_po_varval(16) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 566: t_po_varval(16) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

562: t_po_varval(15) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
563: itemkey => itemkey,
564: aname => 'PO_AMOUNT_DSP');
565: t_po_varname(16) := 'VIEW_DOC_URL';
566: t_po_varval(16) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
567: itemkey => itemkey,
568: aname => 'VIEW_DOC_URL');
569: t_po_varval (16) := t_po_varval(16) || '&' || 'item_key=' || l_item_key;
570: t_po_varname(17) := 'EDIT_DOC_URL';

Line 571: t_po_varval(17) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

567: itemkey => itemkey,
568: aname => 'VIEW_DOC_URL');
569: t_po_varval (16) := t_po_varval(16) || '&' || 'item_key=' || l_item_key;
570: t_po_varname(17) := 'EDIT_DOC_URL';
571: t_po_varval(17) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
572: itemkey => itemkey,
573: aname => 'EDIT_DOC_URL');
574: if(t_po_varval (17) is not NULL) then --Bug 12810660
575: t_po_varval (17) := t_po_varval(17) || '&' || 'item_key=' || l_item_key;

Line 713: t_po_varval(22) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

709: end if;
710: if l_document_type <> 'REQUISITION' then
711:
712: t_po_varname(22) := 'DOCUMENT_TYPE_DISP';
713: t_po_varval(22) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
714: itemkey => itemkey,
715: aname => 'DOCUMENT_TYPE_DISP');
716:
717:

Line 719: t_po_varval(23) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

715: aname => 'DOCUMENT_TYPE_DISP');
716:
717:
718: t_po_varname(23) := 'REQUIRES_APPROVAL_MSG';
719: t_po_varval(23) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
720: itemkey => itemkey,
721: aname => 'REQUIRES_APPROVAL_MSG');
722:
723:

Line 725: t_po_varval(24) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

721: aname => 'REQUIRES_APPROVAL_MSG');
722:
723:
724: t_po_varname(24) := 'WRONG_FORWARD_TO_MSG';
725: t_po_varval(24) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
726: itemkey => itemkey,
727: aname => 'WRONG_FORWARD_TO_MSG');
728:
729:

Line 731: t_po_varval(25) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

727: aname => 'WRONG_FORWARD_TO_MSG');
728:
729:
730: t_po_varname(25) := 'OPERATING_UNIT_NAME';
731: t_po_varval(25) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
732: itemkey => itemkey,
733: aname => 'OPERATING_UNIT_NAME');
734:
735: t_po_varname(26) := 'NOTE';

Line 736: t_po_varval(26) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

732: itemkey => itemkey,
733: aname => 'OPERATING_UNIT_NAME');
734:
735: t_po_varname(26) := 'NOTE';
736: t_po_varval(26) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
737: itemkey => itemkey,
738: aname => 'NOTE');
739:
740:

Line 742: t_po_varval(27) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

738: aname => 'NOTE');
739:
740:
741: t_po_varname(27) := 'PO_LINES_DETAILS';
742: t_po_varval(27) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
743: itemkey => itemkey,
744: aname => 'PO_LINES_DETAILS');
745:
746:

Line 748: t_po_varval(28) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

744: aname => 'PO_LINES_DETAILS');
745:
746:
747: t_po_varname(28) := 'DOCUMENT_SUBTYPE_DISP';
748: t_po_varval(28) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
749: itemkey => itemkey,
750: aname => 'DOCUMENT_SUBTYPE_DISP');
751:
752:

Line 754: t_po_varval(29) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

750: aname => 'DOCUMENT_SUBTYPE_DISP');
751:
752:
753: t_po_varname(29) := 'ACTION_HISTORY';
754: t_po_varval(29) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
755: itemkey => itemkey,
756: aname => 'ACTION_HISTORY');
757:
758: t_po_varname(30) := 'PO_APPROVE_MSG';

Line 759: t_po_varval(30) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

755: itemkey => itemkey,
756: aname => 'ACTION_HISTORY');
757:
758: t_po_varname(30) := 'PO_APPROVE_MSG';
759: t_po_varval(30) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
760: itemkey => itemkey,
761: aname => 'PO_APPROVE_MSG');
762:
763:

Line 765: t_po_varval(31) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

761: aname => 'PO_APPROVE_MSG');
762:
763:
764: t_po_varname(31) := 'SUPPLIER';
765: t_po_varval(31) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
766: itemkey => itemkey,
767: aname => 'SUPPLIER');
768:
769:

Line 771: t_po_varval(32) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

767: aname => 'SUPPLIER');
768:
769:
770: t_po_varname(32) := 'SUPPLIER_SITE';
771: t_po_varval(32) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
772: itemkey => itemkey,
773: aname => 'SUPPLIER_SITE');
774:
775:

Line 777: t_po_varval(33) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

773: aname => 'SUPPLIER_SITE');
774:
775:
776: t_po_varname(33) := 'FUNDED_TITLE_DSP';
777: t_po_varval(33) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
778: itemkey => itemkey,
779: aname => 'FUNDED_TITLE_DSP');
780:
781:

Line 783: t_po_varval(34) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

779: aname => 'FUNDED_TITLE_DSP');
780:
781:
782: t_po_varname(34) := 'FUNDED_AMOUNT_DISPLAY';
783: t_po_varval(34) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
784: itemkey => itemkey,
785: aname => 'FUNDED_AMOUNT_DISPLAY');
786:
787: t_po_varname(35) := 'AUTHORIZATION_STATUS';

Line 788: t_po_varval(35) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

784: itemkey => itemkey,
785: aname => 'FUNDED_AMOUNT_DISPLAY');
786:
787: t_po_varname(35) := 'AUTHORIZATION_STATUS';
788: t_po_varval(35) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
789: itemkey => itemkey,
790: aname => 'AUTHORIZATION_STATUS');
791:
792: t_po_varname(36) := 'WITH_TERMS';

Line 793: t_po_varval(36) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

789: itemkey => itemkey,
790: aname => 'AUTHORIZATION_STATUS');
791:
792: t_po_varname(36) := 'WITH_TERMS';
793: t_po_varval(36) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
794: itemkey => itemkey,
795: aname => 'WITH_TERMS');
796:
797: t_po_varname(37) := 'LANGUAGE_CODE';

Line 798: t_po_varval(37) := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,

794: itemkey => itemkey,
795: aname => 'WITH_TERMS');
796:
797: t_po_varname(37) := 'LANGUAGE_CODE';
798: t_po_varval(37) := PO_WF_UTIL_PKG.GetItemAttrText(itemtype => itemtype,
799: itemkey => itemkey,
800: aname=>'LANGUAGE_CODE');
801:
802: --multi-mod changes start

Line 804: t_po_varval(38) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

800: aname=>'LANGUAGE_CODE');
801:
802: --multi-mod changes start
803: t_po_varname(38) := 'SUPPLIER_CHANGE_NOTE';
804: t_po_varval(38) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
805: itemkey => itemkey,
806: aname => 'SUPPLIER_CHANGE_NOTE');
807: t_po_varname(39) := 'SUPPLIER_SITE_CHANGE_NOTE';
808: t_po_varval(39) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 808: t_po_varval(39) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

804: t_po_varval(38) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
805: itemkey => itemkey,
806: aname => 'SUPPLIER_CHANGE_NOTE');
807: t_po_varname(39) := 'SUPPLIER_SITE_CHANGE_NOTE';
808: t_po_varval(39) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
809: itemkey => itemkey,
810: aname => 'SUPPLIER_SITE_CHANGE_NOTE');
811: t_po_varname(40) := 'VALIDATION_DETAILS_URL';
812: t_po_varval(40) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 812: t_po_varval(40) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

808: t_po_varval(39) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
809: itemkey => itemkey,
810: aname => 'SUPPLIER_SITE_CHANGE_NOTE');
811: t_po_varname(40) := 'VALIDATION_DETAILS_URL';
812: t_po_varval(40) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
813: itemkey => itemkey,
814: aname => 'VALIDATION_DETAILS_URL');
815: t_po_varname(41) := 'APPROVAL_SOURCE';
816: t_po_varval(41) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 816: t_po_varval(41) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

812: t_po_varval(40) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
813: itemkey => itemkey,
814: aname => 'VALIDATION_DETAILS_URL');
815: t_po_varname(41) := 'APPROVAL_SOURCE';
816: t_po_varval(41) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
817: itemkey => itemkey,
818: aname => 'APPROVAL_SOURCE');
819: --multi-mod changes end
820: -- PAR Approval

Line 822: t_po_varval(42) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

818: aname => 'APPROVAL_SOURCE');
819: --multi-mod changes end
820: -- PAR Approval
821: t_po_varname(42) := 'DRAFT_TYPE';
822: t_po_varval(42) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
823: itemkey => itemkey,
824: aname => 'DRAFT_TYPE');
825:
826:

Line 871: n_varval(6) := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

867: end if;
868:
869: --Bug: 9877170 Setting Responsibility_id and Application_id
870: n_varname(6) := 'RESPONSIBILITY_ID';
871: n_varval(6) := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
872: itemkey => itemkey,
873: aname => 'RESPONSIBILITY_ID');
874: n_varname(7) := 'APPLICATION_ID';
875: n_varval(7) := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

Line 875: n_varval(7) := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

871: n_varval(6) := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
872: itemkey => itemkey,
873: aname => 'RESPONSIBILITY_ID');
874: n_varname(7) := 'APPLICATION_ID';
875: n_varval(7) := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
876: itemkey => itemkey,
877: aname => 'APPLICATION_ID');
878: l_progress := 'Launch_Parallel_Approval - setting responsibility_id:'||n_varval(6)||' and application_id:'||n_varval(7);
879: IF (g_po_wf_debug = 'Y') THEN

Line 887: n_varval(9) := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

883: if l_document_type <> 'REQUISITION' then
884: n_varname(8) := 'AME_TRANSACTION_ID';
885: n_varval(8) := l_ame_transaction_id;
886: n_varname(9) := 'DRAFT_ID';
887: n_varval(9) := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
888: itemkey => itemkey,
889: aname => 'DRAFT_ID');
890: n_varname(10) := 'PO_REVISION_NUM';
891: n_varval(10) := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

Line 891: n_varval(10) := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

887: n_varval(9) := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
888: itemkey => itemkey,
889: aname => 'DRAFT_ID');
890: n_varname(10) := 'PO_REVISION_NUM';
891: n_varval(10) := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
892: itemkey => itemkey,
893: aname => 'PO_REVISION_NUM');
894:
895: n_varname(11) := 'REVISION_NUMBER';

Line 896: n_varval(11) := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

892: itemkey => itemkey,
893: aname => 'PO_REVISION_NUM');
894:
895: n_varname(11) := 'REVISION_NUMBER';
896: n_varval(11) := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
897: itemkey => itemkey,
898: aname => 'REVISION_NUMBER');
899:
900: end if;

Line 911: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,

907: aname => 'ATTACHMENT',
908: documentid => ( wf_engine.GetItemAttrDocument( itemtype => itemtype,
909: itemkey => itemkey,
910: aname => 'ATTACHMENT')));
911: po_wf_util_pkg.SetItemAttrText(itemtype => itemtype,
912: itemkey => l_item_key,
913: aname => 'PDF_ATTACHMENT_BUYER',
914: avalue => 'PLSQLBLOB:PO_COMMUNICATION_PVT.PDF_ATTACH_APP/'|| itemtype||':'||l_item_key);
915:

Line 1012: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

1008: IF (g_po_wf_debug = 'Y') THEN
1009: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1010: END IF;
1011:
1012: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1013: itemkey => itemkey,
1014: aname => 'DOCUMENT_ID');
1015: --
1016: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 1016: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

1012: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1013: itemkey => itemkey,
1014: aname => 'DOCUMENT_ID');
1015: --
1016: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1017: itemkey => itemkey,
1018: aname => 'DOCUMENT_TYPE');
1019:
1020:

Line 1022: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

1018: aname => 'DOCUMENT_TYPE');
1019:
1020:
1021: if l_document_type <> 'REQUISITION' then
1022: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1023: itemkey => itemkey,
1024: aname => 'AME_TRANSACTION_ID');
1025:
1026:

Line 1030: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

1026:
1027: end if;
1028: --
1029:
1030: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1031: itemkey => itemkey,
1032: aname => 'AME_TRANSACTION_TYPE');
1033:
1034: l_approver_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 1034: l_approver_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

1030: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1031: itemkey => itemkey,
1032: aname => 'AME_TRANSACTION_TYPE');
1033:
1034: l_approver_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1035: itemkey => itemkey,
1036: aname => 'AME_APPROVER_TYPE');
1037:
1038: l_progress := 'Process_Response_Internal: 002 -- l_approver_type :' || l_approver_type||

Line 1052: l_current_approver.name := po_wf_util_pkg.GetItemAttrText( itemtype => itemType,

1048: l_current_approver.orig_system := ame_util.fndUserOrigSystem;
1049: l_forwardee.orig_system := ame_util.fndUserOrigSystem;
1050: else
1051: l_current_approver.orig_system := ame_util.perOrigSystem;
1052: l_current_approver.name := po_wf_util_pkg.GetItemAttrText( itemtype => itemType,
1053: itemkey => itemkey,
1054: aname => 'APPROVER_USER_NAME');
1055: -- CLM Apprvl
1056: l_forwardee.orig_system := ame_util.perOrigSystem;

Line 1057: l_forwardee.name := po_wf_util_pkg.GetItemAttrText( itemtype => itemType,

1053: itemkey => itemkey,
1054: aname => 'APPROVER_USER_NAME');
1055: -- CLM Apprvl
1056: l_forwardee.orig_system := ame_util.perOrigSystem;
1057: l_forwardee.name := po_wf_util_pkg.GetItemAttrText( itemtype => itemType,
1058: itemkey => itemkey,
1059: aname => 'FORWARD_TO_USERNAME_RESPONSE');
1060:
1061: end if;

Line 1063: l_current_approver.orig_system_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

1059: aname => 'FORWARD_TO_USERNAME_RESPONSE');
1060:
1061: end if;
1062:
1063: l_current_approver.orig_system_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1064: itemkey => itemkey,
1065: aname => 'AME_APPROVER_ID');
1066:
1067:

Line 1161: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1157: into l_parent_item_type, l_parent_item_key
1158: FROM wf_items
1159: WHERE item_type = itemtype and item_key = itemkey;
1160:
1161: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1162: itemkey => l_parent_item_key,
1163: aname => 'AME_EXCEPTION',
1164: avalue => l_error_message );
1165:

Line 1258: l_ame_exception := po_wf_util_pkg.GetItemAttrText( itemtype => l_parent_item_type,

1254:
1255: /* Check if there we have encountered any ame exception.
1256: If the value of ame_exception is not null, then we have faced some exception.
1257: So just comlete the block activity and return */
1258: l_ame_exception := po_wf_util_pkg.GetItemAttrText( itemtype => l_parent_item_type,
1259: itemkey => l_parent_item_key,
1260: aname => 'AME_EXCEPTION' );
1261:
1262: IF l_ame_exception IS NOT NULL THEN

Line 1277: l_approver_group_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

1273: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
1274: END IF;
1275:
1276: --Bug 12944203
1277: l_approver_group_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1278: itemkey => itemkey,
1279: aname => 'APPROVAL_GROUP_ID');
1280:
1281:

Line 1282: l_req_header_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

1278: itemkey => itemkey,
1279: aname => 'APPROVAL_GROUP_ID');
1280:
1281:
1282: l_req_header_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1283: itemkey => itemkey,
1284: aname => 'DOCUMENT_ID');
1285:
1286: l_approver_response := po_wf_util_pkg.GetItemAttrText(itemtype => itemtype,

Line 1286: l_approver_response := po_wf_util_pkg.GetItemAttrText(itemtype => itemtype,

1282: l_req_header_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1283: itemkey => itemkey,
1284: aname => 'DOCUMENT_ID');
1285:
1286: l_approver_response := po_wf_util_pkg.GetItemAttrText(itemtype => itemtype,
1287: itemkey => itemkey,
1288: aname => 'APPROVER_RESPONSE');
1289:
1290: -- CLM Apprvl --

Line 1291: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

1287: itemkey => itemkey,
1288: aname => 'APPROVER_RESPONSE');
1289:
1290: -- CLM Apprvl --
1291: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1292: itemkey => itemkey,
1293: aname => 'DOCUMENT_TYPE');
1294:
1295: --Bug 13444730

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

1292: itemkey => itemkey,
1293: aname => 'DOCUMENT_TYPE');
1294:
1295: --Bug 13444730
1296: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
1297: itemkey => itemkey,
1298: aname => 'DOCUMENT_SUBTYPE');
1299:
1300: if l_document_type <> 'REQUISITION' then

Line 1301: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

1297: itemkey => itemkey,
1298: aname => 'DOCUMENT_SUBTYPE');
1299:
1300: if l_document_type <> 'REQUISITION' then
1301: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1302: itemkey => itemkey,
1303: aname => 'AME_TRANSACTION_ID');
1304:
1305: l_approver_disp_name := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

Line 1305: l_approver_disp_name := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,

1301: l_ame_transaction_id := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1302: itemkey => itemkey,
1303: aname => 'AME_TRANSACTION_ID');
1304:
1305: l_approver_disp_name := po_wf_util_pkg.GetItemAttrText ( itemtype => itemtype,
1306: itemkey => itemkey,
1307: aname => 'APPROVER_DISPLAY_NAME');
1308:
1309: end if;

Line 1312: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

1308:
1309: end if;
1310:
1311:
1312: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1313: itemkey => itemkey,
1314: aname => 'AME_TRANSACTION_TYPE');
1315:
1316: -- CLM Apprvl --

Line 1364: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

1360: fnd_message.set_name('PO', 'PO_ALREADY_APPROVED');
1361: fnd_message.set_token('PERSON_NAME', l_approver_disp_name);
1362: l_note := fnd_message.get;
1363:
1364: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1365: itemkey => itemkey,
1366: aname => 'DRAFT_ID');
1367:
1368: ame_api2.getAllApprovers7( applicationIdIn => applicationId,

Line 1455: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,

1451: LOOP
1452: FETCH l_child_wf INTO l_child_wf_cur;
1453: EXIT WHEN l_child_wf%NOTFOUND;
1454:
1455: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,
1456: itemkey => l_child_wf_cur.item_key,
1457: aname => 'APPROVER_EMPID');
1458:
1459: l_child_approver_groupid := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,

Line 1459: l_child_approver_groupid := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,

1455: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,
1456: itemkey => l_child_wf_cur.item_key,
1457: aname => 'APPROVER_EMPID');
1458:
1459: l_child_approver_groupid := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,
1460: itemkey => l_child_wf_cur.item_key,
1461: aname => 'APPROVAL_GROUP_ID');
1462:
1463: -- Bug 10043085 extra condition is added to check whether the notification is a delegated one.

Line 1499: l_person_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,

1495: FETCH l_child_wf INTO l_child_wf_cur;
1496: EXIT WHEN l_child_wf%NOTFOUND;
1497:
1498: -- Get the approver id as the person id to update the action history
1499: l_person_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,
1500: itemkey => l_child_wf_cur.item_key,
1501: aname => 'APPROVER_EMPID');
1502:
1503: l_progress := 'Process_Beat_By_First: 0051';

Line 1530: l_person_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,

1526: FETCH l_child_wf INTO l_child_wf_cur;
1527: EXIT WHEN l_child_wf%NOTFOUND;
1528:
1529: -- Get the approver id as the person id to update the action history
1530: l_person_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,
1531: itemkey => l_child_wf_cur.item_key,
1532: aname => 'APPROVER_EMPID');
1533:
1534: l_progress := 'Process_Beat_By_First: 006';

Line 1642: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1638: FROM wf_items
1639: WHERE item_type = itemtype and item_key = itemkey;
1640:
1641: Process_Response_Internal(itemtype, itemkey, 'APPROVE');
1642: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1643: itemkey => l_parent_item_key,
1644: aname => 'AME_SUB_APPROVAL_RESPONSE',
1645: avalue => 'APPROVE');
1646:

Line 1648: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

1644: aname => 'AME_SUB_APPROVAL_RESPONSE',
1645: avalue => 'APPROVE');
1646:
1647:
1648: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1649: itemkey => itemkey,
1650: aname => 'APPROVER_EMPID');
1651:
1652: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 1652: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

1648: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1649: itemkey => itemkey,
1650: aname => 'APPROVER_EMPID');
1651:
1652: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1653: itemkey => itemkey,
1654: aname => 'APPROVER_USER_NAME');
1655:
1656: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 1656: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

1652: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1653: itemkey => itemkey,
1654: aname => 'APPROVER_USER_NAME');
1655:
1656: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1657: itemkey => itemkey,
1658: aname => 'APPROVER_DISPLAY_NAME');
1659:
1660:

Line 1661: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1657: itemkey => itemkey,
1658: aname => 'APPROVER_DISPLAY_NAME');
1659:
1660:
1661: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1662: itemkey => l_parent_item_key,
1663: aname => 'FORWARD_FROM_ID',
1664: avalue => l_child_approver_empid );
1665:

Line 1666: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1662: itemkey => l_parent_item_key,
1663: aname => 'FORWARD_FROM_ID',
1664: avalue => l_child_approver_empid );
1665:
1666: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1667: itemkey => l_parent_item_key,
1668: aname => 'FORWARD_FROM_USER_NAME',
1669: avalue => l_child_approver_user_name);
1670:

Line 1671: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1667: itemkey => l_parent_item_key,
1668: aname => 'FORWARD_FROM_USER_NAME',
1669: avalue => l_child_approver_user_name);
1670:
1671: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1672: itemkey => l_parent_item_key,
1673: aname => 'FORWARD_FROM_DISP_NAME',
1674: avalue => l_child_approver_display_name);
1675:

Line 1676: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1672: itemkey => l_parent_item_key,
1673: aname => 'FORWARD_FROM_DISP_NAME',
1674: avalue => l_child_approver_display_name);
1675:
1676: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1677: itemkey => l_parent_item_key,
1678: aname => 'APPROVER_EMPID',
1679: avalue => l_child_approver_empid );
1680:

Line 1681: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1677: itemkey => l_parent_item_key,
1678: aname => 'APPROVER_EMPID',
1679: avalue => l_child_approver_empid );
1680:
1681: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1682: itemkey => l_parent_item_key,
1683: aname => 'APPROVER_USER_NAME',
1684: avalue => l_child_approver_user_name );
1685:

Line 1687: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1683: aname => 'APPROVER_USER_NAME',
1684: avalue => l_child_approver_user_name );
1685:
1686:
1687: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1688: itemkey => l_parent_item_key,
1689: aname => 'APPROVER_DISPLAY_NAME',
1690: avalue => l_child_approver_display_name );
1691:

Line 1750: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1746: into l_parent_item_type, l_parent_item_key
1747: FROM wf_items
1748: WHERE item_type = itemtype and item_key = itemkey;
1749:
1750: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1751: itemkey => l_parent_item_key,
1752: aname => 'AME_SUB_APPROVAL_RESPONSE',
1753: avalue => 'REJECT');
1754:

Line 1755: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

1751: itemkey => l_parent_item_key,
1752: aname => 'AME_SUB_APPROVAL_RESPONSE',
1753: avalue => 'REJECT');
1754:
1755: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1756: itemkey => itemkey,
1757: aname => 'APPROVER_EMPID');
1758:
1759: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 1759: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

1755: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1756: itemkey => itemkey,
1757: aname => 'APPROVER_EMPID');
1758:
1759: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1760: itemkey => itemkey,
1761: aname => 'APPROVER_USER_NAME');
1762:
1763: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 1763: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

1759: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1760: itemkey => itemkey,
1761: aname => 'APPROVER_USER_NAME');
1762:
1763: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1764: itemkey => itemkey,
1765: aname => 'APPROVER_DISPLAY_NAME');
1766:
1767:

Line 1768: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1764: itemkey => itemkey,
1765: aname => 'APPROVER_DISPLAY_NAME');
1766:
1767:
1768: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1769: itemkey => l_parent_item_key,
1770: aname => 'FORWARD_FROM_ID',
1771: avalue => l_child_approver_empid );
1772:

Line 1774: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1770: aname => 'FORWARD_FROM_ID',
1771: avalue => l_child_approver_empid );
1772:
1773:
1774: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1775: itemkey => l_parent_item_key,
1776: aname => 'FORWARD_FROM_USER_NAME',
1777: avalue => l_child_approver_user_name);
1778:

Line 1779: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1775: itemkey => l_parent_item_key,
1776: aname => 'FORWARD_FROM_USER_NAME',
1777: avalue => l_child_approver_user_name);
1778:
1779: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1780: itemkey => l_parent_item_key,
1781: aname => 'FORWARD_FROM_DISP_NAME',
1782: avalue => l_child_approver_display_name);
1783:

Line 1786: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1782: avalue => l_child_approver_display_name);
1783:
1784:
1785:
1786: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1787: itemkey => l_parent_item_key,
1788: aname => 'APPROVER_EMPID',
1789: avalue => l_child_approver_empid );
1790:

Line 1792: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1788: aname => 'APPROVER_EMPID',
1789: avalue => l_child_approver_empid );
1790:
1791:
1792: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1793: itemkey => l_parent_item_key,
1794: aname => 'APPROVER_USER_NAME',
1795: avalue => l_child_approver_user_name );
1796:

Line 1798: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1794: aname => 'APPROVER_USER_NAME',
1795: avalue => l_child_approver_user_name );
1796:
1797:
1798: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1799: itemkey => l_parent_item_key,
1800: aname => 'APPROVER_DISPLAY_NAME',
1801: avalue => l_child_approver_display_name );
1802:

Line 1865: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1861: into l_parent_item_type, l_parent_item_key
1862: FROM wf_items
1863: WHERE item_type = itemtype and item_key = itemkey;
1864:
1865: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1866: itemkey => l_parent_item_key,
1867: aname => 'AME_SUB_APPROVAL_RESPONSE',
1868: avalue => 'TIMEOUT');
1869:

Line 1870: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

1866: itemkey => l_parent_item_key,
1867: aname => 'AME_SUB_APPROVAL_RESPONSE',
1868: avalue => 'TIMEOUT');
1869:
1870: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1871: itemkey => itemkey,
1872: aname => 'APPROVER_EMPID');
1873:
1874: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 1874: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

1870: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1871: itemkey => itemkey,
1872: aname => 'APPROVER_EMPID');
1873:
1874: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1875: itemkey => itemkey,
1876: aname => 'APPROVER_USER_NAME');
1877:
1878: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 1878: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

1874: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1875: itemkey => itemkey,
1876: aname => 'APPROVER_USER_NAME');
1877:
1878: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1879: itemkey => itemkey,
1880: aname => 'APPROVER_DISPLAY_NAME');
1881:
1882:

Line 1883: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1879: itemkey => itemkey,
1880: aname => 'APPROVER_DISPLAY_NAME');
1881:
1882:
1883: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1884: itemkey => l_parent_item_key,
1885: aname => 'FORWARD_FROM_ID',
1886: avalue => l_child_approver_empid );
1887:

Line 1889: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1885: aname => 'FORWARD_FROM_ID',
1886: avalue => l_child_approver_empid );
1887:
1888:
1889: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1890: itemkey => l_parent_item_key,
1891: aname => 'FORWARD_FROM_USER_NAME',
1892: avalue => l_child_approver_user_name);
1893:

Line 1894: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1890: itemkey => l_parent_item_key,
1891: aname => 'FORWARD_FROM_USER_NAME',
1892: avalue => l_child_approver_user_name);
1893:
1894: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1895: itemkey => l_parent_item_key,
1896: aname => 'FORWARD_FROM_DISP_NAME',
1897: avalue => l_child_approver_display_name);
1898:

Line 1901: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1897: avalue => l_child_approver_display_name);
1898:
1899:
1900:
1901: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1902: itemkey => l_parent_item_key,
1903: aname => 'APPROVER_EMPID',
1904: avalue => l_child_approver_empid );
1905:

Line 1907: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1903: aname => 'APPROVER_EMPID',
1904: avalue => l_child_approver_empid );
1905:
1906:
1907: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1908: itemkey => l_parent_item_key,
1909: aname => 'APPROVER_USER_NAME',
1910: avalue => l_child_approver_user_name );
1911:

Line 1913: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1909: aname => 'APPROVER_USER_NAME',
1910: avalue => l_child_approver_user_name );
1911:
1912:
1913: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1914: itemkey => l_parent_item_key,
1915: aname => 'APPROVER_DISPLAY_NAME',
1916: avalue => l_child_approver_display_name );
1917:

Line 1983: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1979: FROM wf_items
1980: WHERE item_type = itemtype and item_key = itemkey;
1981:
1982: Process_Response_Internal(itemtype, itemkey, 'FORWARD');
1983: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1984: itemkey => l_parent_item_key,
1985: aname => 'AME_SUB_APPROVAL_RESPONSE',
1986: avalue => 'FORWARD');
1987:

Line 1989: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

1985: aname => 'AME_SUB_APPROVAL_RESPONSE',
1986: avalue => 'FORWARD');
1987:
1988:
1989: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1990: itemkey => itemkey,
1991: aname => 'APPROVER_EMPID');
1992:
1993: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 1993: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

1989: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1990: itemkey => itemkey,
1991: aname => 'APPROVER_EMPID');
1992:
1993: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1994: itemkey => itemkey,
1995: aname => 'APPROVER_USER_NAME');
1996:
1997: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 1997: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

1993: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1994: itemkey => itemkey,
1995: aname => 'APPROVER_USER_NAME');
1996:
1997: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1998: itemkey => itemkey,
1999: aname => 'APPROVER_DISPLAY_NAME');
2000:
2001:

Line 2002: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

1998: itemkey => itemkey,
1999: aname => 'APPROVER_DISPLAY_NAME');
2000:
2001:
2002: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
2003: itemkey => l_parent_item_key,
2004: aname => 'FORWARD_FROM_ID',
2005: avalue => l_child_approver_empid );
2006:

Line 2007: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

2003: itemkey => l_parent_item_key,
2004: aname => 'FORWARD_FROM_ID',
2005: avalue => l_child_approver_empid );
2006:
2007: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
2008: itemkey => l_parent_item_key,
2009: aname => 'FORWARD_FROM_USER_NAME',
2010: avalue => l_child_approver_user_name);
2011:

Line 2012: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

2008: itemkey => l_parent_item_key,
2009: aname => 'FORWARD_FROM_USER_NAME',
2010: avalue => l_child_approver_user_name);
2011:
2012: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
2013: itemkey => l_parent_item_key,
2014: aname => 'FORWARD_FROM_DISP_NAME',
2015: avalue => l_child_approver_display_name);
2016:

Line 2017: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

2013: itemkey => l_parent_item_key,
2014: aname => 'FORWARD_FROM_DISP_NAME',
2015: avalue => l_child_approver_display_name);
2016:
2017: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
2018: itemkey => l_parent_item_key,
2019: aname => 'APPROVER_EMPID',
2020: avalue => l_child_approver_empid );
2021:

Line 2022: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

2018: itemkey => l_parent_item_key,
2019: aname => 'APPROVER_EMPID',
2020: avalue => l_child_approver_empid );
2021:
2022: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
2023: itemkey => l_parent_item_key,
2024: aname => 'APPROVER_USER_NAME',
2025: avalue => l_child_approver_user_name );
2026:

Line 2028: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

2024: aname => 'APPROVER_USER_NAME',
2025: avalue => l_child_approver_user_name );
2026:
2027:
2028: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
2029: itemkey => l_parent_item_key,
2030: aname => 'APPROVER_DISPLAY_NAME',
2031: avalue => l_child_approver_display_name );
2032:

Line 2091: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

2087: FROM wf_items
2088: WHERE item_type = itemtype and item_key = itemkey;
2089:
2090: Process_Response_Internal(itemtype, itemkey, 'APPROVE AND FORWARD');
2091: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
2092: itemkey => l_parent_item_key,
2093: aname => 'AME_SUB_APPROVAL_RESPONSE',
2094: avalue => 'APPROVE AND FORWARD');
2095:

Line 2097: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

2093: aname => 'AME_SUB_APPROVAL_RESPONSE',
2094: avalue => 'APPROVE AND FORWARD');
2095:
2096:
2097: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2098: itemkey => itemkey,
2099: aname => 'APPROVER_EMPID');
2100:
2101: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 2101: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2097: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2098: itemkey => itemkey,
2099: aname => 'APPROVER_EMPID');
2100:
2101: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2102: itemkey => itemkey,
2103: aname => 'APPROVER_USER_NAME');
2104:
2105: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 2105: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2101: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2102: itemkey => itemkey,
2103: aname => 'APPROVER_USER_NAME');
2104:
2105: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2106: itemkey => itemkey,
2107: aname => 'APPROVER_DISPLAY_NAME');
2108:
2109:

Line 2110: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

2106: itemkey => itemkey,
2107: aname => 'APPROVER_DISPLAY_NAME');
2108:
2109:
2110: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
2111: itemkey => l_parent_item_key,
2112: aname => 'FORWARD_FROM_ID',
2113: avalue => l_child_approver_empid );
2114:

Line 2115: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

2111: itemkey => l_parent_item_key,
2112: aname => 'FORWARD_FROM_ID',
2113: avalue => l_child_approver_empid );
2114:
2115: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
2116: itemkey => l_parent_item_key,
2117: aname => 'FORWARD_FROM_USER_NAME',
2118: avalue => l_child_approver_user_name);
2119:

Line 2120: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

2116: itemkey => l_parent_item_key,
2117: aname => 'FORWARD_FROM_USER_NAME',
2118: avalue => l_child_approver_user_name);
2119:
2120: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
2121: itemkey => l_parent_item_key,
2122: aname => 'FORWARD_FROM_DISP_NAME',
2123: avalue => l_child_approver_display_name);
2124:

Line 2125: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

2121: itemkey => l_parent_item_key,
2122: aname => 'FORWARD_FROM_DISP_NAME',
2123: avalue => l_child_approver_display_name);
2124:
2125: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
2126: itemkey => l_parent_item_key,
2127: aname => 'APPROVER_EMPID',
2128: avalue => l_child_approver_empid );
2129:

Line 2130: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

2126: itemkey => l_parent_item_key,
2127: aname => 'APPROVER_EMPID',
2128: avalue => l_child_approver_empid );
2129:
2130: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
2131: itemkey => l_parent_item_key,
2132: aname => 'APPROVER_USER_NAME',
2133: avalue => l_child_approver_user_name );
2134:

Line 2136: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

2132: aname => 'APPROVER_USER_NAME',
2133: avalue => l_child_approver_user_name );
2134:
2135:
2136: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
2137: itemkey => l_parent_item_key,
2138: aname => 'APPROVER_DISPLAY_NAME',
2139: avalue => l_child_approver_display_name );
2140:

Line 2289: l_next_approver_id := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,

2285:
2286: IF (funcmode='RUN') THEN
2287:
2288:
2289: l_next_approver_id := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
2290: itemkey=>itemkey,
2291: aname=>'APPROVER_EMPID');
2292:
2293: l_document_type := po_wf_util_pkg.GetItemAttrText(itemtype => itemtype,

Line 2293: l_document_type := po_wf_util_pkg.GetItemAttrText(itemtype => itemtype,

2289: l_next_approver_id := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
2290: itemkey=>itemkey,
2291: aname=>'APPROVER_EMPID');
2292:
2293: l_document_type := po_wf_util_pkg.GetItemAttrText(itemtype => itemtype,
2294: itemkey => itemkey,
2295: aname => 'DOCUMENT_TYPE');
2296: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (
2297: itemtype => itemtype,

Line 2296: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (

2292:
2293: l_document_type := po_wf_util_pkg.GetItemAttrText(itemtype => itemtype,
2294: itemkey => itemkey,
2295: aname => 'DOCUMENT_TYPE');
2296: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText (
2297: itemtype => itemtype,
2298: itemkey => itemkey,
2299: aname => 'DOCUMENT_SUBTYPE');
2300:

Line 2301: l_transaction_type := po_wf_util_pkg.GetItemAttrText(itemtype => itemtype,

2297: itemtype => itemtype,
2298: itemkey => itemkey,
2299: aname => 'DOCUMENT_SUBTYPE');
2300:
2301: l_transaction_type := po_wf_util_pkg.GetItemAttrText(itemtype => itemtype,
2302: itemkey => itemkey,
2303: aname => 'AME_TRANSACTION_TYPE');
2304: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2305: itemkey => itemkey,

Line 2304: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

2300:
2301: l_transaction_type := po_wf_util_pkg.GetItemAttrText(itemtype => itemtype,
2302: itemkey => itemkey,
2303: aname => 'AME_TRANSACTION_TYPE');
2304: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2305: itemkey => itemkey,
2306: aname => 'APPROVAL_GROUP_ID');
2307:
2308: -- Set the multi-org context

Line 2309: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

2305: itemkey => itemkey,
2306: aname => 'APPROVAL_GROUP_ID');
2307:
2308: -- Set the multi-org context
2309: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2310: itemkey => itemkey,
2311: aname => 'ORG_ID');
2312:
2313: IF l_org_id is NOT NULL THEN

Line 2318: l_req_header_id := po_wf_util_pkg.GetItemAttrNumber(itemtype => itemtype,

2314: PO_MOAC_UTILS_PVT.set_org_context(l_org_id);
2315: END IF;
2316:
2317: if l_document_type = 'REQUISITION' then
2318: l_req_header_id := po_wf_util_pkg.GetItemAttrNumber(itemtype => itemtype,
2319: itemkey => itemkey,
2320: aname => 'DOCUMENT_ID');
2321: l_progress := 'Insert_Action_History: 004 - Calling insertActionHistory.';
2322: IF (g_po_wf_debug = 'Y') THEN

Line 2333: /* l_ame_transaction_id := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2329: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
2330: END IF;
2331:
2332: else
2333: /* l_ame_transaction_id := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2334: itemkey => itemkey,
2335: aname => 'AME_TRANSACTION_ID');*/
2336: l_document_id:= po_wf_util_pkg.GetItemAttrNumber(itemtype => itemtype,
2337: itemkey => itemkey,

Line 2336: l_document_id:= po_wf_util_pkg.GetItemAttrNumber(itemtype => itemtype,

2332: else
2333: /* l_ame_transaction_id := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2334: itemkey => itemkey,
2335: aname => 'AME_TRANSACTION_ID');*/
2336: l_document_id:= po_wf_util_pkg.GetItemAttrNumber(itemtype => itemtype,
2337: itemkey => itemkey,
2338: aname => 'DOCUMENT_ID');
2339: l_draft_id := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2340: itemkey => itemkey,

Line 2339: l_draft_id := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2335: aname => 'AME_TRANSACTION_ID');*/
2336: l_document_id:= po_wf_util_pkg.GetItemAttrNumber(itemtype => itemtype,
2337: itemkey => itemkey,
2338: aname => 'DOCUMENT_ID');
2339: l_draft_id := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2340: itemkey => itemkey,
2341: aname => 'DRAFT_ID');
2342: l_progress := 'Insert_Action_History: 006 - Calling insertActionHistory.';
2343: IF (g_po_wf_debug = 'Y') THEN

Line 2360: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,

2356: END IF;
2357: end if;
2358:
2359: /* Reset the FORWARD_TO_USERNAME_RESPONSE attribute */
2360: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
2361: itemkey => itemkey,
2362: aname => 'FORWARD_TO_USERNAME_RESPONSE',
2363: avalue => NULL);
2364:

Line 2366: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,

2362: aname => 'FORWARD_TO_USERNAME_RESPONSE',
2363: avalue => NULL);
2364:
2365: /* Reset the NOTE attribute */
2366: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
2367: itemkey => itemkey,
2368: aname => 'NOTE',
2369: avalue => NULL);
2370:

Line 2445: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,

2441: END IF;
2442:
2443: IF (funcmode='RUN') THEN
2444:
2445: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
2446: itemkey=>itemkey,
2447: aname=>'APPROVER_EMPID');
2448:
2449: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

Line 2449: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

2445: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
2446: itemkey=>itemkey,
2447: aname=>'APPROVER_EMPID');
2448:
2449: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2450: itemkey => itemkey,
2451: aname => 'DOCUMENT_ID');
2452:
2453: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 2453: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2449: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2450: itemkey => itemkey,
2451: aname => 'DOCUMENT_ID');
2452:
2453: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2454: itemkey => itemkey,
2455: aname => 'DOCUMENT_TYPE');
2456:
2457: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 2457: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2453: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2454: itemkey => itemkey,
2455: aname => 'DOCUMENT_TYPE');
2456:
2457: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2458: itemkey => itemkey,
2459: aname => 'DOCUMENT_SUBTYPE');
2460:
2461: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 2461: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2457: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2458: itemkey => itemkey,
2459: aname => 'DOCUMENT_SUBTYPE');
2460:
2461: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2462: itemkey => itemkey,
2463: aname => 'AME_TRANSACTION_TYPE');
2464:
2465:

Line 2466: l_note := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2462: itemkey => itemkey,
2463: aname => 'AME_TRANSACTION_TYPE');
2464:
2465:
2466: l_note := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2467: itemkey => itemkey,
2468: aname => 'NOTE');
2469:
2470: -- Set the multi-org context

Line 2471: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

2467: itemkey => itemkey,
2468: aname => 'NOTE');
2469:
2470: -- Set the multi-org context
2471: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2472: itemkey => itemkey,
2473: aname => 'ORG_ID');
2474:
2475: IF l_org_id is NOT NULL THEN

Line 2498: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

2494: x_last_approver=>l_result,
2495: x_note=>l_note);
2496:
2497: else
2498: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2499: itemkey => itemkey,
2500: aname => 'DRAFT_ID');
2501:
2502: l_progress := 'Update_Action_History_Approve: 003-'|| to_char(l_document_id)||

Line 2516: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,

2512: l_note, l_current_approver);
2513:
2514: end if;
2515:
2516: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
2517: itemkey => itemkey,
2518: aname => 'APPROVER_RESPONSE',
2519: avalue => 'APPROVED' );
2520:

Line 2597: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,

2593: END IF;
2594:
2595: IF (funcmode='RUN') THEN
2596:
2597: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
2598: itemkey=>itemkey,
2599: aname=>'APPROVER_EMPID');
2600:
2601: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

Line 2601: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

2597: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
2598: itemkey=>itemkey,
2599: aname=>'APPROVER_EMPID');
2600:
2601: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2602: itemkey => itemkey,
2603: aname => 'DOCUMENT_ID');
2604:
2605: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 2605: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2601: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2602: itemkey => itemkey,
2603: aname => 'DOCUMENT_ID');
2604:
2605: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2606: itemkey => itemkey,
2607: aname => 'DOCUMENT_TYPE');
2608:
2609: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 2609: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2605: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2606: itemkey => itemkey,
2607: aname => 'DOCUMENT_TYPE');
2608:
2609: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2610: itemkey => itemkey,
2611: aname => 'DOCUMENT_SUBTYPE');
2612:
2613: -- CLM Apprvl --

Line 2614: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2610: itemkey => itemkey,
2611: aname => 'DOCUMENT_SUBTYPE');
2612:
2613: -- CLM Apprvl --
2614: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2615: itemkey => itemkey,
2616: aname => 'AME_TRANSACTION_TYPE');
2617:
2618:

Line 2619: l_note := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2615: itemkey => itemkey,
2616: aname => 'AME_TRANSACTION_TYPE');
2617:
2618:
2619: l_note := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2620: itemkey => itemkey,
2621: aname => 'NOTE');
2622:
2623: -- Set the multi-org context

Line 2624: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

2620: itemkey => itemkey,
2621: aname => 'NOTE');
2622:
2623: -- Set the multi-org context
2624: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2625: itemkey => itemkey,
2626: aname => 'ORG_ID');
2627:
2628: IF l_org_id is NOT NULL THEN

Line 2651: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

2647: x_last_approver=>l_result,
2648: x_note=>l_note);
2649: else
2650:
2651: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2652: itemkey => itemkey,
2653: aname => 'DRAFT_ID');
2654: l_progress := 'Update_Action_History_Reject: 003-'|| to_char(l_document_id)||'-'||to_char(l_draft_id)||'-'||
2655: l_document_type||'-'||l_document_subtype;

Line 2667: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,

2663: l_note, l_current_approver);
2664:
2665: end if;
2666:
2667: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
2668: itemkey => itemkey,
2669: aname => 'APPROVER_RESPONSE',
2670: avalue => 'REJECTED' );
2671:

Line 2747: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,

2743: END IF;
2744:
2745: IF (funcmode='RUN') THEN
2746:
2747: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
2748: itemkey=>itemkey,
2749: aname=>'APPROVER_EMPID');
2750:
2751: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

Line 2751: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

2747: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
2748: itemkey=>itemkey,
2749: aname=>'APPROVER_EMPID');
2750:
2751: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2752: itemkey => itemkey,
2753: aname => 'DOCUMENT_ID');
2754:
2755: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 2755: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2751: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2752: itemkey => itemkey,
2753: aname => 'DOCUMENT_ID');
2754:
2755: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2756: itemkey => itemkey,
2757: aname => 'DOCUMENT_TYPE');
2758:
2759: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 2759: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2755: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2756: itemkey => itemkey,
2757: aname => 'DOCUMENT_TYPE');
2758:
2759: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2760: itemkey => itemkey,
2761: aname => 'DOCUMENT_SUBTYPE');
2762:
2763: -- CLM Apprvl --

Line 2764: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2760: itemkey => itemkey,
2761: aname => 'DOCUMENT_SUBTYPE');
2762:
2763: -- CLM Apprvl --
2764: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2765: itemkey => itemkey,
2766: aname => 'AME_TRANSACTION_TYPE');
2767:
2768:

Line 2772: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

2768:
2769: l_note := fnd_message.get_string('ICX', 'ICX_POR_NOTIF_TIMEOUT');
2770:
2771: -- Set the multi-org context
2772: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2773: itemkey => itemkey,
2774: aname => 'ORG_ID');
2775:
2776: IF l_org_id is NOT NULL THEN

Line 2799: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

2795: x_last_approver=>l_result,
2796: x_note=>l_note);
2797: else
2798:
2799: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2800: itemkey => itemkey,
2801: aname => 'DRAFT_ID');
2802:
2803: l_progress := 'Update_Action_History_Timeout: 003-'|| to_char(l_document_id)||'-'||to_char(l_draft_id)||'-'||

Line 2889: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,

2885: END IF;
2886:
2887: IF (funcmode='RUN') THEN
2888:
2889: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
2890: itemkey=>itemkey,
2891: aname=>'APPROVER_EMPID');
2892:
2893: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

Line 2893: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

2889: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
2890: itemkey=>itemkey,
2891: aname=>'APPROVER_EMPID');
2892:
2893: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2894: itemkey => itemkey,
2895: aname => 'DOCUMENT_ID');
2896:
2897: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 2897: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2893: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2894: itemkey => itemkey,
2895: aname => 'DOCUMENT_ID');
2896:
2897: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2898: itemkey => itemkey,
2899: aname => 'DOCUMENT_TYPE');
2900:
2901: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 2901: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2897: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2898: itemkey => itemkey,
2899: aname => 'DOCUMENT_TYPE');
2900:
2901: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2902: itemkey => itemkey,
2903: aname => 'DOCUMENT_SUBTYPE');
2904:
2905: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 2905: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2901: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2902: itemkey => itemkey,
2903: aname => 'DOCUMENT_SUBTYPE');
2904:
2905: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2906: itemkey => itemkey,
2907: aname => 'AME_TRANSACTION_TYPE');
2908:
2909:

Line 2910: l_note := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

2906: itemkey => itemkey,
2907: aname => 'AME_TRANSACTION_TYPE');
2908:
2909:
2910: l_note := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2911: itemkey => itemkey,
2912: aname => 'NOTE');
2913:
2914: -- Set the multi-org context

Line 2915: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

2911: itemkey => itemkey,
2912: aname => 'NOTE');
2913:
2914: -- Set the multi-org context
2915: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2916: itemkey => itemkey,
2917: aname => 'ORG_ID');
2918:
2919: IF l_org_id is NOT NULL THEN

Line 2936: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

2932: UpdateActionHistory(l_document_id, l_action,
2933: l_note, l_current_approver);
2934: else
2935:
2936: l_draft_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
2937: itemkey => itemkey,
2938: aname => 'DRAFT_ID');
2939:
2940:

Line 2954: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,

2950: l_note, l_current_approver);
2951:
2952: end if;
2953:
2954: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
2955: itemkey => itemkey,
2956: aname => 'APPROVER_RESPONSE',
2957: avalue => 'FORWARD' );
2958:

Line 3025: l_doc_header_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

3021: return;
3022: end if;
3023:
3024:
3025: l_doc_header_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
3026: itemkey => itemkey,
3027: aname => 'DOCUMENT_ID');
3028:
3029: l_doc_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

Line 3029: l_doc_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

3025: l_doc_header_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
3026: itemkey => itemkey,
3027: aname => 'DOCUMENT_ID');
3028:
3029: l_doc_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
3030: itemkey => itemkey,
3031: aname => 'DOCUMENT_TYPE');
3032:
3033: BEGIN

Line 3035: l_response_action := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

3031: aname => 'DOCUMENT_TYPE');
3032:
3033: BEGIN
3034:
3035: l_response_action := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
3036: itemkey => itemkey,
3037: aname => 'AME_SUB_APPROVAL_RESPONSE');
3038: IF( l_response_action = 'APPROVE' ) THEN
3039: l_note := fnd_message.get_string('ICX', 'ICX_POR_REQ_ALREADY_APPROVED');

Line 3180: l_ame_exception :=PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,

3176: l_doc_string VARCHAR2(200);
3177: Begin
3178: IF (funcmode = 'RUN') THEN
3179: l_progress := 'IS_AME_EXCEPTION: 001';
3180: l_ame_exception :=PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
3181: itemkey => itemkey,
3182: aname => 'AME_EXCEPTION');
3183:
3184: if l_ame_exception IS NOT NULL then

Line 3741: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

3737: FROM wf_items
3738: WHERE item_type = itemtype and item_key = itemkey;
3739:
3740: Process_Response_Internal(itemtype, itemkey, 'EXCEPTION');
3741: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
3742: itemkey => l_parent_item_key,
3743: aname => 'AME_SUB_APPROVAL_RESPONSE',
3744: avalue => 'EXCEPTION');
3745: