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 FA_LOOKUP_TYPES

Line 1: package body FA_LOOKUP_TYPES_PKG as

1: package body FA_LOOKUP_TYPES_PKG as
2: /* $Header: faxiltb.pls 120.11 2011/03/11 02:20:14 saalampa ship $ */
3: procedure INSERT_ROW (
4: X_ROWID in out nocopy VARCHAR2,
5: X_LOOKUP_TYPE in VARCHAR2,

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

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

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 288: from fa_lookup_types

284: end if;
285:
286: select count(*)
287: into h_record_exists
288: from fa_lookup_types
289: where lookup_type = X_Lookup_Type;
290:
291: if (h_record_exists > 0) then
292: fa_lookup_types_pkg.update_row (

Line 292: fa_lookup_types_pkg.update_row (

288: from fa_lookup_types
289: where lookup_type = X_Lookup_Type;
290:
291: if (h_record_exists > 0) then
292: fa_lookup_types_pkg.update_row (
293: X_Lookup_Type => X_Lookup_Type,
294: X_User_Maintainable => X_User_Maintainable,
295: X_Meaning => X_Meaning,
296: X_Description => X_Description,

Line 302: fa_lookup_types_pkg.insert_row (

298: X_Last_Updated_By => user_id,
299: X_Last_Update_Login => 0
300: , p_log_level_rec => p_log_level_rec);
301: else
302: fa_lookup_types_pkg.insert_row (
303: X_Rowid => row_id,
304: X_Lookup_Type => X_Lookup_Type,
305: X_User_Maintainable => X_User_Maintainable,
306: X_Meaning => X_Meaning,

Line 319: CALLED_FN => 'fa_lookup_types_pkg.load_row',

315:
316: exception
317: when others then
318: FA_STANDARD_PKG.RAISE_ERROR(
319: CALLED_FN => 'fa_lookup_types_pkg.load_row',
320: CALLING_FN => 'upload fa_lookup_types',
321: p_log_level_rec => p_log_level_rec);
322:
323: end LOAD_ROW;

Line 320: CALLING_FN => 'upload fa_lookup_types',

316: exception
317: when others then
318: FA_STANDARD_PKG.RAISE_ERROR(
319: CALLED_FN => 'fa_lookup_types_pkg.load_row',
320: CALLING_FN => 'upload fa_lookup_types',
321: p_log_level_rec => p_log_level_rec);
322:
323: end LOAD_ROW;
324: /*Bug 8355119 overloading function for release specific signatures*/

Line 349: from fa_lookup_types

345: user_id := fnd_load_util.owner_id (X_Owner);
346:
347: select count(*)
348: into h_record_exists
349: from fa_lookup_types
350: where lookup_type = X_Lookup_Type;
351:
352: if (h_record_exists > 0) then
353:

Line 356: from fa_lookup_types

352: if (h_record_exists > 0) then
353:
354: select last_updated_by, last_update_date
355: into db_last_updated_by, db_last_update_date
356: from fa_lookup_types
357: where lookup_type = x_lookup_type;
358:
359: if (fnd_load_util.upload_test(user_id, x_last_update_date,
360: db_last_updated_by, db_last_update_date,

Line 363: fa_lookup_types_pkg.update_row (

359: if (fnd_load_util.upload_test(user_id, x_last_update_date,
360: db_last_updated_by, db_last_update_date,
361: X_CUSTOM_MODE)) then
362:
363: fa_lookup_types_pkg.update_row (
364: X_Lookup_Type => X_Lookup_Type,
365: X_User_Maintainable => X_User_Maintainable,
366: X_Meaning => X_Meaning,
367: X_Description => X_Description,

Line 374: fa_lookup_types_pkg.insert_row (

370: X_Last_Update_Login => 0
371: ,p_log_level_rec => p_log_level_rec);
372: end if;
373: else
374: fa_lookup_types_pkg.insert_row (
375: X_Rowid => row_id,
376: X_Lookup_Type => X_Lookup_Type,
377: X_User_Maintainable => X_User_Maintainable,
378: X_Meaning => X_Meaning,

Line 391: CALLED_FN => 'fa_lookup_types_pkg.load_row',

387:
388: exception
389: when others then
390: FA_STANDARD_PKG.RAISE_ERROR(
391: CALLED_FN => 'fa_lookup_types_pkg.load_row',
392: CALLING_FN => 'upload fa_lookup_types'
393: ,p_log_level_rec => p_log_level_rec);
394:
395: end LOAD_ROW;

Line 392: CALLING_FN => 'upload fa_lookup_types'

388: exception
389: when others then
390: FA_STANDARD_PKG.RAISE_ERROR(
391: CALLED_FN => 'fa_lookup_types_pkg.load_row',
392: CALLING_FN => 'upload fa_lookup_types'
393: ,p_log_level_rec => p_log_level_rec);
394:
395: end LOAD_ROW;
396:

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 428: CALLED_FN => 'fa_lookup_types_pkg.translate_row',

424:
425: exception
426: when others then
427: FA_STANDARD_PKG.RAISE_ERROR(
428: CALLED_FN => 'fa_lookup_types_pkg.translate_row',
429: CALLING_FN => 'upload fa_lookup_types',
430: p_log_level_rec => p_log_level_rec);
431:
432: end TRANSLATE_ROW;

Line 429: CALLING_FN => 'upload fa_lookup_types',

425: exception
426: when others then
427: FA_STANDARD_PKG.RAISE_ERROR(
428: CALLED_FN => 'fa_lookup_types_pkg.translate_row',
429: CALLING_FN => 'upload fa_lookup_types',
430: p_log_level_rec => p_log_level_rec);
431:
432: end TRANSLATE_ROW;
433: /*Bug 8355119 overloading function for release specific signatures*/

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,

Line 477: CALLED_FN => 'fa_lookup_types_pkg.translate_row',

473:
474: exception
475: when others then
476: FA_STANDARD_PKG.RAISE_ERROR(
477: CALLED_FN => 'fa_lookup_types_pkg.translate_row',
478: CALLING_FN => 'upload fa_lookup_types'
479: ,p_log_level_rec => p_log_level_rec);
480:
481: end TRANSLATE_ROW;

Line 478: CALLING_FN => 'upload fa_lookup_types'

474: exception
475: when others then
476: FA_STANDARD_PKG.RAISE_ERROR(
477: CALLED_FN => 'fa_lookup_types_pkg.translate_row',
478: CALLING_FN => 'upload fa_lookup_types'
479: ,p_log_level_rec => p_log_level_rec);
480:
481: end TRANSLATE_ROW;
482: /*bug 8355119 adding R12 specific funtion LOAD_SEED_ROW*/

Line 497: fa_lookup_types_pkg.TRANSLATE_ROW (

493:
494: BEGIN
495:
496: if (x_upload_mode = 'NLS') then
497: fa_lookup_types_pkg.TRANSLATE_ROW (
498: x_custom_mode => x_custom_mode,
499: x_lookup_type => x_lookup_type,
500: x_owner => x_owner,
501: x_last_update_date => x_last_update_date,

Line 505: fa_lookup_types_pkg.LOAD_ROW (

501: x_last_update_date => x_last_update_date,
502: x_meaning => x_meaning,
503: x_description => x_description);
504: else
505: fa_lookup_types_pkg.LOAD_ROW (
506: x_custom_mode => x_custom_mode,
507: x_lookup_type => x_lookup_type,
508: x_owner => x_owner,
509: x_last_update_date => x_last_update_date,

Line 517: end FA_LOOKUP_TYPES_PKG;

513: end if;
514:
515: END LOAD_SEED_ROW;
516:
517: end FA_LOOKUP_TYPES_PKG;