[Home] [Help]
9: | xla_tb_data_manager_pvt |
10: | |
11: | DESCRIPTION |
12: | This IS a XLA PRIVATE PACKAGE, which contains ALL THE logic required |
13: | TO upload trial balance data INTO xla_trial_balances |
14: | |
15: | |
16: | HISTORY |
17: | 07-OCT-2005 M.Asada Created |
96: -- insert_trial_balance_wu.
97: -- **********************End Note*****************************************
98:
99: C_TB_INSERT_SQL CONSTANT VARCHAR2(32000) := '
100: INSERT INTO xla_trial_balances (
101: record_type_code
102: ,source_entity_id
103: ,event_class_code
104: ,source_application_id
436: -- for Flex/Segment Definition, when TB Definition Code is re-built
437: -- Also, all commented code has been removed from the String as Variable can hold only 32000
438:
439: C_TB_INSERT_UPG_SQL_AE CONSTANT VARCHAR2(32000) := '
440: INSERT INTO xla_trial_balances xtb(
441: record_type_code
442: ,source_entity_id
443: ,event_class_code
444: ,source_application_id
741: -- for Flex/Segment Definition, when TB Definition Code is re-built
742: -- Also, all commented code has been removed from the String as Variable can hold only 32000
743:
744: C_TB_INSERT_UPG_SQL_SLE CONSTANT VARCHAR2(32000) := '
745: INSERT INTO xla_trial_balances xtb(
746: record_type_code
747: ,source_entity_id
748: ,event_class_code
749: ,source_application_id
1046: --
1047: -- Template for upgraded transactions
1048: --
1049: C_TB_UPG_SQL CONSTANT VARCHAR2(32000) := '
1050: INSERT INTO xla_trial_balances (
1051: record_type_code
1052: ,source_entity_id
1053: ,event_class_code
1054: ,source_application_id
1720: END IF;
1721:
1722: -- Add partition.
1723: EXECUTE IMMEDIATE
1724: 'ALTER TABLE '||l_schema||'.xla_trial_balances'||' ADD PARTITION '||p_definition_code||
1725: ' VALUES ('''||p_definition_code||''' )';
1726: EXCEPTION
1727: WHEN OTHERS THEN
1728:
1779: ,l_Log_module);
1780: END IF;
1781:
1782:
1783: DELETE xla_trial_balances
1784: WHERE source_application_id = p_application_id
1785: AND ae_header_id = p_ae_header_id;
1786:
1787: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1851: DELETE xla_tb_user_trans_views
1852: WHERE definition_code = p_definition_code
1853: AND application_id = g_application_id;
1854:
1855: DELETE xla_trial_balances
1856: WHERE definition_code = p_definition_code
1857: AND source_application_id = g_application_id;
1858: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1859: trace('rows deleted'||sql%rowcount,C_LEVEL_PROCEDURE,l_Log_module);
1953: DELETE xla_tb_user_trans_views
1954: WHERE definition_code = p_definition_code
1955: AND application_id = g_application_id;
1956:
1957: DELETE xla_trial_balances
1958: WHERE definition_code = p_definition_code
1959: AND source_application_id = g_application_id;
1960:
1961: END IF;
2045: trace('Begin of drop_partition',C_LEVEL_PROCEDURE,l_Log_module);
2046: END IF;
2047:
2048: l_schema := get_schema;
2049: EXECUTE IMMEDIATE 'ALTER TABLE ' ||l_schema ||'.XLA_TRIAL_BALANCES drop partition '||p_definition_code;
2050:
2051: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2052: trace('End of drop_partition',C_LEVEL_PROCEDURE,l_Log_module);
2053: END IF;
2582: IF p_definition_code IS NOT NULL THEN
2583:
2584: --perf imp 13-may-2008
2585:
2586: -- Bug#8333978 Changed the select clause to remove the reference of xla_trial_balances
2587: -- table in the from. To get the definition code and application id
2588: -- used the following tables in the join ie xla_tb_defn_je_sources and
2589: -- xla_subledgers.
2590:
2712:
2713:
2714: ELSE
2715:
2716: -- Bug#8333978 Changed the select clause to remove the reference of xla_trial_balances
2717: -- table in the from clause. To get the definition code and application id
2718: -- used the following tables in the join ie xla_tb_defn_je_sources and
2719: -- xla_subledgers.
2720:
3493: g_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
3494: g_program_id := xla_environment_pkg.g_prog_id;
3495: g_tb_insert_sql := C_TB_INSERT_SQL;
3496:
3497: DELETE xla_trial_balances
3498: WHERE source_application_id = p_application_id
3499: AND ae_header_id = p_ae_header_id
3500: RETURNING definition_code BULK COLLECT INTO l_array_defn_code;
3501:
3773: to the current group_id generated for transfer to GL.
3774: The failed worker units in xla_tb_work_units table is updated with the
3775: current transfer to GL's parent request id in recover_failed_requests procedure.
3776: The ae_header_id of that failed request would be picked up by the worker's and
3777: will be passed to this procedure for inserting into xla_trial_balances table.
3778: Part of recovery is handled here.
3779: */
3780:
3781: FOR i in ( SELECT group_id FROM xla_tb_work_units
4543: l_schema := get_schema;
4544:
4545:
4546: -- Truncate Partition
4547: EXECUTE IMMEDIATE 'ALTER TABLE ' || l_schema ||'.XLA_TRIAL_BALANCES TRUNCATE partition '||p_definition_code;
4548:
4549:
4550: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4551: trace('END truncate_partition',C_LEVEL_PROCEDURE,l_Log_module);
5083:
5084: --
5085: -- Delete existing records
5086: --
5087: DELETE FROM xla_trial_balances
5088: WHERE definition_code = c_def.definition_code
5089: AND source_entity_id = -1;
5090:
5091: insert_trial_balance_upg
5221: | - xla_tb_def_seg_ranges |
5222: | - xla_tb_user_trans_views |
5223: | - xla_tb_work_units |
5224: | |
5225: | For xla_trial_balances, call drop_partition separately |
5226: | Called from TbReportDefnsAMImpl.java. |
5227: +======================================================================*/
5228: PROCEDURE delete_non_ui_rows
5229: (p_definition_code IN VARCHAR2)