-- Fire when APPROVE button is pressed
update leave_transaction set
  status = 'APPROVE'                  -- another process would set it to REJECT
  where leave_id = :P5_LEAVE_ID;

  for i in 1 .. apex_application.g_f01.count loop

    if apex_application.g_f02(i) = 1 then       -- g_f02 is a tabular form checkbox
       select p.naziv
         into l_naziv
         from dg_slike_popis p
         where p.id = apex_application.g_f01(i);

       utl_file.putf(file_handler, l_naziv || '\n');
    end if;

  end loop;

if apex_application.g_f02(i) = 1 then 

select 
  id,
  id id_display,
  naziv,
  cb_delete
from dg_slike_popis
order by 1

update your_table set
  status = case when apex_application.g_f02(i) = 1 then 'APPROVED'
                else 'REJECTED'
           end
  where leave_id = apex_application.g_f01(i);

DECLARE
   v_rowno NUMBER;
BEGIN
  for i in 1 .. apex_application.g_f01.count 
loop
v_rowno := apex_application.g_f01(i);
 if apex_application.g_f02(i) = 1 then       
update leave_transaction set status='Approved' where
leave_id=v_rowno;
else
update leave_transaction set status='Rejected' where
leave_id=v_rowno;
end if;
end loop;
end;