[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 |
81: -- insert_trial_balance_wu.
82: -- **********************End Note*****************************************
83:
84: C_TB_INSERT_SQL CONSTANT VARCHAR2(32000) := '
85: INSERT INTO xla_trial_balances (
86: record_type_code
87: ,source_entity_id
88: ,event_class_code
89: ,source_application_id
417: -- cannot remove this join as performance will be affected since ledger_id is
418: -- leading part of index _N1 in xteu.
419:
420: C_TB_INSERT_UPG_SQL_AE CONSTANT VARCHAR2(32000) := '
421: INSERT INTO xla_trial_balances xtb(
422: record_type_code
423: ,source_entity_id
424: ,event_class_code
425: ,source_application_id
707: --Reason gl_date is populated with time component and the trial balance report
708: --query does not fetch data for a date including time stamp.
709:
710: C_TB_INSERT_UPG_SQL_SLE CONSTANT VARCHAR2(32000) := '
711: INSERT INTO xla_trial_balances xtb(
712: record_type_code
713: ,source_entity_id
714: ,event_class_code
715: ,source_application_id
1001: --
1002: -- Template for upgraded transactions
1003: --
1004: C_TB_UPG_SQL CONSTANT VARCHAR2(32000) := '
1005: INSERT INTO xla_trial_balances (
1006: record_type_code
1007: ,source_entity_id
1008: ,event_class_code
1009: ,source_application_id
1671: END IF;
1672:
1673: -- Add partition.
1674: EXECUTE IMMEDIATE
1675: 'ALTER TABLE '||l_schema||'.xla_trial_balances'||' ADD PARTITION '||p_definition_code||
1676: ' VALUES ('''||p_definition_code||''' )';
1677: EXCEPTION
1678: WHEN OTHERS THEN
1679:
1730: ,l_Log_module);
1731: END IF;
1732:
1733:
1734: DELETE xla_trial_balances
1735: WHERE source_application_id = p_application_id
1736: AND ae_header_id = p_ae_header_id;
1737:
1738: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1802: DELETE xla_tb_user_trans_views
1803: WHERE definition_code = p_definition_code
1804: AND application_id = g_application_id;
1805:
1806: DELETE xla_trial_balances
1807: WHERE definition_code = p_definition_code
1808: AND source_application_id = g_application_id;
1809: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1810: trace('rows deleted'||sql%rowcount,C_LEVEL_PROCEDURE,l_Log_module);
1904: DELETE xla_tb_user_trans_views
1905: WHERE definition_code = p_definition_code
1906: AND application_id = g_application_id;
1907:
1908: DELETE xla_trial_balances
1909: WHERE definition_code = p_definition_code
1910: AND source_application_id = g_application_id;
1911:
1912: END IF;
1996: trace('Begin of drop_partition',C_LEVEL_PROCEDURE,l_Log_module);
1997: END IF;
1998:
1999: l_schema := get_schema;
2000: EXECUTE IMMEDIATE 'ALTER TABLE ' ||l_schema ||'.XLA_TRIAL_BALANCES drop partition '||p_definition_code;
2001:
2002: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2003: trace('End of drop_partition',C_LEVEL_PROCEDURE,l_Log_module);
2004: END IF;
2572: FROM
2573: (
2574: SELECT DISTINCT definition_code, event_class_code,
2575: source_application_id
2576: FROM xla_trial_balances
2577: WHERE definition_code = p_definition_code
2578: ) xtb,
2579: xla_event_class_attrs xeca
2580: WHERE xeca.event_class_code <> 'MANUAL'
2694: ,g_request_id
2695: ,g_prog_appl_id
2696: ,g_program_id
2697: ,SYSDATE
2698: FROM xla_trial_balances xtb
2699: ,xla_tb_definitions_b xtd
2700: ,xla_event_class_attrs xeca
2701: WHERE xeca.event_class_code <> 'MANUAL'
2702: AND xtb.event_class_code = xeca.event_class_code
3340: g_prog_appl_id := xla_environment_pkg.g_prog_appl_id;
3341: g_program_id := xla_environment_pkg.g_prog_id;
3342: g_tb_insert_sql := C_TB_INSERT_SQL;
3343:
3344: DELETE xla_trial_balances
3345: WHERE source_application_id = p_application_id
3346: AND ae_header_id = p_ae_header_id
3347: RETURNING definition_code BULK COLLECT INTO l_array_defn_code;
3348:
3620: to the current group_id generated for transfer to GL.
3621: The failed worker units in xla_tb_work_units table is updated with the
3622: current transfer to GL's parent request id in recover_failed_requests procedure.
3623: The ae_header_id of that failed request would be picked up by the worker's and
3624: will be passed to this procedure for inserting into xla_trial_balances table.
3625: Part of recovery is handled here.
3626: */
3627:
3628: FOR i in ( SELECT group_id FROM xla_tb_work_units
4390: l_schema := get_schema;
4391:
4392:
4393: -- Truncate Partition
4394: EXECUTE IMMEDIATE 'ALTER TABLE ' || l_schema ||'.XLA_TRIAL_BALANCES TRUNCATE partition '||p_definition_code;
4395:
4396:
4397: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4398: trace('END truncate_partition',C_LEVEL_PROCEDURE,l_Log_module);
4927:
4928: --
4929: -- Delete existing records
4930: --
4931: DELETE FROM xla_trial_balances
4932: WHERE definition_code = c_def.definition_code
4933: AND source_entity_id = -1;
4934:
4935: insert_trial_balance_upg
5065: | - xla_tb_def_seg_ranges |
5066: | - xla_tb_user_trans_views |
5067: | - xla_tb_work_units |
5068: | |
5069: | For xla_trial_balances, call drop_partition separately |
5070: | Called from TbReportDefnsAMImpl.java. |
5071: +======================================================================*/
5072: PROCEDURE delete_non_ui_rows
5073: (p_definition_code IN VARCHAR2)