APPS.GME_POST_MIGRATION dependencies on GME_LAB_BATCH_LOTS

Line 3969: FROM gme_batch_mapping_mig m, gme_lab_batch_lots l

3965: PROCEDURE insert_lab_lots IS
3966: l_api_name VARCHAR2(30) := 'insert_lab_lots';
3967: CURSOR Cur_lab_lots IS
3968: SELECT l.*, m.organization_id, m.new_batch_no, m.new_batch_id, m.plant_code, l.rowid
3969: FROM gme_batch_mapping_mig m, gme_lab_batch_lots l
3970: WHERE m.old_batch_id = l.batch_id
3971: AND NVL(attribute27, 'A') <> 'M';
3972: CURSOR Cur_item_dtl(v_organization_id NUMBER, v_inventory_item_id NUMBER) IS
3973: SELECT i.segment1, i.lot_control_code

Line 4059: UPDATE gme_lab_batch_lots

4055: x_pending_product_lots_rec => l_plot_out_rec);
4056: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
4057: RAISE create_pp_lot_err;
4058: END IF;
4059: UPDATE gme_lab_batch_lots
4060: SET attribute27 = 'M'
4061: WHERE rowid = get_lots.rowid;
4062: END IF;
4063: END IF;