DBA Data[Home] [Help]

APPS.AMS_LIST_SRC_MAPPING dependencies on AMS_LIST_SRC_FIELDS_TL

Line 216: DELETE FROM ams_list_src_fields_tl

212:
213: delete from ams_list_src_types_tl
214: where list_source_type_id = px_src_type_id ;
215:
216: DELETE FROM ams_list_src_fields_tl
217: WHERE list_source_field_id IN
218: (SELECT list_source_field_id FROM ams_list_src_fields
219: WHERE list_source_type_id =px_src_type_id);
220:

Line 386: insert into ams_list_src_fields_tl (

382: 'Y',
383: '',
384: '' from dual);
385:
386: insert into ams_list_src_fields_tl (
387: language,
388: source_lang,
389: source_column_meaning,
390: list_source_field_id,

Line 411: from AMS_LIST_SRC_FIELDS_TL T

407: from FND_LANGUAGES L
408: where L.INSTALLED_FLAG in ('I', 'B')
409: and not exists
410: (select NULL
411: from AMS_LIST_SRC_FIELDS_TL T
412: where T.LIST_source_field_ID = l_list_source_field_id
413: and T.LANGUAGE = L.LANGUAGE_CODE);
414: end loop;
415: