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

Line 1: package body FA_LOOKUPS_PKG as

1: package body FA_LOOKUPS_PKG as
2: /* $Header: faxilob.pls 120.9 2006/06/29 20:49:14 glchen ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_LOOKUP_TYPE in VARCHAR2,

Line 34: cursor C is select ROWID from FA_LOOKUPS_B

30: X_LAST_UPDATE_DATE in DATE,
31: X_LAST_UPDATED_BY in NUMBER,
32: X_LAST_UPDATE_LOGIN in NUMBER,
33: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
34: cursor C is select ROWID from FA_LOOKUPS_B
35: where LOOKUP_TYPE = X_LOOKUP_TYPE
36: and LOOKUP_CODE = X_LOOKUP_CODE
37: ;
38: begin

Line 39: insert into FA_LOOKUPS_B (

35: where LOOKUP_TYPE = X_LOOKUP_TYPE
36: and LOOKUP_CODE = X_LOOKUP_CODE
37: ;
38: begin
39: insert into FA_LOOKUPS_B (
40: LOOKUP_TYPE,
41: LOOKUP_CODE,
42: ENABLED_FLAG,
43: START_DATE_ACTIVE,

Line 95: insert into FA_LOOKUPS_TL (

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

Line 123: from FA_LOOKUPS_TL T

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

Line 183: from FA_LOOKUPS_B

179: ATTRIBUTE13,
180: ATTRIBUTE14,
181: ATTRIBUTE15,
182: ATTRIBUTE_CATEGORY_CODE
183: from FA_LOOKUPS_B
184: where LOOKUP_TYPE = X_LOOKUP_TYPE
185: and LOOKUP_CODE = X_LOOKUP_CODE
186: for update of LOOKUP_TYPE nowait;
187: recinfo c%rowtype;

Line 193: from FA_LOOKUPS_TL

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

Line 294: update FA_LOOKUPS_B set

290: X_LAST_UPDATED_BY in NUMBER,
291: X_LAST_UPDATE_LOGIN in NUMBER,
292: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
293: begin
294: update FA_LOOKUPS_B set
295: ENABLED_FLAG = X_ENABLED_FLAG,
296: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
297: END_DATE_ACTIVE = X_END_DATE_ACTIVE,
298: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 324: update FA_LOOKUPS_TL set

320: if (sql%notfound) then
321: raise no_data_found;
322: end if;
323:
324: update FA_LOOKUPS_TL set
325: MEANING = X_MEANING,
326: DESCRIPTION = X_DESCRIPTION,
327: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
328: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 345: delete from FA_LOOKUPS_TL

341: X_LOOKUP_TYPE in VARCHAR2,
342: X_LOOKUP_CODE in VARCHAR2,
343: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
344: begin
345: delete from FA_LOOKUPS_TL
346: where LOOKUP_TYPE = X_LOOKUP_TYPE
347: and LOOKUP_CODE = X_LOOKUP_CODE;
348:
349: if (sql%notfound) then

Line 353: delete from FA_LOOKUPS_B

349: if (sql%notfound) then
350: raise no_data_found;
351: end if;
352:
353: delete from FA_LOOKUPS_B
354: where LOOKUP_TYPE = X_LOOKUP_TYPE
355: and LOOKUP_CODE = X_LOOKUP_CODE;
356:
357: if (sql%notfound) then

Line 365: delete from FA_LOOKUPS_TL T

361:
362: procedure ADD_LANGUAGE(p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
363: is
364: begin
365: delete from FA_LOOKUPS_TL T
366: where not exists
367: (select NULL
368: from FA_LOOKUPS_B B
369: where B.LOOKUP_TYPE = T.LOOKUP_TYPE

Line 368: from FA_LOOKUPS_B B

364: begin
365: delete from FA_LOOKUPS_TL T
366: where not exists
367: (select NULL
368: from FA_LOOKUPS_B B
369: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
370: and B.LOOKUP_CODE = T.LOOKUP_CODE
371: );
372:

Line 373: update FA_LOOKUPS_TL T set (

369: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
370: and B.LOOKUP_CODE = T.LOOKUP_CODE
371: );
372:
373: update FA_LOOKUPS_TL T set (
374: MEANING,
375: DESCRIPTION
376: ) = (select
377: B.MEANING,

Line 379: from FA_LOOKUPS_TL B

375: DESCRIPTION
376: ) = (select
377: B.MEANING,
378: B.DESCRIPTION
379: from FA_LOOKUPS_TL B
380: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
381: and B.LOOKUP_CODE = T.LOOKUP_CODE
382: and B.LANGUAGE = T.SOURCE_LANG)
383: where (

Line 391: from FA_LOOKUPS_TL SUBB, FA_LOOKUPS_TL SUBT

387: ) in (select
388: SUBT.LOOKUP_TYPE,
389: SUBT.LOOKUP_CODE,
390: SUBT.LANGUAGE
391: from FA_LOOKUPS_TL SUBB, FA_LOOKUPS_TL SUBT
392: where SUBB.LOOKUP_TYPE = SUBT.LOOKUP_TYPE
393: and SUBB.LOOKUP_CODE = SUBT.LOOKUP_CODE
394: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
395: and (SUBB.MEANING <> SUBT.MEANING

Line 401: insert into FA_LOOKUPS_TL (

397: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
398: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
399: ));
400:
401: insert into FA_LOOKUPS_TL (
402: LOOKUP_TYPE,
403: LOOKUP_CODE,
404: MEANING,
405: DESCRIPTION,

Line 425: from FA_LOOKUPS_TL B, FND_LANGUAGES L

421: B.CREATION_DATE,
422: B.LAST_UPDATE_LOGIN,
423: L.LANGUAGE_CODE,
424: B.SOURCE_LANG
425: from FA_LOOKUPS_TL B, FND_LANGUAGES L
426: where L.INSTALLED_FLAG in ('I', 'B')
427: and B.LANGUAGE = userenv('LANG')
428: and not exists
429: (select NULL

Line 430: from FA_LOOKUPS_TL T

426: where L.INSTALLED_FLAG in ('I', 'B')
427: and B.LANGUAGE = userenv('LANG')
428: and not exists
429: (select NULL
430: from FA_LOOKUPS_TL T
431: where T.LOOKUP_TYPE = B.LOOKUP_TYPE
432: and T.LOOKUP_CODE = B.LOOKUP_CODE
433: and T.LANGUAGE = L.LANGUAGE_CODE);
434: end ADD_LANGUAGE;

Line 479: from fa_lookups

475: user_id := fnd_load_util.owner_id (X_Owner);
476:
477: select count(*)
478: into h_record_exists
479: from fa_lookups
480: where lookup_type = X_Lookup_Type
481: and lookup_code = X_Lookup_Code;
482:
483: if (h_record_exists > 0) then

Line 487: from fa_lookups

483: if (h_record_exists > 0) then
484:
485: select last_updated_by, last_update_date
486: into db_last_updated_by, db_last_update_date
487: from fa_lookups
488: where lookup_type = x_lookup_type
489: and lookup_code = x_lookup_code;
490:
491: if (fnd_load_util.upload_test(user_id, x_last_update_date,

Line 495: fa_lookups_pkg.update_row (

491: if (fnd_load_util.upload_test(user_id, x_last_update_date,
492: db_last_updated_by, db_last_update_date,
493: X_CUSTOM_MODE)) then
494:
495: fa_lookups_pkg.update_row (
496: X_Lookup_Type => X_Lookup_Type,
497: X_Lookup_Code => X_Lookup_Code,
498: X_Enabled_Flag => X_Enabled_Flag,
499: X_Start_Date_Active => X_Start_Date_Active,

Line 525: fa_lookups_pkg.insert_row (

521: X_Last_Update_Login => 0
522: ,p_log_level_rec => p_log_level_rec);
523: end if;
524: else
525: fa_lookups_pkg.insert_row (
526: X_Rowid => row_id,
527: X_Lookup_Type => X_Lookup_Type,
528: X_Lookup_Code => X_Lookup_Code,
529: X_Enabled_Flag => X_Enabled_Flag,

Line 561: CALLED_FN => 'fa_lookups_pkg.load_row',

557:
558: exception
559: when others then
560: FA_STANDARD_PKG.RAISE_ERROR(
561: CALLED_FN => 'fa_lookups_pkg.load_row',
562: CALLING_FN => 'upload fa_lookups'
563: ,p_log_level_rec => p_log_level_rec);
564:
565: end LOAD_ROW;

Line 562: CALLING_FN => 'upload fa_lookups'

558: exception
559: when others then
560: FA_STANDARD_PKG.RAISE_ERROR(
561: CALLED_FN => 'fa_lookups_pkg.load_row',
562: CALLING_FN => 'upload fa_lookups'
563: ,p_log_level_rec => p_log_level_rec);
564:
565: end LOAD_ROW;
566:

Line 586: from fa_lookups_tl

582: begin
583:
584: select last_updated_by, last_update_date
585: into db_last_updated_by, db_last_update_date
586: from fa_lookups_tl
587: where lookup_type = x_lookup_type
588: and lookup_code = x_lookup_code
589: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
590:

Line 597: update FA_LOOKUPS_TL set

593: if (fnd_load_util.upload_test(user_id, sysdate,
594: db_last_updated_by, db_last_update_date,
595: X_CUSTOM_MODE)) then
596:
597: update FA_LOOKUPS_TL set
598: MEANING = nvl(X_Meaning, MEANING),
599: DESCRIPTION = nvl(X_Description, DESCRIPTION),
600: LAST_UPDATE_DATE = X_Last_Update_Date,
601: LAST_UPDATED_BY = user_id,

Line 645: fa_lookups_pkg.TRANSLATE_ROW (

641:
642: BEGIN
643:
644: if (x_upload_mode = 'NLS') then
645: fa_lookups_pkg.TRANSLATE_ROW (
646: x_custom_mode => x_custom_mode,
647: x_lookup_type => x_lookup_type,
648: x_lookup_code => x_lookup_code,
649: x_owner => x_owner,

Line 654: fa_lookups_pkg.LOAD_ROW (

650: x_last_update_date => x_last_update_date,
651: x_meaning => x_meaning,
652: x_description => x_description);
653: else
654: fa_lookups_pkg.LOAD_ROW (
655: x_custom_mode => x_custom_mode,
656: x_lookup_type => x_lookup_type,
657: x_lookup_code => x_lookup_code,
658: x_owner => x_owner,

Line 686: end FA_LOOKUPS_PKG;

682: end if;
683:
684: END LOAD_SEED_ROW;
685:
686: end FA_LOOKUPS_PKG;