eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_IMP_LIST_HEADERS_PKG dependencies on AMS_IMP_LIST_HEADERS_ALL

Line 121: cursor C is select ROWID from AMS_IMP_LIST_HEADERS_ALL

117: p_charset VARCHAR2)
118:
119: IS
120: l_rowid VARCHAR2(20);
121: cursor C is select ROWID from AMS_IMP_LIST_HEADERS_ALL
122: where IMPORT_LIST_HEADER_ID = px_import_list_header_id;
123:
124: BEGIN
125:

Line 128: INSERT INTO AMS_IMP_LIST_HEADERS_ALL(

124: BEGIN
125:
126:
127:
128: INSERT INTO AMS_IMP_LIST_HEADERS_ALL(
129: import_list_header_id,
130: last_update_date,
131: last_updated_by,
132: creation_date,

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 418: Update AMS_IMP_LIST_HEADERS_ALL

414: p_error_threshold NUMBER)
415:
416: IS
417: BEGIN
418: Update AMS_IMP_LIST_HEADERS_ALL
419: SET
420: import_list_header_id = DECODE( p_import_list_header_id, FND_API.g_miss_num, import_list_header_id, p_import_list_header_id),
421: last_update_date = DECODE( p_last_update_date, FND_API.g_miss_date, last_update_date, p_last_update_date),
422: last_updated_by = DECODE( p_last_updated_by, FND_API.g_miss_num, last_updated_by, p_last_updated_by),

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 529: DELETE FROM AMS_IMP_LIST_HEADERS_ALL

525: PROCEDURE Delete_Row(
526: p_IMPORT_LIST_HEADER_ID NUMBER)
527: IS
528: BEGIN
529: DELETE FROM AMS_IMP_LIST_HEADERS_ALL
530: WHERE IMPORT_LIST_HEADER_ID = p_IMPORT_LIST_HEADER_ID;
531: If (SQL%NOTFOUND) then
532: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533: End If;

Line 626: FROM AMS_IMP_LIST_HEADERS_ALL

622:
623: IS
624: CURSOR C IS
625: SELECT *
626: FROM AMS_IMP_LIST_HEADERS_ALL
627: WHERE IMPORT_LIST_HEADER_ID = p_IMPORT_LIST_HEADER_ID
628: FOR UPDATE of IMPORT_LIST_HEADER_ID NOWAIT;
629: Recinfo C%ROWTYPE;
630: BEGIN

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 854: from AMS_IMP_LIST_HEADERS_ALL B

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
856: );
857:
858: update AMS_IMP_LIST_HEADERS_ALL_TL T set (

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;