APPS.AHL_UMP_UNPLANNED_PVT dependencies on AHL_UE_RELATIONSHIPS_PKG

Line 617: AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW

613: END IF;
614:
615: SELECT AHL_UE_RELATIONSHIPS_S.NEXTVAL INTO l_ue_relationship_id FROM DUAL;
616:
617: AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW
618: (
619: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
620: X_UE_ID => l_unit_effectivity_id,
621: X_RELATED_UE_ID => l_appl_mrs_relns.ue_id,

Line 650: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW for Related MRs from AHL_APPLICABLE_MR_RELNS' );

646: );
647: END LOOP;
648:
649: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
650: FND_LOG.STRING(G_DEBUG_STMT, L_DEBUG_MODULE , ' AFTER Calling AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW for Related MRs from AHL_APPLICABLE_MR_RELNS' );
651: END IF;
652: END IF;
653:
654:

Line 902: AHL_UE_RELATIONSHIPS_PKG.DELETE_ROW( l_all_ue_ids.UE_RELATIONSHIP_ID);

898: CLOSE GetStatusCode;
899: IF ( l_get_status_code IS NULL OR l_get_status_code IN ('EXCEPTION') )
900: THEN
901: -- delete the corresponding relationships records too.
902: AHL_UE_RELATIONSHIPS_PKG.DELETE_ROW( l_all_ue_ids.UE_RELATIONSHIP_ID);
903: -- deletes all related ue ids of the originator ue id of the ue id passed for deletion.
904: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW( l_all_ue_ids.RELATED_UE_ID);
905:
906: ELSE