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 82: l_ame_exception := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

78: END IF;
79:
80: /* Check if there is any AME exception.
81: If yes, then return 'invalid approver' */
82: l_ame_exception := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
83: itemkey => itemkey,
84: aname => 'AME_EXCEPTION');
85: IF l_ame_exception IS NOT NULL THEN
86: resultout:='COMPLETE:'||'INVALID_APPROVER';

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

86: resultout:='COMPLETE:'||'INVALID_APPROVER';
87: RETURN;
88: END IF;
89:
90: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
91: itemkey => itemkey,
92: aname => 'DOCUMENT_ID');
93:
94: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

90: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
91: itemkey => itemkey,
92: aname => 'DOCUMENT_ID');
93:
94: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
95: itemkey => itemkey,
96: aname => 'DOCUMENT_TYPE');
97:
98: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

94: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
95: itemkey => itemkey,
96: aname => 'DOCUMENT_TYPE');
97:
98: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
99: itemkey => itemkey,
100: aname => 'DOCUMENT_SUBTYPE');
101:
102: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

98: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
99: itemkey => itemkey,
100: aname => 'DOCUMENT_SUBTYPE');
101:
102: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
103: itemkey => itemkey,
104: aname => 'AME_TRANSACTION_TYPE');
105:
106: l_progress := 'Get_Next_Approver: 002-'||to_char(l_document_id)||'-'|| l_document_type||'-'||l_document_subtype;

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

277: IF (g_po_wf_debug = 'Y') THEN
278: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
279: END IF;
280:
281: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
282: itemkey => itemkey,
283: aname => 'DOCUMENT_ID');
284:
285: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

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

281: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
282: itemkey => itemkey,
283: aname => 'DOCUMENT_ID');
284:
285: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
286: itemkey => itemkey,
287: aname => 'ORG_ID');
288:
289: l_start_block_activity := 'N';

Line 322: t_varval(2) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

318: t_varname(1) := 'DOCUMENT_TYPE';
319: t_varval(1) := 'REQUISITION';
320:
321: t_varname(2) := 'DOCUMENT_SUBTYPE';
322: t_varval(2) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
323: itemkey => itemkey,
324: aname => 'DOCUMENT_SUBTYPE');
325:
326: t_varname(3) := 'PREPARER_USER_NAME';

Line 327: t_varval(3) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

323: itemkey => itemkey,
324: aname => 'DOCUMENT_SUBTYPE');
325:
326: t_varname(3) := 'PREPARER_USER_NAME';
327: t_varval(3) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
328: itemkey => itemkey,
329: aname => 'PREPARER_USER_NAME');
330:
331: t_varname(4) := 'PREPARER_DISPLAY_NAME';

Line 332: t_varval(4) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

328: itemkey => itemkey,
329: aname => 'PREPARER_USER_NAME');
330:
331: t_varname(4) := 'PREPARER_DISPLAY_NAME';
332: t_varval(4) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
333: itemkey => itemkey,
334: aname => 'PREPARER_DISPLAY_NAME');
335:
336: t_varname(5) := 'FUNCTIONAL_CURRENCY';

Line 337: t_varval(5) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

333: itemkey => itemkey,
334: aname => 'PREPARER_DISPLAY_NAME');
335:
336: t_varname(5) := 'FUNCTIONAL_CURRENCY';
337: t_varval(5) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
338: itemkey => itemkey,
339: aname => 'FUNCTIONAL_CURRENCY');
340:
341: t_varname(6) := 'IS_AME_APPROVAL';

Line 345: t_varval(7) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

341: t_varname(6) := 'IS_AME_APPROVAL';
342: t_varval(6) := 'Y';
343:
344: t_varname(7) := 'TOTAL_AMOUNT_DSP';
345: t_varval(7) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
346: itemkey => itemkey,
347: aname => 'TOTAL_AMOUNT_DSP');
348:
349: t_varname(8) := 'FORWARD_FROM_DISP_NAME';

Line 350: t_varval(8) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

346: itemkey => itemkey,
347: aname => 'TOTAL_AMOUNT_DSP');
348:
349: t_varname(8) := 'FORWARD_FROM_DISP_NAME';
350: t_varval(8) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
351: itemkey => itemkey,
352: aname => 'FORWARD_FROM_DISP_NAME');
353:
354: t_varname(9) := 'FORWARD_FROM_USER_NAME';

Line 355: t_varval(9) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

351: itemkey => itemkey,
352: aname => 'FORWARD_FROM_DISP_NAME');
353:
354: t_varname(9) := 'FORWARD_FROM_USER_NAME';
355: t_varval(9) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
356: itemkey => itemkey,
357: aname => 'FORWARD_FROM_USER_NAME');
358:
359: t_varname(10) := 'REQ_DESCRIPTION';

Line 360: t_varval(10) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

356: itemkey => itemkey,
357: aname => 'FORWARD_FROM_USER_NAME');
358:
359: t_varname(10) := 'REQ_DESCRIPTION';
360: t_varval(10) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
361: itemkey => itemkey,
362: aname => 'REQ_DESCRIPTION');
363:
364: t_varname(11) := 'REQ_AMOUNT_CURRENCY_DSP';

Line 365: t_varval(11) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

361: itemkey => itemkey,
362: aname => 'REQ_DESCRIPTION');
363:
364: t_varname(11) := 'REQ_AMOUNT_CURRENCY_DSP';
365: t_varval(11) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
366: itemkey => itemkey,
367: aname => 'REQ_AMOUNT_CURRENCY_DSP');
368:
369: t_varname(12) := 'TAX_AMOUNT_CURRENCY_DSP';

Line 370: t_varval(12) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

366: itemkey => itemkey,
367: aname => 'REQ_AMOUNT_CURRENCY_DSP');
368:
369: t_varname(12) := 'TAX_AMOUNT_CURRENCY_DSP';
370: t_varval(12) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
371: itemkey => itemkey,
372: aname => 'TAX_AMOUNT_CURRENCY_DSP');
373:
374: t_varname(13) := 'JUSTIFICATION';

Line 375: t_varval(13) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

371: itemkey => itemkey,
372: aname => 'TAX_AMOUNT_CURRENCY_DSP');
373:
374: t_varname(13) := 'JUSTIFICATION';
375: t_varval(13) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
376: itemkey => itemkey,
377: aname => 'JUSTIFICATION');
378:
379: t_varname(14) := 'CONTRACTOR_REQUISITION_FLAG';

Line 380: t_varval(14) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

376: itemkey => itemkey,
377: aname => 'JUSTIFICATION');
378:
379: t_varname(14) := 'CONTRACTOR_REQUISITION_FLAG';
380: t_varval(14) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
381: itemkey => itemkey,
382: aname => 'CONTRACTOR_REQUISITION_FLAG');
383:
384: t_varname(15) := 'CONTRACTOR_REQUISITION_FLAG';

Line 385: t_varval(15) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

381: itemkey => itemkey,
382: aname => 'CONTRACTOR_REQUISITION_FLAG');
383:
384: t_varname(15) := 'CONTRACTOR_REQUISITION_FLAG';
385: t_varval(15) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
386: itemkey => itemkey,
387: aname => 'CONTRACTOR_REQUISITION_FLAG');
388:
389: t_varname(16) := 'CONTRACTOR_STATUS';

Line 390: t_varval(16) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

386: itemkey => itemkey,
387: aname => 'CONTRACTOR_REQUISITION_FLAG');
388:
389: t_varname(16) := 'CONTRACTOR_STATUS';
390: t_varval(16) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
391: itemkey => itemkey,
392: aname => 'CONTRACTOR_STATUS');
393:
394: t_varname(17) := 'VENDOR_DISPLAY_NAME';

Line 395: t_varval(17) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

391: itemkey => itemkey,
392: aname => 'CONTRACTOR_STATUS');
393:
394: t_varname(17) := 'VENDOR_DISPLAY_NAME';
395: t_varval(17) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
396: itemkey => itemkey,
397: aname => 'VENDOR_DISPLAY_NAME');
398:
399: t_varname(18) := 'IS_SUPPLIER_EMAIL_NOT_AVAIL';

Line 400: t_varval(18) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

396: itemkey => itemkey,
397: aname => 'VENDOR_DISPLAY_NAME');
398:
399: t_varname(18) := 'IS_SUPPLIER_EMAIL_NOT_AVAIL';
400: t_varval(18) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
401: itemkey => itemkey,
402: aname => 'IS_SUPPLIER_EMAIL_NOT_AVAIL');
403:
404: t_varname(19) := 'CONTRACTOR_ASSIGNMENT_REQD';

Line 405: t_varval(19) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

401: itemkey => itemkey,
402: aname => 'IS_SUPPLIER_EMAIL_NOT_AVAIL');
403:
404: t_varname(19) := 'CONTRACTOR_ASSIGNMENT_REQD';
405: t_varval(19) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
406: itemkey => itemkey,
407: aname => 'CONTRACTOR_ASSIGNMENT_REQD');
408:
409: t_varname(20) := 'DOCUMENT_NUMBER';

Line 410: t_varval(20) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

406: itemkey => itemkey,
407: aname => 'CONTRACTOR_ASSIGNMENT_REQD');
408:
409: t_varname(20) := 'DOCUMENT_NUMBER';
410: t_varval(20) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
411: itemkey => itemkey,
412: aname => 'DOCUMENT_NUMBER');
413:
414: t_varname(21) := 'AME_TRANSACTION_TYPE';

Line 415: t_varval(21) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

411: itemkey => itemkey,
412: aname => 'DOCUMENT_NUMBER');
413:
414: t_varname(21) := 'AME_TRANSACTION_TYPE';
415: t_varval(21) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
416: itemkey => itemkey,
417: aname => 'AME_TRANSACTION_TYPE');
418:
419: l_progress := 'Launch_Parallel_Approval: 003 -- Record Type :' || g_next_approvers(l_approver_index).orig_system;

Line 526: t_varval(26) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

522:
523: end if;
524:
525: t_varname(26) := 'VIEW_REQ_DTLS_URL';
526: t_varval(26) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
527: itemkey => itemkey,
528: aname => 'VIEW_REQ_DTLS_URL');
529: t_varval (26) := t_varval(26) || '&' || 'item_key=' || l_item_key;
530:

Line 532: t_varval(27) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

528: aname => 'VIEW_REQ_DTLS_URL');
529: t_varval (26) := t_varval(26) || '&' || 'item_key=' || l_item_key;
530:
531: t_varname(27) := 'EDIT_REQ_URL';
532: t_varval(27) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
533: itemkey => itemkey,
534: aname => 'EDIT_REQ_URL');
535: t_varval (27) := t_varval(27) || '&' || 'item_key=' || l_item_key;
536:

Line 538: t_varval(28) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

534: aname => 'EDIT_REQ_URL');
535: t_varval (27) := t_varval(27) || '&' || 'item_key=' || l_item_key;
536:
537: t_varname(28) := 'RESUBMIT_REQ_URL';
538: t_varval(28) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
539: itemkey => itemkey,
540: aname => 'RESUBMIT_REQ_URL');
541:
542: t_varname(28) := 'OPEN_FORM_COMMAND';

Line 543: t_varval(28) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

539: itemkey => itemkey,
540: aname => 'RESUBMIT_REQ_URL');
541:
542: t_varname(28) := 'OPEN_FORM_COMMAND';
543: t_varval(28) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
544: itemkey => itemkey,
545: aname => 'OPEN_FORM_COMMAND');
546:
547: -- Set the item attributes.

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

669: IF (g_po_wf_debug = 'Y') THEN
670: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
671: END IF;
672:
673: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
674: itemkey => itemkey,
675: aname => 'DOCUMENT_ID');
676:
677: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

673: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
674: itemkey => itemkey,
675: aname => 'DOCUMENT_ID');
676:
677: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
678: itemkey => itemkey,
679: aname => 'AME_TRANSACTION_TYPE');
680:
681: l_approver_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

677: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
678: itemkey => itemkey,
679: aname => 'AME_TRANSACTION_TYPE');
680:
681: l_approver_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
682: itemkey => itemkey,
683: aname => 'AME_APPROVER_TYPE');
684:
685: l_progress := 'Process_Response_Internal: 002 -- l_approver_type :' || l_approver_type ;

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

692: elsif (l_approver_type = ame_util.fndUserOrigSystem) then
693: l_current_approver.orig_system := ame_util.fndUserOrigSystem;
694: else
695: l_current_approver.orig_system := ame_util.perOrigSystem;
696: l_current_approver.name := po_wf_util_pkg.GetItemAttrText( itemtype => itemType,
697: itemkey => itemkey,
698: aname => 'APPROVER_USER_NAME');
699: end if;
700:

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

697: itemkey => itemkey,
698: aname => 'APPROVER_USER_NAME');
699: end if;
700:
701: l_current_approver.orig_system_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
702: itemkey => itemkey,
703: aname => 'AME_APPROVER_ID');
704:
705: l_progress := 'Process_Response_Internal: 003 -- l_current_approver.orig_system_id :' || l_current_approver.orig_system_id ;

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

755: into l_parent_item_type, l_parent_item_key
756: FROM wf_items
757: WHERE item_type = itemtype and item_key = itemkey;
758:
759: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
760: itemkey => l_parent_item_key,
761: aname => 'AME_EXCEPTION',
762: avalue => l_error_message );
763:

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

844:
845: /* Check if there we have encountered any ame exception.
846: If the value of ame_exception is not null, then we have faced some exception.
847: So just comlete the block activity and return */
848: l_ame_exception := po_wf_util_pkg.GetItemAttrText( itemtype => l_parent_item_type,
849: itemkey => l_parent_item_key,
850: aname => 'AME_EXCEPTION' );
851:
852: IF l_ame_exception IS NOT NULL THEN

Line 866: l_approver_group_id := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

862: IF (g_po_wf_debug = 'Y') THEN
863: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
864: END IF;
865:
866: l_approver_group_id := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
867: itemkey => itemkey,
868: aname => 'APPROVAL_GROUP_ID');
869:
870: l_req_header_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

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

866: l_approver_group_id := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
867: itemkey => itemkey,
868: aname => 'APPROVAL_GROUP_ID');
869:
870: l_req_header_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
871: itemkey => itemkey,
872: aname => 'DOCUMENT_ID');
873:
874: l_approver_response := po_wf_util_pkg.GetItemAttrText(itemtype => itemtype,

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

870: l_req_header_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
871: itemkey => itemkey,
872: aname => 'DOCUMENT_ID');
873:
874: l_approver_response := po_wf_util_pkg.GetItemAttrText(itemtype => itemtype,
875: itemkey => itemkey,
876: aname => 'APPROVER_RESPONSE');
877:
878: select first_position_id, first_approver_id

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

981: LOOP
982: FETCH l_child_wf INTO l_child_wf_cur;
983: EXIT WHEN l_child_wf%NOTFOUND;
984:
985: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,
986: itemkey => l_child_wf_cur.item_key,
987: aname => 'APPROVER_EMPID');
988:
989: l_child_approver_groupid := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,

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

985: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,
986: itemkey => l_child_wf_cur.item_key,
987: aname => 'APPROVER_EMPID');
988:
989: l_child_approver_groupid := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,
990: itemkey => l_child_wf_cur.item_key,
991: aname => 'APPROVAL_GROUP_ID');
992:
993:

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

1016: FETCH l_child_wf INTO l_child_wf_cur;
1017: EXIT WHEN l_child_wf%NOTFOUND;
1018:
1019: -- Get the approver id as the person id to update the action history
1020: l_person_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => l_child_wf_cur.item_type,
1021: itemkey => l_child_wf_cur.item_key,
1022: aname => 'APPROVER_EMPID');
1023:
1024: l_progress := 'Process_Beat_By_First: 006';

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

1117: FROM wf_items
1118: WHERE item_type = itemtype and item_key = itemkey;
1119:
1120: Process_Response_Internal(itemtype, itemkey, 'APPROVE');
1121: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1122: itemkey => l_parent_item_key,
1123: aname => 'AME_SUB_APPROVAL_RESPONSE',
1124: avalue => 'APPROVE');
1125:

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

1123: aname => 'AME_SUB_APPROVAL_RESPONSE',
1124: avalue => 'APPROVE');
1125:
1126:
1127: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1128: itemkey => itemkey,
1129: aname => 'APPROVER_EMPID');
1130:
1131: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1127: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1128: itemkey => itemkey,
1129: aname => 'APPROVER_EMPID');
1130:
1131: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1132: itemkey => itemkey,
1133: aname => 'APPROVER_USER_NAME');
1134:
1135: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1131: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1132: itemkey => itemkey,
1133: aname => 'APPROVER_USER_NAME');
1134:
1135: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1136: itemkey => itemkey,
1137: aname => 'APPROVER_DISPLAY_NAME');
1138:
1139:

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

1136: itemkey => itemkey,
1137: aname => 'APPROVER_DISPLAY_NAME');
1138:
1139:
1140: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1141: itemkey => l_parent_item_key,
1142: aname => 'FORWARD_FROM_ID',
1143: avalue => l_child_approver_empid );
1144:

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

1141: itemkey => l_parent_item_key,
1142: aname => 'FORWARD_FROM_ID',
1143: avalue => l_child_approver_empid );
1144:
1145: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1146: itemkey => l_parent_item_key,
1147: aname => 'FORWARD_FROM_USER_NAME',
1148: avalue => l_child_approver_user_name);
1149:

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

1146: itemkey => l_parent_item_key,
1147: aname => 'FORWARD_FROM_USER_NAME',
1148: avalue => l_child_approver_user_name);
1149:
1150: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1151: itemkey => l_parent_item_key,
1152: aname => 'FORWARD_FROM_DISP_NAME',
1153: avalue => l_child_approver_display_name);
1154:

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

1151: itemkey => l_parent_item_key,
1152: aname => 'FORWARD_FROM_DISP_NAME',
1153: avalue => l_child_approver_display_name);
1154:
1155: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1156: itemkey => l_parent_item_key,
1157: aname => 'APPROVER_EMPID',
1158: avalue => l_child_approver_empid );
1159:

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

1156: itemkey => l_parent_item_key,
1157: aname => 'APPROVER_EMPID',
1158: avalue => l_child_approver_empid );
1159:
1160: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1161: itemkey => l_parent_item_key,
1162: aname => 'APPROVER_USER_NAME',
1163: avalue => l_child_approver_user_name );
1164:

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

1162: aname => 'APPROVER_USER_NAME',
1163: avalue => l_child_approver_user_name );
1164:
1165:
1166: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1167: itemkey => l_parent_item_key,
1168: aname => 'APPROVER_DISPLAY_NAME',
1169: avalue => l_child_approver_display_name );
1170:

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

1225: into l_parent_item_type, l_parent_item_key
1226: FROM wf_items
1227: WHERE item_type = itemtype and item_key = itemkey;
1228:
1229: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1230: itemkey => l_parent_item_key,
1231: aname => 'AME_SUB_APPROVAL_RESPONSE',
1232: avalue => 'REJECT');
1233:

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

1230: itemkey => l_parent_item_key,
1231: aname => 'AME_SUB_APPROVAL_RESPONSE',
1232: avalue => 'REJECT');
1233:
1234: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1235: itemkey => itemkey,
1236: aname => 'APPROVER_EMPID');
1237:
1238: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1234: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1235: itemkey => itemkey,
1236: aname => 'APPROVER_EMPID');
1237:
1238: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1239: itemkey => itemkey,
1240: aname => 'APPROVER_USER_NAME');
1241:
1242: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1238: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1239: itemkey => itemkey,
1240: aname => 'APPROVER_USER_NAME');
1241:
1242: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1243: itemkey => itemkey,
1244: aname => 'APPROVER_DISPLAY_NAME');
1245:
1246:

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

1243: itemkey => itemkey,
1244: aname => 'APPROVER_DISPLAY_NAME');
1245:
1246:
1247: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1248: itemkey => l_parent_item_key,
1249: aname => 'FORWARD_FROM_ID',
1250: avalue => l_child_approver_empid );
1251:

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

1249: aname => 'FORWARD_FROM_ID',
1250: avalue => l_child_approver_empid );
1251:
1252:
1253: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1254: itemkey => l_parent_item_key,
1255: aname => 'FORWARD_FROM_USER_NAME',
1256: avalue => l_child_approver_user_name);
1257:

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

1254: itemkey => l_parent_item_key,
1255: aname => 'FORWARD_FROM_USER_NAME',
1256: avalue => l_child_approver_user_name);
1257:
1258: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1259: itemkey => l_parent_item_key,
1260: aname => 'FORWARD_FROM_DISP_NAME',
1261: avalue => l_child_approver_display_name);
1262:

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

1261: avalue => l_child_approver_display_name);
1262:
1263:
1264:
1265: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1266: itemkey => l_parent_item_key,
1267: aname => 'APPROVER_EMPID',
1268: avalue => l_child_approver_empid );
1269:

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

1267: aname => 'APPROVER_EMPID',
1268: avalue => l_child_approver_empid );
1269:
1270:
1271: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1272: itemkey => l_parent_item_key,
1273: aname => 'APPROVER_USER_NAME',
1274: avalue => l_child_approver_user_name );
1275:

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

1273: aname => 'APPROVER_USER_NAME',
1274: avalue => l_child_approver_user_name );
1275:
1276:
1277: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1278: itemkey => l_parent_item_key,
1279: aname => 'APPROVER_DISPLAY_NAME',
1280: avalue => l_child_approver_display_name );
1281:

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

1340: into l_parent_item_type, l_parent_item_key
1341: FROM wf_items
1342: WHERE item_type = itemtype and item_key = itemkey;
1343:
1344: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1345: itemkey => l_parent_item_key,
1346: aname => 'AME_SUB_APPROVAL_RESPONSE',
1347: avalue => 'TIMEOUT');
1348:

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

1345: itemkey => l_parent_item_key,
1346: aname => 'AME_SUB_APPROVAL_RESPONSE',
1347: avalue => 'TIMEOUT');
1348:
1349: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1350: itemkey => itemkey,
1351: aname => 'APPROVER_EMPID');
1352:
1353: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1349: l_child_approver_empid := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1350: itemkey => itemkey,
1351: aname => 'APPROVER_EMPID');
1352:
1353: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1354: itemkey => itemkey,
1355: aname => 'APPROVER_USER_NAME');
1356:
1357: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1353: l_child_approver_user_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1354: itemkey => itemkey,
1355: aname => 'APPROVER_USER_NAME');
1356:
1357: l_child_approver_display_name := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1358: itemkey => itemkey,
1359: aname => 'APPROVER_DISPLAY_NAME');
1360:
1361:

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

1358: itemkey => itemkey,
1359: aname => 'APPROVER_DISPLAY_NAME');
1360:
1361:
1362: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1363: itemkey => l_parent_item_key,
1364: aname => 'FORWARD_FROM_ID',
1365: avalue => l_child_approver_empid );
1366:

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

1364: aname => 'FORWARD_FROM_ID',
1365: avalue => l_child_approver_empid );
1366:
1367:
1368: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1369: itemkey => l_parent_item_key,
1370: aname => 'FORWARD_FROM_USER_NAME',
1371: avalue => l_child_approver_user_name);
1372:

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

1369: itemkey => l_parent_item_key,
1370: aname => 'FORWARD_FROM_USER_NAME',
1371: avalue => l_child_approver_user_name);
1372:
1373: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1374: itemkey => l_parent_item_key,
1375: aname => 'FORWARD_FROM_DISP_NAME',
1376: avalue => l_child_approver_display_name);
1377:

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

1376: avalue => l_child_approver_display_name);
1377:
1378:
1379:
1380: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1381: itemkey => l_parent_item_key,
1382: aname => 'APPROVER_EMPID',
1383: avalue => l_child_approver_empid );
1384:

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

1382: aname => 'APPROVER_EMPID',
1383: avalue => l_child_approver_empid );
1384:
1385:
1386: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1387: itemkey => l_parent_item_key,
1388: aname => 'APPROVER_USER_NAME',
1389: avalue => l_child_approver_user_name );
1390:

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

1388: aname => 'APPROVER_USER_NAME',
1389: avalue => l_child_approver_user_name );
1390:
1391:
1392: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1393: itemkey => l_parent_item_key,
1394: aname => 'APPROVER_DISPLAY_NAME',
1395: avalue => l_child_approver_display_name );
1396:

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

1543:
1544: IF (funcmode='RUN') THEN
1545:
1546:
1547: l_next_approver_id := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
1548: itemkey=>itemkey,
1549: aname=>'APPROVER_EMPID');
1550:
1551:

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

1548: itemkey=>itemkey,
1549: aname=>'APPROVER_EMPID');
1550:
1551:
1552: l_req_header_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1553: itemkey => itemkey,
1554: aname => 'DOCUMENT_ID');
1555:
1556: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

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

1552: l_req_header_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1553: itemkey => itemkey,
1554: aname => 'DOCUMENT_ID');
1555:
1556: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1557: itemkey => itemkey,
1558: aname => 'APPROVAL_GROUP_ID');
1559:
1560: -- Set the multi-org context

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

1557: itemkey => itemkey,
1558: aname => 'APPROVAL_GROUP_ID');
1559:
1560: -- Set the multi-org context
1561: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1562: itemkey => itemkey,
1563: aname => 'ORG_ID');
1564:
1565: IF l_org_id is NOT NULL THEN

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

1574: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1575: END IF;
1576:
1577: /* Reset the FORWARD_TO_USERNAME_RESPONSE attribute */
1578: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
1579: itemkey => itemkey,
1580: aname => 'FORWARD_TO_USERNAME_RESPONSE',
1581: avalue => NULL);
1582:

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

1580: aname => 'FORWARD_TO_USERNAME_RESPONSE',
1581: avalue => NULL);
1582:
1583: /* Reset the NOTE attribute */
1584: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
1585: itemkey => itemkey,
1586: aname => 'NOTE',
1587: avalue => NULL);
1588:

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

1656: END IF;
1657:
1658: IF (funcmode='RUN') THEN
1659:
1660: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
1661: itemkey=>itemkey,
1662: aname=>'APPROVER_EMPID');
1663:
1664: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

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

1660: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
1661: itemkey=>itemkey,
1662: aname=>'APPROVER_EMPID');
1663:
1664: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1665: itemkey => itemkey,
1666: aname => 'DOCUMENT_ID');
1667:
1668: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

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

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

1668: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1669: itemkey => itemkey,
1670: aname => 'DOCUMENT_TYPE');
1671:
1672: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1673: itemkey => itemkey,
1674: aname => 'DOCUMENT_SUBTYPE');
1675:
1676: l_note := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1672: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1673: itemkey => itemkey,
1674: aname => 'DOCUMENT_SUBTYPE');
1675:
1676: l_note := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1677: itemkey => itemkey,
1678: aname => 'NOTE');
1679:
1680: -- Set the multi-org context

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

1677: itemkey => itemkey,
1678: aname => 'NOTE');
1679:
1680: -- Set the multi-org context
1681: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1682: itemkey => itemkey,
1683: aname => 'ORG_ID');
1684:
1685: IF l_org_id is NOT NULL THEN

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

1694:
1695: UpdateActionHistory(l_document_id, l_action,
1696: l_note, l_current_approver);
1697:
1698: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
1699: itemkey => itemkey,
1700: aname => 'APPROVER_RESPONSE',
1701: avalue => 'APPROVED' );
1702:

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

1772: END IF;
1773:
1774: IF (funcmode='RUN') THEN
1775:
1776: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
1777: itemkey=>itemkey,
1778: aname=>'APPROVER_EMPID');
1779:
1780: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

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

1776: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
1777: itemkey=>itemkey,
1778: aname=>'APPROVER_EMPID');
1779:
1780: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1781: itemkey => itemkey,
1782: aname => 'DOCUMENT_ID');
1783:
1784: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1780: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1781: itemkey => itemkey,
1782: aname => 'DOCUMENT_ID');
1783:
1784: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1785: itemkey => itemkey,
1786: aname => 'DOCUMENT_TYPE');
1787:
1788: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1784: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1785: itemkey => itemkey,
1786: aname => 'DOCUMENT_TYPE');
1787:
1788: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1789: itemkey => itemkey,
1790: aname => 'DOCUMENT_SUBTYPE');
1791:
1792: l_note := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1788: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1789: itemkey => itemkey,
1790: aname => 'DOCUMENT_SUBTYPE');
1791:
1792: l_note := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1793: itemkey => itemkey,
1794: aname => 'NOTE');
1795:
1796: -- Set the multi-org context

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

1793: itemkey => itemkey,
1794: aname => 'NOTE');
1795:
1796: -- Set the multi-org context
1797: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1798: itemkey => itemkey,
1799: aname => 'ORG_ID');
1800:
1801: IF l_org_id is NOT NULL THEN

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

1810:
1811: UpdateActionHistory(l_document_id, l_action,
1812: l_note, l_current_approver);
1813:
1814: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
1815: itemkey => itemkey,
1816: aname => 'APPROVER_RESPONSE',
1817: avalue => 'REJECTED' );
1818:

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

1887: END IF;
1888:
1889: IF (funcmode='RUN') THEN
1890:
1891: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
1892: itemkey=>itemkey,
1893: aname=>'APPROVER_EMPID');
1894:
1895: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

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

1891: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
1892: itemkey=>itemkey,
1893: aname=>'APPROVER_EMPID');
1894:
1895: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1896: itemkey => itemkey,
1897: aname => 'DOCUMENT_ID');
1898:
1899: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1895: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1896: itemkey => itemkey,
1897: aname => 'DOCUMENT_ID');
1898:
1899: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1900: itemkey => itemkey,
1901: aname => 'DOCUMENT_TYPE');
1902:
1903: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1899: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1900: itemkey => itemkey,
1901: aname => 'DOCUMENT_TYPE');
1902:
1903: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1904: itemkey => itemkey,
1905: aname => 'DOCUMENT_SUBTYPE');
1906:
1907: l_note := fnd_message.get_string('ICX', 'ICX_POR_NOTIF_TIMEOUT');

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

1906:
1907: l_note := fnd_message.get_string('ICX', 'ICX_POR_NOTIF_TIMEOUT');
1908:
1909: -- Set the multi-org context
1910: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1911: itemkey => itemkey,
1912: aname => 'ORG_ID');
1913:
1914: IF l_org_id is NOT NULL THEN

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

1988: return;
1989: end if;
1990:
1991:
1992: l_doc_header_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1993: itemkey => itemkey,
1994: aname => 'DOCUMENT_ID');
1995:
1996: l_doc_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1992: l_doc_header_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1993: itemkey => itemkey,
1994: aname => 'DOCUMENT_ID');
1995:
1996: l_doc_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1997: itemkey => itemkey,
1998: aname => 'DOCUMENT_TYPE');
1999:
2000: BEGIN

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

1998: aname => 'DOCUMENT_TYPE');
1999:
2000: BEGIN
2001:
2002: l_response_action := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
2003: itemkey => itemkey,
2004: aname => 'AME_SUB_APPROVAL_RESPONSE');
2005: IF( l_response_action = 'APPROVE' ) THEN
2006: l_note := fnd_message.get_string('ICX', 'ICX_POR_REQ_ALREADY_APPROVED');

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

2143: l_doc_string VARCHAR2(200);
2144: Begin
2145: IF (funcmode = 'RUN') THEN
2146: l_progress := 'IS_AME_EXCEPTION: 001';
2147: l_ame_exception :=PO_WF_UTIL_PKG.GetItemAttrText (itemtype => itemtype,
2148: itemkey => itemkey,
2149: aname => 'AME_EXCEPTION');
2150:
2151: if l_ame_exception IS NOT NULL then