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.XLA_ACCT_ATTRIBUTES_F_PKG dependencies on XLA_ACCT_ATTRIBUTES_TL

Line 84: INSERT INTO xla_acct_attributes_tl

80: ,x_last_updated_by
81: ,x_last_update_login)
82: ;
83:
84: INSERT INTO xla_acct_attributes_tl
85: (name
86: ,creation_date
87: ,created_by
88: ,last_update_date

Line 108: FROM xla_acct_attributes_tl t

104: FROM fnd_languages l
105: WHERE l.installed_flag IN ('I', 'B')
106: AND NOT EXISTS
107: (SELECT NULL
108: FROM xla_acct_attributes_tl t
109: WHERE t.accounting_attribute_code = x_accounting_attribute_code
110: AND t.language = l.language_code);
111:
112: OPEN c;

Line 161: FROM xla_acct_attributes_tl

157: CURSOR c1 IS
158: SELECT language
159: ,name
160: ,DECODE(language , USERENV('LANG'), 'Y', 'N') baselang
161: FROM xla_acct_attributes_tl
162: WHERE accounting_attribute_code = X_accounting_attribute_code
163: AND USERENV('LANG') IN (language ,source_lang)
164: FOR UPDATE OF accounting_attribute_code NOWAIT;
165:

Line 254: UPDATE xla_acct_attributes_tl

250: IF (SQL%NOTFOUND) THEN
251: RAISE NO_DATA_FOUND;
252: END IF;
253:
254: UPDATE xla_acct_attributes_tl
255: SET
256: last_update_date = x_last_update_date
257: ,name = X_name
258: ,last_updated_by = x_last_updated_by

Line 283: DELETE FROM xla_acct_attributes_tl

279: IS
280:
281: BEGIN
282: xla_utility_pkg.trace('> xla_acct_attributes_f_pkg.delete_row' ,20);
283: DELETE FROM xla_acct_attributes_tl
284: WHERE accounting_attribute_code = x_accounting_attribute_code;
285:
286:
287: IF (SQL%NOTFOUND) THEN

Line 315: DELETE FROM xla_acct_attributes_tl T

311:
312: BEGIN
313: xla_utility_pkg.trace('> xla_acct_attributes_f_pkg.add_language' ,20);
314:
315: DELETE FROM xla_acct_attributes_tl T
316: WHERE NOT EXISTS
317: (SELECT NULL
318: FROM xla_acct_attributes_b b
319: WHERE b.accounting_attribute_code = t.accounting_attribute_code);

Line 321: UPDATE xla_acct_attributes_tl t

317: (SELECT NULL
318: FROM xla_acct_attributes_b b
319: WHERE b.accounting_attribute_code = t.accounting_attribute_code);
320:
321: UPDATE xla_acct_attributes_tl t
322: SET (name)
323: = (SELECT b.name
324: FROM xla_acct_attributes_tl b
325: WHERE b.accounting_attribute_code = t.accounting_attribute_code

Line 324: FROM xla_acct_attributes_tl b

320:
321: UPDATE xla_acct_attributes_tl t
322: SET (name)
323: = (SELECT b.name
324: FROM xla_acct_attributes_tl b
325: WHERE b.accounting_attribute_code = t.accounting_attribute_code
326: AND b.language = t.source_lang)
327: WHERE (t.accounting_attribute_code
328: ,t.language)

Line 331: FROM xla_acct_attributes_tl subb

327: WHERE (t.accounting_attribute_code
328: ,t.language)
329: IN (SELECT subt.accounting_attribute_code
330: ,subt.language
331: FROM xla_acct_attributes_tl subb
332: ,xla_acct_attributes_tl subt
333: WHERE subb.accounting_attribute_code = subt.accounting_attribute_code
334: AND subb.language = subt.source_lang
335: AND (SUBB.name <> SUBT.name

Line 332: ,xla_acct_attributes_tl subt

328: ,t.language)
329: IN (SELECT subt.accounting_attribute_code
330: ,subt.language
331: FROM xla_acct_attributes_tl subb
332: ,xla_acct_attributes_tl subt
333: WHERE subb.accounting_attribute_code = subt.accounting_attribute_code
334: AND subb.language = subt.source_lang
335: AND (SUBB.name <> SUBT.name
336: ))

Line 339: INSERT INTO xla_acct_attributes_tl

335: AND (SUBB.name <> SUBT.name
336: ))
337: ;
338:
339: INSERT INTO xla_acct_attributes_tl
340: (name
341: ,creation_date
342: ,created_by
343: ,last_update_date

Line 359: FROM xla_acct_attributes_tl b

355: ,b.accounting_attribute_code
356: ,b.last_update_login
357: ,l.language_code
358: ,b.source_lang
359: FROM xla_acct_attributes_tl b
360: ,fnd_languages l
361: WHERE l.installed_flag IN ('I', 'B')
362: AND b.language = userenv('LANG')
363: AND NOT EXISTS

Line 365: FROM xla_acct_attributes_tl t

361: WHERE l.installed_flag IN ('I', 'B')
362: AND b.language = userenv('LANG')
363: AND NOT EXISTS
364: (SELECT NULL
365: FROM xla_acct_attributes_tl t
366: WHERE t.accounting_attribute_code = b.accounting_attribute_code
367: AND t.language = l.language_code);
368:
369: xla_utility_pkg.trace('< xla_acct_attributes_f_pkg.add_language' ,20);

Line 499: FROM xla_acct_attributes_tl

495:
496: BEGIN
497: SELECT last_updated_by, last_update_date
498: INTO db_luby, db_ludate
499: FROM xla_acct_attributes_tl
500: WHERE accounting_attribute_code = p_accounting_attribute_code
501: AND language = userenv('LANG');
502:
503: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,

Line 505: UPDATE xla_acct_attributes_tl

501: AND language = userenv('LANG');
502:
503: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
504: db_ludate, p_custom_mode)) then
505: UPDATE xla_acct_attributes_tl
506: SET name = p_name
507: ,last_update_date = f_ludate
508: ,last_updated_by = f_luby
509: ,last_update_login = 0