APPS.AHL_PC_ASSOCIATION_PVT dependencies on AHL_UTIL_UC_PKG

Line 1044: AHL_UTIL_UC_PKG.get_uc_status_code(p_unit_item_id) in ('COMPLETE', 'INCOMPLETE');

1040: select 'X'
1041: from ahl_unit_config_headers
1042: where unit_config_header_id = p_unit_item_id and
1043: trunc(sysdate) between nvl(trunc(active_start_date), trunc(sysdate)) and nvl(trunc(active_end_date), trunc(sysdate)) AND
1044: AHL_UTIL_UC_PKG.get_uc_status_code(p_unit_item_id) in ('COMPLETE', 'INCOMPLETE');
1045: -- bug 8970548 fix unit_config_status_code in ('COMPLETE', 'INCOMPLETE');
1046:
1047: CURSOR check_item_valid (p_unit_item_id IN NUMBER)
1048: IS

Line 1061: AHL_UTIL_UC_PKG.get_uc_status_code(p_unit_item_id) IN ('QUARANTINE', 'DEACTIVATE_QUARANTINE');

1057: IS
1058: select 'X'
1059: from ahl_unit_config_headers
1060: where unit_config_header_id = p_unit_item_id AND
1061: AHL_UTIL_UC_PKG.get_uc_status_code(p_unit_item_id) IN ('QUARANTINE', 'DEACTIVATE_QUARANTINE');
1062: -- bug 8970548 fix unit_config_status_code in ('QUARANTINE', 'DEACTIVATE_QUARANTINE');
1063:
1064: BEGIN
1065: -- Check for object_version_number sanity