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.7 2006/06/29 20:50:35 glchen 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 default null) is
15: cursor C is select ROWID from FA_LOOKUP_TYPES_B
16: where LOOKUP_TYPE = X_LOOKUP_TYPE
17: ;
18: begin
19: insert into FA_LOOKUP_TYPES_B (

Line 19: insert into 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: insert into FA_LOOKUP_TYPES_B (
20: LOOKUP_TYPE,
21: USER_MAINTAINABLE,
22: CREATION_DATE,
23: CREATED_BY,

Line 37: insert into FA_LOOKUP_TYPES_TL (

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

Line 63: from FA_LOOKUP_TYPES_TL T

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

Line 85: from FA_LOOKUP_TYPES_B

81: X_DESCRIPTION in VARCHAR2,
82: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
83: cursor c is select
84: USER_MAINTAINABLE
85: from FA_LOOKUP_TYPES_B
86: where LOOKUP_TYPE = X_LOOKUP_TYPE
87: for update of LOOKUP_TYPE nowait;
88: recinfo c%rowtype;
89:

Line 94: from FA_LOOKUP_TYPES_TL

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

Line 138: update FA_LOOKUP_TYPES_B set

134: X_LAST_UPDATED_BY in NUMBER,
135: X_LAST_UPDATE_LOGIN in NUMBER,
136: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
137: begin
138: update FA_LOOKUP_TYPES_B set
139: USER_MAINTAINABLE = X_USER_MAINTAINABLE,
140: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
141: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
142: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN

Line 149: update FA_LOOKUP_TYPES_TL set

145: if (sql%notfound) then
146: raise no_data_found;
147: end if;
148:
149: update FA_LOOKUP_TYPES_TL set
150: MEANING = X_MEANING,
151: DESCRIPTION = X_DESCRIPTION,
152: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
153: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 168: delete from FA_LOOKUP_TYPES_TL

164: procedure DELETE_ROW (
165: X_LOOKUP_TYPE in VARCHAR2
166: ,p_log_level_rec in fa_api_types.log_level_rec_type default null) is
167: begin
168: delete from FA_LOOKUP_TYPES_TL
169: where LOOKUP_TYPE = X_LOOKUP_TYPE;
170:
171: if (sql%notfound) then
172: raise no_data_found;

Line 175: delete from FA_LOOKUP_TYPES_B

171: if (sql%notfound) then
172: raise no_data_found;
173: end if;
174:
175: delete from FA_LOOKUP_TYPES_B
176: where LOOKUP_TYPE = X_LOOKUP_TYPE;
177:
178: if (sql%notfound) then
179: raise no_data_found;

Line 186: delete from FA_LOOKUP_TYPES_TL T

182:
183: procedure ADD_LANGUAGE(p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
184: is
185: begin
186: delete from FA_LOOKUP_TYPES_TL T
187: where not exists
188: (select NULL
189: from FA_LOOKUP_TYPES_B B
190: where B.LOOKUP_TYPE = T.LOOKUP_TYPE

Line 189: from FA_LOOKUP_TYPES_B B

185: begin
186: delete from FA_LOOKUP_TYPES_TL T
187: where not exists
188: (select NULL
189: from FA_LOOKUP_TYPES_B B
190: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
191: );
192:
193: update FA_LOOKUP_TYPES_TL T set (

Line 193: update FA_LOOKUP_TYPES_TL T set (

189: from FA_LOOKUP_TYPES_B B
190: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
191: );
192:
193: update FA_LOOKUP_TYPES_TL T set (
194: MEANING,
195: DESCRIPTION
196: ) = (select
197: B.MEANING,

Line 199: from FA_LOOKUP_TYPES_TL B

195: DESCRIPTION
196: ) = (select
197: B.MEANING,
198: B.DESCRIPTION
199: from FA_LOOKUP_TYPES_TL B
200: where B.LOOKUP_TYPE = T.LOOKUP_TYPE
201: and B.LANGUAGE = T.SOURCE_LANG)
202: where (
203: T.LOOKUP_TYPE,

Line 208: from FA_LOOKUP_TYPES_TL SUBB, FA_LOOKUP_TYPES_TL SUBT

204: T.LANGUAGE
205: ) in (select
206: SUBT.LOOKUP_TYPE,
207: SUBT.LANGUAGE
208: from FA_LOOKUP_TYPES_TL SUBB, FA_LOOKUP_TYPES_TL SUBT
209: where SUBB.LOOKUP_TYPE = SUBT.LOOKUP_TYPE
210: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
211: and (SUBB.MEANING <> SUBT.MEANING
212: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 215: insert into FA_LOOKUP_TYPES_TL (

211: and (SUBB.MEANING <> SUBT.MEANING
212: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION
213: ));
214:
215: insert into FA_LOOKUP_TYPES_TL (
216: LOOKUP_TYPE,
217: MEANING,
218: DESCRIPTION,
219: LAST_UPDATE_DATE,

Line 237: from FA_LOOKUP_TYPES_TL B, FND_LANGUAGES L

233: B.CREATION_DATE,
234: B.LAST_UPDATE_LOGIN,
235: L.LANGUAGE_CODE,
236: B.SOURCE_LANG
237: from FA_LOOKUP_TYPES_TL B, FND_LANGUAGES L
238: where L.INSTALLED_FLAG in ('I', 'B')
239: and B.LANGUAGE = userenv('LANG')
240: and not exists
241: (select NULL

Line 242: from FA_LOOKUP_TYPES_TL T

238: where L.INSTALLED_FLAG in ('I', 'B')
239: and B.LANGUAGE = userenv('LANG')
240: and not exists
241: (select NULL
242: from FA_LOOKUP_TYPES_TL T
243: where T.LOOKUP_TYPE = B.LOOKUP_TYPE
244: and T.LANGUAGE = L.LANGUAGE_CODE);
245: end ADD_LANGUAGE;
246:

Line 271: from fa_lookup_types

267: user_id := fnd_load_util.owner_id (X_Owner);
268:
269: select count(*)
270: into h_record_exists
271: from fa_lookup_types
272: where lookup_type = X_Lookup_Type;
273:
274: if (h_record_exists > 0) then
275:

Line 278: from fa_lookup_types

274: if (h_record_exists > 0) then
275:
276: select last_updated_by, last_update_date
277: into db_last_updated_by, db_last_update_date
278: from fa_lookup_types
279: where lookup_type = x_lookup_type;
280:
281: if (fnd_load_util.upload_test(user_id, x_last_update_date,
282: db_last_updated_by, db_last_update_date,

Line 285: fa_lookup_types_pkg.update_row (

281: if (fnd_load_util.upload_test(user_id, x_last_update_date,
282: db_last_updated_by, db_last_update_date,
283: X_CUSTOM_MODE)) then
284:
285: fa_lookup_types_pkg.update_row (
286: X_Lookup_Type => X_Lookup_Type,
287: X_User_Maintainable => X_User_Maintainable,
288: X_Meaning => X_Meaning,
289: X_Description => X_Description,

Line 296: fa_lookup_types_pkg.insert_row (

292: X_Last_Update_Login => 0
293: ,p_log_level_rec => p_log_level_rec);
294: end if;
295: else
296: fa_lookup_types_pkg.insert_row (
297: X_Rowid => row_id,
298: X_Lookup_Type => X_Lookup_Type,
299: X_User_Maintainable => X_User_Maintainable,
300: X_Meaning => X_Meaning,

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

309:
310: exception
311: when others then
312: FA_STANDARD_PKG.RAISE_ERROR(
313: CALLED_FN => 'fa_lookup_types_pkg.load_row',
314: CALLING_FN => 'upload fa_lookup_types'
315: ,p_log_level_rec => p_log_level_rec);
316:
317: end LOAD_ROW;

Line 314: CALLING_FN => 'upload fa_lookup_types'

310: exception
311: when others then
312: FA_STANDARD_PKG.RAISE_ERROR(
313: CALLED_FN => 'fa_lookup_types_pkg.load_row',
314: CALLING_FN => 'upload fa_lookup_types'
315: ,p_log_level_rec => p_log_level_rec);
316:
317: end LOAD_ROW;
318:

Line 337: from fa_lookup_types_tl

333: begin
334:
335: select last_updated_by, last_update_date
336: into db_last_updated_by, db_last_update_date
337: from fa_lookup_types_tl
338: where lookup_type = x_lookup_type
339: and userenv('LANG') in (LANGUAGE, SOURCE_LANG);
340:
341: user_id := fnd_load_util.owner_id (X_Owner);

Line 347: update FA_LOOKUP_TYPES_TL set

343: if (fnd_load_util.upload_test(user_id, sysdate,
344: db_last_updated_by, db_last_update_date,
345: X_CUSTOM_MODE)) then
346:
347: update FA_LOOKUP_TYPES_TL set
348: MEANING = nvl(X_Meaning, MEANING),
349: DESCRIPTION = nvl(X_Description, DESCRIPTION),
350: LAST_UPDATE_DATE = X_Last_Update_Date,
351: LAST_UPDATED_BY = user_id,

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

358:
359: exception
360: when others then
361: FA_STANDARD_PKG.RAISE_ERROR(
362: CALLED_FN => 'fa_lookup_types_pkg.translate_row',
363: CALLING_FN => 'upload fa_lookup_types'
364: ,p_log_level_rec => p_log_level_rec);
365:
366: end TRANSLATE_ROW;

Line 363: CALLING_FN => 'upload fa_lookup_types'

359: exception
360: when others then
361: FA_STANDARD_PKG.RAISE_ERROR(
362: CALLED_FN => 'fa_lookup_types_pkg.translate_row',
363: CALLING_FN => 'upload fa_lookup_types'
364: ,p_log_level_rec => p_log_level_rec);
365:
366: end TRANSLATE_ROW;
367:

Line 382: fa_lookup_types_pkg.TRANSLATE_ROW (

378:
379: BEGIN
380:
381: if (x_upload_mode = 'NLS') then
382: fa_lookup_types_pkg.TRANSLATE_ROW (
383: x_custom_mode => x_custom_mode,
384: x_lookup_type => x_lookup_type,
385: x_owner => x_owner,
386: x_last_update_date => x_last_update_date,

Line 390: fa_lookup_types_pkg.LOAD_ROW (

386: x_last_update_date => x_last_update_date,
387: x_meaning => x_meaning,
388: x_description => x_description);
389: else
390: fa_lookup_types_pkg.LOAD_ROW (
391: x_custom_mode => x_custom_mode,
392: x_lookup_type => x_lookup_type,
393: x_owner => x_owner,
394: x_last_update_date => x_last_update_date,

Line 402: end FA_LOOKUP_TYPES_PKG;

398: end if;
399:
400: END LOAD_SEED_ROW;
401:
402: end FA_LOOKUP_TYPES_PKG;