1718: EXIT;
1719: END IF;
1720:
1721: -- Bug 9845460
1722: -- Insert into new table HXC_DEP_TRANSACTIONS
1723: FORALL i IN txnidtab.FIRST..txnidtab.LAST
1724: INSERT
1725: INTO hxc_dep_transactions
1726: (SELECT transaction_id,
1721: -- Bug 9845460
1722: -- Insert into new table HXC_DEP_TRANSACTIONS
1723: FORALL i IN txnidtab.FIRST..txnidtab.LAST
1724: INSERT
1725: INTO hxc_dep_transactions
1726: (SELECT transaction_id,
1727: transaction_process_id,
1728: transaction_date,
1729: type,
1740: FROM hxc_transactions
1741: WHERE transaction_id = txnidtab(i)
1742: AND type = 'DEPOSIT') ;
1743:
1744: put_log('Migrated data to HXC_DEP_TRANSACTIONS');
1745:
1746: -- Delete DEPOSIT transaction records from HXC_TRANSACTIONS
1747: FORALL i IN txnidtab.FIRST..txnidtab.LAST
1748: DELETE