I am in the process of implementing a process in APEX. This process includes some roles. The process is initiated by a person who fills in forms in the first step.
The data entered is stored in collections and entered into the corresponding tables after submission. This also initiates the next step of the process.

Now to my question, I would like to display a kind of history of the completed steps after the completed forms have been submitted (i.e. after the first process step has been completed).
I was thinking of a kind of log table.
This summarises which action has been taken, who has taken the action, and what other important information has been entered in the table (e.g. which person responsible was selected in the form, etc., the ID of the table).

-- create log tbl
create table form_submitted
log_id number not null,
Responsible_id1 number ,
Responsible_id2 number,
Responsible_id3 number,
Responsible_id4 number,
added_date date,
action varchar2(100);

alter table form_submitted add constraint pk_log_id PRIMARY KEY (log_id);
-- create sequence to autoincrement values
create sequence seq_log_id
start with 1
increment by 1
nocache
nocycle;
--create trigger to insert auto-incremented value
create or replace trigger bi_form_submitted
before insert 
on form_submitted
for each row 
begin
:new.log_id :=seq_log_id.nextval;
end;

To achieve this, I thought of creating a trigger that would track the user's activities and enter the necessary information into the log table.

-- create trigger to track user activity and insert on logs table
create or replace trigger trg_user_activity
after insert or update or delete
on tbl1

for each row 
begin
  if deleting then 
  --insert data in tbl_logs
  insert into form_submitted
  (Responsible_id1,Responsible_id2, Responsible_id3, Responsible_id4,created_time, added_date, action)
  values
    (:new.Responsible_id1,:new.Responsible_id2,:new.Responsible_id3,:new.Responsible_id4, SYSDATE,to_char(SYSDATE,'HH:MI:SS PM'),SYSDATE, 'form_deleted');
end if;
if updating then 
  --insert data in tbl_logs
  insert into form_submitted
   (Responsible_id1,Responsible_id2, Responsible_id3, Responsible_id4,created_time, added_date, action)
  values
  (:new.Responsible_id1,:new.Responsible_id2,:new.Responsible_id3,:new.Responsible_id4, SYSDATE,to_char(SYSDATE,'HH:MI:SS PM'),SYSDATE, 'form_updated');

end if;
if inserting then 
  --insert data in tbl_logs
  insert into form_submitted
   (Responsible_id1,Responsible_id2, Responsible_id3, Responsible_id4,created_time, added_date, action)
  values
    (:new.Responsible_id1,:new.Responsible_id2,:new.Responsible_id3,:new.Responsible_id4, SYSDATE,to_char(SYSDATE,'HH:MI:SS PM'),SYSDATE, 'form_submitted');

end if;
end;

This table I want then to display as a classic report in the history tab.
Each time a user makes a change it will be logged and displayed. But each time in a different log tables. This means in the second step, another user has to make an action, this should as well be logged and been displayed in the history tab.
The aim is to log and display every activity of each user in the process.

I would like some help with the following three things:

1. how can I get the information I need for the log table( like Responsible_id1 ) from the other table (here tbl1).
2. different users edit the same table (which means that the next user adds data to the same table) but a different entry has to be made in a different log table. Can I bind the trigger to a user or to this specific process step.
3.After the first process step has been successfully completed, how can I display the current status (this means that the steps should not have to be carried out again the next time the user logs in but he should see in which step of the process he is at the moment)?

A few suggestions would already be very helpful.
I am relatively new to APEX and not very familiar with the development.
I am also not sure whether a trigger is the right common solution for such a use case.

with rws as (
  select ..., 
         row_number () over (
           order by update_time desc
         ) rn
  from   ...
  where  ...
)
  select * from rws
  where  rn = 1;

create or replace package form_submission_mgr as 
  function insert_form ( ... ) 
    return table.id%type;
  procedure update_form ( ... );
  procedure delete_form ( ... );
end;
/

:new.log_id :=seq_log_id.nextval;