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.FA_LOOKUPS_PKG dependencies on FA_LOOKUPS_TL

Line 40: ad_zd_seed.prepare('FA_LOOKUPS_TL');

36: and LOOKUP_CODE = X_LOOKUP_CODE
37: ;
38: begin
39: ad_zd_seed.prepare('FA_LOOKUPS_B');
40: ad_zd_seed.prepare('FA_LOOKUPS_TL');
41: insert into FA_LOOKUPS_B (
42: LOOKUP_TYPE,
43: LOOKUP_CODE,
44: ENABLED_FLAG,

Line 97: insert into FA_LOOKUPS_TL (

93: X_LAST_UPDATED_BY,
94: X_LAST_UPDATE_LOGIN
95: );
96:
97: insert into FA_LOOKUPS_TL (
98: LOOKUP_TYPE,
99: LOOKUP_CODE,
100: MEANING,
101: DESCRIPTION,

Line 125: from FA_LOOKUPS_TL T

121: from FND_LANGUAGES L
122: where L.INSTALLED_FLAG in ('I', 'B')
123: and not exists
124: (select NULL
125: from FA_LOOKUPS_TL T
126: where T.LOOKUP_TYPE = X_LOOKUP_TYPE
127: and T.LOOKUP_CODE = X_LOOKUP_CODE
128: and T.LANGUAGE = L.LANGUAGE_CODE);
129:

Line 195: from FA_LOOKUPS_TL

191: cursor c1 is select
192: MEANING,
193: DESCRIPTION,
194: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
195: from FA_LOOKUPS_TL
196: where LOOKUP_TYPE = X_LOOKUP_TYPE
197: and LOOKUP_CODE = X_LOOKUP_CODE
198: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
199: for update of LOOKUP_TYPE nowait;

Line 299: ad_zd_seed.prepare('FA_LOOKUPS_TL');

295: X_LAST_UPDATE_LOGIN in NUMBER
296: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
297: begin
298: ad_zd_seed.prepare('FA_LOOKUPS_B');
299: ad_zd_seed.prepare('FA_LOOKUPS_TL');
300: update FA_LOOKUPS_B set
301: ENABLED_FLAG = X_ENABLED_FLAG,
302: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
303: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 330: update FA_LOOKUPS_TL set

326: if (sql%notfound) then
327: raise no_data_found;
328: end if;
329:
330: update FA_LOOKUPS_TL set
331: MEANING = X_MEANING,
332: DESCRIPTION = X_DESCRIPTION,
333: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
334: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 352: ad_zd_seed.prepare('FA_LOOKUPS_TL');

348: X_LOOKUP_CODE in VARCHAR2
349: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
350: begin
351: ad_zd_seed.prepare('FA_LOOKUPS_B');
352: ad_zd_seed.prepare('FA_LOOKUPS_TL');
353: delete from FA_LOOKUPS_TL
354: where LOOKUP_TYPE = X_LOOKUP_TYPE
355: and LOOKUP_CODE = X_LOOKUP_CODE;
356:

Line 353: delete from FA_LOOKUPS_TL

349: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
350: begin
351: ad_zd_seed.prepare('FA_LOOKUPS_B');
352: ad_zd_seed.prepare('FA_LOOKUPS_TL');
353: delete from FA_LOOKUPS_TL
354: where LOOKUP_TYPE = X_LOOKUP_TYPE
355: and LOOKUP_CODE = X_LOOKUP_CODE;
356:
357: if (sql%notfound) then

Line 373: delete from FA_LOOKUPS_TL T

369:
370: procedure ADD_LANGUAGE
371: is
372: begin
373: delete from FA_LOOKUPS_TL T
374: where not exists
375: (select NULL
376: from FA_LOOKUPS_B B
377: where B.LOOKUP_TYPE = T.LOOKUP_TYPE

Line 381: update FA_LOOKUPS_TL T set (

377: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
378: and B.LOOKUP_CODE = T.LOOKUP_CODE
379: );
380:
381: update FA_LOOKUPS_TL T set (
382: MEANING,
383: DESCRIPTION
384: ) = (select
385: B.MEANING,

Line 387: from FA_LOOKUPS_TL B

383: DESCRIPTION
384: ) = (select
385: B.MEANING,
386: B.DESCRIPTION
387: from FA_LOOKUPS_TL B
388: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
389: and B.LOOKUP_CODE = T.LOOKUP_CODE
390: and B.LANGUAGE = T.SOURCE_LANG)
391: where (

Line 399: from FA_LOOKUPS_TL SUBB, FA_LOOKUPS_TL SUBT

395: ) in (select
396: SUBT.LOOKUP_TYPE,
397: SUBT.LOOKUP_CODE,
398: SUBT.LANGUAGE
399: from FA_LOOKUPS_TL SUBB, FA_LOOKUPS_TL SUBT
400: where SUBB.LOOKUP_TYPE = SUBT.LOOKUP_TYPE
401: and SUBB.LOOKUP_CODE = SUBT.LOOKUP_CODE
402: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
403: and (SUBB.MEANING <> SUBT.MEANING

Line 409: insert into FA_LOOKUPS_TL (

405: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
406: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
407: ));
408:
409: insert into FA_LOOKUPS_TL (
410: LOOKUP_TYPE,
411: LOOKUP_CODE,
412: MEANING,
413: DESCRIPTION,

Line 433: from FA_LOOKUPS_TL B, FND_LANGUAGES L

429: B.CREATION_DATE,
430: B.LAST_UPDATE_LOGIN,
431: L.LANGUAGE_CODE,
432: B.SOURCE_LANG
433: from FA_LOOKUPS_TL B, FND_LANGUAGES L
434: where L.INSTALLED_FLAG in ('I', 'B')
435: and B.LANGUAGE = userenv('LANG')
436: and not exists
437: (select NULL

Line 438: from FA_LOOKUPS_TL T

434: where L.INSTALLED_FLAG in ('I', 'B')
435: and B.LANGUAGE = userenv('LANG')
436: and not exists
437: (select NULL
438: from FA_LOOKUPS_TL T
439: where T.LOOKUP_TYPE = B.LOOKUP_TYPE
440: and T.LOOKUP_CODE = B.LOOKUP_CODE
441: and T.LANGUAGE = L.LANGUAGE_CODE);
442: end ADD_LANGUAGE;

Line 711: update FA_LOOKUPS_TL set

707: else
708: user_id := 0;
709: end if;
710:
711: update FA_LOOKUPS_TL set
712: MEANING = nvl(X_Meaning, MEANING),
713: DESCRIPTION = nvl(X_Description, DESCRIPTION),
714: LAST_UPDATE_DATE = sysdate,
715: LAST_UPDATED_BY = user_id,

Line 743: from fa_lookups_tl

739: begin
740:
741: select last_updated_by, last_update_date
742: into db_last_updated_by, db_last_update_date
743: from fa_lookups_tl
744: where lookup_type = x_lookup_type
745: and lookup_code = x_lookup_code
746: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
747:

Line 754: update FA_LOOKUPS_TL set

750: if (fnd_load_util.upload_test(user_id, sysdate,
751: db_last_updated_by, db_last_update_date,
752: X_CUSTOM_MODE)) then
753:
754: update FA_LOOKUPS_TL set
755: MEANING = nvl(X_Meaning, MEANING),
756: DESCRIPTION = nvl(X_Description, DESCRIPTION),
757: LAST_UPDATE_DATE = X_Last_Update_Date,
758: LAST_UPDATED_BY = user_id,