DBA Data[Home] [Help]

APPS.AHL_UMP_PROCESSUNIT_PVT dependencies on AHL_UMP_UTIL_PKG

Line 671: AHL_UMP_UTIL_PKG.Populate_Appl_MRs ( p_csi_ii_id => l_csi_item_instance_id,

667: AHL_DEBUG_PUB.debug('AHL Installation processing');
668: END IF;
669:
670: -- Call FMP api to build applicable MRs for the unit.
671: AHL_UMP_UTIL_PKG.Populate_Appl_MRs ( p_csi_ii_id => l_csi_item_instance_id,
672: --p_include_doNotImplmt => 'N',
673: p_include_doNotImplmt => 'Y',
674: x_return_status => x_return_status,
675: x_msg_count => x_msg_count,

Line 685: AHL_UMP_UTIL_PKG.Process_Group_MRs;

681: RAISE FND_API.G_EXC_ERROR;
682: END IF;
683:
684: -- Build applicability for group MRs.
685: AHL_UMP_UTIL_PKG.Process_Group_MRs;
686:
687: ELSE -- for PM installation.
688: IF G_DEBUG = 'Y' THEN
689: AHL_DEBUG_PUB.debug('PM Installation processing');

Line 2591: AHL_UMP_UTIL_PKG.get_last_accomplishment(p_applicable_mrs_rec.csi_item_instance_id,

2587: ELSE
2588: -- Lookup if any accomplishments exist.
2589:
2590: -- Get last accomplishment for the MR..
2591: AHL_UMP_UTIL_PKG.get_last_accomplishment(p_applicable_mrs_rec.csi_item_instance_id,
2592: p_applicable_mrs_rec.mr_header_id,
2593: l_last_accomplishment_date,
2594: l_acc_unit_effectivity_id,
2595: l_acc_deferral_flag,

Line 2621: AHL_UMP_UTIL_PKG.get_first_accomplishment(p_applicable_mrs_rec.csi_item_instance_id,

2617: THEN
2618: l_dependent_mr_flag := TRUE;
2619: --dbms_output.put_line ('dependent flag true');
2620: -- Modified to get first accomplishment to fix bug#6711228
2621: AHL_UMP_UTIL_PKG.get_first_accomplishment(p_applicable_mrs_rec.csi_item_instance_id,
2622: p_applicable_mrs_rec.preceding_mr_header_id,
2623: l_last_accomplishment_date,
2624: l_acc_unit_effectivity_id,
2625: l_acc_deferral_flag,

Line 3042: AHL_UMP_UTIL_PKG.get_visit_details (l_unit_effectivity_tbl(i).unit_effectivity_id,

3038: l_unit_effectivity_tbl(i).related_ue_id := l_related_ue_tbl(j);
3039: l_unit_effectivity_tbl(i).originator_ue_id := l_orig_ue_tbl(j);
3040:
3041: -- Call visit work package to get visit end date if unit effectivity has been assigned to a visit.
3042: AHL_UMP_UTIL_PKG.get_visit_details (l_unit_effectivity_tbl(i).unit_effectivity_id,
3043: l_visit_start_date,
3044: l_visit_end_date,
3045: l_visit_assign_code);
3046:

Line 3082: AHL_UMP_UTIL_PKG.get_visit_details (ahl_unplanned_MRs_rec.unit_effectivity_id,

3078: FOR ahl_unplanned_MRs_rec IN ahl_unplanned_MRs_csr(p_applicable_mrs_rec.csi_item_instance_id,
3079: p_applicable_mrs_rec.mr_header_id)
3080: LOOP
3081: -- Get visit end date; unplanned MRs is always assigned to a visit.
3082: AHL_UMP_UTIL_PKG.get_visit_details (ahl_unplanned_MRs_rec.unit_effectivity_id,
3083: l_visit_start_date,
3084: l_visit_end_date,
3085: l_visit_assign_code);
3086: IF (l_visit_end_date IS NOT NULL) THEN

Line 6212: l_visit_status := AHL_UMP_UTIL_PKG.get_Visit_Status (l_unit_effectivity_id);

6208: l_reln_found := TRUE; /* ue_relns record found */
6209: l_appl_grp_found := TRUE; /* applicable grp mrs found */
6210:
6211: -- Check if workorder already created.
6212: l_visit_status := AHL_UMP_UTIL_PKG.get_Visit_Status (l_unit_effectivity_id);
6213:
6214: -- when UE is on shop floor or UE status is INIT-DUE, skip group MR comparison.
6215: -- This will be done later in flush_from_temp_table proc.
6216: IF (p_unit_effectivity_tbl(p_old_UE_forecast_sequence).status_code) = 'INIT-DUE'

Line 8898: AHL_UMP_UTIL_PKG.get_visit_details (unit_effectivity_rec.unit_effectivity_id,

8894:
8895: END IF; -- unit_effectivity_rec.unit_deferral_type = 'MEL'
8896:
8897: -- Call visit work package to get visit end date if unit effectivity has been assigned to a visit.
8898: AHL_UMP_UTIL_PKG.get_visit_details (unit_effectivity_rec.unit_effectivity_id,
8899: l_visit_start_date,
8900: l_visit_end_date,
8901: l_visit_assign_code);
8902:

Line 8939: l_visit_status := AHL_UMP_UTIL_PKG.get_Visit_Status(unit_effectivity_rec.unit_effectivity_id);

8935: --dbms_output.put_line ('Adue_ctr_val:' || l_calc_due_counter_value);
8936:
8937:
8938: -- Check if workorder already created.
8939: l_visit_status := AHL_UMP_UTIL_PKG.get_Visit_Status(unit_effectivity_rec.unit_effectivity_id);
8940:
8941: IF (nvl(l_visit_status,'X') IN ('RELEASED','CLOSED')) THEN
8942: -- if UE is on shop floor then keep UE structure as is.
8943: l_grp_match := 'Y';

Line 9151: AHL_UMP_UTIL_PKG.get_visit_details (ahl_ue_sr_rec.unit_effectivity_id,

9147: -- Get all UE's with object-type = SR.
9148: FOR ahl_ue_sr_rec IN ahl_ue_sr_csr(p_csi_item_instance_id) LOOP
9149:
9150: -- Call visit work package to get visit end date if unit effectivity has been assigned to a visit.
9151: AHL_UMP_UTIL_PKG.get_visit_details (ahl_ue_sr_rec.unit_effectivity_id,
9152: l_visit_start_date,
9153: l_visit_end_date,
9154: l_visit_assign_code);
9155:

Line 9179: l_visit_status := AHL_UMP_UTIL_PKG.get_Visit_Status(ahl_ue_sr_rec.unit_effectivity_id);

9175: END IF;
9176: END IF;
9177:
9178: -- Check if workorder already created.
9179: l_visit_status := AHL_UMP_UTIL_PKG.get_Visit_Status(ahl_ue_sr_rec.unit_effectivity_id);
9180:
9181: IF (nvl(l_visit_status,'X') IN ('RELEASED','CLOSED')) THEN
9182: -- if UE is on shop floor then keep UE structure as is.
9183: l_grp_match := 'Y';

Line 9592: l_visit_status := AHL_UMP_UTIL_PKG.get_Visit_Status (ahl_unplanned_ue_rec.unit_effectivity_id);

9588: -- initialize.
9589: l_exception_flag := FALSE;
9590:
9591: -- Check if workorder already created.
9592: l_visit_status := AHL_UMP_UTIL_PKG.get_Visit_Status (ahl_unplanned_ue_rec.unit_effectivity_id);
9593:
9594: -- only if visit is in planning status we must mark an exception.
9595: -- if visit is already on the floor, we do nothing.
9596: IF (nvl(l_visit_status,'X') NOT IN ('RELEASED','CLOSED')) THEN