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_MC_MASTERCONFIG_PVT dependencies on AHL_MC_HEADERS_B

Line 78: FROM ahl_mc_headers_b

74: p_mc_id in number
75: )
76: IS
77: SELECT 'x'
78: FROM ahl_mc_headers_b
79: WHERE upper(name) = upper(p_mc_name) AND
80: mc_id <> p_mc_id;
81:
82: -- 1. Declare local variables

Line 209: -- 6. Select next value from the AHL_MC_HEADERS_B_S sequence

205: 'Header validation successful'
206: );
207: END IF;
208:
209: -- 6. Select next value from the AHL_MC_HEADERS_B_S sequence
210: SELECT ahl_mc_headers_b_s.nextval INTO p_x_mc_header_rec.mc_header_id FROM dual;
211:
212: -- 7. Set values for p_x_mc_header_rec
213: p_x_mc_header_rec.object_version_number := 1;

Line 210: SELECT ahl_mc_headers_b_s.nextval INTO p_x_mc_header_rec.mc_header_id FROM dual;

206: );
207: END IF;
208:
209: -- 6. Select next value from the AHL_MC_HEADERS_B_S sequence
210: SELECT ahl_mc_headers_b_s.nextval INTO p_x_mc_header_rec.mc_header_id FROM dual;
211:
212: -- 7. Set values for p_x_mc_header_rec
213: p_x_mc_header_rec.object_version_number := 1;
214: p_x_mc_header_rec.security_group_id := null;

Line 1126: UPDATE ahl_mc_headers_b

1122: );
1123: END IF;
1124:
1125: -- 7b. Update the config_status_code = 'CLOSED' and object_version_number for the MC with MC_HEADER_ID = p_ mc_header_id
1126: UPDATE ahl_mc_headers_b
1127: SET object_version_number = p_object_ver_num + 1,
1128: config_status_code = 'CLOSED',
1129: last_update_date = G_SYSDATE,
1130: last_updated_by = G_USER_ID,

Line 1654: FROM ahl_mc_headers_b

1650: p_version_number in number
1651: )
1652: IS
1653: SELECT 'x'
1654: FROM ahl_mc_headers_b
1655: WHERE mc_id = p_mc_id AND
1656: nvl(version_number, 0) > nvl(p_version_number, 0);
1657:
1658: -- 2. Define local variables

Line 2122: FROM ahl_mc_headers_b

2118: p_mc_header_id in number
2119: )
2120: IS
2121: SELECT config_status_code
2122: FROM ahl_mc_headers_b
2123: WHERE mc_header_id = p_mc_header_id;
2124:
2125: -- 1. Define local variables
2126: l_api_name CONSTANT VARCHAR2(30) := 'Reopen_Master_Config';

Line 2245: UPDATE ahl_mc_headers_b

2241:
2242:
2243:
2244: -- 4. Reopen the MC header
2245: UPDATE ahl_mc_headers_b
2246: SET config_status_code = l_config_status_code,
2247: object_version_number = p_object_ver_num + 1,
2248: last_update_date = G_SYSDATE,
2249: last_updated_by = G_USER_ID,

Line 2487: UPDATE ahl_mc_headers_b

2483: );
2484: END IF;
2485:
2486: -- 54b.i. Update the status and object_version_number of the MC header record
2487: UPDATE ahl_mc_headers_b
2488: SET config_status_code = 'APPROVAL_PENDING',
2489: object_version_number = p_object_ver_num + 1,
2490: last_update_date = G_SYSDATE,
2491: last_updated_by = G_USER_ID,

Line 2533: UPDATE ahl_mc_headers_b

2529: );
2530: END IF;
2531:
2532: -- If wortkflow process is inactive, then force complete the MC
2533: UPDATE ahl_mc_headers_b
2534: SET config_status_code = 'COMPLETE',
2535: object_version_number = p_object_ver_num + 1,
2536: last_update_date = G_SYSDATE,
2537: last_updated_by = G_USER_ID,

Line 2632: FROM ahl_mc_headers_b

2628: p_mc_header_id in number
2629: )
2630: IS
2631: SELECT object_version_number
2632: FROM ahl_mc_headers_b
2633: WHERE mc_header_id = p_mc_header_id;
2634:
2635: BEGIN
2636:

Line 2687: FROM ahl_mc_headers_b

2683: p_mc_name in varchar2
2684: )
2685: IS
2686: SELECT 'x'
2687: FROM ahl_mc_headers_b
2688: WHERE upper(name) = upper(p_mc_name);
2689:
2690: CURSOR check_mc_name_noupdate
2691: (

Line 2696: FROM ahl_mc_headers_b

2692: p_mc_header_id in number
2693: )
2694: IS
2695: SELECT name
2696: FROM ahl_mc_headers_b
2697: WHERE mc_header_id = p_mc_header_id;
2698:
2699: l_dummy_name VARCHAR2(80);
2700: BEGIN

Line 2776: FROM ahl_mc_headers_b

2772: p_mc_id in number
2773: )
2774: IS
2775: SELECT 'x'
2776: FROM ahl_mc_headers_b
2777: WHERE upper(revision) = upper(p_mc_revision) AND
2778: mc_id = p_mc_id and
2779: mc_header_id <> p_mc_header_id;
2780:

Line 2787: FROM ahl_mc_headers_b

2783: p_mc_header_id in number
2784: )
2785: IS
2786: SELECT revision
2787: FROM ahl_mc_headers_b
2788: WHERE mc_header_id = p_mc_header_id;
2789:
2790: l_ret_val BOOLEAN;
2791: l_dummy_rev VARCHAR2(30);

Line 2920: FROM ahl_mc_headers_b

2916: p_mc_header_id in number
2917: )
2918: IS
2919: SELECT config_status_code
2920: FROM ahl_mc_headers_b
2921: WHERE mc_header_id = p_mc_header_id;
2922:
2923: -- 2. Define local variables
2924: l_status VARCHAR2(30) := 'DRAFT';

Line 2936: UPDATE ahl_mc_headers_b

2932: IF (get_mc_header_status%FOUND)
2933: THEN
2934: IF (l_status = 'APPROVAL_REJECTED')
2935: THEN
2936: UPDATE ahl_mc_headers_b
2937: SET config_status_code = 'DRAFT'
2938: WHERE mc_header_id = p_mc_header_id;
2939: END IF;
2940: END IF;

Line 2969: FROM ahl_mc_config_relations mccr, ahl_mc_headers_b mch

2965: p_relationship_id IN NUMBER
2966: )
2967: IS
2968: SELECT mch.name, mch.config_status_code
2969: FROM ahl_mc_config_relations mccr, ahl_mc_headers_b mch
2970: WHERE mccr.relationship_id = p_relationship_id AND
2971: mccr.mc_header_id = mch.mc_header_id;
2972: -- Since expired subconfig associations can be unexpired, so no need to filter on active_end_date
2973: -- AND trunc(nvl(mccr.active_end_date, G_SYSDATE + 1)) > G_TRUNC_DATE;