APPS.AHL_UMP_UNPLANNED_PVT dependencies on AHL_UE_RELATIONSHIPS_PKG

Line 543: AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW

539: END IF;
540:
541: SELECT AHL_UE_RELATIONSHIPS_S.NEXTVAL INTO l_ue_relationship_id FROM DUAL;
542:
543: AHL_UE_RELATIONSHIPS_PKG.INSERT_ROW
544: (
545: X_UE_RELATIONSHIP_ID => l_ue_relationship_id,
546: X_UE_ID => l_unit_effectivity_id,
547: X_RELATED_UE_ID => l_appl_mrs_relns.ue_id,

Line 576: 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' );

572: );
573: END LOOP;
574:
575: IF (G_DEBUG_STMT >= G_DEBUG_LEVEL) THEN
576: 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' );
577: END IF;
578: END IF;
579:
580:

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

824: CLOSE GetStatusCode;
825: IF ( l_get_status_code IS NULL OR l_get_status_code IN ('EXCEPTION') )
826: THEN
827: -- delete the corresponding relationships records too.
828: AHL_UE_RELATIONSHIPS_PKG.DELETE_ROW( l_all_ue_ids.UE_RELATIONSHIP_ID);
829: -- deletes all related ue ids of the originator ue id of the ue id passed for deletion.
830: AHL_UNIT_EFFECTIVITIES_PKG.DELETE_ROW( l_all_ue_ids.RELATED_UE_ID);
831:
832: ELSE