720: IF p_wip_spec_rec.step_id IS NOT NULL AND p_wip_spec_rec.step_no IS NULL THEN
721: IF p_wip_spec_rec.batch_id IS NOT NULL THEN
722: BEGIN
723: SELECT BATCHSTEP_NO INTO l_step_no
724: FROM gme_batch_steps
725: WHERE batchstep_id = p_wip_spec_rec.step_id
726: AND batch_id = p_wip_spec_rec.batch_id;
727:
728:
748: EXCEPTION
749: WHEN OTHERS THEN
750: BEGIN
751: SELECT BATCHSTEP_NO INTO l_step_no
752: FROM gme_batch_steps
753: WHERE batchstep_id = p_wip_spec_rec.step_id
754: AND batch_id = p_wip_spec_rec.batch_id;
755:
756: EXCEPTION WHEN OTHERS THEN