update tab_je
  set id  = :control_blk.id,
      rec_id  = :detail_blk.rec_id,
     rec_text = :detail_blk.rec_text;
update_record;

Insert into tab_je 
 (id, rec_id, rec_text)
 values
  (:control_blk.id, :detail_blk.rec_id, :detail_blk.rec_text);
  insert_record;

exists (select 1 from Tab_js where tab_js.id = tab_je.id and tab_js.text in ('TEX'))
UNION ALL
  select tab_js.id, tab_jf.cid, tab_je.mal
    from tab_js, tab_jf, tab_je
    where tab_je.id (+) = tab_js.id
    and   tab_je.rec_id (+) = tab_js.rec_id
    and   tab_jf.id (+) = tab_js.id
    and   tab_jf.fil (+) = tab_js.fil
    and   tab_js.text in ('TEX')

declare
 var varchar2(20)
begin
var := get_item_property('block1.field1', database_value); 
 update....
   set....
 where field1 = var
   and ...... ;
if SQL%rowcount then
 insert into ....
 values ....
end if;
end;