261: =====================================*/
262:
263: CURSOR get_new_step_id (p_batch_id NUMBER, p_step_no VARCHAR2) IS
264: SELECT batchstep_id
265: FROM gme_batch_steps
266: WHERE batch_id = p_batch_id
267: AND batchstep_no = p_step_no;
268:
269: l_new_step_id gme_batch_steps.batchstep_id%TYPE;
265: FROM gme_batch_steps
266: WHERE batch_id = p_batch_id
267: AND batchstep_no = p_step_no;
268:
269: l_new_step_id gme_batch_steps.batchstep_id%TYPE;
270:
271: /*=====================================
272: Cursor to get gmd_wip_spec_vrs.
273: =====================================*/