create table test (
    test_id number( 9 )
  , entry_date date
  , constraint pk_test primary key(test_id)
)
/
create table test2 (
    test_id number( 9 )
  , entry_date date
  , constraint pk_test2 primary key(test_id)
)
/

create or replace procedure insert_test2 (
  p_test_id number
) as
begin
  insert into test2 (test_id, entry_date)
  values (p_test_id, sysdate);
end;
/
create or replace trigger tbir_test
before insert on test
for each row
begin
  :new.entry_date := sysdate;
end;
/

create or replace trigger tair_test
after insert on test
for each row
declare v_job integer;
  pragma autonomous_transaction;
begin
  dbms_job.submit (
      job => v_job
    , what => 'begin insert_test2('||:new.test_id||'); end;'
    , next_date => sysdate -  1 / 24 / 60 / 60 
    , interval => null
  );
  commit;
end;
/
begin
  for i in  1 .. 20  loop
    insert into test(test_id) values (i);
  end loop;
end;
/

select t.test_id
     , t.entry_date t_entry_date
     , t2.entry_date t2_entry_date
from test t
   , test2 t2
where  1 = 1 
  and t.test_id = t2.test_id
/