APPS.AMS_IMP_LIST_HEADERS_PKG dependencies on AMS_IMP_LIST_HEADERS_ALL_TL

Line 288: INSERT INTO AMS_IMP_LIST_HEADERS_ALL_TL(

284: DECODE( p_error_threshold, FND_API.g_miss_num, NULL, p_error_threshold),
285: DECODE( p_charset, FND_API.g_miss_char, NULL, p_charset)
286: );
287:
288: INSERT INTO AMS_IMP_LIST_HEADERS_ALL_TL(
289: import_list_header_id,
290: last_update_date,
291: last_update_by,
292: creation_date,

Line 314: from AMS_IMP_LIST_HEADERS_ALL_TL T

310: from FND_LANGUAGES L
311: where L.INSTALLED_FLAG in ('I', 'B')
312: and not exists
313: (select NULL
314: from AMS_IMP_LIST_HEADERS_ALL_TL T
315: where T.IMPORT_LIST_HEADER_ID = px_import_list_header_id
316: and T.LANGUAGE = L.LANGUAGE_CODE);
317:
318: open c;

Line 491: update AMS_IMP_LIST_HEADERS_ALL_TL

487: error_threshold = DECODE( p_error_threshold, FND_API.g_miss_num, error_threshold, p_error_threshold)
488: WHERE IMPORT_LIST_HEADER_ID = p_IMPORT_LIST_HEADER_ID
489: AND object_version_number = p_object_version_number;
490:
491: update AMS_IMP_LIST_HEADERS_ALL_TL
492: set
493: last_update_date=DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
494: last_update_by=DECODE( p_last_updated_by, FND_API.g_miss_num, last_update_by, p_last_updated_by),
495: last_update_login=DECODE( p_last_update_login, FND_API.g_miss_num, last_update_login, p_last_update_login),

Line 851: delete from AMS_IMP_LIST_HEADERS_ALL_TL T

847: -- --------------------------------------------------------
848: procedure ADD_LANGUAGE
849: is
850: begin
851: delete from AMS_IMP_LIST_HEADERS_ALL_TL T
852: where not exists
853: (select NULL
854: from AMS_IMP_LIST_HEADERS_ALL B
855: where B.IMPORT_LIST_HEADER_ID = T.IMPORT_LIST_HEADER_ID

Line 858: update AMS_IMP_LIST_HEADERS_ALL_TL T set (

854: from AMS_IMP_LIST_HEADERS_ALL B
855: where B.IMPORT_LIST_HEADER_ID = T.IMPORT_LIST_HEADER_ID
856: );
857:
858: update AMS_IMP_LIST_HEADERS_ALL_TL T set (
859: NAME,
860: DESCRIPTION
861: ) = (select
862: B.NAME,

Line 864: from AMS_IMP_LIST_HEADERS_ALL_TL B

860: DESCRIPTION
861: ) = (select
862: B.NAME,
863: B.DESCRIPTION
864: from AMS_IMP_LIST_HEADERS_ALL_TL B
865: where B.IMPORT_LIST_HEADER_ID = T.IMPORT_LIST_HEADER_ID
866: and B.LANGUAGE = T.SOURCE_LANG)
867: where (
868: T.IMPORT_LIST_HEADER_ID,

Line 873: from AMS_IMP_LIST_HEADERS_ALL_TL SUBB, AMS_IMP_LIST_HEADERS_ALL_TL SUBT

869: T.LANGUAGE
870: ) in (select
871: SUBT.IMPORT_LIST_HEADER_ID,
872: SUBT.LANGUAGE
873: from AMS_IMP_LIST_HEADERS_ALL_TL SUBB, AMS_IMP_LIST_HEADERS_ALL_TL SUBT
874: where SUBB.IMPORT_LIST_HEADER_ID = SUBT.IMPORT_LIST_HEADER_ID
875: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
876: and (SUBB.NAME <> SUBT.NAME
877: or (SUBB.NAME is null and SUBT.NAME is not null)

Line 884: insert into AMS_IMP_LIST_HEADERS_ALL_TL (

880: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
881: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
882: ));
883:
884: insert into AMS_IMP_LIST_HEADERS_ALL_TL (
885: NAME,
886: DESCRIPTION,
887: LAST_UPDATE_LOGIN,
888: IMPORT_LIST_HEADER_ID,

Line 906: from AMS_IMP_LIST_HEADERS_ALL_TL B, FND_LANGUAGES L

902: B.CREATION_DATE,
903: B.CREATED_BY,
904: L.LANGUAGE_CODE,
905: B.SOURCE_LANG
906: from AMS_IMP_LIST_HEADERS_ALL_TL B, FND_LANGUAGES L
907: where L.INSTALLED_FLAG in ('I', 'B')
908: and B.LANGUAGE = userenv('LANG')
909: and not exists
910: (select NULL

Line 911: from AMS_IMP_LIST_HEADERS_ALL_TL T

907: where L.INSTALLED_FLAG in ('I', 'B')
908: and B.LANGUAGE = userenv('LANG')
909: and not exists
910: (select NULL
911: from AMS_IMP_LIST_HEADERS_ALL_TL T
912: where T.IMPORT_LIST_HEADER_ID = B.IMPORT_LIST_HEADER_ID
913: and T.LANGUAGE = L.LANGUAGE_CODE);
914:
915: end ADD_LANGUAGE;