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.AHL_APPROVALS_PVT dependencies on AHL_APPROVERS

Line 11: -- AHL_Approvers:

7: -- PROCEDURES
8: -- AHL_Approval_Rules_B AND AHL_Approval_Rules_TL:
9: -- Check_Approval_Rules_Req_Items
10: -- Check_Approval_Rules_UK_Items
11: -- AHL_Approvers:
12: -- Check_Approvers_Req_Items
13: -- Check_Approvers_UK_Items
14: --
15: -- NOTES

Line 1162: SELECT 1 FROM ahl_approvers

1158: l_count NUMBER;
1159: l_status VARCHAR2(30);
1160:
1161: CURSOR check_approver1 IS
1162: SELECT 1 FROM ahl_approvers
1163: WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id;
1164:
1165: CURSOR chk_STATUS IS
1166: SELECT status_code FROM ahl_approval_rules_b WHERE approval_rule_id = p_Approval_Rules_rec.approval_rule_id;

Line 2364: SELECT Ahl_Approvers_S.NEXTVAL

2360: l_rowid VARCHAR2(30);
2361: l_object_version_number NUMBER := 1;
2362:
2363: CURSOR c_seq IS
2364: SELECT Ahl_Approvers_S.NEXTVAL
2365: FROM dual;
2366:
2367: CURSOR c_id_exists (x_id IN NUMBER) IS
2368: SELECT 1

Line 2371: FROM AHL_Approvers

2367: CURSOR c_id_exists (x_id IN NUMBER) IS
2368: SELECT 1
2369: FROM dual
2370: WHERE EXISTS (SELECT 1
2371: FROM AHL_Approvers
2372: WHERE Approval_Approver_Id = x_id);
2373: BEGIN
2374: --------------------- initialize -----------------------
2375: SAVEPOINT Create_Approvers;

Line 2487: Ahl_Approvers_Pkg.Insert_Row (

2483: Ahl_Debug_Pub.debug( l_full_name ||':Insert');
2484: END IF;
2485: -- Invoke the table handler to create a record
2486: --
2487: Ahl_Approvers_Pkg.Insert_Row (
2488: X_ROWID => l_rowid,
2489: X_APPROVAL_APPROVER_ID => l_Approvers_rec.APPROVAL_APPROVER_ID,
2490: X_OBJECT_VERSION_NUMBER => 1,
2491: X_APPROVAL_RULE_ID => l_Approvers_rec.APPROVAL_RULE_ID,

Line 2669: Ahl_Approvers_Pkg. UPDATE_ROW (

2665: IF G_DEBUG='Y' THEN
2666: Ahl_Debug_Pub.debug( l_full_name ||':Update');
2667: END IF;
2668:
2669: Ahl_Approvers_Pkg. UPDATE_ROW (
2670: X_APPROVAL_APPROVER_ID => l_Approvers_rec.APPROVAL_APPROVER_ID,
2671: X_OBJECT_VERSION_NUMBER => l_Approvers_rec.OBJECT_VERSION_NUMBER + 1,
2672: X_APPROVAL_RULE_ID => l_Approvers_rec.APPROVAL_RULE_ID,
2673: X_APPROVER_TYPE_CODE => l_Approvers_rec.APPROVER_TYPE_CODE,

Line 2816: FROM AHL_Approvers

2812: )
2813: IS
2814: CURSOR c_Approvers IS
2815: SELECT *
2816: FROM AHL_Approvers
2817: WHERE APPROVAL_APPROVER_ID = p_Approval_Approver_Id;
2818:
2819: /* Start Code for checking approvals by shbhanda Mar'08---*/
2820: CURSOR check_approval_rules IS

Line 2821: SELECT COUNT(*) FROM Ahl_Approvers

2817: WHERE APPROVAL_APPROVER_ID = p_Approval_Approver_Id;
2818:
2819: /* Start Code for checking approvals by shbhanda Mar'08---*/
2820: CURSOR check_approval_rules IS
2821: SELECT COUNT(*) FROM Ahl_Approvers
2822: WHERE Approval_Rule_Id IN
2823: (SELECT Approval_Rule_Id FROM Ahl_Approvers WHERE APPROVAL_APPROVER_ID = p_Approval_Approver_Id);
2824:
2825: CURSOR check_appr_status IS

Line 2823: (SELECT Approval_Rule_Id FROM Ahl_Approvers WHERE APPROVAL_APPROVER_ID = p_Approval_Approver_Id);

2819: /* Start Code for checking approvals by shbhanda Mar'08---*/
2820: CURSOR check_approval_rules IS
2821: SELECT COUNT(*) FROM Ahl_Approvers
2822: WHERE Approval_Rule_Id IN
2823: (SELECT Approval_Rule_Id FROM Ahl_Approvers WHERE APPROVAL_APPROVER_ID = p_Approval_Approver_Id);
2824:
2825: CURSOR check_appr_status IS
2826: SELECT status_code FROM Ahl_Approval_rules_b
2827: WHERE Approval_Rule_Id IN

Line 2828: (SELECT Approval_Rule_Id FROM Ahl_Approvers WHERE APPROVAL_APPROVER_ID = p_Approval_Approver_Id);

2824:
2825: CURSOR check_appr_status IS
2826: SELECT status_code FROM Ahl_Approval_rules_b
2827: WHERE Approval_Rule_Id IN
2828: (SELECT Approval_Rule_Id FROM Ahl_Approvers WHERE APPROVAL_APPROVER_ID = p_Approval_Approver_Id);
2829:
2830: /* End Code for checking approvals by shbhanda Mar'08---*/
2831:
2832: --

Line 2911: DELETE FROM Ahl_Approvers

2907: Ahl_Debug_Pub.debug( l_full_name ||':Delete');
2908: END IF;
2909: -- Delete data
2910:
2911: DELETE FROM Ahl_Approvers
2912: WHERE APPROVAL_APPROVER_ID = p_Approval_Approver_Id;
2913: IF (SQL%NOTFOUND) THEN
2914: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN
2915: Fnd_Message.set_name ('AHL', 'AHL_API_RECORD_NOT_FOUND');

Line 3139: FROM AHL_Approvers

3135: )
3136: IS
3137: CURSOR c_Approvers IS
3138: SELECT *
3139: FROM AHL_Approvers
3140: WHERE APPROVAL_APPROVER_ID = p_Approvers_rec.Approval_Approver_Id;
3141: --
3142: -- This is the only exception for using %ROWTYPE.
3143: -- We are selecting from the V view, which may

Line 3232: FROM AHL_APPROVERS_TYPE_V

3228: /*
3229: CURSOR c_approver_id (approver_name IN VARCHAR2)
3230: IS
3231: SELECT ROLE_ID
3232: FROM AHL_APPROVERS_TYPE_V
3233: WHERE UPPER(ROLE_NAME) LIKE UPPER(approver_name)
3234: AND UPPER(LOOKUP_CODE) LIKE UPPER(p_approvers_rec.approver_type_code);
3235: */
3236:

Line 3263: FROM AHL_APPROVERS_TYPE_V

3259: CURSOR c_approver_name_id (approver_name IN VARCHAR2,
3260: approver_id IN NUMBER)
3261: IS
3262: SELECT ROLE_ID
3263: FROM AHL_APPROVERS_TYPE_V
3264: WHERE UPPER(ROLE_NAME) LIKE UPPER(approver_name)
3265: AND ROLE_ID = approver_id
3266: AND UPPER(LOOKUP_CODE) LIKE UPPER(p_approvers_rec.approver_type_code);
3267: */

Line 3388: 'AHL_Approvers',

3384: IF p_validation_mode = Jtf_Plsql_Api.g_create
3385: AND p_Approvers_rec.Approval_Approver_Id IS NOT NULL
3386: THEN
3387: IF Ahl_Utility_Pvt.check_uniqueness(
3388: 'AHL_Approvers',
3389: 'APPROVAL_APPROVER_ID = ' || p_Approvers_rec.Approval_Approver_Id
3390: ) = Fnd_Api.g_false
3391: THEN
3392: IF Fnd_Msg_Pub.check_msg_level (Fnd_Msg_Pub.g_msg_lvl_error) THEN

Line 3404: 'AHL_Approvers',

3400: -- check if Approval_Rule_Id,Approver_Sequence and Approver_Id is UNIQUE
3401:
3402: IF p_validation_mode = Jtf_Plsql_Api.g_create THEN
3403: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (
3404: 'AHL_Approvers',
3405: 'Approval_Rule_Id = ' || p_Approvers_rec.Approval_Rule_Id ||
3406: ' AND Approver_Sequence = ' || p_Approvers_rec.Approver_Sequence
3407: );
3408: ELSE

Line 3410: 'AHL_Approvers',

3406: ' AND Approver_Sequence = ' || p_Approvers_rec.Approver_Sequence
3407: );
3408: ELSE
3409: l_valid_flag := Ahl_Utility_Pvt.check_uniqueness (
3410: 'AHL_Approvers',
3411: 'Approval_Rule_Id = ' || p_Approvers_rec.Approval_Rule_Id ||
3412: ' AND Approver_Sequence = ' || p_Approvers_rec.Approver_Sequence ||
3413: ' AND Approval_Approver_id <> ' || p_Approvers_rec.Approval_Approver_id
3414: );