717: IF p_wip_spec_rec.step_id IS NOT NULL AND p_wip_spec_rec.step_no IS NULL THEN
718: IF p_wip_spec_rec.batch_id IS NOT NULL THEN
719: BEGIN
720: SELECT BATCHSTEP_NO INTO l_step_no
721: FROM gme_batch_steps
722: WHERE batchstep_id = p_wip_spec_rec.step_id
723: AND batch_id = p_wip_spec_rec.batch_id;
724:
725:
745: EXCEPTION
746: WHEN OTHERS THEN
747: BEGIN
748: SELECT BATCHSTEP_NO INTO l_step_no
749: FROM gme_batch_steps
750: WHERE batchstep_id = p_wip_spec_rec.step_id
751: AND batch_id = p_wip_spec_rec.batch_id;
752:
753: EXCEPTION WHEN OTHERS THEN