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_ACCTG_METHODS_F_PKG dependencies on XLA_ACCTG_METHODS_TL

Line 125: INSERT INTO xla_acctg_methods_tl

121: ,x_last_updated_by
122: ,x_last_update_login)
123: ;
124:
125: INSERT INTO xla_acctg_methods_tl
126: (accounting_method_type_code
127: ,accounting_method_code
128: ,name
129: ,description

Line 153: FROM xla_acctg_methods_tl t

149: FROM fnd_languages l
150: WHERE l.installed_flag IN ('I', 'B')
151: AND NOT EXISTS
152: (SELECT NULL
153: FROM xla_acctg_methods_tl t
154: WHERE t.accounting_method_type_code = x_accounting_method_type_code
155: AND t.accounting_method_code = x_accounting_method_code
156: AND t.language = l.language_code);
157:

Line 208: FROM xla_acctg_methods_tl

204: SELECT accounting_method_type_code
205: ,name
206: ,description
207: ,DECODE(language , USERENV('LANG'), 'Y', 'N') baselang
208: FROM xla_acctg_methods_tl
209: WHERE accounting_method_type_code = X_accounting_method_type_code
210: AND accounting_method_code = X_accounting_method_code
211: AND USERENV('LANG') IN (language ,source_lang)
212: FOR UPDATE OF accounting_method_type_code NOWAIT;

Line 323: UPDATE xla_acctg_methods_tl

319: IF (SQL%NOTFOUND) THEN
320: RAISE NO_DATA_FOUND;
321: END IF;
322:
323: UPDATE xla_acctg_methods_tl
324: SET
325: last_update_date = x_last_update_date
326: ,name = X_name
327: ,description = X_description

Line 370: DELETE FROM xla_acctg_methods_tl

366: p_module => l_log_module,
367: p_level => C_LEVEL_PROCEDURE);
368: END IF;
369:
370: DELETE FROM xla_acctg_methods_tl
371: WHERE accounting_method_type_code = x_accounting_method_type_code
372: AND accounting_method_code = x_accounting_method_code;
373:
374:

Line 419: DELETE FROM xla_acctg_methods_tl T

415: p_level => C_LEVEL_PROCEDURE);
416: END IF;
417:
418:
419: DELETE FROM xla_acctg_methods_tl T
420: WHERE NOT EXISTS
421: (SELECT NULL
422: FROM xla_acctg_methods_b b
423: WHERE b.accounting_method_type_code = t.accounting_method_type_code

Line 426: UPDATE xla_acctg_methods_tl t

422: FROM xla_acctg_methods_b b
423: WHERE b.accounting_method_type_code = t.accounting_method_type_code
424: AND b.accounting_method_code = t.accounting_method_code);
425:
426: UPDATE xla_acctg_methods_tl t
427: SET (name
428: ,description)
429: = (SELECT b.name
430: ,b.description

Line 431: FROM xla_acctg_methods_tl b

427: SET (name
428: ,description)
429: = (SELECT b.name
430: ,b.description
431: FROM xla_acctg_methods_tl b
432: WHERE b.accounting_method_type_code = t.accounting_method_type_code
433: AND b.accounting_method_code = t.accounting_method_code
434: AND b.language = t.source_lang)
435: WHERE (t.accounting_method_type_code

Line 441: FROM xla_acctg_methods_tl subb

437: ,t.language)
438: IN (SELECT subt.accounting_method_type_code
439: ,subt.accounting_method_code
440: ,subt.language
441: FROM xla_acctg_methods_tl subb
442: ,xla_acctg_methods_tl subt
443: WHERE subb.accounting_method_type_code = subt.accounting_method_type_code
444: AND subb.accounting_method_code = subt.accounting_method_code
445: AND subb.language = subt.source_lang

Line 442: ,xla_acctg_methods_tl subt

438: IN (SELECT subt.accounting_method_type_code
439: ,subt.accounting_method_code
440: ,subt.language
441: FROM xla_acctg_methods_tl subb
442: ,xla_acctg_methods_tl subt
443: WHERE subb.accounting_method_type_code = subt.accounting_method_type_code
444: AND subb.accounting_method_code = subt.accounting_method_code
445: AND subb.language = subt.source_lang
446: AND (SUBB.name <> SUBT.name

Line 455: INSERT INTO xla_acctg_methods_tl

451: AND subt.description IS NULL)
452: ))
453: ;
454:
455: INSERT INTO xla_acctg_methods_tl
456: (accounting_method_type_code
457: ,accounting_method_code
458: ,name
459: ,description

Line 479: FROM xla_acctg_methods_tl b

475: ,b.last_updated_by
476: ,b.last_update_login
477: ,l.language_code
478: ,b.source_lang
479: FROM xla_acctg_methods_tl b
480: ,fnd_languages l
481: WHERE l.installed_flag IN ('I', 'B')
482: AND b.language = userenv('LANG')
483: AND NOT EXISTS

Line 485: FROM xla_acctg_methods_tl t

481: WHERE l.installed_flag IN ('I', 'B')
482: AND b.language = userenv('LANG')
483: AND NOT EXISTS
484: (SELECT NULL
485: FROM xla_acctg_methods_tl t
486: WHERE t.accounting_method_type_code = b.accounting_method_type_code
487: AND t.accounting_method_code = b.accounting_method_code
488: AND t.language = l.language_code);
489:

Line 540: FROM xla_acctg_methods_tl

536:
537: BEGIN
538: SELECT last_updated_by, last_update_date
539: INTO db_luby, db_ludate
540: FROM xla_acctg_methods_tl
541: WHERE accounting_method_type_code = p_accounting_method_type_code
542: AND accounting_method_code = p_accounting_method_code
543: AND language = userenv('LANG');
544:

Line 547: UPDATE xla_acctg_methods_tl

543: AND language = userenv('LANG');
544:
545: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
546: db_ludate, p_custom_mode)) then
547: UPDATE xla_acctg_methods_tl
548: SET name = p_name
549: ,description = p_description
550: ,last_update_date = f_ludate
551: ,last_updated_by = f_luby