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.FND_LOOKUP_TYPES_PKG dependencies on FND_LOOKUP_TYPES_TL

Line 54: insert into FND_LOOKUP_TYPES_TL (

50: X_LAST_UPDATED_BY,
51: X_LAST_UPDATE_LOGIN
52: );
53:
54: insert into FND_LOOKUP_TYPES_TL (
55: LOOKUP_TYPE,
56: SECURITY_GROUP_ID,
57: VIEW_APPLICATION_ID,
58: MEANING,

Line 84: from FND_LOOKUP_TYPES_TL T

80: from FND_LANGUAGES L
81: where L.INSTALLED_FLAG in ('I', 'B')
82: and not exists
83: (select NULL
84: from FND_LOOKUP_TYPES_TL T
85: where T.LOOKUP_TYPE = X_LOOKUP_TYPE
86: and T.SECURITY_GROUP_ID = X_SECURITY_GROUP_ID
87: and T.VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
88: and T.LANGUAGE = L.LANGUAGE_CODE);

Line 170: from fnd_lookup_types_tl

166: f_ludate := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
167:
168: select last_updated_by, last_update_date
169: into db_luby, db_ludate
170: from fnd_lookup_types_tl
171: where lookup_type = X_LOOKUP_TYPE
172: and security_group_id = X_SECURITY_GROUP_ID
173: and view_application_id = X_VIEW_APPLICATION_ID
174: and language = userenv('LANG');

Line 178: update fnd_lookup_types_tl set

174: and language = userenv('LANG');
175:
176: if (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
177: db_ludate, X_CUSTOM_MODE)) then
178: update fnd_lookup_types_tl set
179: meaning = nvl(X_MEANING, meaning),
180: description = nvl(X_DESCRIPTION, description),
181: last_update_date = f_ludate,
182: last_updated_by = f_luby,

Line 237: from FND_LOOKUP_TYPES_TL

233: cursor c1 is select
234: MEANING,
235: DESCRIPTION,
236: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
237: from FND_LOOKUP_TYPES_TL
238: where LOOKUP_TYPE = X_LOOKUP_TYPE
239: and SECURITY_GROUP_ID = X_SECURITY_GROUP_ID
240: and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID
241: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)

Line 307: update FND_LOOKUP_TYPES_TL set

303: if (sql%notfound) then
304: raise no_data_found;
305: end if;
306:
307: update FND_LOOKUP_TYPES_TL set
308: MEANING = X_MEANING,
309: DESCRIPTION = X_DESCRIPTION,
310: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
311: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 351: delete from FND_LOOKUP_TYPES_TL

347: X_SECURITY_GROUP_ID in NUMBER,
348: X_VIEW_APPLICATION_ID in NUMBER
349: ) is
350: begin
351: delete from FND_LOOKUP_TYPES_TL
352: where LOOKUP_TYPE = X_LOOKUP_TYPE
353: and SECURITY_GROUP_ID = X_SECURITY_GROUP_ID
354: and VIEW_APPLICATION_ID = X_VIEW_APPLICATION_ID;
355:

Line 400: delete from FND_LOOKUP_TYPES_TL T

396: /* as a quick workaround to fix the time-consuming table handler issue */
397: /* Eventually we'll need to turn them into a separate fix_language procedure */
398: /*
399:
400: delete from FND_LOOKUP_TYPES_TL T
401: where not exists
402: (select NULL
403: from FND_LOOKUP_TYPES B
404: where B.LOOKUP_TYPE = T.LOOKUP_TYPE

Line 409: update FND_LOOKUP_TYPES_TL T set (

405: and B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
406: and B.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
407: );
408:
409: update FND_LOOKUP_TYPES_TL T set (
410: MEANING,
411: DESCRIPTION
412: ) = (select
413: B.MEANING,

Line 415: from FND_LOOKUP_TYPES_TL B

411: DESCRIPTION
412: ) = (select
413: B.MEANING,
414: B.DESCRIPTION
415: from FND_LOOKUP_TYPES_TL B
416: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
417: and B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
418: and B.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
419: and B.LANGUAGE = T.SOURCE_LANG)

Line 430: from FND_LOOKUP_TYPES_TL SUBB, FND_LOOKUP_TYPES_TL SUBT

426: SUBT.LOOKUP_TYPE,
427: SUBT.SECURITY_GROUP_ID,
428: SUBT.VIEW_APPLICATION_ID,
429: SUBT.LANGUAGE
430: from FND_LOOKUP_TYPES_TL SUBB, FND_LOOKUP_TYPES_TL SUBT
431: where SUBB.LOOKUP_TYPE = SUBT.LOOKUP_TYPE
432: and SUBB.SECURITY_GROUP_ID = SUBT.SECURITY_GROUP_ID
433: and SUBB.VIEW_APPLICATION_ID = SUBT.VIEW_APPLICATION_ID
434: and SUBB.LANGUAGE = SUBT.SOURCE_LANG

Line 443: from FND_LOOKUP_TYPES_TL DUP

439: ))
440: -- ***** BEGIN NEW CLAUSE FOR UPDATE *****
441: and not exists
442: (select null
443: from FND_LOOKUP_TYPES_TL DUP
444: where DUP.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
445: and DUP.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
446: and DUP.LANGUAGE = T.LANGUAGE
447: and (DUP.MEANING) =

Line 450: from FND_LOOKUP_TYPES_TL B

446: and DUP.LANGUAGE = T.LANGUAGE
447: and (DUP.MEANING) =
448: (select
449: B.MEANING
450: from FND_LOOKUP_TYPES_TL B
451: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
452: and B.SECURITY_GROUP_ID = T.SECURITY_GROUP_ID
453: and B.VIEW_APPLICATION_ID = T.VIEW_APPLICATION_ID
454: and B.LANGUAGE = T.SOURCE_LANG));

Line 459: update FND_LOOKUP_TYPES_TL set

455: -- ***** END NEW CLAUSE FOR UPDATE *****
456:
457: -- ***** NEW CODE FOR INSERT HERE *****
458: loop
459: update FND_LOOKUP_TYPES_TL set
460: MEANING = '@'||MEANING
461: where (
462: MEANING,
463: VIEW_APPLICATION_ID,

Line 471: from FND_LOOKUP_TYPES_TL B, FND_LANGUAGES L

467: B.MEANING,
468: B.VIEW_APPLICATION_ID,
469: B.SECURITY_GROUP_ID,
470: L.LANGUAGE_CODE
471: from FND_LOOKUP_TYPES_TL B, FND_LANGUAGES L
472: where L.INSTALLED_FLAG in ('I', 'B')
473: and B.LANGUAGE = userenv('LANG')
474: and not exists
475: (select NULL

Line 476: from FND_LOOKUP_TYPES_TL T

472: where L.INSTALLED_FLAG in ('I', 'B')
473: and B.LANGUAGE = userenv('LANG')
474: and not exists
475: (select NULL
476: from FND_LOOKUP_TYPES_TL T
477: where T.LOOKUP_TYPE = B.LOOKUP_TYPE
478: and T.SECURITY_GROUP_ID = B.SECURITY_GROUP_ID
479: and T.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID
480: and T.LANGUAGE = L.LANGUAGE_CODE));

Line 487: insert into FND_LOOKUP_TYPES_TL (

483: end loop;
484: -- ***** END CODE FOR INSERT HERE *****
485: */
486:
487: insert into FND_LOOKUP_TYPES_TL (
488: LOOKUP_TYPE,
489: SECURITY_GROUP_ID,
490: VIEW_APPLICATION_ID,
491: MEANING,

Line 513: from FND_LOOKUP_TYPES_TL B, FND_LANGUAGES L

509: B.LAST_UPDATE_DATE,
510: B.LAST_UPDATE_LOGIN,
511: L.LANGUAGE_CODE,
512: B.SOURCE_LANG
513: from FND_LOOKUP_TYPES_TL B, FND_LANGUAGES L
514: where L.INSTALLED_FLAG in ('I', 'B')
515: and B.LANGUAGE = userenv('LANG')
516: and not exists
517: (select NULL

Line 518: from FND_LOOKUP_TYPES_TL T

514: where L.INSTALLED_FLAG in ('I', 'B')
515: and B.LANGUAGE = userenv('LANG')
516: and not exists
517: (select NULL
518: from FND_LOOKUP_TYPES_TL T
519: where T.LOOKUP_TYPE = B.LOOKUP_TYPE
520: and T.SECURITY_GROUP_ID = B.SECURITY_GROUP_ID
521: and T.VIEW_APPLICATION_ID = B.VIEW_APPLICATION_ID
522: and T.LANGUAGE = L.LANGUAGE_CODE);