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 313: -- AND ahl_util_uc_pkg.get_uc_status_code (unit_config_header_id) IN ('COMPLETE', 'INCOMPLETE');

309: SELECT unit_config_header_id
310: FROM AHL_UNIT_CONFIG_HEADERS
311: WHERE name = p_uc_name
312: --priyan Bug # 5303188
313: -- AND ahl_util_uc_pkg.get_uc_status_code (unit_config_header_id) IN ('COMPLETE', 'INCOMPLETE');
314: --AND unit_config_status_code in ('COMPLETE','INCOMPLETE');
315: --AND TRUNC(NVL(active_end_date,sysdate+1)) > TRUNC(sysdate);
316: -- fix for bug number 5528416
317: AND ahl_util_uc_pkg.get_uc_status_code (unit_config_header_id) NOT IN ('DRAFT', 'EXPIRED');

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

313: -- AND ahl_util_uc_pkg.get_uc_status_code (unit_config_header_id) IN ('COMPLETE', 'INCOMPLETE');
314: --AND unit_config_status_code in ('COMPLETE','INCOMPLETE');
315: --AND TRUNC(NVL(active_end_date,sysdate+1)) > TRUNC(sysdate);
316: -- fix for bug number 5528416
317: AND ahl_util_uc_pkg.get_uc_status_code (unit_config_header_id) NOT IN ('DRAFT', 'EXPIRED');
318:
319:
320: -- Cursor for getting org id from org name
321: CURSOR org_name_to_id_csr(p_org_code IN VARCHAR2)