APPS.AHL_PRD_DF_PVT dependencies on AHL_UNIT_EFFECTIVITIES_PKG

Line 4434: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (

4430: -- copy records here
4431: l_new_unit_effectivity_id := NULL;
4432: l_rowid := NULL;
4433:
4434: AHL_UNIT_EFFECTIVITIES_PKG.Insert_Row (
4435: X_ROWID => l_rowid,
4436: X_UNIT_EFFECTIVITY_ID => l_new_unit_effectivity_id,
4437: X_CSI_ITEM_INSTANCE_ID => ue_rec.csi_item_instance_id,
4438: X_MR_HEADER_ID => ue_rec.mr_header_id,

Line 4519: AHL_UNIT_EFFECTIVITIES_PKG.update_row(

4515: ELSE
4516: l_update_status := ue_rec.status_code;
4517: END IF;
4518: -- update status here
4519: AHL_UNIT_EFFECTIVITIES_PKG.update_row(
4520: x_unit_effectivity_id => ue_rec.UNIT_EFFECTIVITY_ID,
4521: x_csi_item_instance_id => ue_rec.CSI_ITEM_INSTANCE_ID,
4522: x_mr_interval_id => ue_rec.MR_INTERVAL_ID,
4523: x_mr_effectivity_id => ue_rec.MR_EFFECTIVITY_ID,

Line 4718: AHL_UNIT_EFFECTIVITIES_PKG.update_row(

4714: --update applicable unit deferral id for all children
4715: -- and removing it if deferral got rejected.
4716: IF(ue_rec.UNIT_EFFECTIVITY_ID <> l_unit_effectivity_id)THEN
4717: -- update status here
4718: AHL_UNIT_EFFECTIVITIES_PKG.update_row(
4719: x_unit_effectivity_id => ue_rec.UNIT_EFFECTIVITY_ID,
4720: x_csi_item_instance_id => ue_rec.CSI_ITEM_INSTANCE_ID,
4721: x_mr_interval_id => ue_rec.MR_INTERVAL_ID,
4722: x_mr_effectivity_id => ue_rec.MR_EFFECTIVITY_ID,

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

4879: OPEN assigned_to_visit_csr(ue_id_rec.unit_effectivity_id);
4880: FETCH assigned_to_visit_csr INTO l_exists;
4881: IF(assigned_to_visit_csr%NOTFOUND)THEN
4882: -- if not assigned to a visit delete the ue rec and relationships
4883: AHL_UNIT_EFFECTIVITIES_PKG.delete_row(ue_id_rec.unit_effectivity_id);
4884: OPEN ue_rel_id_csr(ue_id_rec.unit_effectivity_id);
4885: FETCH ue_rel_id_csr INTO l_ue_relationship_id;
4886: IF(ue_rel_id_csr%FOUND) THEN
4887: AHL_UE_RELATIONSHIPS_PKG.delete_row(l_ue_relationship_id);

Line 4893: AHL_UNIT_EFFECTIVITIES_PKG.update_row(

4889: CLOSE ue_rel_id_csr;
4890: ELSE -- assigned to visit -- mark as exception
4891: FOR ue_rec IN unit_effectivity_csr(ue_id_rec.unit_effectivity_id) LOOP
4892: -- update status
4893: AHL_UNIT_EFFECTIVITIES_PKG.update_row(
4894: x_unit_effectivity_id => ue_rec.UNIT_EFFECTIVITY_ID,
4895: x_csi_item_instance_id => ue_rec.CSI_ITEM_INSTANCE_ID,
4896: x_mr_interval_id => ue_rec.MR_INTERVAL_ID,
4897: x_mr_effectivity_id => ue_rec.MR_EFFECTIVITY_ID,