[Home] [Help]
1851: ,xla_environment_pkg.g_req_Id
1852: ,xla_environment_pkg.g_Prog_Appl_Id
1853: ,xla_environment_pkg.g_Prog_Id
1854: ,SYSDATE
1855: FROM xla_trial_balances xtb
1856: ,xla_tb_definitions_b xtd
1857: ,xla_event_class_attrs xeca
1858: WHERE xeca.event_class_code <> 'MANUAL'
1859: AND xtb.event_class_code = xeca.event_class_code
2013: -- range for the next day ie '01-MAY-2008' to '01-JUN-2008'
2014:
2015: --BUG 8222265 added a swap_join_inputs(gcc) hint and flipped first 2 tables in FROM clause
2016:
2017: INSERT /*+ parallel(xtb) append */ INTO xla_trial_balances xtb(
2018: record_type_code
2019: ,source_entity_id
2020: ,event_class_code
2021: ,source_application_id
2732: l_schema := NULL;
2733: END IF;
2734:
2735: --
2736: -- Add partitions to xla_trial_balances
2737: --
2738: IF (l_array_defn_code.COUNT > 0 ) THEN
2739: FOR i in l_array_defn_code.FIRST .. l_array_defn_code.LAST LOOP
2740: BEGIN
2739: FOR i in l_array_defn_code.FIRST .. l_array_defn_code.LAST LOOP
2740: BEGIN
2741: IF (C_LEVEL_STATEMENT>= g_log_level) THEN
2742: trace
2743: (p_msg => 'ALTER TABLE '||l_schema||'.xla_trial_balances'
2744: ||' ADD PARTITION '||l_array_defn_code(i)
2745: || ' VALUES ('''||l_array_defn_code(i)||''' ) executing'
2746: ,p_level => C_LEVEL_STATEMENT
2747: ,p_module => l_log_module);
2752: ,p_module => l_log_module);
2753: END IF;
2754:
2755: EXECUTE IMMEDIATE
2756: 'ALTER TABLE '||l_schema||'.xla_trial_balances'||' ADD PARTITION '||l_array_defn_code(i)||
2757: ' VALUES ('''||l_array_defn_code(i)||''' )';
2758: EXCEPTION
2759: WHEN OTHERS THEN
2760: IF(SQLCODE = -14312) THEN