APPS.AMS_LIST_SRC_MAPPING dependencies on AMS_LIST_SRC_FIELDS

Line 42: SELECT ams_list_src_fields_s.NEXTVAL

38: SELECT ams_list_src_types_s.NEXTVAL
39: FROM DUAL;
40:
41: CURSOR c_get_field_id is
42: SELECT ams_list_src_fields_s.NEXTVAL
43: FROM DUAL;
44:
45: CURSOR c_get_source_col_name(p_src_id number) is
46: SELECT source_column_name

Line 47: FROM ams_list_src_fields_vl

43: FROM DUAL;
44:
45: CURSOR c_get_source_col_name(p_src_id number) is
46: SELECT source_column_name
47: FROM ams_list_src_fields_vl
48: WHERE list_source_type_id=p_src_id
49: ORDER BY LIST_SOURCE_FIELD_ID;
50:
51: CURSOR c_get_source_name(p_src_type_id number) is

Line 79: -- FROM ams_list_src_fields al

75: --FROM ams_imp_col_mapping ai
76: --WHERE ai.required_flag = 'Y'
77: --AND ai.table_name = cur_table_name
78: --AND NOT EXISTS ( SELECT 'x'
79: -- FROM ams_list_src_fields al
80: -- WHERE al.field_table_name = ai.table_name
81: -- AND al.field_column_name IS NOT NULL
82: -- AND NVL (al.field_column_name, '') = ai.column_name
83: -- AND al.list_source_type_id = cur_source_type_id );

Line 93: FROM ams_list_src_fields al

89: WHERE ai.region_code LIKE 'AMS_IMPH_METADATA_0%'
90: AND ai.required_flag = 'Y'
91: AND ai.SORTBY_VIEW_ATTRIBUTE_NAME = p_import_type
92: AND NOT EXISTS ( SELECT 'x'
93: FROM ams_list_src_fields al
94: WHERE UPPER(al.field_table_name) = UPPER(ai.view_usage_name)
95: AND al.field_column_name IS NOT NULL
96: AND UPPER(al.field_column_name) = UPPER(ai.view_attribute_name)
97: AND al.list_source_type_id = cur_source_type_id );

Line 106: -- FROM ams_list_src_fields al

102: --FROM ams_imp_col_mapping ai
103: --WHERE ai.required_flag = 'Y'
104: --AND ai.table_name = p_table_name
105: --AND ai.column_name NOT IN ( SELECT al.field_column_name
106: -- FROM ams_list_src_fields al
107: -- WHERE al.field_table_name = ai.table_name
108: -- AND al.field_column_name IS NOT NULL
109: -- AND al.list_source_type_id = p_source_type_id );
110:

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 218: (SELECT list_source_field_id FROM ams_list_src_fields

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:
221:
222: delete from ams_list_src_fields

Line 222: delete from ams_list_src_fields

218: (SELECT list_source_field_id FROM ams_list_src_fields
219: WHERE list_source_type_id =px_src_type_id);
220:
221:
222: delete from ams_list_src_fields
223: where list_source_type_id = px_src_type_id;
224:
225: l_list_source_type_id := px_src_type_id ;
226: ****/

Line 349: INSERT INTO ams_list_src_fields (

345: OPEN c_get_field_id;
346: FETCH c_get_field_id INTO l_list_source_field_id;
347: CLOSE c_get_field_id;
348:
349: INSERT INTO ams_list_src_fields (
350: list_source_field_id,
351: last_update_date,
352: last_updated_by,
353: creation_date,

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: