create or replace procedure proc_Test_1(
    in_CustomerId IN VARCHAR2, 
    in_Facility IN VARCHAR2 DEFAULT null,
    out_Order_results OUT SYS_REFCURSOR,
    out_Load_results OUT SYS_REFCURSOR) AS
  BEGIN
    dbms_output.put_line('1 '||systimestamp);
    proc_Test_2(in_CustomerId, in_Facility, out_Order_results );
    dbms_output.put_line('1.1 '||systimestamp);
    proc_Test_3(in_CustomerId, in_Facility, out_Load_results );
    dbms_output.put_line('1.2 '||systimestamp);
  End proc_Test_1;

create or replace procedure proc_Test_2(
    in_CustomerId IN VARCHAR2, 
    in_Facility IN VARCHAR2 DEFAULT null,
    out_Order_results OUT SYS_REFCURSOR) AS 
  BEGIN
  dbms_output.put_line('2 '||systimestamp);
    open out_Order_results for select * from Table1 where rownum < 5;
      insert into t1 values(sysdate);
      commit;    
     DBMS_LOCK.SLEEP(10);
dbms_output.put_line('2.1 '||systimestamp);     
  End proc_Test_2;

create or replace procedure proc_Test_3(
    in_CustomerId IN VARCHAR2, 
    in_Facility IN VARCHAR2 DEFAULT null,
    out_Load_results OUT SYS_REFCURSOR) AS
  BEGIN
  dbms_output.put_line('3 '||systimestamp);
    open out_Load_results for select * from Table2 where rownum < 5;
    insert into t1 values(sysdate);
    commit;
    DBMS_LOCK.SLEEP(10);
  dbms_output.put_line('3.1 '||systimestamp);      
  End proc_Test_3;