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.

[Home] [Help]

APPS.FA_LOOKUP_TYPES_PKG dependencies on FA_LOOKUP_TYPES_TL

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 39: insert into FA_LOOKUP_TYPES_TL (

35: X_LAST_UPDATED_BY,
36: X_LAST_UPDATE_LOGIN
37: );
38:
39: insert into FA_LOOKUP_TYPES_TL (
40: LOOKUP_TYPE,
41: MEANING,
42: DESCRIPTION,
43: LAST_UPDATE_DATE,

Line 65: from FA_LOOKUP_TYPES_TL T

61: from FND_LANGUAGES L
62: where L.INSTALLED_FLAG in ('I', 'B')
63: and not exists
64: (select NULL
65: from FA_LOOKUP_TYPES_TL T
66: where T.LOOKUP_TYPE = X_LOOKUP_TYPE
67: and T.LANGUAGE = L.LANGUAGE_CODE);
68:
69: open c;

Line 96: from FA_LOOKUP_TYPES_TL

92: cursor c1 is select
93: MEANING,
94: DESCRIPTION,
95: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
96: from FA_LOOKUP_TYPES_TL
97: where LOOKUP_TYPE = X_LOOKUP_TYPE
98: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
99: for update of LOOKUP_TYPE nowait;
100: begin

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 155: update FA_LOOKUP_TYPES_TL set

151: if (sql%notfound) then
152: raise no_data_found;
153: end if;
154:
155: update FA_LOOKUP_TYPES_TL set
156: MEANING = X_MEANING,
157: DESCRIPTION = X_DESCRIPTION,
158: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
159: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

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

Line 176: delete from FA_LOOKUP_TYPES_TL

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
180: raise no_data_found;

Line 194: delete from FA_LOOKUP_TYPES_TL T

190: /* bug 8355119
191: procedure ADD_LANGUAGE
192: is
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

Line 204: delete from FA_LOOKUP_TYPES_TL T

200: /* bug 8355119*/
201: procedure ADD_LANGUAGE(p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
202: is
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

Line 211: update FA_LOOKUP_TYPES_TL T set (

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 (
212: MEANING,
213: DESCRIPTION
214: ) = (select
215: B.MEANING,

Line 217: from FA_LOOKUP_TYPES_TL B

213: DESCRIPTION
214: ) = (select
215: B.MEANING,
216: B.DESCRIPTION
217: from FA_LOOKUP_TYPES_TL B
218: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
219: and B.LANGUAGE = T.SOURCE_LANG)
220: where (
221: T.LOOKUP_TYPE,

Line 226: from FA_LOOKUP_TYPES_TL SUBB, FA_LOOKUP_TYPES_TL SUBT

222: T.LANGUAGE
223: ) in (select
224: SUBT.LOOKUP_TYPE,
225: SUBT.LANGUAGE
226: from FA_LOOKUP_TYPES_TL SUBB, FA_LOOKUP_TYPES_TL SUBT
227: where SUBB.LOOKUP_TYPE = SUBT.LOOKUP_TYPE
228: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
229: and (SUBB.MEANING <> SUBT.MEANING
230: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 233: insert into FA_LOOKUP_TYPES_TL (

229: and (SUBB.MEANING <> SUBT.MEANING
230: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
231: ));
232:
233: insert into FA_LOOKUP_TYPES_TL (
234: LOOKUP_TYPE,
235: MEANING,
236: DESCRIPTION,
237: LAST_UPDATE_DATE,

Line 255: from FA_LOOKUP_TYPES_TL B, FND_LANGUAGES L

251: B.CREATION_DATE,
252: B.LAST_UPDATE_LOGIN,
253: L.LANGUAGE_CODE,
254: B.SOURCE_LANG
255: from FA_LOOKUP_TYPES_TL B, FND_LANGUAGES L
256: where L.INSTALLED_FLAG in ('I', 'B')
257: and B.LANGUAGE = userenv('LANG')
258: and not exists
259: (select NULL

Line 260: from FA_LOOKUP_TYPES_TL T

256: where L.INSTALLED_FLAG in ('I', 'B')
257: and B.LANGUAGE = userenv('LANG')
258: and not exists
259: (select NULL
260: from FA_LOOKUP_TYPES_TL T
261: where T.LOOKUP_TYPE = B.LOOKUP_TYPE
262: and T.LANGUAGE = L.LANGUAGE_CODE);
263: end ADD_LANGUAGE;
264:

Line 414: update FA_LOOKUP_TYPES_TL set

410: else
411: user_id := 0;
412: end if;
413:
414: update FA_LOOKUP_TYPES_TL set
415: MEANING = nvl(X_Meaning, MEANING),
416: DESCRIPTION = nvl(X_Description, DESCRIPTION),
417: LAST_UPDATE_DATE = sysdate,
418: LAST_UPDATED_BY = user_id,

Line 452: from fa_lookup_types_tl

448: begin
449:
450: select last_updated_by, last_update_date
451: into db_last_updated_by, db_last_update_date
452: from fa_lookup_types_tl
453: where lookup_type = x_lookup_type
454: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
455:
456: user_id := fnd_load_util.owner_id (X_Owner);

Line 462: update FA_LOOKUP_TYPES_TL set

458: if (fnd_load_util.upload_test(user_id, sysdate,
459: db_last_updated_by, db_last_update_date,
460: X_CUSTOM_MODE)) then
461:
462: update FA_LOOKUP_TYPES_TL set
463: MEANING = nvl(X_Meaning, MEANING),
464: DESCRIPTION = nvl(X_Description, DESCRIPTION),
465: LAST_UPDATE_DATE = X_Last_Update_Date,
466: LAST_UPDATED_BY = user_id,