APPS.FA_LOOKUPS_PKG dependencies on AD_ZD_SEED

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 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 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 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 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 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: