DBA Data[Home] [Help]

APPS.HXC_UPGRADE_PKG dependencies on HXC_DEP_TRANSACTIONS

Line 1722: -- Insert into new table HXC_DEP_TRANSACTIONS

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,

Line 1725: INTO hxc_dep_transactions

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,

Line 1744: put_log('Migrated data to HXC_DEP_TRANSACTIONS');

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