APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_UE_RELATIONSHIPS_PKG

Line 901: AHL_UE_RELATIONSHIPS_PKG.Delete_Row (ue_reln_rec.ue_relationship_id);

897:
898: FOR ue_reln_rec IN decendent_csr(exception_rec.unit_effectivity_id) LOOP
899:
900: -- delete relationship.
901: AHL_UE_RELATIONSHIPS_PKG.Delete_Row (ue_reln_rec.ue_relationship_id);
902: -- delete unit effectivity record.
903: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(ue_reln_rec.related_ue_id);
904:
905: -- Delete the corresponding rows in ahl_schedule materials for this ue.

Line 1285: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(

1281: END IF;
1282: CLOSE ahl_temp_parent_csr;
1283:
1284: -- Insert into ahl_ue_relationships.
1285: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
1286: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
1287: X_UE_ID => l_parent_ue_id,
1288: X_RELATED_UE_ID => l_temp_grp_rec.unit_effectivity_id,
1289: X_RELATIONSHIP_CODE => 'PARENT',

Line 2314: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(

2310: END IF;
2311: CLOSE ahl_temp_parent_csr;
2312:
2313: -- Insert into ahl_ue_relationships.
2314: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
2315: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
2316: X_UE_ID => l_parent_ue_id,
2317: X_RELATED_UE_ID => ahl_temp_rec.unit_effectivity_id,
2318: X_RELATIONSHIP_CODE => 'PARENT',

Line 2426: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(

2422:
2423: CLOSE ahl_unit_effectivity_csr;
2424:
2425: -- Now create the relationship record.
2426: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
2427: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
2428: X_UE_ID => l_parent_ue_id,
2429: X_RELATED_UE_ID => l_unit_effectivity_id,
2430: X_RELATIONSHIP_CODE => 'PARENT',