APPS.AHL_UMP_PROCESSUNIT_EXTN_PVT dependencies on AHL_UE_RELATIONSHIPS_PKG

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

1268:
1269: FOR ue_reln_rec IN decendent_csr(exception_rec.unit_effectivity_id) LOOP
1270:
1271: -- delete relationship.
1272: AHL_UE_RELATIONSHIPS_PKG.Delete_Row (ue_reln_rec.ue_relationship_id);
1273: -- delete unit effectivity record.
1274: AHL_UNIT_EFFECTIVITIES_PKG.Delete_Row(ue_reln_rec.related_ue_id);
1275:
1276: -- Delete the corresponding rows in ahl_schedule materials for this ue.

Line 1685: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(

1681: END IF;
1682: CLOSE ahl_temp_parent_csr;
1683:
1684: -- Insert into ahl_ue_relationships.
1685: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
1686: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
1687: X_UE_ID => l_parent_ue_id,
1688: X_RELATED_UE_ID => l_temp_grp_rec.unit_effectivity_id,
1689: X_RELATIONSHIP_CODE => 'PARENT',

Line 2742: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(

2738: END IF;
2739: CLOSE ahl_temp_parent_csr;
2740:
2741: -- Insert into ahl_ue_relationships.
2742: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
2743: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
2744: X_UE_ID => l_parent_ue_id,
2745: X_RELATED_UE_ID => ahl_temp_rec.unit_effectivity_id,
2746: X_RELATIONSHIP_CODE => 'PARENT',

Line 2853: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(

2849:
2850: CLOSE ahl_unit_effectivity_csr;
2851:
2852: -- Now create the relationship record.
2853: AHL_UE_RELATIONSHIPS_PKG.Insert_Row(
2854: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
2855: X_UE_ID => l_parent_ue_id,
2856: X_RELATED_UE_ID => l_unit_effectivity_id,
2857: X_RELATIONSHIP_CODE => 'PARENT',