v_prior_wip extend_wip%rowtype;
select * into v_prior_wip
from extend_wip ew
when ew.sn=p_serial_num
and ew.active=1;
update routing_wip rw
set rw.current_level =v_prior_wip.current_levle,
rw.material_number = v_prior_wip.material_number,
rw.material_rstate = v_prior_wip.material_rstate,
rw.line_id = v_prior_wip.line_id,
rw.station_group = v_prior_wip.station_group,
rw.fail_n = v_prior_wip.fail_n,
rw.fail_times = v_prior_wip.fail_times,
rw.last_modified_time = sysdate
where rw.sn = p_serial_num;
====================================
check_rework_unit_for_krh:
select count(*)
into o_allow
from dual
where v_imei_prefix=(case v_current_pn when '1214-0898' then '35726202'
when '1203-5374' then '35507602'
when '1203-6762' then '35698302'
else v_imei_prefix end);