APPS.HXC_RESTORE dependencies on HXC_DEP_TRANSACTIONS

Line 447: -- transactions from hxc_dep_transactions_ar and hxc_transactions_ar

443: AND thread_id = p_thread_id;
444:
445: -- Bug 8888813
446: -- Added the following cursors to pick up DEPOSIT type
447: -- transactions from hxc_dep_transactions_ar and hxc_transactions_ar
448:
449: CURSOR get_old_transactions
450: IS SELECT /*+ LEADING(temp) */
451: transaction_detail_id,

Line 1352: INSERT INTO hxc_dep_transactions

1348: FROM hxc_transactions
1349: WHERE transaction_id = master_id )
1350: AND thread_id = p_thread_id ;
1351:
1352: INSERT INTO hxc_dep_transactions
1353: (DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,TRANSACTION_DATE,TYPE,
1354: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1355: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TRANSACTION_CODE)
1356: SELECT /*+ LEADING(temp) USE_NL(bkuptxn) */

Line 1366: FROM hxc_dep_transactions hxc

1362: hxc_archive_temp temp
1363: WHERE transaction_id = master_id
1364: AND thread_id = p_thread_id
1365: AND transaction_id NOT IN ( SELECT transaction_id
1366: FROM hxc_dep_transactions hxc
1367: WHERE bkuptxn.transaction_id = hxc.transaction_id)
1368: AND type = 'DEPOSIT'
1369: AND bkuptxn.data_set_id = p_data_set_id
1370: ;

Line 1470: INSERT INTO hxc_dep_transactions

1466: WHERE transaction_id = master_id )
1467: AND thread_id = p_thread_id ;
1468:
1469:
1470: INSERT INTO hxc_dep_transactions
1471: (DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,TRANSACTION_DATE,TYPE,
1472: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1473: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TRANSACTION_CODE)
1474: SELECT /*+ LEADING(temp) USE_NL(bkuptxn) */

Line 1479: FROM hxc_dep_transactions_ar bkuptxn,

1475: bkuptxn.DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,
1476: TRANSACTION_DATE,TYPE,STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,
1477: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1478: TRANSACTION_CODE
1479: FROM hxc_dep_transactions_ar bkuptxn,
1480: hxc_archive_temp temp
1481: WHERE transaction_id = master_id
1482: AND thread_id = p_thread_id
1483: AND transaction_id NOT IN ( SELECT transaction_id

Line 1484: FROM hxc_dep_transactions hxc

1480: hxc_archive_temp temp
1481: WHERE transaction_id = master_id
1482: AND thread_id = p_thread_id
1483: AND transaction_id NOT IN ( SELECT transaction_id
1484: FROM hxc_dep_transactions hxc
1485: WHERE bkuptxn.transaction_id = hxc.transaction_id)
1486: AND bkuptxn.data_set_id = p_data_set_id
1487: ;
1488:

Line 1493: FROM hxc_dep_transactions_ar bkuptxn

1489:
1490: l_trans_count := l_trans_count + SQL%ROWCOUNT;
1491:
1492: DELETE /*+ LEADING(temp) USE_NL(bkuptxn) */
1493: FROM hxc_dep_transactions_ar bkuptxn
1494: WHERE transaction_id IN ( SELECT master_id
1495: FROM hxc_archive_temp temp
1496: WHERE thread_id = p_thread_id)
1497: AND data_set_id = p_data_set_id ;