select ims_md_id
from ims_md_life_cycle
where ims_md_id = :ims_md_id
update ims_md_life_cycle
set version_l = :version_l,
version_s = :version_s
where ims_md_id = :ims_md_id
insert into ims_md_life_cycle
(ims_md_id, version_l, version_s)
values
(:ims_md_id, :version_l, :version_s)
select version_l, version_s, ims_md_id
from ims_md_life_cycle
where ims_md_id = :ims_md_id