APPS.GME_POST_MIGRATION dependencies on MTL_LOT_CONV_AUDIT

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

512: IF (g_debug <= gme_debug.g_log_statement) THEN
513: gme_debug.put_line('Close Steps');
514: END IF;
515: close_steps;
516: /* Bug 5703541 Added update stmt and loop for mtl_lot_conv_audit */
517: IF (g_debug <= gme_debug.g_log_statement) THEN
518: gme_debug.put_line('Update mtl_lot_conv_audit');
519: END IF;
520: FOR get_rec IN (SELECT old_batch_id, new_batch_id FROM gme_batch_mapping_mig

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

514: END IF;
515: close_steps;
516: /* Bug 5703541 Added update stmt and loop for mtl_lot_conv_audit */
517: IF (g_debug <= gme_debug.g_log_statement) THEN
518: gme_debug.put_line('Update mtl_lot_conv_audit');
519: END IF;
520: FOR get_rec IN (SELECT old_batch_id, new_batch_id FROM gme_batch_mapping_mig
521: WHERE old_batch_id IN (SELECT DISTINCT(batch_id) FROM mtl_lot_conv_audit)) LOOP
522: UPDATE mtl_lot_conv_audit

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

517: IF (g_debug <= gme_debug.g_log_statement) THEN
518: gme_debug.put_line('Update mtl_lot_conv_audit');
519: END IF;
520: FOR get_rec IN (SELECT old_batch_id, new_batch_id FROM gme_batch_mapping_mig
521: WHERE old_batch_id IN (SELECT DISTINCT(batch_id) FROM mtl_lot_conv_audit)) LOOP
522: UPDATE mtl_lot_conv_audit
523: SET batch_id = get_rec.new_batch_id
524: WHERE batch_id = get_rec.old_batch_id;
525: END LOOP;

Line 522: UPDATE mtl_lot_conv_audit

518: gme_debug.put_line('Update mtl_lot_conv_audit');
519: END IF;
520: FOR get_rec IN (SELECT old_batch_id, new_batch_id FROM gme_batch_mapping_mig
521: WHERE old_batch_id IN (SELECT DISTINCT(batch_id) FROM mtl_lot_conv_audit)) LOOP
522: UPDATE mtl_lot_conv_audit
523: SET batch_id = get_rec.new_batch_id
524: WHERE batch_id = get_rec.old_batch_id;
525: END LOOP;
526: