[Home] [Help]
1832:
1833: DELETE xla_tb_user_trans_views
1834: WHERE definition_code = p_definition_code;
1835:
1836: DELETE xla_tb_work_units
1837: WHERE definition_code = p_definition_code;
1838:
1839: DELETE xla_tb_def_seg_ranges
1840: WHERE definition_code = p_definition_code;
1927:
1928: DELETE xla_tb_user_trans_views
1929: WHERE definition_code = p_definition_code;
1930:
1931: DELETE xla_tb_work_units
1932: WHERE definition_code = p_definition_code;
1933:
1934: DELETE xla_tb_def_seg_ranges
1935: WHERE definition_code = p_definition_code;
3768:
3769: IF g_group_id IS NOT NULL THEN
3770: /*
3771: bug#7338524 This cursor has been introduced to find the correct group_id
3772: for the header_id passed and lying in xla_tb_work_units but not associated
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
3770: /*
3771: bug#7338524 This cursor has been introduced to find the correct group_id
3772: for the header_id passed and lying in xla_tb_work_units but not associated
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.
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
3782: WHERE FROM_HEADER_ID = p_from_header_id )
3783: LOOP
3784: l_group_id := i.group_id;
3785: END LOOP;
3909: trace('failed_req_rec - Updating TB work units',C_LEVEL_STATEMENT,l_Log_module);
3910: END IF;
3911:
3912: -- Process
3913: UPDATE xla_tb_work_units
3914: SET status_code = C_WU_UNPROCESSED
3915: ,parent_request_id = g_request_id
3916: WHERE definition_code = g_definition_code;
3917:
3932: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3933: trace('Updating work units for request id = ' || failed_req_rec.request_id,C_LEVEL_STATEMENT,l_Log_module);
3934: END IF;
3935:
3936: UPDATE xla_tb_work_units
3937: SET status_code = C_WU_UNPROCESSED
3938: ,parent_request_id = g_request_id
3939: WHERE parent_request_id = failed_req_rec.request_id;
3940:
4085: IF l_ledger_info.object_type_code = 'S' THEN
4086: --
4087: -- Ledger Set
4088: --
4089: INSERT INTO xla_tb_work_units
4090: (group_id
4091: ,upg_batch_id
4092: ,from_header_id
4093: ,to_header_id
4126: ELSE
4127: --
4128: -- p_ledger_id is not a ledger set
4129: --
4130: INSERT INTO xla_tb_work_units
4131: (group_id
4132: ,upg_batch_id
4133: ,from_header_id
4134: ,to_header_id
4181: IF l_ledger_info.object_type_code = 'S' THEN
4182: --
4183: -- Ledger Set
4184: --
4185: INSERT INTO xla_tb_work_units
4186: (group_id
4187: ,upg_batch_id
4188: ,from_header_id
4189: ,to_header_id
4229: ELSE
4230: --
4231: -- p_ledger_id is not a ledger set
4232: --
4233: INSERT INTO xla_tb_work_units
4234: (group_id
4235: ,upg_batch_id
4236: ,from_header_id
4237: ,to_header_id
4287: IF l_ledger_info.object_type_code = 'S' THEN
4288: --
4289: -- Ledger Set
4290: --
4291: INSERT INTO xla_tb_work_units
4292: (group_id
4293: ,upg_batch_id
4294: ,from_header_id
4295: ,to_header_id
4340: ELSE
4341: --
4342: -- p_ledger_id is not a ledger set
4343: --
4344: INSERT INTO xla_tb_work_units
4345: (group_id
4346: ,upg_batch_id
4347: ,from_header_id
4348: ,to_header_id
4438: trace('Updating tb_work_units.status_code to ' || C_WU_PROCESSING,C_LEVEL_STATEMENT,l_log_module);
4439: END IF;
4440:
4441:
4442: UPDATE xla_tb_work_units
4443: SET status_code = C_WU_PROCESSING
4444: WHERE parent_request_id = p_parent_request_id
4445: AND status_code = C_WU_UNPROCESSED
4446: AND ROWNUM = 1
4941: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
4942: trace('p_from_header_id = '||p_from_header_id,C_LEVEL_STATEMENT,l_Log_module);
4943: END IF;
4944:
4945: DELETE xla_tb_work_units
4946: WHERE from_header_id = p_from_header_id;
4947:
4948: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
4949: trace('END of delete_wu',C_LEVEL_PROCEDURE,l_Log_module);
5219: | Deletes rows from the following tables: |
5220: | - xla_tb_logs |
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: +======================================================================*/
5248:
5249: DELETE xla_tb_user_trans_views
5250: WHERE definition_code = p_definition_code;
5251:
5252: DELETE xla_tb_work_units
5253: WHERE definition_code = p_definition_code;
5254:
5255: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
5256: trace('END delete_non_ui_rows'