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.

[Home] [Help]

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 2264: FROM aso_apr_approval_details

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

Line 2267: FROM aso_apr_approval_details

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

Line 2280: FROM aso_apr_approval_details

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

Line 2655: TYPE existing_approvers_tbl_type IS TABLE OF aso_apr_approval_details%ROWTYPE

2651: l_oam_rule_id NUMBER;
2652: l_rule_count NUMBER;
2653: l_rules_changed_flag VARCHAR2 (1) := 'N';
2654:
2655: TYPE existing_approvers_tbl_type IS TABLE OF aso_apr_approval_details%ROWTYPE
2656: INDEX BY BINARY_INTEGER;
2657:
2658: l_new_approvers_tbl existing_approvers_tbl_type;
2659: l_employee_id NUMBER;

Line 2673: FROM aso_apr_approval_details

2669: c_object_approval_id NUMBER
2670: ) IS
2671: SELECT approval_det_id, approver_person_id, approver_user_id,
2672: approver_status
2673: FROM aso_apr_approval_details
2674: WHERE object_approval_id = c_object_approval_id
2675: ORDER BY approver_sequence;
2676:
2677: CURSOR get_approver_count (

Line 2683: FROM aso_apr_approval_details

2679: ) IS
2680: SELECT COUNT (
2681: *
2682: )
2683: FROM aso_apr_approval_details
2684: WHERE object_approval_id = c_object_approval_id;
2685:
2686: CURSOR get_old_approvers (
2687: c_object_approval_id NUMBER,

Line 2691: FROM aso_apr_approval_details

2687: c_object_approval_id NUMBER,
2688: c_approval_det_id NUMBER
2689: ) IS
2690: SELECT *
2691: FROM aso_apr_approval_details
2692: WHERE object_approval_id = c_object_approval_id
2693: AND approval_det_id = c_approval_det_id;
2694:
2695: CURSOR get_existing_rules (

Line 2982: DELETE FROM aso_apr_approval_details

2978: 'N'
2979: );
2980: END IF;
2981:
2982: DELETE FROM aso_apr_approval_details
2983: WHERE object_approval_id = p_object_approval_id;
2984:
2985: l_approver_status := NULL;
2986: -- third loop to insert the data

Line 3435: FROM aso_apr_approval_details

3431: CURSOR get_approvers (
3432: c_object_approval_id NUMBER
3433: ) IS
3434: SELECT approval_det_id
3435: FROM aso_apr_approval_details
3436: WHERE object_approval_id = c_object_approval_id;
3437:
3438: CURSOR get_approver_sequence (
3439: c_object_approval_id NUMBER

Line 3444: FROM aso_apr_approval_details

3440: ) IS
3441: SELECT MAX (
3442: approver_sequence
3443: ) + 1
3444: FROM aso_apr_approval_details
3445: WHERE object_approval_id = c_object_approval_id;
3446:
3447: CURSOR get_application_id (
3448: c_object_approval_id NUMBER

Line 3955: FROM aso_apr_approval_details apd, aso_lookups fl

3951: CURSOR approver_details (
3952: c_object_approval_id NUMBER
3953: ) IS
3954: SELECT approver_user_id, approver_person_id, fl.meaning, approver_comments
3955: FROM aso_apr_approval_details apd, aso_lookups fl
3956: WHERE apd.approver_status = fl.lookup_code
3957: AND object_approval_id = c_object_approval_id
3958: AND fl.lookup_type = 'ASO_APPROVER_STATUS'
3959: ORDER BY approver_sequence;

Line 5593: UPDATE aso_apr_approval_details

5589:
5590: END IF;
5591:
5592: IF p_update_header_or_detail_flag = 'DETAIL' THEN
5593: UPDATE aso_apr_approval_details
5594: SET approver_status = p_status,
5595: date_received = SYSDATE,
5596: last_update_date = SYSDATE,
5597: approver_comments = note,