APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UNIT_EFFECTIVITIES_PKG

Line 2829: AHL_UNIT_EFFECTIVITIES_PKG.update_row(

2825: l_ue_rec.ATTRIBUTE15 := p_unit_Effectivity_rec.ATTRIBUTE15;
2826: END IF;
2827:
2828: -- Call Table Handler to update record
2829: AHL_UNIT_EFFECTIVITIES_PKG.update_row(
2830: x_unit_effectivity_id => p_unit_Effectivity_rec.UNIT_EFFECTIVITY_ID,
2831: x_csi_item_instance_id => l_ue_rec.CSI_ITEM_INSTANCE_ID,
2832: x_mr_interval_id => l_ue_rec.MR_INTERVAL_ID,
2833: x_mr_effectivity_id => l_ue_rec.MR_EFFECTIVITY_ID,

Line 3153: AHL_UNIT_EFFECTIVITIES_PKG.update_row(

3149: FETCH l_get_unit_effectivity_csr INTO l_ue_rec;
3150: CLOSE l_get_unit_effectivity_csr;
3151:
3152: -- Call Table Handler to update record
3153: AHL_UNIT_EFFECTIVITIES_PKG.update_row(
3154: x_unit_effectivity_id => p_descendent_ue_id,
3155: x_csi_item_instance_id => l_ue_rec.CSI_ITEM_INSTANCE_ID,
3156: x_mr_interval_id => l_ue_rec.MR_INTERVAL_ID,
3157: x_mr_effectivity_id => l_ue_rec.MR_EFFECTIVITY_ID,

Line 4573: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW (

4569:
4570: IF G_DEBUG='Y' THEN
4571: AHL_DEBUG_PUB.debug('before update record status to MR-TERMINATE');
4572: END IF;
4573: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW (
4574: x_unit_effectivity_id => l_ue_rec.UNIT_EFFECTIVITY_ID,
4575: x_csi_item_instance_id => l_ue_rec.CSI_ITEM_INSTANCE_ID,
4576: x_mr_interval_id => l_ue_rec.MR_INTERVAL_ID ,
4577: x_MR_EFFECTIVITY_ID => l_ue_rec.MR_EFFECTIVITY_ID ,

Line 4648: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW (

4644: END IF;
4645: l_ue_descendent_rec.STATUS_CODE := 'MR-TERMINATE';
4646: l_ue_descendent_rec.MESSAGE_CODE := 'TERMINATE-W-NEW-REV';
4647: l_ue_descendent_rec.ACCOMPLISHED_DATE := SYSDATE;
4648: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW (
4649: x_unit_effectivity_id => l_ue_descendent_rec.UNIT_EFFECTIVITY_ID,
4650: x_csi_item_instance_id => l_ue_descendent_rec.CSI_ITEM_INSTANCE_ID,
4651: x_mr_interval_id => l_ue_descendent_rec.MR_INTERVAL_ID ,
4652: x_MR_EFFECTIVITY_ID => l_ue_descendent_rec.MR_EFFECTIVITY_ID ,

Line 4724: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW (

4720:
4721: IF G_DEBUG='Y' THEN
4722: AHL_DEBUG_PUB.debug('Before update record status to EXCEPTION');
4723: END IF;
4724: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW (
4725: x_unit_effectivity_id => l_ue_rec.UNIT_EFFECTIVITY_ID,
4726: x_csi_item_instance_id => l_ue_rec.CSI_ITEM_INSTANCE_ID,
4727: x_mr_interval_id => l_ue_rec.MR_INTERVAL_ID ,
4728: x_MR_EFFECTIVITY_ID => l_ue_rec.MR_EFFECTIVITY_ID ,

Line 4799: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW (

4795:
4796: IF G_DEBUG='Y' THEN
4797: AHL_DEBUG_PUB.debug('start update status to Exception descedant ue_id' || l_ue_descendent_rec.UNIT_EFFECTIVITY_ID);
4798: END IF;
4799: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW (
4800: x_unit_effectivity_id => l_ue_descendent_rec.UNIT_EFFECTIVITY_ID,
4801: x_csi_item_instance_id => l_ue_descendent_rec.CSI_ITEM_INSTANCE_ID,
4802: x_mr_interval_id => l_ue_descendent_rec.MR_INTERVAL_ID ,
4803: x_MR_EFFECTIVITY_ID => l_ue_descendent_rec.MR_EFFECTIVITY_ID ,

Line 4861: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(l_ue_rec.UNIT_EFFECTIVITY_ID);

4857: END LOOP;
4858: CLOSE l_ue_descendent_csr;
4859:
4860: ELSE
4861: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(l_ue_rec.UNIT_EFFECTIVITY_ID);
4862:
4863: --Delete Descendants effectivities
4864: OPEN l_ue_descendent_csr(l_ue_rec.UNIT_EFFECTIVITY_ID);
4865: LOOP

Line 4872: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(l_ue_descendent_rec.UNIT_EFFECTIVITY_ID);

4868:
4869: IF G_DEBUG='Y' THEN
4870: AHL_DEBUG_PUB.debug('start delete descedant ue_id' ||l_ue_descendent_rec.UNIT_EFFECTIVITY_ID);
4871: END IF;
4872: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(l_ue_descendent_rec.UNIT_EFFECTIVITY_ID);
4873: END LOOP;
4874: CLOSE l_ue_descendent_csr;
4875:
4876: END IF;

Line 4992: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (

4988: CLOSE unit_deferral_id_csr;
4989: END IF;
4990:
4991: IF(l_copy_record)THEN
4992: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (
4993: X_ROWID => l_rowid,
4994: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,
4995: X_CSI_ITEM_INSTANCE_ID => cp_ue_rec.csi_item_instance_id,
4996: X_MR_INTERVAL_ID => cp_ue_rec.mr_interval_id,

Line 5644: AHL_UNIT_EFFECTIVITIES_PKG.update_row(

5640: l_ue_rec.MESSAGE_CODE := 'TERMINATE-W-NEW-REV';
5641: l_ue_rec.ACCOMPLISHED_DATE := SYSDATE;
5642:
5643: -- Call Table Handler to update record
5644: AHL_UNIT_EFFECTIVITIES_PKG.update_row(
5645: x_unit_effectivity_id => p_unit_effectivity_id,
5646: x_csi_item_instance_id => l_ue_rec.CSI_ITEM_INSTANCE_ID,
5647: x_mr_interval_id => l_ue_rec.MR_INTERVAL_ID,
5648: x_mr_effectivity_id => l_ue_rec.MR_EFFECTIVITY_ID,