APPS.FA_LOOKUP_TYPES_PKG dependencies on FA_LOOKUP_TYPES_B

Line 15: cursor C is select ROWID from FA_LOOKUP_TYPES_B

11: X_LAST_UPDATE_DATE in DATE,
12: X_LAST_UPDATED_BY in NUMBER,
13: X_LAST_UPDATE_LOGIN in NUMBER
14: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
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');

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 21: insert into FA_LOOKUP_TYPES_B (

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,
25: CREATED_BY,

Line 87: from FA_LOOKUP_TYPES_B

83: X_DESCRIPTION in VARCHAR2
84: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
85: cursor c is select
86: USER_MAINTAINABLE
87: from FA_LOOKUP_TYPES_B
88: where LOOKUP_TYPE = X_LOOKUP_TYPE
89: for update of LOOKUP_TYPE nowait;
90: recinfo c%rowtype;
91:

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 144: update FA_LOOKUP_TYPES_B set

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,
148: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

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 183: delete from FA_LOOKUP_TYPES_B

179: if (sql%notfound) then
180: raise no_data_found;
181: end if;
182:
183: delete from FA_LOOKUP_TYPES_B
184: where LOOKUP_TYPE = X_LOOKUP_TYPE;
185:
186: if (sql%notfound) then
187: raise no_data_found;

Line 197: from FA_LOOKUP_TYPES_B B

193: begin
194: delete from FA_LOOKUP_TYPES_TL T
195: where not exists
196: (select NULL
197: from FA_LOOKUP_TYPES_B B
198: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
199: );*/
200: /* bug 8355119*/
201: procedure ADD_LANGUAGE(p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)

Line 207: from FA_LOOKUP_TYPES_B B

203: begin
204: delete from FA_LOOKUP_TYPES_TL T
205: where not exists
206: (select NULL
207: from FA_LOOKUP_TYPES_B B
208: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
209: );
210:
211: update FA_LOOKUP_TYPES_TL T set (