DBA Data[Home] [Help]

APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_UTIL_UC_PKG

Line 12378: l_uc_header_id := AHL_UTIL_UC_PKG.get_uc_header_id(p_prd_workorder_rec.ITEM_INSTANCE_ID);

12374: FETCH get_uc_from_visit into l_uc_header_id;
12375: CLOSE get_uc_from_visit;
12376:
12377: IF(l_uc_header_id IS NULL)THEN
12378: l_uc_header_id := AHL_UTIL_UC_PKG.get_uc_header_id(p_prd_workorder_rec.ITEM_INSTANCE_ID);
12379: END IF;
12380:
12381: l_nha_uc_header_id := AHL_UTIL_UC_PKG.get_sub_uc_header_id(p_prd_workorder_rec.ITEM_INSTANCE_ID);
12382: IF (p_prd_workorder_rec.visit_task_id IS NOT NULL) THEN

Line 12381: l_nha_uc_header_id := AHL_UTIL_UC_PKG.get_sub_uc_header_id(p_prd_workorder_rec.ITEM_INSTANCE_ID);

12377: IF(l_uc_header_id IS NULL)THEN
12378: l_uc_header_id := AHL_UTIL_UC_PKG.get_uc_header_id(p_prd_workorder_rec.ITEM_INSTANCE_ID);
12379: END IF;
12380:
12381: l_nha_uc_header_id := AHL_UTIL_UC_PKG.get_sub_uc_header_id(p_prd_workorder_rec.ITEM_INSTANCE_ID);
12382: IF (p_prd_workorder_rec.visit_task_id IS NOT NULL) THEN
12383:
12384: OPEN get_fleet_maintenance_csr(p_prd_workorder_rec.visit_task_id);
12385: FETCH get_fleet_maintenance_csr into l_fleet_header_id,l_unit_effectivity_id,l_maintenance_type_code;