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_ATTB_LOV_VALUES_PKG dependencies on AMS_ATTB_LOV_VALUES_TL

Line 60: insert into AMS_ATTB_LOV_VALUES_TL (

56: X_PROGRAM_APPLICATION_ID,
57: X_PROGRAM_UPDATE_DATE
58: );
59:
60: insert into AMS_ATTB_LOV_VALUES_TL (
61: ATTB_LOV_VALUE_ID,
62: LAST_UPDATE_DATE,
63: LAST_UPDATED_BY,
64: CREATION_DATE,

Line 86: from AMS_ATTB_LOV_VALUES_TL T

82: from FND_LANGUAGES L
83: where L.INSTALLED_FLAG in ('I', 'B')
84: and not exists
85: (select NULL
86: from AMS_ATTB_LOV_VALUES_TL T
87: where T.ATTB_LOV_VALUE_ID = X_ATTB_LOV_VALUE_ID
88: and T.LANGUAGE = L.LANGUAGE_CODE);
89:
90: open c;

Line 128: from AMS_ATTB_LOV_VALUES_TL

124:
125: cursor c1 is select
126: VALUE_MEANING,
127: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
128: from AMS_ATTB_LOV_VALUES_TL
129: where ATTB_LOV_VALUE_ID = X_ATTB_LOV_VALUE_ID
130: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
131: for update of ATTB_LOV_VALUE_ID nowait;
132: begin

Line 205: update AMS_ATTB_LOV_VALUES_TL set

201: if (sql%notfound) then
202: raise no_data_found;
203: end if;
204:
205: update AMS_ATTB_LOV_VALUES_TL set
206: VALUE_MEANING = X_VALUE_MEANING,
207: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
208: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
209: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 223: delete from AMS_ATTB_LOV_VALUES_TL

219: procedure DELETE_ROW (
220: X_ATTB_LOV_VALUE_ID in NUMBER
221: ) is
222: begin
223: delete from AMS_ATTB_LOV_VALUES_TL
224: where ATTB_LOV_VALUE_ID = X_ATTB_LOV_VALUE_ID;
225:
226: if (sql%notfound) then
227: raise no_data_found;

Line 241: delete from AMS_ATTB_LOV_VALUES_TL T

237:
238: procedure ADD_LANGUAGE
239: is
240: begin
241: delete from AMS_ATTB_LOV_VALUES_TL T
242: where not exists
243: (select NULL
244: from AMS_ATTB_LOV_VALUES_B B
245: where B.ATTB_LOV_VALUE_ID = T.ATTB_LOV_VALUE_ID

Line 248: update AMS_ATTB_LOV_VALUES_TL T set (

244: from AMS_ATTB_LOV_VALUES_B B
245: where B.ATTB_LOV_VALUE_ID = T.ATTB_LOV_VALUE_ID
246: );
247:
248: update AMS_ATTB_LOV_VALUES_TL T set (
249: VALUE_MEANING
250: ) = (select
251: B.VALUE_MEANING
252: from AMS_ATTB_LOV_VALUES_TL B

Line 252: from AMS_ATTB_LOV_VALUES_TL B

248: update AMS_ATTB_LOV_VALUES_TL T set (
249: VALUE_MEANING
250: ) = (select
251: B.VALUE_MEANING
252: from AMS_ATTB_LOV_VALUES_TL B
253: where B.ATTB_LOV_VALUE_ID = T.ATTB_LOV_VALUE_ID
254: and B.LANGUAGE = T.SOURCE_LANG)
255: where (
256: T.ATTB_LOV_VALUE_ID,

Line 261: from AMS_ATTB_LOV_VALUES_TL SUBB, AMS_ATTB_LOV_VALUES_TL SUBT

257: T.LANGUAGE
258: ) in (select
259: SUBT.ATTB_LOV_VALUE_ID,
260: SUBT.LANGUAGE
261: from AMS_ATTB_LOV_VALUES_TL SUBB, AMS_ATTB_LOV_VALUES_TL SUBT
262: where SUBB.ATTB_LOV_VALUE_ID = SUBT.ATTB_LOV_VALUE_ID
263: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
264: and (SUBB.VALUE_MEANING <> SUBT.VALUE_MEANING
265: ));

Line 267: insert into AMS_ATTB_LOV_VALUES_TL (

263: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
264: and (SUBB.VALUE_MEANING <> SUBT.VALUE_MEANING
265: ));
266:
267: insert into AMS_ATTB_LOV_VALUES_TL (
268: ATTB_LOV_VALUE_ID,
269: LAST_UPDATE_DATE,
270: LAST_UPDATED_BY,
271: CREATION_DATE,

Line 289: from AMS_ATTB_LOV_VALUES_TL B, FND_LANGUAGES L

285: -- B.SOURCE_LANG,
286: B.VALUE_MEANING,
287: L.LANGUAGE_CODE,
288: B.SOURCE_LANG
289: from AMS_ATTB_LOV_VALUES_TL B, FND_LANGUAGES L
290: where L.INSTALLED_FLAG in ('I', 'B')
291: and B.LANGUAGE = userenv('LANG')
292: and not exists
293: (select NULL

Line 294: from AMS_ATTB_LOV_VALUES_TL T

290: where L.INSTALLED_FLAG in ('I', 'B')
291: and B.LANGUAGE = userenv('LANG')
292: and not exists
293: (select NULL
294: from AMS_ATTB_LOV_VALUES_TL T
295: where T.ATTB_LOV_VALUE_ID = B.ATTB_LOV_VALUE_ID
296: and T.LANGUAGE = L.LANGUAGE_CODE);
297: end ADD_LANGUAGE;
298: procedure TRANSLATE_ROW(

Line 308: from AMS_ATTB_LOV_VALUES_TL

304: ) is
305:
306: cursor c_last_updated_by is
307: select last_updated_by
308: from AMS_ATTB_LOV_VALUES_TL
309: where ATTB_LOV_VALUE_ID = X_ATTB_LOV_VALUE_ID
310: and USERENV('LANG') = LANGUAGE;
311:
312: l_luby number; --last updated by

Line 323: update AMS_ATTB_LOV_VALUES_TL set

319:
320: if (l_luby IN (0, 1, 2) or NVL(x_custom_mode, 'PRESERVE')='FORCE')
321: then
322:
323: update AMS_ATTB_LOV_VALUES_TL set
324: VALUE_MEANING= nvl(X_VALUE_MEANING, VALUE_MEANING),
325: source_lang = userenv('LANG'),
326: last_update_date = sysdate,
327: last_updated_by = decode(x_owner, 'SEED', 1, 'ORACLE', 2, 'SYSADMIN', 0, -1),