APPS.GME_POST_MIGRATION dependencies on GME_LAB_BATCH_LOTS

Line 3419: FROM gme_batch_mapping_mig m, gme_lab_batch_lots l

3415: PROCEDURE insert_lab_lots IS
3416: l_api_name VARCHAR2(30) := 'insert_lab_lots';
3417: CURSOR Cur_lab_lots IS
3418: SELECT l.*, m.organization_id, m.new_batch_no, m.new_batch_id, m.plant_code, l.rowid
3419: FROM gme_batch_mapping_mig m, gme_lab_batch_lots l
3420: WHERE m.old_batch_id = l.batch_id
3421: AND NVL(attribute27, 'A') <> 'M';
3422: CURSOR Cur_item_dtl(v_organization_id NUMBER, v_inventory_item_id NUMBER) IS
3423: SELECT i.segment1, i.lot_control_code

Line 3509: UPDATE gme_lab_batch_lots

3505: x_pending_product_lots_rec => l_plot_out_rec);
3506: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
3507: RAISE create_pp_lot_err;
3508: END IF;
3509: UPDATE gme_lab_batch_lots
3510: SET attribute27 = 'M'
3511: WHERE rowid = get_lots.rowid;
3512: END IF;
3513: END IF;