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_UA_FLIGHT_SCHEDULES_PVT dependencies on AHL_UTIL_UC_PKG

Line 247: -- AND ahl_util_uc_pkg.get_uc_status_code (unit_config_header_id) IN ('COMPLETE', 'INCOMPLETE');

243: SELECT unit_config_header_id
244: FROM AHL_UNIT_CONFIG_HEADERS
245: WHERE name = p_uc_name
246: --priyan Bug # 5303188
247: -- AND ahl_util_uc_pkg.get_uc_status_code (unit_config_header_id) IN ('COMPLETE', 'INCOMPLETE');
248: --AND unit_config_status_code in ('COMPLETE','INCOMPLETE');
249: --AND TRUNC(NVL(active_end_date,sysdate+1)) > TRUNC(sysdate);
250: -- fix for bug number 5528416
251: AND ahl_util_uc_pkg.get_uc_status_code (unit_config_header_id) NOT IN ('DRAFT', 'EXPIRED');

Line 251: AND ahl_util_uc_pkg.get_uc_status_code (unit_config_header_id) NOT IN ('DRAFT', 'EXPIRED');

247: -- AND ahl_util_uc_pkg.get_uc_status_code (unit_config_header_id) IN ('COMPLETE', 'INCOMPLETE');
248: --AND unit_config_status_code in ('COMPLETE','INCOMPLETE');
249: --AND TRUNC(NVL(active_end_date,sysdate+1)) > TRUNC(sysdate);
250: -- fix for bug number 5528416
251: AND ahl_util_uc_pkg.get_uc_status_code (unit_config_header_id) NOT IN ('DRAFT', 'EXPIRED');
252:
253:
254: -- Cursor for getting org id from org name
255: CURSOR org_name_to_id_csr(p_org_code IN VARCHAR2)