APPS.AHL_UMP_UNITMAINT_PVT dependencies on AHL_UNIT_EFFECTIVITIES_PKG

Line 2519: AHL_UNIT_EFFECTIVITIES_PKG.update_row(

2515: l_ue_rec.ATTRIBUTE15 := p_unit_Effectivity_rec.ATTRIBUTE15;
2516: END IF;
2517:
2518: -- Call Table Handler to update record
2519: AHL_UNIT_EFFECTIVITIES_PKG.update_row(
2520: x_unit_effectivity_id => p_unit_Effectivity_rec.UNIT_EFFECTIVITY_ID,
2521: x_csi_item_instance_id => l_ue_rec.CSI_ITEM_INSTANCE_ID,
2522: x_mr_interval_id => l_ue_rec.MR_INTERVAL_ID,
2523: x_mr_effectivity_id => l_ue_rec.MR_EFFECTIVITY_ID,

Line 2841: AHL_UNIT_EFFECTIVITIES_PKG.update_row(

2837: FETCH l_get_unit_effectivity_csr INTO l_ue_rec;
2838: CLOSE l_get_unit_effectivity_csr;
2839:
2840: -- Call Table Handler to update record
2841: AHL_UNIT_EFFECTIVITIES_PKG.update_row(
2842: x_unit_effectivity_id => p_descendent_ue_id,
2843: x_csi_item_instance_id => l_ue_rec.CSI_ITEM_INSTANCE_ID,
2844: x_mr_interval_id => l_ue_rec.MR_INTERVAL_ID,
2845: x_mr_effectivity_id => l_ue_rec.MR_EFFECTIVITY_ID,

Line 4249: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW (

4245:
4246: IF G_DEBUG='Y' THEN
4247: AHL_DEBUG_PUB.debug('before update record status to MR-TERMINATE');
4248: END IF;
4249: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW (
4250: x_unit_effectivity_id => l_ue_rec.UNIT_EFFECTIVITY_ID,
4251: x_csi_item_instance_id => l_ue_rec.CSI_ITEM_INSTANCE_ID,
4252: x_mr_interval_id => l_ue_rec.MR_INTERVAL_ID ,
4253: x_MR_EFFECTIVITY_ID => l_ue_rec.MR_EFFECTIVITY_ID ,

Line 4324: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW (

4320: END IF;
4321: l_ue_descendent_rec.STATUS_CODE := 'MR-TERMINATE';
4322: l_ue_descendent_rec.MESSAGE_CODE := 'TERMINATE-W-NEW-REV';
4323: l_ue_descendent_rec.ACCOMPLISHED_DATE := SYSDATE;
4324: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW (
4325: x_unit_effectivity_id => l_ue_descendent_rec.UNIT_EFFECTIVITY_ID,
4326: x_csi_item_instance_id => l_ue_descendent_rec.CSI_ITEM_INSTANCE_ID,
4327: x_mr_interval_id => l_ue_descendent_rec.MR_INTERVAL_ID ,
4328: x_MR_EFFECTIVITY_ID => l_ue_descendent_rec.MR_EFFECTIVITY_ID ,

Line 4400: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW (

4396:
4397: IF G_DEBUG='Y' THEN
4398: AHL_DEBUG_PUB.debug('Before update record status to EXCEPTION');
4399: END IF;
4400: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW (
4401: x_unit_effectivity_id => l_ue_rec.UNIT_EFFECTIVITY_ID,
4402: x_csi_item_instance_id => l_ue_rec.CSI_ITEM_INSTANCE_ID,
4403: x_mr_interval_id => l_ue_rec.MR_INTERVAL_ID ,
4404: x_MR_EFFECTIVITY_ID => l_ue_rec.MR_EFFECTIVITY_ID ,

Line 4475: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW (

4471:
4472: IF G_DEBUG='Y' THEN
4473: AHL_DEBUG_PUB.debug('start update status to Exception descedant ue_id' || l_ue_descendent_rec.UNIT_EFFECTIVITY_ID);
4474: END IF;
4475: AHL_UNIT_EFFECTIVITIES_PKG.UPDATE_ROW (
4476: x_unit_effectivity_id => l_ue_descendent_rec.UNIT_EFFECTIVITY_ID,
4477: x_csi_item_instance_id => l_ue_descendent_rec.CSI_ITEM_INSTANCE_ID,
4478: x_mr_interval_id => l_ue_descendent_rec.MR_INTERVAL_ID ,
4479: x_MR_EFFECTIVITY_ID => l_ue_descendent_rec.MR_EFFECTIVITY_ID ,

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

4533: END LOOP;
4534: CLOSE l_ue_descendent_csr;
4535:
4536: ELSE
4537: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(l_ue_rec.UNIT_EFFECTIVITY_ID);
4538:
4539: --Delete Descendants effectivities
4540: OPEN l_ue_descendent_csr(l_ue_rec.UNIT_EFFECTIVITY_ID);
4541: LOOP

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

4544:
4545: IF G_DEBUG='Y' THEN
4546: AHL_DEBUG_PUB.debug('start delete descedant ue_id' ||l_ue_descendent_rec.UNIT_EFFECTIVITY_ID);
4547: END IF;
4548: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(l_ue_descendent_rec.UNIT_EFFECTIVITY_ID);
4549: END LOOP;
4550: CLOSE l_ue_descendent_csr;
4551:
4552: END IF;

Line 4658: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (

4654: CLOSE unit_deferral_id_csr;
4655: END IF;
4656:
4657: IF(l_copy_record)THEN
4658: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (
4659: X_ROWID => l_rowid,
4660: X_UNIT_EFFECTIVITY_ID => l_unit_effectivity_id,
4661: X_CSI_ITEM_INSTANCE_ID => cp_ue_rec.csi_item_instance_id,
4662: X_MR_INTERVAL_ID => cp_ue_rec.mr_interval_id,

Line 5273: AHL_UNIT_EFFECTIVITIES_PKG.update_row(

5269: l_ue_rec.MESSAGE_CODE := 'TERMINATE-W-NEW-REV';
5270: l_ue_rec.ACCOMPLISHED_DATE := SYSDATE;
5271:
5272: -- Call Table Handler to update record
5273: AHL_UNIT_EFFECTIVITIES_PKG.update_row(
5274: x_unit_effectivity_id => p_unit_effectivity_id,
5275: x_csi_item_instance_id => l_ue_rec.CSI_ITEM_INSTANCE_ID,
5276: x_mr_interval_id => l_ue_rec.MR_INTERVAL_ID,
5277: x_mr_effectivity_id => l_ue_rec.MR_EFFECTIVITY_ID,