[Home] [Help]
112:
113: -- Bug 13706812 - Use old batch id to make use of index.
114: CURSOR Cur_get_rsrc_txns(v_batchstep_rsrc_id NUMBER, v_old_batch_id NUMBER) IS
115: SELECT *
116: FROM gme_resource_txns_mig
117: WHERE line_id = v_batchstep_rsrc_id
118: AND doc_id = v_old_batch_id;
119:
120: -- Bug 13706812/13839066 - Let's make sure we update primary_item_id.
450: IF (g_debug <= gme_debug.g_log_statement) THEN
451: gme_debug.put_line('After insert process params');
452: END IF;
453: FORALL a IN 1..l_rsrc_txns_tbl.count
454: INSERT INTO gme_resource_txns VALUES l_rsrc_txns_tbl(a);
455: IF (g_debug <= gme_debug.g_log_statement) THEN
456: gme_debug.put_line('After insert rsrc txns');
457: END IF;
458:
1798:
1799: -- Let's update any resource transactions that may have a wrong date.
1800: -- Transactions were already inserted before hitting this code.
1801: IF l_other_date_used_step = 1 THEN
1802: UPDATE gme_resource_txns
1803: SET trans_date = l_date
1804: WHERE trans_date < l_date
1805: AND POC_TRANS_ID IN (select t.POC_TRANS_ID
1806: FROM gme_resource_txns t, gme_batch_step_resources r,
1802: UPDATE gme_resource_txns
1803: SET trans_date = l_date
1804: WHERE trans_date < l_date
1805: AND POC_TRANS_ID IN (select t.POC_TRANS_ID
1806: FROM gme_resource_txns t, gme_batch_step_resources r,
1807: gme_batch_step_activities a, gme_batch_steps s
1808: WHERE s.batch_id = l_batch_header.batch_id
1809: AND t.doc_id = l_batch_header.batch_id
1810: AND s.batchstep_id = l_step_rec.batchstep_id