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 587: l_document_id := po_wf_util_pkg.GetItemAttrNumber( itemtype => itemtype,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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