[Home] [Help]
62: | by XLA_AP_CCID_NOT_EXISTS |
63: | 23-Sep-2004 S.Singhania Minor changes due to bulk performance in calls |
64: | to xla_accrounting_err_pkg.build_message. |
65: | 28-Feb-2005 K.boussema Renamed GT table: gl_accounts_map_interface_gt |
66: | => gl_accts_map_int_gt |
67: | 03-MAR-2005 K.Boussema Reviewed MapCCid() function to fix bug 4197942 |
68: | 06-MAR-2005 W. Shen Ledger Currency Project. |
69: | maintain two ccids in line table |
70: | 14-Mar-2005 K.Boussema Changed for ADR-enhancements. |
80: | ='Y' in Create_New_CCID for Update on ALT_CCID |
81: | Since ALT_CCID is used only when XLA calculates |
82: | the Gain/Loss Amounts. |
83: | 04-Apr-2011 NMIKKILI Changed source from which segments are fetched |
84: | in gl_accts_map_int_gt for bug 13735405 |
85: +===========================================================================*/
86:
87: /*-------------------------------------------------------------------+
88: | |
4143:
4144: l_count := 0;
4145: l_rowcount := 0;
4146:
4147: DELETE FROM gl_accts_map_int_gt; -- bug 4564062
4148:
4149: INSERT INTO gl_accts_map_int_gt
4150: (
4151: from_ccid
4145: l_rowcount := 0;
4146:
4147: DELETE FROM gl_accts_map_int_gt; -- bug 4564062
4148:
4149: INSERT INTO gl_accts_map_int_gt
4150: (
4151: from_ccid
4152: , coa_mapping_id
4153: )
4164: l_count := l_count + l_rowcount;
4165:
4166: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4167: trace
4168: (p_msg => '# rows inserted into gl_accts_map_int_gt(ccid) = '||to_char(l_rowcount)
4169: ,p_level => C_LEVEL_STATEMENT
4170: ,p_module => l_log_module);
4171: END IF;
4172:
4270: ELSE temp.code_combination_status_code
4271: END
4272: ELSE C_INVALID
4273: END
4274: FROM gl_accts_map_int_gt gami
4275: , xla_transaction_accts_gt xta
4276: WHERE xta.ae_header_id = temp.ae_header_id
4277: AND xta.temp_line_num = temp.temp_line_num
4278: AND xta.ledger_id = temp.ledger_id
4384: ELSE temp.alt_ccid_status_code
4385: END
4386: ELSE C_INVALID
4387: END
4388: FROM gl_accts_map_int_gt gami
4389: , xla_transaction_accts_gt xta
4390: WHERE xta.ae_header_id = temp.ae_header_id
4391: AND xta.temp_line_num = temp.temp_line_num
4392: AND xta.ledger_id = temp.ledger_id
4572: , l_array_processing_status_code
4573: , l_array_to_segment_code
4574: , l_array_ccid
4575: , l_array_segment_value
4576: FROM gl_accts_map_int_gt gami
4577: , xla_transaction_accts_gt xta
4578: WHERE gami.from_ccid = xta.code_combination_id
4579: AND gami.coa_mapping_id = xta.sl_coa_mapping_id
4580: AND xta.code_combination_id IS NOT NULL
4759: , l_array_alt_proc_status_code
4760: , l_array_alt_to_segment_code
4761: , l_array_alt_ccid
4762: , l_array_alt_segment_value
4763: FROM gl_accts_map_int_gt gami
4764: , xla_transaction_accts_gt xta
4765: WHERE gami.from_ccid = xta.code_combination_id
4766: AND gami.coa_mapping_id = xta.sl_coa_mapping_id
4767: AND xta.code_combination_id IS NOT NULL
4912: ,xjlg.ledger_id ledger_id
4913: ,xjlg.entity_id entity_id
4914: ,gami.from_ccid from_ccid
4915: ,xjlg.ccid_coa_id ccid_coa_id
4916: FROM gl_accts_map_int_gt gami
4917: ,xla_transaction_accts_gt xtag
4918: ,xla_ae_lines_gt xjlg
4919: WHERE xjlg.ae_header_id = xtag.ae_header_id
4920: AND xjlg.temp_line_num = xtag.temp_line_num
4935: ,xjlg.ledger_id ledger_id
4936: ,xjlg.entity_id entity_id
4937: ,gami.from_ccid from_ccid
4938: , xjlg.ccid_coa_id coa_id
4939: FROM gl_accts_map_int_gt gami
4940: ,xla_transaction_accts_gt xtag
4941: ,xla_ae_lines_gt xjlg
4942: WHERE xjlg.ae_header_id = xtag.ae_header_id
4943: AND xjlg.temp_line_num = xtag.temp_line_num