APPS.AMS_DM_TARGET_PVT dependencies on AMS_DM_TARGET_SOURCES

Line 633: AMS_Dm_Target_Sources_PVT.delete_tgtsources_for_target ( p_TARGET_ID );

629:
630: AMS_UTILITY_PVT.debug_message( 'Private API: Going to Delete Child Data Sources Associated with this Target ');
631: END IF;
632:
633: AMS_Dm_Target_Sources_PVT.delete_tgtsources_for_target ( p_TARGET_ID );
634:
635: IF (AMS_DEBUG_HIGH_ON) THEN
636:
637:

Line 1590: from ams_dm_target_sources c

1586: where b.target_id=a.target_id
1587: and b.data_source_id=p_data_source_id)
1588: OR EXISTS
1589: (SELECT 1
1590: from ams_dm_target_sources c
1591: where c.target_id=a.target_id
1592: and c.data_source_id=p_data_source_id));
1593:
1594: End Handle_Data_Source_Disabling;

Line 1768: from ams_dm_target_sources c

1764: where b.target_id=a.target_id
1765: and b.data_source_id=p_master_source_id)
1766: OR EXISTS
1767: (SELECT 1
1768: from ams_dm_target_sources c
1769: where c.target_id=a.target_id
1770: and c.data_source_id=p_sub_source_id));
1771:
1772: DELETE FROM ams_dm_target_sources

Line 1772: DELETE FROM ams_dm_target_sources

1768: from ams_dm_target_sources c
1769: where c.target_id=a.target_id
1770: and c.data_source_id=p_sub_source_id));
1771:
1772: DELETE FROM ams_dm_target_sources
1773: WHERE target_id IN (SELECT target_id FROM ams_dm_targets_b WHERE data_source_id = p_master_source_id AND target_source_id <> p_sub_source_id)
1774: AND data_source_id = p_sub_source_id
1775: ;
1776: