APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_UMP_UTIL_PKG

Line 747: AHL_UMP_UTIL_PKG.get_first_accomplishment(

743: * added to cursor dependent_mr_csr
744: IF (preceding_mr_csr%NOTFOUND) THEN
745: -- check if accomplishment exists for preceding MR to get UE Id.
746: -- Fix for bug# 6711228.
747: AHL_UMP_UTIL_PKG.get_first_accomplishment(
748: dependent_rec.preceding_csi_item_instance_id,
749: dependent_rec.preceding_mr_header_id,
750: l_last_accomplishment_date,
751: l_acc_unit_effectivity_id,

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

945:
946: /*
947: -- If status code is INIT-DUE mark as exception.
948: IF (exception_rec.status_code = 'INIT-DUE') THEN
949: l_visit_status_code := AHL_UMP_UTIL_PKG.get_visit_status (exception_rec.unit_effectivity_id);
950: IF G_DEBUG = 'Y' THEN
951: AHL_DEBUG_PUB.Debug('Visit Status Code from VWP is:' || l_visit_status_code);
952: END IF;
953:

Line 972: AHL_UMP_UTIL_PKG.get_last_accomplishment(l_csi_item_instance_id,

968: END IF;
969:
970: ELSIF (exception_rec.status_code = 'INIT-ACCOMPLISHED') THEN
971: -- Check if accomplishments exist after init-accomplished.
972: AHL_UMP_UTIL_PKG.get_last_accomplishment(l_csi_item_instance_id,
973: exception_rec.mr_header_id,
974: l_last_accomplishment_date,
975: l_acc_unit_effectivity_id,
976: l_acc_status_code,

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

1018: */
1019:
1020: -- check if assigned to visit if not flagged for exception.
1021: IF (AHL_UTIL_PKG.IS_PM_INSTALLED = 'N') THEN -- AHL Installation.
1022: l_visit_status_code := AHL_UMP_UTIL_PKG.get_visit_status (exception_rec.unit_effectivity_id);
1023: IF G_DEBUG = 'Y' THEN
1024: AHL_DEBUG_PUB.Debug('Visit Status Code from VWP is:' || l_visit_status_code);
1025: END IF;
1026:

Line 1078: AHL_UMP_UTIL_PKG.get_ServiceRequest_Details(exception_rec.unit_effectivity_id,

1074: END IF;
1075: END IF;
1076: ELSE
1077: -- PM Installation.
1078: AHL_UMP_UTIL_PKG.get_ServiceRequest_Details(exception_rec.unit_effectivity_id,
1079: l_incident_id,
1080: l_incident_number,
1081: l_scheduled_date);
1082: IF G_DEBUG = 'Y' THEN

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

1893:
1894: -- Set savepoint.
1895: SAVEPOINT update_group;
1896:
1897: l_visit_status := AHL_UMP_UTIL_PKG.get_visit_status (p_temp_mr_rec.unit_effectivity_id);
1898:
1899: IF (l_visit_status IN ('RELEASED','CLOSED')) THEN
1900: l_grp_match_found := TRUE; -- ignore matching group as UE on shop floor.
1901: -- update existing UE children.

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

2892:
2893: FOR i IN l_delete_ue_id_tbl.FIRST..l_delete_ue_id_tbl.LAST LOOP
2894:
2895: -- check if UE assigned to a visit.
2896: l_visit_status := AHL_UMP_UTIL_PKG.get_Visit_Status (l_delete_ue_id_tbl(i));
2897:
2898: -- only if visit is in planning status we must mark an exception.
2899: -- if visit is already on the floor, we do nothing.
2900: IF (l_visit_status = 'PLANNING') THEN