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.OE_APPROVALS_WF dependencies on AME_UTIL

Line 1325: l_admin_approver ame_util.approverrecord;

1321: l_expiration_date DATE;
1322: l_aname wf_engine.nametabtyp;
1323: l_avaluetext wf_engine.texttabtyp;
1324: ----++++++++++++++++++++++++++++++++++++++++++++
1325: l_admin_approver ame_util.approverrecord;
1326: l_ret_approver VARCHAR2 (50);
1327: l_name wf_users.NAME%TYPE; --bug 8620671
1328: l_display_name VARCHAR2 (150);
1329: l_debug_info VARCHAR2 (50);

Line 1340: l_next_approvers ame_util.approverstable2;

1336: l_count NUMBER (9);
1337: l_hist_rec ap_inv_aprvl_hist%ROWTYPE;
1338: l_notf_iteration NUMBER;
1339: l_complete VARCHAR2 (1);
1340: l_next_approvers ame_util.approverstable2;
1341: l_next_approver ame_util.approverrecord2;
1342: l_index ame_util.idlist;
1343: l_ids ame_util.stringlist;
1344: l_class ame_util.stringlist;

Line 1341: l_next_approver ame_util.approverrecord2;

1337: l_hist_rec ap_inv_aprvl_hist%ROWTYPE;
1338: l_notf_iteration NUMBER;
1339: l_complete VARCHAR2 (1);
1340: l_next_approvers ame_util.approverstable2;
1341: l_next_approver ame_util.approverrecord2;
1342: l_index ame_util.idlist;
1343: l_ids ame_util.stringlist;
1344: l_class ame_util.stringlist;
1345: l_source ame_util.longstringlist;

Line 1342: l_index ame_util.idlist;

1338: l_notf_iteration NUMBER;
1339: l_complete VARCHAR2 (1);
1340: l_next_approvers ame_util.approverstable2;
1341: l_next_approver ame_util.approverrecord2;
1342: l_index ame_util.idlist;
1343: l_ids ame_util.stringlist;
1344: l_class ame_util.stringlist;
1345: l_source ame_util.longstringlist;
1346: l_ampersand VARCHAR2 (1);

Line 1343: l_ids ame_util.stringlist;

1339: l_complete VARCHAR2 (1);
1340: l_next_approvers ame_util.approverstable2;
1341: l_next_approver ame_util.approverrecord2;
1342: l_index ame_util.idlist;
1343: l_ids ame_util.stringlist;
1344: l_class ame_util.stringlist;
1345: l_source ame_util.longstringlist;
1346: l_ampersand VARCHAR2 (1);
1347: l_next_approver_s ame_util.approverrecord;

Line 1344: l_class ame_util.stringlist;

1340: l_next_approvers ame_util.approverstable2;
1341: l_next_approver ame_util.approverrecord2;
1342: l_index ame_util.idlist;
1343: l_ids ame_util.stringlist;
1344: l_class ame_util.stringlist;
1345: l_source ame_util.longstringlist;
1346: l_ampersand VARCHAR2 (1);
1347: l_next_approver_s ame_util.approverrecord;
1348: --itemkey VARCHAR2(100):='';

Line 1345: l_source ame_util.longstringlist;

1341: l_next_approver ame_util.approverrecord2;
1342: l_index ame_util.idlist;
1343: l_ids ame_util.stringlist;
1344: l_class ame_util.stringlist;
1345: l_source ame_util.longstringlist;
1346: l_ampersand VARCHAR2 (1);
1347: l_next_approver_s ame_util.approverrecord;
1348: --itemkey VARCHAR2(100):='';
1349: l_application_id NUMBER := 660;

Line 1347: l_next_approver_s ame_util.approverrecord;

1343: l_ids ame_util.stringlist;
1344: l_class ame_util.stringlist;
1345: l_source ame_util.longstringlist;
1346: l_ampersand VARCHAR2 (1);
1347: l_next_approver_s ame_util.approverrecord;
1348: --itemkey VARCHAR2(100):='';
1349: l_application_id NUMBER := 660;
1350: --l_transaction_id VARCHAR2(100); --'232349';
1351: l_transaction_type_id VARCHAR2 (100); --'OENH';

Line 1380: approverlist ame_util.approverstable2;

1376: i NUMBER := 0;
1377: -- for attribute text
1378: j NUMBER := 0;
1379: l_process_out VARCHAR2 (10);
1380: approverlist ame_util.approverstable2;
1381: -- for attribute number
1382: BEGIN
1383: SAVEPOINT get_ame_approvers_launch; --establishing save point here.
1384:

Line 1537: flagapproversasnotifiedin => ame_util.booleantrue,

1533: transactiontypein => l_ame_transaction,
1534: --itemtype,
1535: transactionidin => TO_NUMBER
1536: (itemkey),
1537: flagapproversasnotifiedin => ame_util.booleantrue,
1538: --ame_util.booleanFalse --16084377 change
1539: approvalprocesscompleteynout => l_complete,
1540: nextapproversout => l_next_approvers,
1541: itemindexesout => l_index,

Line 1538: --ame_util.booleanFalse --16084377 change

1534: --itemtype,
1535: transactionidin => TO_NUMBER
1536: (itemkey),
1537: flagapproversasnotifiedin => ame_util.booleantrue,
1538: --ame_util.booleanFalse --16084377 change
1539: approvalprocesscompleteynout => l_complete,
1540: nextapproversout => l_next_approvers,
1541: itemindexesout => l_index,
1542: itemidsout => l_ids,

Line 1580: IF l_complete = ame_util2.completefullyapproved

1576: END IF;
1577: end if;
1578:
1579: -----------
1580: IF l_complete = ame_util2.completefullyapproved
1581: THEN
1582: IF l_debug_level > 0
1583: THEN
1584: oe_debug_pub.ADD ('Fully Approved');

Line 1586: ELSIF l_complete = ame_util2.completefullyrejected

1582: IF l_debug_level > 0
1583: THEN
1584: oe_debug_pub.ADD ('Fully Approved');
1585: END IF;
1586: ELSIF l_complete = ame_util2.completefullyrejected
1587: THEN
1588: IF l_debug_level > 0
1589: THEN
1590: oe_debug_pub.ADD ('Fully Rejected');

Line 1592: ELSIF l_complete = ame_util2.completepartiallyapproved

1588: IF l_debug_level > 0
1589: THEN
1590: oe_debug_pub.ADD ('Fully Rejected');
1591: END IF;
1592: ELSIF l_complete = ame_util2.completepartiallyapproved
1593: THEN
1594: IF l_debug_level > 0
1595: THEN
1596: oe_debug_pub.ADD ('Partially Approved');

Line 1598: ELSIF l_complete = ame_util2.completenoapprovers

1594: IF l_debug_level > 0
1595: THEN
1596: oe_debug_pub.ADD ('Partially Approved');
1597: END IF;
1598: ELSIF l_complete = ame_util2.completenoapprovers
1599: THEN
1600: IF l_debug_level > 0
1601: THEN
1602: oe_debug_pub.ADD ('No Approvers');

Line 1604: ELSIF l_complete = ame_util2.notcompleted

1600: IF l_debug_level > 0
1601: THEN
1602: oe_debug_pub.ADD ('No Approvers');
1603: END IF;
1604: ELSIF l_complete = ame_util2.notcompleted
1605: THEN
1606: IF l_debug_level > 0
1607: THEN
1608: oe_debug_pub.ADD ('Not Completed');

Line 1613: IF l_complete = ame_util.booleanfalse

1609: END IF;
1610: END IF;
1611:
1612: -- Loop through approvers' table returned by AME
1613: IF l_complete = ame_util.booleanfalse
1614: THEN
1615: IF l_debug_level > 0
1616: THEN
1617: oe_debug_pub.ADD ( 'l_next_approvers.count= '

Line 2003: ELSIF l_complete = ame_util.booleantrue

1999: resultout := 'COMPLETE:VALID_APPROVER';
2000: oe_standard_wf.clear_msg_context;
2001: RETURN;
2002: END IF; --approvers count
2003: ELSIF l_complete = ame_util.booleantrue
2004: THEN
2005: resultout := 'COMPLETE:NO_NEXT_APPROVER';
2006: END IF;
2007: END IF; -- End for 'RUN' mode

Line 2300: l_admin_approver ame_util.approverrecord;

2296: l_expiration_date DATE;
2297: l_aname wf_engine.nametabtyp;
2298: l_avaluetext wf_engine.texttabtyp;
2299: ----++++++++++++++++++++++++++++++++++++++++++++
2300: l_admin_approver ame_util.approverrecord;
2301: l_ret_approver VARCHAR2 (50);
2302: l_name wf_users.NAME%TYPE; --bug 8620671
2303: l_display_name VARCHAR2 (150);
2304: l_debug_info VARCHAR2 (50);

Line 2315: l_next_approvers ame_util.approverstable2;

2311: l_count NUMBER (9);
2312: l_hist_rec ap_inv_aprvl_hist%ROWTYPE;
2313: l_notf_iteration NUMBER;
2314: l_complete VARCHAR2 (1);
2315: l_next_approvers ame_util.approverstable2;
2316: l_next_approver ame_util.approverrecord2;
2317: l_index ame_util.idlist;
2318: l_ids ame_util.stringlist;
2319: l_class ame_util.stringlist;

Line 2316: l_next_approver ame_util.approverrecord2;

2312: l_hist_rec ap_inv_aprvl_hist%ROWTYPE;
2313: l_notf_iteration NUMBER;
2314: l_complete VARCHAR2 (1);
2315: l_next_approvers ame_util.approverstable2;
2316: l_next_approver ame_util.approverrecord2;
2317: l_index ame_util.idlist;
2318: l_ids ame_util.stringlist;
2319: l_class ame_util.stringlist;
2320: l_source ame_util.longstringlist;

Line 2317: l_index ame_util.idlist;

2313: l_notf_iteration NUMBER;
2314: l_complete VARCHAR2 (1);
2315: l_next_approvers ame_util.approverstable2;
2316: l_next_approver ame_util.approverrecord2;
2317: l_index ame_util.idlist;
2318: l_ids ame_util.stringlist;
2319: l_class ame_util.stringlist;
2320: l_source ame_util.longstringlist;
2321: l_ampersand VARCHAR2 (1);

Line 2318: l_ids ame_util.stringlist;

2314: l_complete VARCHAR2 (1);
2315: l_next_approvers ame_util.approverstable2;
2316: l_next_approver ame_util.approverrecord2;
2317: l_index ame_util.idlist;
2318: l_ids ame_util.stringlist;
2319: l_class ame_util.stringlist;
2320: l_source ame_util.longstringlist;
2321: l_ampersand VARCHAR2 (1);
2322: l_next_approver_s ame_util.approverrecord;

Line 2319: l_class ame_util.stringlist;

2315: l_next_approvers ame_util.approverstable2;
2316: l_next_approver ame_util.approverrecord2;
2317: l_index ame_util.idlist;
2318: l_ids ame_util.stringlist;
2319: l_class ame_util.stringlist;
2320: l_source ame_util.longstringlist;
2321: l_ampersand VARCHAR2 (1);
2322: l_next_approver_s ame_util.approverrecord;
2323: --itemkey VARCHAR2(100):='';

Line 2320: l_source ame_util.longstringlist;

2316: l_next_approver ame_util.approverrecord2;
2317: l_index ame_util.idlist;
2318: l_ids ame_util.stringlist;
2319: l_class ame_util.stringlist;
2320: l_source ame_util.longstringlist;
2321: l_ampersand VARCHAR2 (1);
2322: l_next_approver_s ame_util.approverrecord;
2323: --itemkey VARCHAR2(100):='';
2324: l_application_id NUMBER := 660;

Line 2322: l_next_approver_s ame_util.approverrecord;

2318: l_ids ame_util.stringlist;
2319: l_class ame_util.stringlist;
2320: l_source ame_util.longstringlist;
2321: l_ampersand VARCHAR2 (1);
2322: l_next_approver_s ame_util.approverrecord;
2323: --itemkey VARCHAR2(100):='';
2324: l_application_id NUMBER := 660;
2325: --l_transaction_id VARCHAR2(100); --'232349';
2326: l_transaction_type_id VARCHAR2 (100); --'OENH';

Line 2334: l_approver ame_util.approverrecord2;

2330: l_person_id NUMBER;
2331: l_s_count NUMBER := 0;
2332: l_step VARCHAR2 (200);
2333: xx_ame EXCEPTION;
2334: l_approver ame_util.approverrecord2;
2335: l_parent_itemkey VARCHAR2 (100);
2336: l_parent_itemtype VARCHAR2 (20);
2337: l_ame_transaction_type VARCHAR2 (250);
2338: BEGIN

Line 2470: approvalstatusin => ame_util.approvedstatus,

2466: transactiontypein => l_ame_transaction_type,
2467: --itemtype,
2468: transactionidin => TO_NUMBER
2469: (l_parent_itemkey),
2470: approvalstatusin => ame_util.approvedstatus,
2471: approvernamein => l_name,
2472: itemclassin => 'header',
2473: itemidin => TO_NUMBER
2474: (l_parent_itemkey)

Line 2490: approvalstatusin => ame_util.approvedstatus,

2486: transactiontypein => l_ame_transaction_type,
2487: --itemtype,
2488: transactionidin => TO_NUMBER
2489: (l_parent_itemkey),
2490: approvalstatusin => ame_util.approvedstatus,
2491: approvernamein => l_name,
2492: itemclassin => 'header',
2493: itemidin => TO_NUMBER
2494: (l_parent_itemkey)

Line 2510: approvalstatusin => ame_util.approvedstatus,

2506: transactiontypein => l_ame_transaction_type,
2507: --itemtype,
2508: transactionidin => TO_NUMBER
2509: (l_parent_itemkey),
2510: approvalstatusin => ame_util.approvedstatus,
2511: approvernamein => l_name,
2512: itemclassin => 'header',
2513: itemidin => TO_NUMBER
2514: (l_parent_itemkey)

Line 2626: l_admin_approver ame_util.approverrecord;

2622: l_expiration_date DATE;
2623: l_aname wf_engine.nametabtyp;
2624: l_avaluetext wf_engine.texttabtyp;
2625: ----++++++++++++++++++++++++++++++++++++++++++++
2626: l_admin_approver ame_util.approverrecord;
2627: l_ret_approver VARCHAR2 (50);
2628: l_name wf_users.NAME%TYPE; --bug 8620671
2629: l_display_name VARCHAR2 (150);
2630: l_debug_info VARCHAR2 (50);

Line 2641: l_next_approvers ame_util.approverstable2;

2637: l_count NUMBER (9);
2638: l_hist_rec ap_inv_aprvl_hist%ROWTYPE;
2639: l_notf_iteration NUMBER;
2640: l_complete VARCHAR2 (1);
2641: l_next_approvers ame_util.approverstable2;
2642: l_next_approver ame_util.approverrecord2;
2643: l_index ame_util.idlist;
2644: l_ids ame_util.stringlist;
2645: l_class ame_util.stringlist;

Line 2642: l_next_approver ame_util.approverrecord2;

2638: l_hist_rec ap_inv_aprvl_hist%ROWTYPE;
2639: l_notf_iteration NUMBER;
2640: l_complete VARCHAR2 (1);
2641: l_next_approvers ame_util.approverstable2;
2642: l_next_approver ame_util.approverrecord2;
2643: l_index ame_util.idlist;
2644: l_ids ame_util.stringlist;
2645: l_class ame_util.stringlist;
2646: l_source ame_util.longstringlist;

Line 2643: l_index ame_util.idlist;

2639: l_notf_iteration NUMBER;
2640: l_complete VARCHAR2 (1);
2641: l_next_approvers ame_util.approverstable2;
2642: l_next_approver ame_util.approverrecord2;
2643: l_index ame_util.idlist;
2644: l_ids ame_util.stringlist;
2645: l_class ame_util.stringlist;
2646: l_source ame_util.longstringlist;
2647: l_ampersand VARCHAR2 (1);

Line 2644: l_ids ame_util.stringlist;

2640: l_complete VARCHAR2 (1);
2641: l_next_approvers ame_util.approverstable2;
2642: l_next_approver ame_util.approverrecord2;
2643: l_index ame_util.idlist;
2644: l_ids ame_util.stringlist;
2645: l_class ame_util.stringlist;
2646: l_source ame_util.longstringlist;
2647: l_ampersand VARCHAR2 (1);
2648: l_next_approver_s ame_util.approverrecord;

Line 2645: l_class ame_util.stringlist;

2641: l_next_approvers ame_util.approverstable2;
2642: l_next_approver ame_util.approverrecord2;
2643: l_index ame_util.idlist;
2644: l_ids ame_util.stringlist;
2645: l_class ame_util.stringlist;
2646: l_source ame_util.longstringlist;
2647: l_ampersand VARCHAR2 (1);
2648: l_next_approver_s ame_util.approverrecord;
2649: --itemkey VARCHAR2(100):='';

Line 2646: l_source ame_util.longstringlist;

2642: l_next_approver ame_util.approverrecord2;
2643: l_index ame_util.idlist;
2644: l_ids ame_util.stringlist;
2645: l_class ame_util.stringlist;
2646: l_source ame_util.longstringlist;
2647: l_ampersand VARCHAR2 (1);
2648: l_next_approver_s ame_util.approverrecord;
2649: --itemkey VARCHAR2(100):='';
2650: l_application_id NUMBER := 660;

Line 2648: l_next_approver_s ame_util.approverrecord;

2644: l_ids ame_util.stringlist;
2645: l_class ame_util.stringlist;
2646: l_source ame_util.longstringlist;
2647: l_ampersand VARCHAR2 (1);
2648: l_next_approver_s ame_util.approverrecord;
2649: --itemkey VARCHAR2(100):='';
2650: l_application_id NUMBER := 660;
2651: --l_transaction_id VARCHAR2(100); --'232349';
2652: l_transaction_type_id VARCHAR2 (100); --'OENH';

Line 2660: l_approver ame_util.approverrecord2;

2656: l_person_id NUMBER;
2657: l_s_count NUMBER := 0;
2658: l_step VARCHAR2 (200);
2659: xx_ame EXCEPTION;
2660: l_approver ame_util.approverrecord2;
2661: l_parent_itemkey VARCHAR2 (100);
2662: l_parent_item_type VARCHAR2 (20);
2663: l_ame_transaction_type VARCHAR2 (250);
2664: BEGIN

Line 2796: approvalstatusin => ame_util.rejectstatus,

2792: transactiontypein => l_ame_transaction_type,
2793: --itemtype,
2794: transactionidin => TO_NUMBER
2795: (l_parent_itemkey),
2796: approvalstatusin => ame_util.rejectstatus,
2797: approvernamein => l_name,
2798: itemclassin => 'header',
2799: itemidin => TO_NUMBER
2800: (l_parent_itemkey)

Line 2816: approvalstatusin => ame_util.rejectstatus,

2812: transactiontypein => l_ame_transaction_type,
2813: --itemtype,
2814: transactionidin => TO_NUMBER
2815: (l_parent_itemkey),
2816: approvalstatusin => ame_util.rejectstatus,
2817: approvernamein => l_name,
2818: itemclassin => 'header',
2819: itemidin => TO_NUMBER
2820: (l_parent_itemkey)

Line 2836: approvalstatusin => ame_util.rejectstatus,

2832: transactiontypein => l_ame_transaction_type,
2833: --itemtype,
2834: transactionidin => TO_NUMBER
2835: (l_parent_itemkey),
2836: approvalstatusin => ame_util.rejectstatus,
2837: approvernamein => l_name,
2838: itemclassin => 'header',
2839: itemidin => TO_NUMBER
2840: (l_parent_itemkey)

Line 2945: approverlist ame_util.approverstable2;

2941: l_child_approver_groupid NUMBER;
2942: --l_approver_group_id NUMBER;
2943: l_header_id NUMBER;
2944: l_process_out VARCHAR2 (10);
2945: approverlist ame_util.approverstable2;
2946: ametransactiontype po_document_types.ame_transaction_type%TYPE;
2947: l_response_action VARCHAR2 (20);
2948: l_note VARCHAR2 (4000);
2949: l_person_id NUMBER;

Line 2956: l_ame_exception ame_util.longeststringtype;

2952: l_first_approver_id NUMBER;
2953: l_first_position_id NUMBER;
2954: l_preparer_user_name fnd_user.user_name%TYPE;
2955: l_doc_string VARCHAR2 (200);
2956: l_ame_exception ame_util.longeststringtype;
2957: l_approver_response VARCHAR2 (20);
2958: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2959: xx_ame EXCEPTION;
2960:

Line 3118: ame_util.beatbyfirstresponderstatus

3114: );
3115: END IF;
3116:
3117: IF ( approverlist (i).approval_status =
3118: ame_util.beatbyfirstresponderstatus
3119: AND approverlist (i).api_insertion = ame_util.oamgenerated
3120: AND approverlist (i).group_or_chain_id =
3121: l_current_appr_group_id
3122: )

Line 3119: AND approverlist (i).api_insertion = ame_util.oamgenerated

3115: END IF;
3116:
3117: IF ( approverlist (i).approval_status =
3118: ame_util.beatbyfirstresponderstatus
3119: AND approverlist (i).api_insertion = ame_util.oamgenerated
3120: AND approverlist (i).group_or_chain_id =
3121: l_current_appr_group_id
3122: )
3123: THEN

Line 3127: IF (l_orig_system = ame_util.perorigsystem)

3123: THEN
3124: l_orig_system := approverlist (i).orig_system;
3125: l_orig_system_id := approverlist (i).orig_system_id;
3126:
3127: IF (l_orig_system = ame_util.perorigsystem)
3128: THEN
3129: -- Employee Supervisor Record.
3130: l_person_id := l_orig_system_id;
3131: ELSIF (l_orig_system = ame_util.posorigsystem)

Line 3131: ELSIF (l_orig_system = ame_util.posorigsystem)

3127: IF (l_orig_system = ame_util.perorigsystem)
3128: THEN
3129: -- Employee Supervisor Record.
3130: l_person_id := l_orig_system_id;
3131: ELSIF (l_orig_system = ame_util.posorigsystem)
3132: THEN
3133: -- Position Hierarchy Record.
3134: BEGIN
3135: SELECT person_id

Line 3168: ELSIF (l_orig_system = ame_util.fnduserorigsystem)

3164: WHEN NO_DATA_FOUND
3165: THEN
3166: l_person_id := -1;
3167: END;
3168: ELSIF (l_orig_system = ame_util.fnduserorigsystem)
3169: THEN
3170: -- FND User Record.
3171: SELECT employee_id
3172: INTO l_person_id