APPS.GME_POST_MIGRATION dependencies on MTL_LOT_CONV_AUDIT

Line 636: /* Bug 5703541 Added update stmt and loop for mtl_lot_conv_audit */

632: gme_debug.put_line('Close Steps');
633: END IF;
634:
635: close_steps;
636: /* Bug 5703541 Added update stmt and loop for mtl_lot_conv_audit */
637: IF (g_debug <= gme_debug.g_log_statement) THEN
638: gme_debug.put_line('Update mtl_lot_conv_audit');
639: END IF;
640: FOR get_rec IN (SELECT old_batch_id, new_batch_id FROM gme_batch_mapping_mig

Line 638: gme_debug.put_line('Update mtl_lot_conv_audit');

634:
635: close_steps;
636: /* Bug 5703541 Added update stmt and loop for mtl_lot_conv_audit */
637: IF (g_debug <= gme_debug.g_log_statement) THEN
638: gme_debug.put_line('Update mtl_lot_conv_audit');
639: END IF;
640: FOR get_rec IN (SELECT old_batch_id, new_batch_id FROM gme_batch_mapping_mig
641: WHERE old_batch_id IN (SELECT DISTINCT(batch_id) FROM mtl_lot_conv_audit)) LOOP
642: UPDATE mtl_lot_conv_audit

Line 641: WHERE old_batch_id IN (SELECT DISTINCT(batch_id) FROM mtl_lot_conv_audit)) LOOP

637: IF (g_debug <= gme_debug.g_log_statement) THEN
638: gme_debug.put_line('Update mtl_lot_conv_audit');
639: END IF;
640: FOR get_rec IN (SELECT old_batch_id, new_batch_id FROM gme_batch_mapping_mig
641: WHERE old_batch_id IN (SELECT DISTINCT(batch_id) FROM mtl_lot_conv_audit)) LOOP
642: UPDATE mtl_lot_conv_audit
643: SET batch_id = get_rec.new_batch_id
644: WHERE batch_id = get_rec.old_batch_id;
645: END LOOP;

Line 642: UPDATE mtl_lot_conv_audit

638: gme_debug.put_line('Update mtl_lot_conv_audit');
639: END IF;
640: FOR get_rec IN (SELECT old_batch_id, new_batch_id FROM gme_batch_mapping_mig
641: WHERE old_batch_id IN (SELECT DISTINCT(batch_id) FROM mtl_lot_conv_audit)) LOOP
642: UPDATE mtl_lot_conv_audit
643: SET batch_id = get_rec.new_batch_id
644: WHERE batch_id = get_rec.old_batch_id;
645: END LOOP;
646: