APPS.AHL_RA_ANALYSER_PVT dependencies on AHL_UTIL_UC_PKG

Line 95: AND UCI.UNIT_CONFIG_HEADER_ID = AHL_UTIL_UC_PKG.GET_SUB_UC_HEADER_ID(UC.CSI_ITEM_INSTANCE_ID))), -- l_dtls_pos_ref_tbl

91: FROM AHL_MC_RELATIONSHIPS MCR,
92: AHL_UNIT_CONFIG_HEADERS UCI
93: WHERE MCR.MC_HEADER_ID = UCI.MASTER_CONFIG_ID
94: AND MCR.PARENT_RELATIONSHIP_ID IS NULL
95: AND UCI.UNIT_CONFIG_HEADER_ID = AHL_UTIL_UC_PKG.GET_SUB_UC_HEADER_ID(UC.CSI_ITEM_INSTANCE_ID))), -- l_dtls_pos_ref_tbl
96: CII.INVENTORY_ITEM_ID, -- l_dtls_inv_item_id_tbl
97: CII.INV_MASTER_ORGANIZATION_ID, -- l_dtls_inv_master_org_id_tbl
98: CII.INVENTORY_REVISION, -- l_dtls_inv_revision_tbl
99: CII.QUANTITY, -- l_dtls_quantity_tbl

Line 179: AND UCI.UNIT_CONFIG_HEADER_ID(+) = AHL_UTIL_UC_PKG.GET_SUB_UC_HEADER_ID(UC.CSI_ITEM_INSTANCE_ID)) A,

175: WHERE CII.INSTANCE_ID = CIIR.SUBJECT_ID
176: AND CII.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID
177: AND CII.INV_MASTER_ORGANIZATION_ID = KFV.ORGANIZATION_ID
178: AND UC.CSI_ITEM_INSTANCE_ID(+) = CIIR.SUBJECT_ID
179: AND UCI.UNIT_CONFIG_HEADER_ID(+) = AHL_UTIL_UC_PKG.GET_SUB_UC_HEADER_ID(UC.CSI_ITEM_INSTANCE_ID)) A,
180: AHL_MC_RELATIONSHIPS MCR
181: WHERE MCR.MC_HEADER_ID(+) = A.MASTER_CONFIG_ID
182: AND nvl(MCR.PARENT_RELATIONSHIP_ID,-1) = -1;
183:

Line 634: IF (AHL_UTIL_UC_PKG.IS_UNIT_QUARANTINED(l_flight_schedules_tbl(f).UNIT_CONFIG_HEADER_ID,NULL) = FND_API.G_FALSE) THEN

630: END IF;
631:
632: IF l_flight_schedules_tbl.COUNT > 0 THEN
633: FOR f in l_flight_schedules_tbl.FIRST .. l_flight_schedules_tbl.LAST LOOP
634: IF (AHL_UTIL_UC_PKG.IS_UNIT_QUARANTINED(l_flight_schedules_tbl(f).UNIT_CONFIG_HEADER_ID,NULL) = FND_API.G_FALSE) THEN
635: l_fs_unit_sch_id_tbl(l_fs_index) := l_flight_schedules_tbl(f).UNIT_SCHEDULE_ID;
636: l_fs_arr_org_id_tbl(l_fs_index) := l_flight_schedules_tbl(f).ARRIVAL_ORG_ID;
637: l_fs_uc_header_id_tbl(l_fs_index) := l_flight_schedules_tbl(f).UNIT_CONFIG_HEADER_ID;
638: l_fs_csi_instance_id_tbl(l_fs_index) := l_flight_schedules_tbl(f).CSI_INSTANCE_ID;