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_RCO_WF_PVT dependencies on PO_WF_UTIL_PKG

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

71: IF (g_po_wf_debug = 'Y') THEN
72: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
73: END IF;
74:
75: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
76: itemkey => itemkey,
77: aname => 'DOCUMENT_ID');
78:
79: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

75: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
76: itemkey => itemkey,
77: aname => 'DOCUMENT_ID');
78:
79: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
80: itemkey => itemkey,
81: aname => 'DOCUMENT_TYPE');
82:
83: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

79: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
80: itemkey => itemkey,
81: aname => 'DOCUMENT_TYPE');
82:
83: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
84: itemkey => itemkey,
85: aname => 'DOCUMENT_SUBTYPE');
86:
87: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

83: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
84: itemkey => itemkey,
85: aname => 'DOCUMENT_SUBTYPE');
86:
87: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
88: itemkey => itemkey,
89: aname => 'AME_TRANSACTION_TYPE');
90:
91: l_progress := 'Get_Next_Approver: 002-'||to_char(l_document_id)||'-'|| l_document_type||'-'||l_document_subtype;

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

260: IF (g_po_wf_debug = 'Y') THEN
261: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
262: END IF;
263:
264: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
265: itemkey => itemkey,
266: aname => 'DOCUMENT_ID');
267:
268: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

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

264: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
265: itemkey => itemkey,
266: aname => 'DOCUMENT_ID');
267:
268: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
269: itemkey => itemkey,
270: aname => 'ORG_ID');
271:
272: l_change_request_group_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

Line 272: l_change_request_group_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

268: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
269: itemkey => itemkey,
270: aname => 'ORG_ID');
271:
272: l_change_request_group_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
273: itemkey => itemkey,
274: aname => 'CHANGE_REQUEST_GROUP_ID');
275:
276: l_start_block_activity := 'N';

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

303:
304: t_varname(1) := 'DOCUMENT_TYPE';
305: t_varval(1) := 'REQUISITION';
306: t_varname(2) := 'DOCUMENT_TYPE_DISP';
307: t_varval(2) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
308: itemkey => itemkey,
309: aname => 'DOCUMENT_TYPE_DISP');
310:
311: t_varname(3) := 'PREPARER_USER_NAME';

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

308: itemkey => itemkey,
309: aname => 'DOCUMENT_TYPE_DISP');
310:
311: t_varname(3) := 'PREPARER_USER_NAME';
312: t_varval(3) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
313: itemkey => itemkey,
314: aname => 'PREPARER_USER_NAME');
315:
316: t_varname(4) := 'PREPARER_DISPLAY_NAME';

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

313: itemkey => itemkey,
314: aname => 'PREPARER_USER_NAME');
315:
316: t_varname(4) := 'PREPARER_DISPLAY_NAME';
317: t_varval(4) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
318: itemkey => itemkey,
319: aname => 'PREPARER_DISPLAY_NAME');
320:
321: t_varname(5) := 'FUNCTIONAL_CURRENCY';

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

318: itemkey => itemkey,
319: aname => 'PREPARER_DISPLAY_NAME');
320:
321: t_varname(5) := 'FUNCTIONAL_CURRENCY';
322: t_varval(5) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
323: itemkey => itemkey,
324: aname => 'FUNCTIONAL_CURRENCY');
325:
326: t_varname(6) := 'IS_AME_APPROVAL';

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

326: t_varname(6) := 'IS_AME_APPROVAL';
327: t_varval(6) := 'Y';
328:
329: t_varname(7) := 'TOTAL_AMOUNT_DSP';
330: t_varval(7) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
331: itemkey => itemkey,
332: aname => 'TOTAL_AMOUNT_DSP');
333:
334: t_varname(8) := 'FORWARD_FROM_DISP_NAME';

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

331: itemkey => itemkey,
332: aname => 'TOTAL_AMOUNT_DSP');
333:
334: t_varname(8) := 'FORWARD_FROM_DISP_NAME';
335: t_varval(8) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
336: itemkey => itemkey,
337: aname => 'FORWARD_FROM_DISP_NAME');
338:
339: t_varname(9) := 'FORWARD_FROM_USER_NAME';

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

336: itemkey => itemkey,
337: aname => 'FORWARD_FROM_DISP_NAME');
338:
339: t_varname(9) := 'FORWARD_FROM_USER_NAME';
340: t_varval(9) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
341: itemkey => itemkey,
342: aname => 'FORWARD_FROM_USER_NAME');
343:
344: t_varname(10) := 'REQ_DESCRIPTION';

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

341: itemkey => itemkey,
342: aname => 'FORWARD_FROM_USER_NAME');
343:
344: t_varname(10) := 'REQ_DESCRIPTION';
345: t_varval(10) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
346: itemkey => itemkey,
347: aname => 'REQ_DESCRIPTION');
348:
349: t_varname(11) := 'REQ_AMOUNT_CURRENCY_DSP';

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

346: itemkey => itemkey,
347: aname => 'REQ_DESCRIPTION');
348:
349: t_varname(11) := 'REQ_AMOUNT_CURRENCY_DSP';
350: t_varval(11) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
351: itemkey => itemkey,
352: aname => 'REQ_AMOUNT_CURRENCY_DSP');
353:
354: t_varname(12) := 'TAX_AMOUNT_CURRENCY_DSP';

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

351: itemkey => itemkey,
352: aname => 'REQ_AMOUNT_CURRENCY_DSP');
353:
354: t_varname(12) := 'TAX_AMOUNT_CURRENCY_DSP';
355: t_varval(12) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
356: itemkey => itemkey,
357: aname => 'TAX_AMOUNT_CURRENCY_DSP');
358:
359: t_varname(13) := 'JUSTIFICATION';

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

356: itemkey => itemkey,
357: aname => 'TAX_AMOUNT_CURRENCY_DSP');
358:
359: t_varname(13) := 'JUSTIFICATION';
360: t_varval(13) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
361: itemkey => itemkey,
362: aname => 'JUSTIFICATION');
363:
364: t_varname(14) := 'CONTRACTOR_REQUISITION_FLAG';

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

361: itemkey => itemkey,
362: aname => 'JUSTIFICATION');
363:
364: t_varname(14) := 'CONTRACTOR_REQUISITION_FLAG';
365: t_varval(14) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
366: itemkey => itemkey,
367: aname => 'CONTRACTOR_REQUISITION_FLAG');
368:
369: t_varname(15) := 'CONTRACTOR_REQUISITION_FLAG';

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

366: itemkey => itemkey,
367: aname => 'CONTRACTOR_REQUISITION_FLAG');
368:
369: t_varname(15) := 'CONTRACTOR_REQUISITION_FLAG';
370: t_varval(15) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
371: itemkey => itemkey,
372: aname => 'CONTRACTOR_REQUISITION_FLAG');
373:
374: t_varname(16) := 'CONTRACTOR_STATUS';

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

371: itemkey => itemkey,
372: aname => 'CONTRACTOR_REQUISITION_FLAG');
373:
374: t_varname(16) := 'CONTRACTOR_STATUS';
375: t_varval(16) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
376: itemkey => itemkey,
377: aname => 'CONTRACTOR_STATUS');
378:
379: t_varname(17) := 'DOCUMENT_NUMBER';

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

376: itemkey => itemkey,
377: aname => 'CONTRACTOR_STATUS');
378:
379: t_varname(17) := 'DOCUMENT_NUMBER';
380: t_varval(17) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
381: itemkey => itemkey,
382: aname => 'DOCUMENT_NUMBER');
383:
384: t_varname(18) := 'AME_TRANSACTION_TYPE';

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

381: itemkey => itemkey,
382: aname => 'DOCUMENT_NUMBER');
383:
384: t_varname(18) := 'AME_TRANSACTION_TYPE';
385: t_varval(18) := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
386: itemkey => itemkey,
387: aname => 'AME_TRANSACTION_TYPE');
388:
389: l_progress := 'Launch_Parallel_Approval: 003 -- Record Type :' || g_next_approvers(l_approver_index).orig_system;

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

582: IF (g_po_wf_debug = 'Y') THEN
583: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_progress);
584: END IF;
585:
586: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
587: itemkey => itemkey,
588: aname => 'DOCUMENT_ID');
589:
590: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

586: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
587: itemkey => itemkey,
588: aname => 'DOCUMENT_ID');
589:
590: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
591: itemkey => itemkey,
592: aname => 'AME_TRANSACTION_TYPE');
593:
594: l_approver_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

590: l_transaction_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
591: itemkey => itemkey,
592: aname => 'AME_TRANSACTION_TYPE');
593:
594: l_approver_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
595: itemkey => itemkey,
596: aname => 'AME_APPROVER_TYPE');
597:
598: l_progress := 'Process_Response_Internal: 002 -- l_approver_type :' || l_approver_type ;

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

605: elsif (l_approver_type = 'FND') then
606: l_current_approver.orig_system := 'FND';
607: else
608: l_current_approver.orig_system := 'PER';
609: l_current_approver.name := po_wf_util_pkg.GetItemAttrText( itemtype => itemType,
610: itemkey => itemkey,
611: aname => 'APPROVER_USER_NAME');
612: end if;
613:

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

610: itemkey => itemkey,
611: aname => 'APPROVER_USER_NAME');
612: end if;
613:
614: l_current_approver.orig_system_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
615: itemkey => itemkey,
616: aname => 'AME_APPROVER_ID');
617:
618: l_progress := 'Process_Response_Internal: 003 -- l_current_approver.orig_system_id :' || l_current_approver.orig_system_id ;

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

706: WHERE item_type = itemtype and item_key = itemkey;
707:
708: Process_Response_Internal(itemtype, itemkey, 'APPROVE');
709:
710: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
711: itemkey => itemkey,
712: aname => 'RCO_AME_SUB_APPROVAL_RESPONSE',
713: avalue => 'APPROVE');
714:

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

765: into l_parent_item_type, l_parent_item_key
766: FROM wf_items
767: WHERE item_type = itemtype and item_key = itemkey;
768:
769: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
770: itemkey => l_parent_item_key,
771: aname => 'RCO_AME_SUB_APPROVAL_RESPONSE',
772: avalue => 'REJECT');
773:

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

825: into l_parent_item_type, l_parent_item_key
826: FROM wf_items
827: WHERE item_type = itemtype and item_key = itemkey;
828:
829: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
830: itemkey => l_parent_item_key,
831: aname => 'AME_SUB_APPROVAL_RESPONSE',
832: avalue => 'REJECT');
833:

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

979:
980: IF (funcmode='RUN') THEN
981:
982:
983: l_next_approver_id := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
984: itemkey=>itemkey,
985: aname=>'APPROVER_EMPID');
986:
987:

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

984: itemkey=>itemkey,
985: aname=>'APPROVER_EMPID');
986:
987:
988: l_req_header_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
989: itemkey => itemkey,
990: aname => 'DOCUMENT_ID');
991:
992: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

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

988: l_req_header_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
989: itemkey => itemkey,
990: aname => 'DOCUMENT_ID');
991:
992: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
993: itemkey => itemkey,
994: aname => 'APPROVAL_GROUP_ID');
995:
996: -- Set the multi-org context

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

993: itemkey => itemkey,
994: aname => 'APPROVAL_GROUP_ID');
995:
996: -- Set the multi-org context
997: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
998: itemkey => itemkey,
999: aname => 'ORG_ID');
1000:
1001: IF l_org_id is NOT NULL THEN

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

1010: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey,l_progress);
1011: END IF;
1012:
1013: /* Reset the FORWARD_TO_USERNAME_RESPONSE attribute */
1014: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
1015: itemkey => itemkey,
1016: aname => 'FORWARD_TO_USERNAME_RESPONSE',
1017: avalue => NULL);
1018:

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

1016: aname => 'FORWARD_TO_USERNAME_RESPONSE',
1017: avalue => NULL);
1018:
1019: /* Reset the NOTE attribute */
1020: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
1021: itemkey => itemkey,
1022: aname => 'NOTE',
1023: avalue => NULL);
1024:

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

1092: END IF;
1093:
1094: IF (funcmode='RUN') THEN
1095:
1096: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
1097: itemkey=>itemkey,
1098: aname=>'APPROVER_EMPID');
1099:
1100: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

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

1096: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
1097: itemkey=>itemkey,
1098: aname=>'APPROVER_EMPID');
1099:
1100: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1101: itemkey => itemkey,
1102: aname => 'DOCUMENT_ID');
1103:
1104: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1100: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1101: itemkey => itemkey,
1102: aname => 'DOCUMENT_ID');
1103:
1104: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1105: itemkey => itemkey,
1106: aname => 'DOCUMENT_TYPE');
1107:
1108: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1104: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1105: itemkey => itemkey,
1106: aname => 'DOCUMENT_TYPE');
1107:
1108: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1109: itemkey => itemkey,
1110: aname => 'DOCUMENT_SUBTYPE');
1111:
1112: l_note := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1108: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1109: itemkey => itemkey,
1110: aname => 'DOCUMENT_SUBTYPE');
1111:
1112: l_note := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1113: itemkey => itemkey,
1114: aname => 'NOTE');
1115:
1116: -- Set the multi-org context

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

1113: itemkey => itemkey,
1114: aname => 'NOTE');
1115:
1116: -- Set the multi-org context
1117: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1118: itemkey => itemkey,
1119: aname => 'ORG_ID');
1120:
1121: IF l_org_id is NOT NULL THEN

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

1132: l_note, l_current_approver);
1133:
1134: /*This attribute is set to be used in POR_AME_REQ_WF_PVT.Process_Beat_By_First.
1135: Based on this value the flow is determined whether approval or rejection*/
1136: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
1137: itemkey => itemkey,
1138: aname => 'APPROVER_RESPONSE',
1139: avalue => 'APPROVED' );
1140:

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

1211: END IF;
1212:
1213: IF (funcmode='RUN') THEN
1214:
1215: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
1216: itemkey=>itemkey,
1217: aname=>'APPROVER_EMPID');
1218:
1219: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

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

1215: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
1216: itemkey=>itemkey,
1217: aname=>'APPROVER_EMPID');
1218:
1219: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1220: itemkey => itemkey,
1221: aname => 'DOCUMENT_ID');
1222:
1223: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1219: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1220: itemkey => itemkey,
1221: aname => 'DOCUMENT_ID');
1222:
1223: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1224: itemkey => itemkey,
1225: aname => 'DOCUMENT_TYPE');
1226:
1227: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1223: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1224: itemkey => itemkey,
1225: aname => 'DOCUMENT_TYPE');
1226:
1227: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1228: itemkey => itemkey,
1229: aname => 'DOCUMENT_SUBTYPE');
1230:
1231: l_note := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1227: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1228: itemkey => itemkey,
1229: aname => 'DOCUMENT_SUBTYPE');
1230:
1231: l_note := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1232: itemkey => itemkey,
1233: aname => 'NOTE');
1234:
1235: -- Set the multi-org context

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

1232: itemkey => itemkey,
1233: aname => 'NOTE');
1234:
1235: -- Set the multi-org context
1236: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1237: itemkey => itemkey,
1238: aname => 'ORG_ID');
1239:
1240: IF l_org_id is NOT NULL THEN

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

1251: l_note, l_current_approver);
1252:
1253: /*This attribute is set to be used in POR_AME_REQ_WF_PVT.Process_Beat_By_First.
1254: Based on this value the flow is determined whether approval or rejection*/
1255: po_wf_util_pkg.SetItemAttrText( itemtype => itemtype,
1256: itemkey => itemkey,
1257: aname => 'APPROVER_RESPONSE',
1258: avalue => 'REJECTED' );
1259:

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

1329: END IF;
1330:
1331: IF (funcmode='RUN') THEN
1332:
1333: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
1334: itemkey=>itemkey,
1335: aname=>'APPROVER_EMPID');
1336:
1337: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

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

1333: l_current_approver := po_wf_util_pkg.GetItemAttrNumber( itemtype=>itemtype,
1334: itemkey=>itemkey,
1335: aname=>'APPROVER_EMPID');
1336:
1337: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1338: itemkey => itemkey,
1339: aname => 'DOCUMENT_ID');
1340:
1341: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1337: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1338: itemkey => itemkey,
1339: aname => 'DOCUMENT_ID');
1340:
1341: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1342: itemkey => itemkey,
1343: aname => 'DOCUMENT_TYPE');
1344:
1345: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1341: l_document_type := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1342: itemkey => itemkey,
1343: aname => 'DOCUMENT_TYPE');
1344:
1345: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1346: itemkey => itemkey,
1347: aname => 'DOCUMENT_SUBTYPE');
1348:
1349: l_note := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,

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

1345: l_document_subtype := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1346: itemkey => itemkey,
1347: aname => 'DOCUMENT_SUBTYPE');
1348:
1349: l_note := po_wf_util_pkg.GetItemAttrText( itemtype => itemtype,
1350: itemkey => itemkey,
1351: aname => 'NOTE');
1352:
1353: -- Set the multi-org context

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

1350: itemkey => itemkey,
1351: aname => 'NOTE');
1352:
1353: -- Set the multi-org context
1354: l_org_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,
1355: itemkey => itemkey,
1356: aname => 'ORG_ID');
1357:
1358: IF l_org_id is NOT NULL THEN