[Home] [Help]
229: gme_debug.put_line ( 'deleting transactions for '
230: || x_batch_step_rec.batchstep_id);
231: END IF;
232:
233: DELETE FROM gme_resource_txns
234: WHERE doc_type = l_doc_type
235: AND doc_id = x_batch_step_rec.batch_id
236: AND line_id IN (
237: SELECT batchstep_resource_id
239: WHERE batch_id = x_batch_step_rec.batch_id
240: AND batchstep_id = x_batch_step_rec.batchstep_id);
241:
242: -- Navin Added as part of Reschedule Batch/Step Build.
243: DELETE FROM gme_resource_txns_gtmp
244: WHERE doc_type = l_doc_type
245: AND doc_id = x_batch_step_rec.batch_id
246: AND line_id IN (
247: SELECT batchstep_resource_id