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_LOOKUP_TYPES_PKG dependencies on AD_ZD_SEED

Line 19: ad_zd_seed.prepare('FA_LOOKUP_TYPES_B');

15: cursor C is select ROWID from FA_LOOKUP_TYPES_B
16: where LOOKUP_TYPE = X_LOOKUP_TYPE
17: ;
18: begin
19: ad_zd_seed.prepare('FA_LOOKUP_TYPES_B');
20: ad_zd_seed.prepare('FA_LOOKUP_TYPES_TL');
21: insert into FA_LOOKUP_TYPES_B (
22: LOOKUP_TYPE,
23: USER_MAINTAINABLE,

Line 20: ad_zd_seed.prepare('FA_LOOKUP_TYPES_TL');

16: where LOOKUP_TYPE = X_LOOKUP_TYPE
17: ;
18: begin
19: ad_zd_seed.prepare('FA_LOOKUP_TYPES_B');
20: ad_zd_seed.prepare('FA_LOOKUP_TYPES_TL');
21: insert into FA_LOOKUP_TYPES_B (
22: LOOKUP_TYPE,
23: USER_MAINTAINABLE,
24: CREATION_DATE,

Line 142: ad_zd_seed.prepare('FA_LOOKUP_TYPES_B');

138: X_LAST_UPDATED_BY in NUMBER,
139: X_LAST_UPDATE_LOGIN in NUMBER
140: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
141: begin
142: ad_zd_seed.prepare('FA_LOOKUP_TYPES_B');
143: ad_zd_seed.prepare('FA_LOOKUP_TYPES_TL');
144: update FA_LOOKUP_TYPES_B set
145: USER_MAINTAINABLE = X_USER_MAINTAINABLE,
146: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,

Line 143: ad_zd_seed.prepare('FA_LOOKUP_TYPES_TL');

139: X_LAST_UPDATE_LOGIN in NUMBER
140: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
141: begin
142: ad_zd_seed.prepare('FA_LOOKUP_TYPES_B');
143: ad_zd_seed.prepare('FA_LOOKUP_TYPES_TL');
144: update FA_LOOKUP_TYPES_B set
145: USER_MAINTAINABLE = X_USER_MAINTAINABLE,
146: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
147: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 174: ad_zd_seed.prepare('FA_LOOKUP_TYPES_B');

170: procedure DELETE_ROW (
171: X_LOOKUP_TYPE in VARCHAR2
172: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
173: begin
174: ad_zd_seed.prepare('FA_LOOKUP_TYPES_B');
175: ad_zd_seed.prepare('FA_LOOKUP_TYPES_TL');
176: delete from FA_LOOKUP_TYPES_TL
177: where LOOKUP_TYPE = X_LOOKUP_TYPE;
178:

Line 175: ad_zd_seed.prepare('FA_LOOKUP_TYPES_TL');

171: X_LOOKUP_TYPE in VARCHAR2
172: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
173: begin
174: ad_zd_seed.prepare('FA_LOOKUP_TYPES_B');
175: ad_zd_seed.prepare('FA_LOOKUP_TYPES_TL');
176: delete from FA_LOOKUP_TYPES_TL
177: where LOOKUP_TYPE = X_LOOKUP_TYPE;
178:
179: if (sql%notfound) then