APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_UMP_UTIL_PKG

Line 470: AHL_UMP_UTIL_PKG.get_first_accomplishment(

466:
467: IF (preceding_mr_csr%NOTFOUND) THEN
468: -- check if accomplishment exists for preceding MR to get UE Id.
469: -- Fix for bug# 6711228.
470: AHL_UMP_UTIL_PKG.get_first_accomplishment(
471: dependent_rec.preceding_csi_item_instance_id,
472: dependent_rec.preceding_mr_header_id,
473: l_last_accomplishment_date,
474: l_acc_unit_effectivity_id,

Line 601: l_visit_status_code := AHL_UMP_UTIL_PKG.get_visit_status (exception_rec.unit_effectivity_id);

597:
598: /*
599: -- If status code is INIT-DUE mark as exception.
600: IF (exception_rec.status_code = 'INIT-DUE') THEN
601: l_visit_status_code := AHL_UMP_UTIL_PKG.get_visit_status (exception_rec.unit_effectivity_id);
602: IF G_DEBUG = 'Y' THEN
603: AHL_DEBUG_PUB.Debug('Visit Status Code from VWP is:' || l_visit_status_code);
604: END IF;
605:

Line 624: AHL_UMP_UTIL_PKG.get_last_accomplishment(l_csi_item_instance_id,

620: END IF;
621:
622: ELSIF (exception_rec.status_code = 'INIT-ACCOMPLISHED') THEN
623: -- Check if accomplishments exist after init-accomplished.
624: AHL_UMP_UTIL_PKG.get_last_accomplishment(l_csi_item_instance_id,
625: exception_rec.mr_header_id,
626: l_last_accomplishment_date,
627: l_acc_unit_effectivity_id,
628: l_acc_status_code,

Line 674: l_visit_status_code := AHL_UMP_UTIL_PKG.get_visit_status (exception_rec.unit_effectivity_id);

670: */
671:
672: -- check if assigned to visit if not flagged for exception.
673: IF (AHL_UTIL_PKG.IS_PM_INSTALLED = 'N') THEN -- AHL Installation.
674: l_visit_status_code := AHL_UMP_UTIL_PKG.get_visit_status (exception_rec.unit_effectivity_id);
675: IF G_DEBUG = 'Y' THEN
676: AHL_DEBUG_PUB.Debug('Visit Status Code from VWP is:' || l_visit_status_code);
677: END IF;
678:

Line 714: AHL_UMP_UTIL_PKG.get_ServiceRequest_Details(exception_rec.unit_effectivity_id,

710: END IF;
711: END IF;
712: ELSE
713: -- PM Installation.
714: AHL_UMP_UTIL_PKG.get_ServiceRequest_Details(exception_rec.unit_effectivity_id,
715: l_incident_id,
716: l_incident_number,
717: l_scheduled_date);
718: IF G_DEBUG = 'Y' THEN

Line 1497: l_visit_status := AHL_UMP_UTIL_PKG.get_visit_status (p_temp_mr_rec.unit_effectivity_id);

1493:
1494: -- Set savepoint.
1495: SAVEPOINT update_group;
1496:
1497: l_visit_status := AHL_UMP_UTIL_PKG.get_visit_status (p_temp_mr_rec.unit_effectivity_id);
1498:
1499: IF (l_visit_status IN ('RELEASED','CLOSED')) THEN
1500: l_grp_match_found := TRUE; -- ignore matching group as UE on shop floor.
1501: -- update existing UE children.

Line 2469: l_visit_status := AHL_UMP_UTIL_PKG.get_Visit_Status (l_delete_ue_id_tbl(i));

2465:
2466: FOR i IN l_delete_ue_id_tbl.FIRST..l_delete_ue_id_tbl.LAST LOOP
2467:
2468: -- check if UE assigned to a visit.
2469: l_visit_status := AHL_UMP_UTIL_PKG.get_Visit_Status (l_delete_ue_id_tbl(i));
2470:
2471: -- only if visit is in planning status we must mark an exception.
2472: -- if visit is already on the floor, we do nothing.
2473: IF (l_visit_status = 'PLANNING') THEN