[Home] [Help]
6150: AND product_rule_type_code = l_product_rule_type_code(i)
6151: AND product_rule_code = l_product_rule_code(i);
6152: l_num_rows := SQL%ROWCOUNT;
6153: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6154: trace(p_msg => '# xla_acctg_methods_tl delete : '||l_num_rows,
6155: p_module => l_log_module,
6156: p_level => C_LEVEL_STATEMENT);
6157: END IF;
6158: -- Bug : 9923803
6232: p_request_code => 'IMPORT' ,
6233: p_log_type_code => 'MERGE',
6234: p_encoded_message => '# row inserted in xla_acctg_methods_b = '||l_num_rows,
6235: p_component_code => 'merge_acctg_methods');
6236: INSERT INTO xla_acctg_methods_tl
6237: (accounting_method_type_code
6238: ,accounting_method_code
6239: ,language
6240: ,name
6258: ,xla_environment_pkg.g_login_id
6259: FROM xla_stage_acctg_methods s
6260: JOIN fnd_languages fl
6261: ON fl.installed_flag IN ('I', 'B')
6262: LEFT OUTER JOIN xla_acctg_methods_tl w
6263: ON w.accounting_method_type_code = s.accounting_method_type_code
6264: AND w.accounting_method_code = s.accounting_method_code
6265: AND w.language = fl.language_code
6266: WHERE s.staging_amb_context_code = g_staging_context_code
6266: WHERE s.staging_amb_context_code = g_staging_context_code
6267: AND w.accounting_method_type_code IS NULL;
6268: l_num_rows := SQL%ROWCOUNT;
6269: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6270: trace(p_msg => '# row inserted in xla_acctg_methods_tl = '||l_num_rows,
6271: p_module => l_log_module,
6272: p_level => C_LEVEL_STATEMENT);
6273: END IF;
6274: -- Bug : 9923803
6277: p_amb_context_code => g_amb_context_code,
6278: p_application_id => g_application_id,
6279: p_request_code => 'IMPORT' ,
6280: p_log_type_code => 'MERGE',
6281: p_encoded_message => '# row inserted in xla_acctg_methods_tl = '||l_num_rows,
6282: p_component_code => 'merge_acctg_methods');
6283:
6284: UPDATE xla_acctg_method_rules xamr
6285: SET amb_context_code = g_amb_context_code