select ims_md_id
from ims_md_life_cycle
where ims_md_id = :ims_md_id
update ims_md_life_cycle
set status_s = :status_s,
status_v = :status_v
where ims_md_id = :ims_md_id
select status_s, status_v, ims_md_id
from ims_md_life_cycle
where ims_md_id = :ims_md_id