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 1875: SELECT ahl_util_uc_pkg.get_uc_header_id(csi_item_instance_id),

1871: RETURN NUMBER
1872: IS
1873: CURSOR get_ue_details
1874: IS
1875: SELECT ahl_util_uc_pkg.get_uc_header_id(csi_item_instance_id),
1876: mel_cdl_type_code
1877: FROM ahl_unit_effectivities_b
1878: WHERE unit_effectivity_id = p_unit_effectivity_id;
1879:

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

1926: p_csi_instance_id IS NOT NULL AND p_csi_instance_id <> FND_API.G_MISS_NUM AND
1927: p_mel_cdl_type_code IS NOT NULL AND p_mel_cdl_type_code <> FND_API.G_MISS_CHAR
1928: )
1929: THEN
1930: --SELECT ahl_util_uc_pkg.get_uc_header_id(p_csi_instance_id) INTO l_unit_config_id FROM DUAL;
1931: l_unit_config_id := ahl_util_uc_pkg.get_uc_header_id(p_csi_instance_id);
1932: l_mel_cdl_type_code := p_mel_cdl_type_code;
1933: END IF;
1934:

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

1927: p_mel_cdl_type_code IS NOT NULL AND p_mel_cdl_type_code <> FND_API.G_MISS_CHAR
1928: )
1929: THEN
1930: --SELECT ahl_util_uc_pkg.get_uc_header_id(p_csi_instance_id) INTO l_unit_config_id FROM DUAL;
1931: l_unit_config_id := ahl_util_uc_pkg.get_uc_header_id(p_csi_instance_id);
1932: l_mel_cdl_type_code := p_mel_cdl_type_code;
1933: END IF;
1934:
1935: 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 1935: 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'))

1931: l_unit_config_id := ahl_util_uc_pkg.get_uc_header_id(p_csi_instance_id);
1932: l_mel_cdl_type_code := p_mel_cdl_type_code;
1933: END IF;
1934:
1935: 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'))
1936: THEN
1937: OPEN get_mel_cdl(l_unit_config_id, l_mel_cdl_type_code);
1938: FETCH get_mel_cdl INTO l_mel_cdl_header_id, l_mel_version_number, l_pc_node_id;
1939: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL)

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

2205: * if either UI unit/derived unit is in quarantine/deactive_quarantine, throw error
2206: */
2207: 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)
2208: THEN
2209: l_uc_header_id := ahl_util_uc_pkg.get_uc_header_id(p_x_nonroutine_rec.instance_id);
2210: l_uc_status_code := ahl_util_uc_pkg.get_uc_status_code(l_uc_header_id);
2211: IF (l_uc_status_code IN ('COMPLETE', 'INCOMPLETE'))
2212: THEN
2213: p_x_nonroutine_rec.unit_config_header_id := l_uc_header_id;

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

2206: */
2207: 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)
2208: THEN
2209: l_uc_header_id := ahl_util_uc_pkg.get_uc_header_id(p_x_nonroutine_rec.instance_id);
2210: l_uc_status_code := ahl_util_uc_pkg.get_uc_status_code(l_uc_header_id);
2211: IF (l_uc_status_code IN ('COMPLETE', 'INCOMPLETE'))
2212: THEN
2213: p_x_nonroutine_rec.unit_config_header_id := l_uc_header_id;
2214: ELSIF (l_uc_status_code IN ('QUARANTINE', 'DEACTIVATE_QUARANTINE'))

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

2217: FND_MSG_PUB.ADD;
2218: RAISE FND_API.G_EXC_ERROR;
2219: END IF;
2220: ELSE
2221: l_uc_status_code := ahl_util_uc_pkg.get_uc_status_code(p_x_nonroutine_rec.unit_config_header_id);
2222: -- Check for not active and/or quarantined unit
2223: IF (l_uc_status_code IN ('QUARANTINE', 'DEACTIVATE_QUARANTINE'))
2224: THEN
2225: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_UNIT_QUAR_INV');

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

2227: RAISE FND_API.G_EXC_ERROR;
2228: ELSIF (l_uc_status_code IN ('COMPLETE', 'INCOMPLETE'))
2229: THEN
2230: -- Validate instance exists on the unit specified... Assume instance is validated before this is called...
2231: l_uc_header_id := ahl_util_uc_pkg.get_uc_header_id(p_x_nonroutine_rec.instance_id);
2232: IF (NVL(l_uc_header_id, -1 ) <> p_x_nonroutine_rec.unit_config_header_id)
2233: THEN
2234: FND_MESSAGE.SET_NAME(G_APP_NAME, 'AHL_UMP_NR_UNIT_NOMATCH');
2235: FND_MSG_PUB.ADD;

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

2603: l_mel_cdl_header_id NUMBER;
2604:
2605: CURSOR get_ue_details
2606: IS
2607: SELECT ahl_util_uc_pkg.get_uc_header_id(csi_item_instance_id) unit_config_id,
2608: ahl_util_uc_pkg.get_unit_name(csi_item_instance_id) unit_config_name,
2609: mel_cdl_type_code,
2610: position_path_id,
2611: ata_code

Line 2608: ahl_util_uc_pkg.get_unit_name(csi_item_instance_id) unit_config_name,

2604:
2605: CURSOR get_ue_details
2606: IS
2607: SELECT ahl_util_uc_pkg.get_uc_header_id(csi_item_instance_id) unit_config_id,
2608: ahl_util_uc_pkg.get_unit_name(csi_item_instance_id) unit_config_name,
2609: mel_cdl_type_code,
2610: position_path_id,
2611: ata_code
2612: FROM ahl_unit_effectivities_b