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_B

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) 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: ad_zd_seed.prepare('FA_LOOKUPS_B');

35: where LOOKUP_TYPE = X_LOOKUP_TYPE
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,

Line 41: insert into FA_LOOKUPS_B (

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,
45: START_DATE_ACTIVE,

Line 185: from FA_LOOKUPS_B

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

Line 298: ad_zd_seed.prepare('FA_LOOKUPS_B');

294: X_LAST_UPDATED_BY in NUMBER,
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,

Line 300: update FA_LOOKUPS_B set

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,
304: ATTRIBUTE1 = X_ATTRIBUTE1,

Line 351: ad_zd_seed.prepare('FA_LOOKUPS_B');

347: X_LOOKUP_TYPE in VARCHAR2,
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;

Line 361: delete from FA_LOOKUPS_B

357: if (sql%notfound) then
358: raise no_data_found;
359: end if;
360:
361: delete from FA_LOOKUPS_B
362: where LOOKUP_TYPE = X_LOOKUP_TYPE
363: and LOOKUP_CODE = X_LOOKUP_CODE;
364:
365: if (sql%notfound) then

Line 376: from FA_LOOKUPS_B B

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
378: and B.LOOKUP_CODE = T.LOOKUP_CODE
379: );
380: