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

Line 1963: SELECT ahl_util_uc_pkg.get_uc_header_id(csi_item_instance_id),

1959: RETURN NUMBER
1960: IS
1961: CURSOR get_ue_details
1962: IS
1963: SELECT ahl_util_uc_pkg.get_uc_header_id(csi_item_instance_id),
1964: mel_cdl_type_code
1965: FROM ahl_unit_effectivities_b
1966: WHERE unit_effectivity_id = p_unit_effectivity_id;
1967:

Line 2023: --SELECT ahl_util_uc_pkg.get_uc_header_id(p_csi_instance_id) INTO l_unit_config_id FROM DUAL;

2019: p_csi_instance_id IS NOT NULL AND p_csi_instance_id <> FND_API.G_MISS_NUM AND
2020: p_mel_cdl_type_code IS NOT NULL AND p_mel_cdl_type_code <> FND_API.G_MISS_CHAR
2021: )
2022: THEN
2023: --SELECT ahl_util_uc_pkg.get_uc_header_id(p_csi_instance_id) INTO l_unit_config_id FROM DUAL;
2024: l_unit_config_id := ahl_util_uc_pkg.get_uc_header_id(p_csi_instance_id);
2025: l_mel_cdl_type_code := p_mel_cdl_type_code;
2026: END IF;
2027:

Line 2024: l_unit_config_id := ahl_util_uc_pkg.get_uc_header_id(p_csi_instance_id);

2020: p_mel_cdl_type_code IS NOT NULL AND p_mel_cdl_type_code <> FND_API.G_MISS_CHAR
2021: )
2022: THEN
2023: --SELECT ahl_util_uc_pkg.get_uc_header_id(p_csi_instance_id) INTO l_unit_config_id FROM DUAL;
2024: l_unit_config_id := ahl_util_uc_pkg.get_uc_header_id(p_csi_instance_id);
2025: l_mel_cdl_type_code := p_mel_cdl_type_code;
2026: END IF;
2027:
2028: IF (l_unit_config_id IS NOT NULL AND l_mel_cdl_type_code IS NOT NULL AND ahl_util_uc_pkg.get_uc_status_code(l_unit_config_id) IN ('COMPLETE', 'INCOMPLETE'))

Line 2028: IF (l_unit_config_id IS NOT NULL AND l_mel_cdl_type_code IS NOT NULL AND ahl_util_uc_pkg.get_uc_status_code(l_unit_config_id) IN ('COMPLETE', 'INCOMPLETE'))

2024: l_unit_config_id := ahl_util_uc_pkg.get_uc_header_id(p_csi_instance_id);
2025: l_mel_cdl_type_code := p_mel_cdl_type_code;
2026: END IF;
2027:
2028: IF (l_unit_config_id IS NOT NULL AND l_mel_cdl_type_code IS NOT NULL AND ahl_util_uc_pkg.get_uc_status_code(l_unit_config_id) IN ('COMPLETE', 'INCOMPLETE'))
2029: THEN
2030: OPEN get_mel_cdl(l_unit_config_id, l_mel_cdl_type_code);
2031: FETCH get_mel_cdl INTO l_mel_cdl_header_id, l_mel_version_number, l_pc_node_id;
2032: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)

Line 2303: l_uc_header_id := ahl_util_uc_pkg.get_uc_header_id(p_x_nonroutine_rec.instance_id);

2299: * if either UI unit/derived unit is in quarantine/deactive_quarantine, throw error
2300: */
2301: IF (p_x_nonroutine_rec.unit_config_header_id is null or p_x_nonroutine_rec.unit_config_header_id = FND_API.G_MISS_NUM)
2302: THEN
2303: l_uc_header_id := ahl_util_uc_pkg.get_uc_header_id(p_x_nonroutine_rec.instance_id);
2304: l_uc_status_code := ahl_util_uc_pkg.get_uc_status_code(l_uc_header_id);
2305: IF (l_uc_status_code IN ('COMPLETE', 'INCOMPLETE'))
2306: THEN
2307: p_x_nonroutine_rec.unit_config_header_id := l_uc_header_id;

Line 2304: l_uc_status_code := ahl_util_uc_pkg.get_uc_status_code(l_uc_header_id);

2300: */
2301: IF (p_x_nonroutine_rec.unit_config_header_id is null or p_x_nonroutine_rec.unit_config_header_id = FND_API.G_MISS_NUM)
2302: THEN
2303: l_uc_header_id := ahl_util_uc_pkg.get_uc_header_id(p_x_nonroutine_rec.instance_id);
2304: l_uc_status_code := ahl_util_uc_pkg.get_uc_status_code(l_uc_header_id);
2305: IF (l_uc_status_code IN ('COMPLETE', 'INCOMPLETE'))
2306: THEN
2307: p_x_nonroutine_rec.unit_config_header_id := l_uc_header_id;
2308: ELSIF (l_uc_status_code IN ('QUARANTINE', 'DEACTIVATE_QUARANTINE'))

Line 2315: l_uc_status_code := ahl_util_uc_pkg.get_uc_status_code(p_x_nonroutine_rec.unit_config_header_id);

2311: FND_MSG_PUB.ADD;
2312: RAISE FND_API.G_EXC_ERROR;
2313: END IF;
2314: ELSE
2315: l_uc_status_code := ahl_util_uc_pkg.get_uc_status_code(p_x_nonroutine_rec.unit_config_header_id);
2316: -- Check for not active and/or quarantined unit
2317: IF (l_uc_status_code IN ('QUARANTINE', 'DEACTIVATE_QUARANTINE'))
2318: THEN
2319: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_UNIT_QUAR_INV');

Line 2325: l_uc_header_id := ahl_util_uc_pkg.get_uc_header_id(p_x_nonroutine_rec.instance_id);

2321: RAISE FND_API.G_EXC_ERROR;
2322: ELSIF (l_uc_status_code IN ('COMPLETE', 'INCOMPLETE'))
2323: THEN
2324: -- Validate instance exists on the unit specified... Assume instance is validated before this is called...
2325: l_uc_header_id := ahl_util_uc_pkg.get_uc_header_id(p_x_nonroutine_rec.instance_id);
2326: IF (NVL(l_uc_header_id, -1 ) <> p_x_nonroutine_rec.unit_config_header_id)
2327: THEN
2328: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_UNIT_NOMATCH');
2329: FND_MSG_PUB.ADD;

Line 2701: SELECT ahl_util_uc_pkg.get_uc_header_id(csi_item_instance_id) unit_config_id,

2697: l_mel_cdl_header_id NUMBER;
2698:
2699: CURSOR get_ue_details
2700: IS
2701: SELECT ahl_util_uc_pkg.get_uc_header_id(csi_item_instance_id) unit_config_id,
2702: ahl_util_uc_pkg.get_unit_name(csi_item_instance_id) unit_config_name,
2703: mel_cdl_type_code,
2704: position_path_id,
2705: ata_code

Line 2702: ahl_util_uc_pkg.get_unit_name(csi_item_instance_id) unit_config_name,

2698:
2699: CURSOR get_ue_details
2700: IS
2701: SELECT ahl_util_uc_pkg.get_uc_header_id(csi_item_instance_id) unit_config_id,
2702: ahl_util_uc_pkg.get_unit_name(csi_item_instance_id) unit_config_name,
2703: mel_cdl_type_code,
2704: position_path_id,
2705: ata_code
2706: FROM ahl_unit_effectivities_b