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_LIST_SRC_FIELDS_PKG dependencies on AMS_LIST_SRC_FIELDS_TL

Line 145: insert into AMS_LIST_SRC_FIELDS_TL (

141: decode( p_lov_defined_flag,FND_API.g_miss_char,null,p_lov_defined_flag),
142: decode( p_column_type,FND_API.g_miss_char,null,p_column_type)
143: );
144:
145: insert into AMS_LIST_SRC_FIELDS_TL (
146: LANGUAGE,
147: SOURCE_LANG,
148: source_column_meaning,
149: LIST_SOURCE_field_ID,

Line 177: from AMS_LIST_SRC_FIELDS_TL T

173: from FND_LANGUAGES L
174: where L.INSTALLED_FLAG in ('I', 'B')
175: and not exists
176: (select NULL
177: from AMS_LIST_SRC_FIELDS_TL T
178: where T.LIST_source_field_ID = px_LIST_SOURCE_field_ID
179: and T.LANGUAGE = L.LANGUAGE_CODE);
180:
181: END Insert_Row;

Line 275: update AMS_LIST_SRC_FIELDS_TL set

271: IF (SQL%NOTFOUND) THEN
272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
273: END IF;
274:
275: update AMS_LIST_SRC_FIELDS_TL set
276: SOURCE_column_meaning = DECODE( p_source_column_meaning, FND_API.g_miss_char, source_column_meaning, p_source_column_meaning),
277: LAST_UPDATE_DATE = sysdate,
278: -- Modified for bug 5237401. bmuthukr
279: --LAST_UPDATE_BY = FND_GLOBAL.user_id,

Line 320: DELETE FROM AMS_LIST_SRC_FIELDS_TL

316: If (SQL%NOTFOUND) then
317: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
318: End If;
319:
320: DELETE FROM AMS_LIST_SRC_FIELDS_TL
321: WHERE LIST_SOURCE_FIELD_ID = p_LIST_SOURCE_FIELD_ID;
322: If (SQL%NOTFOUND) then
323: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
324: End If;

Line 512: insert into AMS_LIST_SRC_FIELDS_TL (

508: decode( p_use_for_splitting_flag,FND_API.g_miss_char,null,p_use_for_splitting_flag),
509: decode( p_column_type,FND_API.g_miss_char,null,p_column_type)
510: );
511:
512: insert into AMS_LIST_SRC_FIELDS_TL (
513: LANGUAGE,
514: SOURCE_LANG,
515: source_column_meaning,
516: LIST_SOURCE_field_ID,

Line 544: from AMS_LIST_SRC_FIELDS_TL T

540: from FND_LANGUAGES L
541: where L.INSTALLED_FLAG in ('I', 'B')
542: and not exists
543: (select NULL
544: from AMS_LIST_SRC_FIELDS_TL T
545: where T.LIST_source_field_ID = px_LIST_SOURCE_field_ID
546: and T.LANGUAGE = L.LANGUAGE_CODE);
547:
548: END Insert_Row;

Line 649: update AMS_LIST_SRC_FIELDS_TL set

645: IF (SQL%NOTFOUND) THEN
646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
647: END IF;
648:
649: update AMS_LIST_SRC_FIELDS_TL set
650: SOURCE_column_meaning = DECODE( p_source_column_meaning, FND_API.g_miss_char, source_column_meaning, p_source_column_meaning),
651: LAST_UPDATE_DATE = sysdate,
652: -- Added for bug 5237401. bmuthukr.
653: --LAST_UPDATE_BY = FND_GLOBAL.user_id,

Line 839: FROM AMS_LIST_SRC_FIELDS_TL

835: ) is
836:
837: cursor c_last_updated_by is
838: select last_update_by
839: FROM AMS_LIST_SRC_FIELDS_TL
840: where list_source_field_id = x_list_source_field_id
841: and USERENV('LANG') = LANGUAGE;
842:
843: l_last_updated_by number;

Line 855: update AMS_LIST_SRC_FIELDS_TL set

851:
852: if (l_last_updated_by in (1,2,0) OR
853: NVL(x_custom_mode,'PRESERVE')='FORCE') THEN
854:
855: update AMS_LIST_SRC_FIELDS_TL set
856: source_column_meaning = nvl(x_source_column_meaning,
857: source_column_meaning),
858: source_lang = userenv('LANG'),
859: last_update_date = sysdate,

Line 871: delete from AMS_LIST_SRC_FIELDS_TL T

867:
868: procedure ADD_LANGUAGE
869: is
870: begin
871: delete from AMS_LIST_SRC_FIELDS_TL T
872: where not exists
873: (select NULL
874: from AMS_LIST_SRC_FIELDS B
875: where B.LIST_SOURCE_FIELD_ID = T.LIST_SOURCE_FIELD_ID

Line 878: update AMS_LIST_SRC_FIELDS_TL T set (

874: from AMS_LIST_SRC_FIELDS B
875: where B.LIST_SOURCE_FIELD_ID = T.LIST_SOURCE_FIELD_ID
876: );
877:
878: update AMS_LIST_SRC_FIELDS_TL T set (
879: SOURCE_COLUMN_MEANING
880: ) = (select
881: B.SOURCE_COLUMN_MEANING
882: from AMS_LIST_SRC_FIELDS_TL B

Line 882: from AMS_LIST_SRC_FIELDS_TL B

878: update AMS_LIST_SRC_FIELDS_TL T set (
879: SOURCE_COLUMN_MEANING
880: ) = (select
881: B.SOURCE_COLUMN_MEANING
882: from AMS_LIST_SRC_FIELDS_TL B
883: where B.LIST_SOURCE_FIELD_ID = T.LIST_SOURCE_FIELD_ID
884: and B.LANGUAGE = T.SOURCE_LANG)
885: where (
886: T.LIST_SOURCE_FIELD_ID,

Line 891: from AMS_LIST_SRC_FIELDS_TL SUBB, AMS_LIST_SRC_FIELDS_TL SUBT

887: T.LANGUAGE
888: ) in (select
889: SUBT.LIST_SOURCE_FIELD_ID,
890: SUBT.LANGUAGE
891: from AMS_LIST_SRC_FIELDS_TL SUBB, AMS_LIST_SRC_FIELDS_TL SUBT
892: where SUBB.LIST_SOURCE_FIELD_ID = SUBT.LIST_SOURCE_FIELD_ID
893: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
894: and (SUBB.SOURCE_COLUMN_MEANING <> SUBT.SOURCE_COLUMN_MEANING
895: or (SUBB.SOURCE_COLUMN_MEANING is null and SUBT.SOURCE_COLUMN_MEANING is not null)

Line 899: insert into AMS_LIST_SRC_FIELDS_TL (

895: or (SUBB.SOURCE_COLUMN_MEANING is null and SUBT.SOURCE_COLUMN_MEANING is not null)
896: or (SUBB.SOURCE_COLUMN_MEANING is not null and SUBT.SOURCE_COLUMN_MEANING is null)
897: ));
898:
899: insert into AMS_LIST_SRC_FIELDS_TL (
900: LAST_UPDATE_LOGIN,
901: SOURCE_COLUMN_MEANING,
902: CREATION_DATE,
903: CREATED_BY,

Line 919: from AMS_LIST_SRC_FIELDS_TL B, FND_LANGUAGES L

915: B.LAST_UPDATE_DATE,
916: B.LAST_UPDATE_BY,
917: L.LANGUAGE_CODE,
918: B.SOURCE_LANG
919: from AMS_LIST_SRC_FIELDS_TL B, FND_LANGUAGES L
920: where L.INSTALLED_FLAG in ('I', 'B')
921: and B.LANGUAGE = userenv('LANG')
922: and not exists
923: (select NULL

Line 924: from AMS_LIST_SRC_FIELDS_TL T

920: where L.INSTALLED_FLAG in ('I', 'B')
921: and B.LANGUAGE = userenv('LANG')
922: and not exists
923: (select NULL
924: from AMS_LIST_SRC_FIELDS_TL T
925: where T.LIST_SOURCE_FIELD_ID = B.LIST_SOURCE_FIELD_ID
926: and T.LANGUAGE = L.LANGUAGE_CODE);
927: end ADD_LANGUAGE;
928: