eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_DM_TARGET_PVT dependencies on AMS_LIST_SRC_TYPES

Line 187: update ams_list_src_types

183: /* obsoleted rosharma 11.5.10 for Audience data source uptake
184: -- After successfully inserting the Target, enable the data source
185: -- associated with it if the target is active
186: IF l_dm_target_rec.active_flag = 'Y' THEN
187: update ams_list_src_types
188: set enabled_flag = 'Y'
189: where list_source_type_id = l_dm_target_rec.data_source_id;
190: END IF;
191: */

Line 672: update ams_list_src_types

668: FETCH c_target_count INTO l_no_of_active_targets;
669: CLOSE c_target_count;
670:
671: IF l_no_of_active_targets = 0 THEN
672: update ams_list_src_types
673: set enabled_flag = 'N'
674: where list_source_type_id = l_datasource_id;
675: END IF;
676: */

Line 1081: 'ams_list_src_types',

1077:
1078: --------------------data_source_id---------------------------
1079: IF p_dm_target_rec.data_source_id <> FND_API.g_miss_num THEN
1080: IF AMS_Utility_PVT.check_fk_exists(
1081: 'ams_list_src_types',
1082: 'list_source_type_id',
1083: p_dm_target_rec.data_source_id
1084: ) = FND_API.g_false
1085: THEN

Line 1110: 'ams_list_src_types',

1106: -- added rosharma for audience DS uptake
1107: --------------------target_source_id---------------------------
1108: IF p_dm_target_rec.target_source_id <> FND_API.g_miss_num THEN
1109: IF AMS_Utility_PVT.check_fk_exists(
1110: 'ams_list_src_types',
1111: 'list_source_type_id',
1112: p_dm_target_rec.target_source_id
1113: ) = FND_API.g_false
1114: THEN

Line 1633: AND EXISTS (SELECT 1 FROM ams_list_src_types b WHERE b.list_source_type_id = a.data_source_id AND b.enabled_flag = 'Y')

1629: SET a.active_flag = 'Y',
1630: a.last_update_date = SYSDATE,
1631: a.last_updated_by = FND_GLOBAL.user_id
1632: WHERE (a.data_source_id = p_data_source_id OR a.target_source_id = p_data_source_id)
1633: AND EXISTS (SELECT 1 FROM ams_list_src_types b WHERE b.list_source_type_id = a.data_source_id AND b.enabled_flag = 'Y')
1634: AND EXISTS (SELECT 1 FROM ams_list_src_types c WHERE c.list_source_type_id = a.target_source_id AND c.enabled_flag = 'Y')
1635: AND (EXISTS (SELECT 1 FROM ams_list_src_type_assocs d WHERE d.MASTER_SOURCE_TYPE_ID = a.data_source_id AND d.SUB_SOURCE_TYPE_ID = a.target_source_id AND d.enabled_flag = 'Y')
1636: OR a.data_source_id = a.target_source_id)
1637: AND EXISTS (SELECT 1 FROM ams_dm_target_values_b e where e.target_id = a.target_id)

Line 1634: AND EXISTS (SELECT 1 FROM ams_list_src_types c WHERE c.list_source_type_id = a.target_source_id AND c.enabled_flag = 'Y')

1630: a.last_update_date = SYSDATE,
1631: a.last_updated_by = FND_GLOBAL.user_id
1632: WHERE (a.data_source_id = p_data_source_id OR a.target_source_id = p_data_source_id)
1633: AND EXISTS (SELECT 1 FROM ams_list_src_types b WHERE b.list_source_type_id = a.data_source_id AND b.enabled_flag = 'Y')
1634: AND EXISTS (SELECT 1 FROM ams_list_src_types c WHERE c.list_source_type_id = a.target_source_id AND c.enabled_flag = 'Y')
1635: AND (EXISTS (SELECT 1 FROM ams_list_src_type_assocs d WHERE d.MASTER_SOURCE_TYPE_ID = a.data_source_id AND d.SUB_SOURCE_TYPE_ID = a.target_source_id AND d.enabled_flag = 'Y')
1636: OR a.data_source_id = a.target_source_id)
1637: AND EXISTS (SELECT 1 FROM ams_dm_target_values_b e where e.target_id = a.target_id)
1638: AND a.active_flag = 'N'

Line 1680: AND EXISTS (SELECT 1 FROM ams_list_src_types b WHERE b.list_source_type_id = a.data_source_id AND b.enabled_flag = 'Y')

1676: SET a.active_flag = 'Y',
1677: a.last_update_date = SYSDATE,
1678: a.last_updated_by = FND_GLOBAL.user_id
1679: WHERE (a.data_source_id = p_master_source_id AND a.target_source_id = p_sub_source_id)
1680: AND EXISTS (SELECT 1 FROM ams_list_src_types b WHERE b.list_source_type_id = a.data_source_id AND b.enabled_flag = 'Y')
1681: AND EXISTS (SELECT 1 FROM ams_list_src_types c WHERE c.list_source_type_id = a.target_source_id AND c.enabled_flag = 'Y')
1682: AND EXISTS (SELECT 1 FROM ams_list_src_type_assocs d WHERE d.MASTER_SOURCE_TYPE_ID = a.data_source_id AND d.SUB_SOURCE_TYPE_ID = a.target_source_id AND d.enabled_flag = 'Y')
1683: AND EXISTS (SELECT 1 FROM ams_dm_target_values_b e where e.target_id = a.target_id)
1684: AND a.active_flag = 'N'

Line 1681: AND EXISTS (SELECT 1 FROM ams_list_src_types c WHERE c.list_source_type_id = a.target_source_id AND c.enabled_flag = 'Y')

1677: a.last_update_date = SYSDATE,
1678: a.last_updated_by = FND_GLOBAL.user_id
1679: WHERE (a.data_source_id = p_master_source_id AND a.target_source_id = p_sub_source_id)
1680: AND EXISTS (SELECT 1 FROM ams_list_src_types b WHERE b.list_source_type_id = a.data_source_id AND b.enabled_flag = 'Y')
1681: AND EXISTS (SELECT 1 FROM ams_list_src_types c WHERE c.list_source_type_id = a.target_source_id AND c.enabled_flag = 'Y')
1682: AND EXISTS (SELECT 1 FROM ams_list_src_type_assocs d WHERE d.MASTER_SOURCE_TYPE_ID = a.data_source_id AND d.SUB_SOURCE_TYPE_ID = a.target_source_id AND d.enabled_flag = 'Y')
1683: AND EXISTS (SELECT 1 FROM ams_dm_target_values_b e where e.target_id = a.target_id)
1684: AND a.active_flag = 'N'
1685: ;