APPS.AMS_LIST_SRC_MAPPING dependencies on AMS_LIST_SRC_TYPES

Line 38: SELECT ams_list_src_types_s.NEXTVAL

34: l_list_target_fields l_Tbl_Type ;
35: l_temp_fields l_Tbl_Type ;
36:
37: CURSOR c_get_id is
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

Line 52: SELECT source_type_code FROM ams_list_src_types_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
52: SELECT source_type_code FROM ams_list_src_types_vl
53: where list_source_type_id = p_src_type_id ;
54:
55: CURSOR c_get_import_type(p_import_list_header_id number) is
56: SELECT import_type, b2b_flag

Line 63: FROM ams_list_src_types_vl

59: l_import_type c_get_import_type%ROWTYPE;
60:
61: CURSOR c_get_list_source_name(name VARCHAR2) IS
62: SELECT 1
63: FROM ams_list_src_types_vl
64: WHERE list_source_name=name;
65:
66: mapping_table dbms_utility.uncl_array;
67: l_no_of_rows number;

Line 210: delete from ams_list_src_types

206: CLOSE c_get_id;
207: px_src_type_id := l_list_source_type_id;
208: else
209: /****
210: delete from ams_list_src_types
211: where list_source_type_id = px_src_type_id ;
212:
213: delete from ams_list_src_types_tl
214: where list_source_type_id = px_src_type_id ;

Line 213: delete from ams_list_src_types_tl

209: /****
210: delete from ams_list_src_types
211: where list_source_type_id = px_src_type_id ;
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

Line 242: INSERT INTO ams_list_src_types (

238: FETCH c_get_id INTO l_list_source_type_id;
239: CLOSE c_get_id;
240: px_src_type_id := l_list_source_type_id;
241:
242: INSERT INTO ams_list_src_types (
243: list_source_type_id,
244: last_update_date,
245: last_updated_by,
246: creation_date,

Line 277: insert into ams_list_src_types_tl (

273: 530, --CHANGE!!
274: l_import_type.IMPORT_TYPE
275: );
276:
277: insert into ams_list_src_types_tl (
278: language,
279: source_lang,
280: list_source_name,
281: description,

Line 304: from AMS_LIST_SRC_TYPES_TL T

300: from FND_LANGUAGES L
301: where L.INSTALLED_FLAG in ('I', 'B')
302: and not exists
303: (select NULL
304: from AMS_LIST_SRC_TYPES_TL T
305: where T.LIST_SOURCE_TYPE_ID = l_list_source_type_id
306: and T.LANGUAGE = L.LANGUAGE_CODE);
307:
308: l_no_of_rows := p_list_src_fields.last;