APPS.AMS_LIST_SRC_TYPES_PKG dependencies on AMS_LIST_SRC_TYPES_TL

Line 98: insert into AMS_LIST_SRC_TYPES_TL (

94: x_SOURCE_CATEGORY ,
95: x_IMPORT_TYPE,
96: x_BASED_ON_TCA_FLAG
97: );
98: insert into AMS_LIST_SRC_TYPES_TL (
99: LANGUAGE,
100: SOURCE_LANG,
101: LIST_SOURCE_NAME,
102: DESCRIPTION,

Line 132: from AMS_LIST_SRC_TYPES_TL T

128: from FND_LANGUAGES L
129: where L.INSTALLED_FLAG in ('I', 'B')
130: and not exists
131: (select NULL
132: from AMS_LIST_SRC_TYPES_TL T
133: where T.LIST_SOURCE_TYPE_ID = x_list_source_type_id
134: and T.LANGUAGE = L.LANGUAGE_CODE);
135:
136:

Line 268: update AMS_LIST_SRC_TYPES_TL set

264: last_update_login = x_last_update_login,
265: BASED_ON_TCA_FLAG = X_BASED_ON_TCA_FLAG
266: WHERE list_source_type_id = x_list_source_type_id;
267:
268: update AMS_LIST_SRC_TYPES_TL set
269: LIST_SOURCE_NAME = x_list_source_name,
270: DESCRIPTION = x_description,
271: LAST_UPDATE_DATE = sysdate,
272: --for bug 5237401

Line 424: delete from AMS_LIST_SRC_TYPES_TL T

420:
421: procedure ADD_LANGUAGE
422: is
423: begin
424: delete from AMS_LIST_SRC_TYPES_TL T
425: where not exists
426: (select NULL
427: from AMS_LIST_SRC_TYPES B
428: where B.LIST_SOURCE_TYPE_ID = T.LIST_SOURCE_TYPE_ID

Line 431: update AMS_LIST_SRC_TYPES_TL T set (

427: from AMS_LIST_SRC_TYPES B
428: where B.LIST_SOURCE_TYPE_ID = T.LIST_SOURCE_TYPE_ID
429: );
430:
431: update AMS_LIST_SRC_TYPES_TL T set (
432: LIST_SOURCE_NAME,
433: DESCRIPTION
434: ) = (select
435: B.LIST_SOURCE_NAME,

Line 437: from AMS_LIST_SRC_TYPES_TL B

433: DESCRIPTION
434: ) = (select
435: B.LIST_SOURCE_NAME,
436: B.DESCRIPTION
437: from AMS_LIST_SRC_TYPES_TL B
438: where B.LIST_SOURCE_TYPE_ID = T.LIST_SOURCE_TYPE_ID
439: and B.LANGUAGE = T.SOURCE_LANG)
440: where (
441: T.LIST_SOURCE_TYPE_ID,

Line 446: from AMS_LIST_SRC_TYPES_TL SUBB, AMS_LIST_SRC_TYPES_TL SUBT

442: T.LANGUAGE
443: ) in (select
444: SUBT.LIST_SOURCE_TYPE_ID,
445: SUBT.LANGUAGE
446: from AMS_LIST_SRC_TYPES_TL SUBB, AMS_LIST_SRC_TYPES_TL SUBT
447: where SUBB.LIST_SOURCE_TYPE_ID = SUBT.LIST_SOURCE_TYPE_ID
448: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
449: and (SUBB.LIST_SOURCE_NAME <> SUBT.LIST_SOURCE_NAME
450: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 455: insert into AMS_LIST_SRC_TYPES_TL (

451: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
452: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
453: ));
454:
455: insert into AMS_LIST_SRC_TYPES_TL (
456: LIST_SOURCE_TYPE_ID,
457: LAST_UPDATE_DATE,
458: LAST_UPDATE_BY,
459: CREATION_DATE,

Line 477: from AMS_LIST_SRC_TYPES_TL B, FND_LANGUAGES L

473: B.LIST_SOURCE_NAME,
474: B.DESCRIPTION,
475: L.LANGUAGE_CODE,
476: B.SOURCE_LANG
477: from AMS_LIST_SRC_TYPES_TL B, FND_LANGUAGES L
478: where L.INSTALLED_FLAG in ('I', 'B')
479: and B.LANGUAGE = userenv('LANG')
480: and not exists
481: (select NULL

Line 482: from AMS_LIST_SRC_TYPES_TL T

478: where L.INSTALLED_FLAG in ('I', 'B')
479: and B.LANGUAGE = userenv('LANG')
480: and not exists
481: (select NULL
482: from AMS_LIST_SRC_TYPES_TL T
483: where T.LIST_SOURCE_TYPE_ID = B.LIST_SOURCE_TYPE_ID
484: and T.LANGUAGE = L.LANGUAGE_CODE);
485: end ADD_LANGUAGE;
486: procedure TRANSLATE_ROW(

Line 496: FROM ams_list_src_types_tl

492: ) is
493:
494: cursor c_last_updated_by is
495: select last_update_by
496: FROM ams_list_src_types_tl
497: where list_source_type_id = x_list_source_type_id
498: and USERENV('LANG') = LANGUAGE;
499:
500: l_last_updated_by number;

Line 513: update AMS_LIST_SRC_TYPES_TL set

509:
510: if (l_last_updated_by in (1,2,0) OR
511: NVL(x_custom_mode,'PRESERVE')='FORCE') THEN
512:
513: update AMS_LIST_SRC_TYPES_TL set
514: list_source_name = nvl(x_list_source_name, list_source_name),
515: description = nvl(x_description, description),
516: source_lang = userenv('LANG'),
517: last_update_date = sysdate,