APPS.AMS_DM_TARGET_VALUE_PVT dependencies on AMS_LIST_SRC_TYPES

Line 213: update ams_list_src_types

209: OPEN c_datasource_id(l_dm_target_value_rec.target_id);
210: FETCH c_datasource_id INTO l_datasource_id;
211: CLOSE c_datasource_id;
212:
213: update ams_list_src_types
214: set enabled_flag = 'Y',
215: object_version_number = object_version_number + 1
216: where list_source_type_id = l_datasource_id;
217:

Line 686: update ams_list_src_types

682: FETCH c_target_count INTO l_no_of_active_targets;
683: CLOSE c_target_count;
684:
685: IF l_no_of_active_targets = 0 THEN
686: update ams_list_src_types
687: set enabled_flag = 'N'
688: where list_source_type_id = l_datasource_id;
689: END IF;
690: