[Home] [Help]
6174: WHERE amb_context_code = g_staging_context_code
6175: AND application_id = g_application_id;
6176: l_num_rows := SQL%ROWCOUNT;
6177: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6178: trace(p_msg => '# xla_acctg_methods_b updated : '||l_num_rows,
6179: p_module => l_log_module,
6180: p_level => C_LEVEL_STATEMENT);
6181: END IF;
6182:
6190: p_encoded_message => '# xla_acctg_method_rules update : '||l_num_rows,
6191: p_component_code => 'merge_acctg_methods');
6192: /********* End of Code Change for Bug 14359104 ************************/
6193:
6194: INSERT INTO xla_acctg_methods_b
6195: (accounting_method_type_code
6196: ,accounting_method_code
6197: ,transaction_coa_id
6198: ,accounting_coa_id
6212: ,sysdate
6213: ,xla_environment_pkg.g_usr_id
6214: ,xla_environment_pkg.g_login_id
6215: FROM xla_stage_acctg_methods s
6216: LEFT OUTER JOIN xla_acctg_methods_b w
6217: ON w.accounting_method_type_code = s.accounting_method_type_code
6218: AND w.accounting_method_code = s.accounting_method_code
6219: WHERE s.staging_amb_context_code = g_staging_context_code
6220: AND w.accounting_method_type_code IS NULL;
6219: WHERE s.staging_amb_context_code = g_staging_context_code
6220: AND w.accounting_method_type_code IS NULL;
6221: l_num_rows := SQL%ROWCOUNT;
6222: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
6223: trace(p_msg => '# row inserted in xla_acctg_methods_b = '||l_num_rows,
6224: p_module => l_log_module,
6225: p_level => C_LEVEL_STATEMENT);
6226: END IF;
6227: -- Bug : 9923803
6230: p_amb_context_code => g_amb_context_code,
6231: p_application_id => g_application_id,
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
6318: ,g_amb_context_code
6319: ,g_application_id
6320: ,'IMPORT'
6321: ,'UNMERGE_AAD_IN_SLAM'
6322: ,'Rows inserted in xla_acctg_methods_b for staging context code : '||g_staging_context_code||
6323: ', ' ||'application_id : '||g_application_id||' is : '||l_num_rows
6324: ,g_application_id
6325: ,product_rule_code
6326: ,product_rule_type_code