APPS.AHL_PRD_DF_PVT dependencies on AHL_UNIT_EFFECTIVITIES_PKG

Line 4860: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (

4856: l_MR_INTERVAL_ID := NULL;
4857: l_DATE_RUN := NULL;
4858: END IF;
4859:
4860: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (
4861: X_ROWID => l_rowid,
4862: X_UNIT_EFFECTIVITY_ID => l_new_unit_effectivity_id,
4863: X_CSI_ITEM_INSTANCE_ID => ue_rec.csi_item_instance_id,
4864: X_MR_HEADER_ID => l_mr_header_id,--ue_rec.mr_header_id,

Line 4976: AHL_UNIT_EFFECTIVITIES_PKG.update_row(

4972: 'ahl.plsql.AHL_PRD_DF_PVT.process_unit_maint_plan',
4973: 'updating UMP :l_update_status : ' || l_update_status
4974: );
4975: END IF;
4976: AHL_UNIT_EFFECTIVITIES_PKG.update_row(
4977: x_unit_effectivity_id => ue_rec.UNIT_EFFECTIVITY_ID,
4978: x_csi_item_instance_id => ue_rec.CSI_ITEM_INSTANCE_ID,
4979: x_mr_interval_id => ue_rec.MR_INTERVAL_ID,
4980: x_mr_effectivity_id => ue_rec.MR_EFFECTIVITY_ID,

Line 5096: AHL_UNIT_EFFECTIVITIES_PKG.update_row(

5092: --update applicable unit deferral id for all children
5093: -- and removing it if deferral got rejected.
5094: IF(ue_rec.UNIT_EFFECTIVITY_ID <> l_unit_effectivity_id)THEN
5095: -- update status here
5096: AHL_UNIT_EFFECTIVITIES_PKG.update_row(
5097: x_unit_effectivity_id => ue_rec.UNIT_EFFECTIVITY_ID,
5098: x_csi_item_instance_id => ue_rec.CSI_ITEM_INSTANCE_ID,
5099: x_mr_interval_id => ue_rec.MR_INTERVAL_ID,
5100: x_mr_effectivity_id => ue_rec.MR_EFFECTIVITY_ID,

Line 5261: AHL_UNIT_EFFECTIVITIES_PKG.delete_row(ue_id_rec.unit_effectivity_id);

5257: OPEN assigned_to_visit_csr(ue_id_rec.unit_effectivity_id);
5258: FETCH assigned_to_visit_csr INTO l_exists;
5259: IF(assigned_to_visit_csr%NOTFOUND)THEN
5260: -- if not assigned to a visit delete the ue rec and relationships
5261: AHL_UNIT_EFFECTIVITIES_PKG.delete_row(ue_id_rec.unit_effectivity_id);
5262: OPEN ue_rel_id_csr(ue_id_rec.unit_effectivity_id);
5263: FETCH ue_rel_id_csr INTO l_ue_relationship_id;
5264: IF(ue_rel_id_csr%FOUND) THEN
5265: AHL_UE_RELATIONSHIPS_PKG.delete_row(l_ue_relationship_id);

Line 5271: AHL_UNIT_EFFECTIVITIES_PKG.update_row(

5267: CLOSE ue_rel_id_csr;
5268: ELSE -- assigned to visit -- mark as exception
5269: FOR ue_rec IN unit_effectivity_csr(ue_id_rec.unit_effectivity_id) LOOP
5270: -- update status
5271: AHL_UNIT_EFFECTIVITIES_PKG.update_row(
5272: x_unit_effectivity_id => ue_rec.UNIT_EFFECTIVITY_ID,
5273: x_csi_item_instance_id => ue_rec.CSI_ITEM_INSTANCE_ID,
5274: x_mr_interval_id => ue_rec.MR_INTERVAL_ID,
5275: x_mr_effectivity_id => ue_rec.MR_EFFECTIVITY_ID,