[Home] [Help]
1783:
1784: DELETE xla_tb_user_trans_views
1785: WHERE definition_code = p_definition_code;
1786:
1787: DELETE xla_tb_work_units
1788: WHERE definition_code = p_definition_code;
1789:
1790: DELETE xla_tb_def_seg_ranges
1791: WHERE definition_code = p_definition_code;
1878:
1879: DELETE xla_tb_user_trans_views
1880: WHERE definition_code = p_definition_code;
1881:
1882: DELETE xla_tb_work_units
1883: WHERE definition_code = p_definition_code;
1884:
1885: DELETE xla_tb_def_seg_ranges
1886: WHERE definition_code = p_definition_code;
3615:
3616: IF g_group_id IS NOT NULL THEN
3617: /*
3618: bug#7338524 This cursor has been introduced to find the correct group_id
3619: for the header_id passed and lying in xla_tb_work_units but not associated
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
3617: /*
3618: bug#7338524 This cursor has been introduced to find the correct group_id
3619: for the header_id passed and lying in xla_tb_work_units but not associated
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.
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
3629: WHERE FROM_HEADER_ID = p_from_header_id )
3630: LOOP
3631: l_group_id := i.group_id;
3632: END LOOP;
3756: trace('failed_req_rec - Updating TB work units',C_LEVEL_STATEMENT,l_Log_module);
3757: END IF;
3758:
3759: -- Process
3760: UPDATE xla_tb_work_units
3761: SET status_code = C_WU_UNPROCESSED
3762: ,parent_request_id = g_request_id
3763: WHERE definition_code = g_definition_code;
3764:
3779: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3780: trace('Updating work units for request id = ' || failed_req_rec.request_id,C_LEVEL_STATEMENT,l_Log_module);
3781: END IF;
3782:
3783: UPDATE xla_tb_work_units
3784: SET status_code = C_WU_UNPROCESSED
3785: ,parent_request_id = g_request_id
3786: WHERE parent_request_id = failed_req_rec.request_id;
3787:
3932: IF l_ledger_info.object_type_code = 'S' THEN
3933: --
3934: -- Ledger Set
3935: --
3936: INSERT INTO xla_tb_work_units
3937: (group_id
3938: ,upg_batch_id
3939: ,from_header_id
3940: ,to_header_id
3973: ELSE
3974: --
3975: -- p_ledger_id is not a ledger set
3976: --
3977: INSERT INTO xla_tb_work_units
3978: (group_id
3979: ,upg_batch_id
3980: ,from_header_id
3981: ,to_header_id
4028: IF l_ledger_info.object_type_code = 'S' THEN
4029: --
4030: -- Ledger Set
4031: --
4032: INSERT INTO xla_tb_work_units
4033: (group_id
4034: ,upg_batch_id
4035: ,from_header_id
4036: ,to_header_id
4076: ELSE
4077: --
4078: -- p_ledger_id is not a ledger set
4079: --
4080: INSERT INTO xla_tb_work_units
4081: (group_id
4082: ,upg_batch_id
4083: ,from_header_id
4084: ,to_header_id
4134: IF l_ledger_info.object_type_code = 'S' THEN
4135: --
4136: -- Ledger Set
4137: --
4138: INSERT INTO xla_tb_work_units
4139: (group_id
4140: ,upg_batch_id
4141: ,from_header_id
4142: ,to_header_id
4187: ELSE
4188: --
4189: -- p_ledger_id is not a ledger set
4190: --
4191: INSERT INTO xla_tb_work_units
4192: (group_id
4193: ,upg_batch_id
4194: ,from_header_id
4195: ,to_header_id
4285: trace('Updating tb_work_units.status_code to ' || C_WU_PROCESSING,C_LEVEL_STATEMENT,l_log_module);
4286: END IF;
4287:
4288:
4289: UPDATE xla_tb_work_units
4290: SET status_code = C_WU_PROCESSING
4291: WHERE parent_request_id = p_parent_request_id
4292: AND status_code = C_WU_UNPROCESSED
4293: AND ROWNUM = 1
4785: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4786: trace('p_from_header_id = '||p_from_header_id,C_LEVEL_STATEMENT,l_Log_module);
4787: END IF;
4788:
4789: DELETE xla_tb_work_units
4790: WHERE from_header_id = p_from_header_id;
4791:
4792: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4793: trace('END of delete_wu',C_LEVEL_PROCEDURE,l_Log_module);
5063: | Deletes rows from the following tables: |
5064: | - xla_tb_logs |
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: +======================================================================*/
5092:
5093: DELETE xla_tb_user_trans_views
5094: WHERE definition_code = p_definition_code;
5095:
5096: DELETE xla_tb_work_units
5097: WHERE definition_code = p_definition_code;
5098:
5099: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
5100: trace('END delete_non_ui_rows'