3562: p_module => l_log_module,
3563: p_level => C_LEVEL_STATEMENT);
3564: END IF;
3565:
3566: INSERT INTO xla_acctg_methods_tl
3567: (accounting_method_type_code
3568: ,accounting_method_code
3569: ,language
3570: ,name
3588: ,xla_environment_pkg.g_login_id
3589: FROM xla_stage_acctg_methods s
3590: JOIN fnd_languages fl
3591: ON fl.installed_flag IN ('I', 'B')
3592: LEFT OUTER JOIN xla_acctg_methods_tl w
3593: ON w.accounting_method_type_code = s.accounting_method_type_code
3594: AND w.accounting_method_code = s.accounting_method_code
3595: AND w.language = fl.language_code
3596: WHERE s.staging_amb_context_code = g_staging_context_code
3596: WHERE s.staging_amb_context_code = g_staging_context_code
3597: AND w.accounting_method_type_code IS NULL;
3598:
3599: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3600: trace(p_msg => '# row inserted in xla_acctg_methods_tl = '||SQL%ROWCOUNT,
3601: p_module => l_log_module,
3602: p_level => C_LEVEL_STATEMENT);
3603: END IF;
3604: