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.ASO_APR_WF_PVT dependencies on ASO_APR_APPROVAL_DETAILS

Line 171: FROM aso_apr_approval_details

167: c_approval_id NUMBER
168: ) IS
169: SELECT approval_det_id, approver_sequence, approver_person_id,
170: approver_user_id
171: FROM aso_apr_approval_details
172: WHERE object_approval_id = c_approval_id
173: AND approver_status = 'NOSUBMIT'
174: ORDER BY approver_sequence;
175: BEGIN

Line 370: UPDATE aso_apr_approval_details

366: 'N'
367: );
368: END IF;
369:
370: UPDATE aso_apr_approval_details
371: SET approver_status = 'PEND',
372: date_sent = SYSDATE,
373: last_update_date = SYSDATE,
374: last_updated_by = fnd_global.user_id,

Line 459: FROM aso_apr_approval_details

455: ) IS
456: SELECT COUNT (
457: *
458: )
459: FROM aso_apr_approval_details
460: WHERE object_approval_id = c_approval_id
461: AND approver_status = 'NOSUBMIT';
462:
463: CURSOR get_max_approver_seq (

Line 469: FROM aso_apr_approval_details

465: ) IS
466: SELECT MAX (
467: approver_sequence
468: )
469: FROM aso_apr_approval_details
470: WHERE object_approval_id = c_approval_id;
471:
472: CURSOR get_tout_approvers (
473: c_approval_id NUMBER,

Line 479: FROM aso_apr_approval_details

475: ) IS
476: SELECT COUNT (
477: *
478: )
479: FROM aso_apr_approval_details
480: WHERE object_approval_id = c_approval_id
481: AND approver_status = 'TOUT'
482: AND approver_sequence = c_max_seq;
483: BEGIN

Line 795: FROM aso_apr_approval_details

791: ) IS
792: SELECT COUNT (
793: *
794: )
795: FROM aso_apr_approval_details
796: WHERE object_approval_id = c_approval_id
797: AND approver_status = 'REJ';
798: BEGIN
799: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN

Line 1418: FROM aso_apr_approval_details

1414: l_approval_id NUMBER
1415: ) IS
1416: SELECT approval_det_id, approver_sequence, approver_person_id,
1417: approver_user_id
1418: FROM aso_apr_approval_details
1419: WHERE object_approval_id = l_approval_id
1420: AND approver_status = 'PEND'
1421: ORDER BY approver_sequence;
1422:

Line 1716: UPDATE aso_apr_approval_details

1712: 'N'
1713: );
1714: END IF;
1715:
1716: UPDATE aso_apr_approval_details
1717: SET approver_status = 'CAN',
1718: date_sent = SYSDATE,
1719: last_update_date = SYSDATE,
1720: last_updated_by = fnd_global.user_id,

Line 2265: FROM aso_apr_approval_details

2261: CURSOR get_last_approver (
2262: c_object_approval_id NUMBER
2263: ) IS
2264: SELECT approver_person_id
2265: FROM aso_apr_approval_details
2266: WHERE object_approval_id = c_object_approval_id
2267: AND approver_sequence = (select max(approver_sequence)
2268: FROM aso_apr_approval_details
2269: WHERE object_approval_id = c_object_approval_id);

Line 2268: FROM aso_apr_approval_details

2264: SELECT approver_person_id
2265: FROM aso_apr_approval_details
2266: WHERE object_approval_id = c_object_approval_id
2267: AND approver_sequence = (select max(approver_sequence)
2268: FROM aso_apr_approval_details
2269: WHERE object_approval_id = c_object_approval_id);
2270:
2271: CURSOR get_user_id ( c_employee_id NUMBER)
2272: IS

Line 2281: FROM aso_apr_approval_details

2277:
2278:
2279: CURSOR get_rejected_approver (c_object_approval_id NUMBER) IS
2280: SELECT approver_person_id
2281: FROM aso_apr_approval_details
2282: WHERE object_approval_id = c_object_approval_id
2283: AND approver_status = 'REJ';
2284:
2285: user_id number;

Line 2684: TYPE existing_approvers_tbl_type IS TABLE OF aso_apr_approval_details%ROWTYPE

2680: l_oam_rule_id NUMBER;
2681: l_rule_count NUMBER;
2682: l_rules_changed_flag VARCHAR2 (1) := 'N';
2683:
2684: TYPE existing_approvers_tbl_type IS TABLE OF aso_apr_approval_details%ROWTYPE
2685: INDEX BY BINARY_INTEGER;
2686:
2687: l_new_approvers_tbl existing_approvers_tbl_type;
2688: l_employee_id NUMBER;

Line 2702: FROM aso_apr_approval_details

2698: c_object_approval_id NUMBER
2699: ) IS
2700: SELECT approval_det_id, approver_person_id, approver_user_id,
2701: approver_status
2702: FROM aso_apr_approval_details
2703: WHERE object_approval_id = c_object_approval_id
2704: ORDER BY approver_sequence;
2705:
2706: CURSOR get_approver_count (

Line 2712: FROM aso_apr_approval_details

2708: ) IS
2709: SELECT COUNT (
2710: *
2711: )
2712: FROM aso_apr_approval_details
2713: WHERE object_approval_id = c_object_approval_id;
2714:
2715: CURSOR get_old_approvers (
2716: c_object_approval_id NUMBER,

Line 2720: FROM aso_apr_approval_details

2716: c_object_approval_id NUMBER,
2717: c_approval_det_id NUMBER
2718: ) IS
2719: SELECT *
2720: FROM aso_apr_approval_details
2721: WHERE object_approval_id = c_object_approval_id
2722: AND approval_det_id = c_approval_det_id;
2723:
2724: CURSOR get_existing_rules (

Line 3011: DELETE FROM aso_apr_approval_details

3007: 'N'
3008: );
3009: END IF;
3010:
3011: DELETE FROM aso_apr_approval_details
3012: WHERE object_approval_id = p_object_approval_id;
3013:
3014: l_approver_status := NULL;
3015: -- third loop to insert the data

Line 3464: FROM aso_apr_approval_details

3460: CURSOR get_approvers (
3461: c_object_approval_id NUMBER
3462: ) IS
3463: SELECT approval_det_id
3464: FROM aso_apr_approval_details
3465: WHERE object_approval_id = c_object_approval_id;
3466:
3467: CURSOR get_approver_sequence (
3468: c_object_approval_id NUMBER

Line 3473: FROM aso_apr_approval_details

3469: ) IS
3470: SELECT MAX (
3471: approver_sequence
3472: ) + 1
3473: FROM aso_apr_approval_details
3474: WHERE object_approval_id = c_object_approval_id;
3475:
3476: CURSOR get_application_id (
3477: c_object_approval_id NUMBER

Line 3985: FROM aso_apr_approval_details apd, aso_lookups fl

3981: CURSOR approver_details (
3982: c_object_approval_id NUMBER
3983: ) IS
3984: SELECT approver_user_id, approver_person_id, fl.meaning, approver_comments
3985: FROM aso_apr_approval_details apd, aso_lookups fl
3986: WHERE apd.approver_status = fl.lookup_code
3987: AND object_approval_id = c_object_approval_id
3988: AND fl.lookup_type = 'ASO_APPROVER_STATUS'
3989: ORDER BY approver_sequence;

Line 5628: UPDATE aso_apr_approval_details

5624:
5625: END IF;
5626:
5627: IF p_update_header_or_detail_flag = 'DETAIL' THEN
5628: UPDATE aso_apr_approval_details
5629: SET approver_status = p_status,
5630: date_received = SYSDATE,
5631: last_update_date = SYSDATE,
5632: approver_comments = note,