CREATE OR REPLACE PROCEDURE move_hist
IS
      move_Dates  varchar2(15);
BEGIN
 select to_char(max(effectivedate),'DD-MON-YYYY' )+15  into move_Dates  from  txn_hist; 

     INSERT      /*+ APPEND NOLOGGING*/
         INTO    txn_temp(              txn_temp,
                                         tnum_date,
                                         TYPE)
      SELECT tnum, effectiveDate, 'P'
        FROM PRNT_TXN       WHERE     STATUS IN ('EX', 'DL')
              AND  (effectivedate) < move_Dates  AND product = 'INTL';

   COMMIT;
end;

SQL> select empno, hiredate from emp where hiredate < (select max(hiredate)+15 from emp);

     EMPNO HIREDATE
---------- ---------
      7369 17-DEC-80
      7499 20-FEB-81
      7521 22-FEB-81
      7566 02-APR-81
      7654 28-SEP-81
      7698 01-MAY-81
      7782 09-JUN-81
      7788 19-APR-87
      7839 17-NOV-81
      7844 08-SEP-81
      7876 23-MAY-87

     EMPNO HIREDATE
---------- ---------
      7900 03-DEC-81
      7902 03-DEC-81
      7934 23-JAN-82

14 rows selected.

SQL> 

CREATE OR REPLACE PROCEDURE move_hist
IS
      move_Dates  varchar2(15);
BEGIN

     INSERT      /*+ APPEND NOLOGGING*/
         INTO    txn_temp(              txn_temp,
                                         tnum_date,
                                         TYPE)
      SELECT tnum, effectiveDate, 'P'
        FROM PRNT_TXN       WHERE     STATUS IN ('EX', 'DL')
              AND  (effectivedate) < (select max(effectivedate)+16 from txn_hist)  AND product = 'INTL';

   COMMIT;
   
      INSERT    /*+ APPEND NOLOGGING*/
         INTO   Qevents_hist
      SELECT *    FROM Qevents
       WHERE   (ENTEREDTIME) <  (select max(ENTEREDTIME)+15 from Qevents_hist) ;
    	   
      DELETE FROM QEVENTS
      WHERE    (ENTEREDTIME) <  (select max(ENTEREDTIME)- 15 from Qevents_hist);  
	  **** Here i have to use - ( minus ) because above insert will already insert the rows into Qevents_hist so ENTEREDTIME will be changed         	 
commit;
	  
end;
/

 INSERT      /*+ APPEND NOLOGGING*/
         INTO    txn_temp(              txn_temp,
                                         tnum_date,
                                         TYPE)
      SELECT tnum, effectiveDate, 'P'
        FROM PRNT_TXN       WHERE     STATUS IN ('EX', 'DL')
              AND  (effectivedate) < select max(effectivedate)+15 from  txn_hist)
 AND product = 'INTL';