APPS.HXC_RESTORE dependencies on HXC_TRANSACTIONS_AR

Line 301: FROM hxc_transactions_ar bkuptxn

297: SELECT bkuptxn.DATA_SET_ID,bkuptxn.TRANSACTION_ID,TRANSACTION_PROCESS_ID,
298: TRANSACTION_DATE,TYPE,STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,
299: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
300: TRANSACTION_CODE
301: FROM hxc_transactions_ar bkuptxn
302: WHERE bkuptxn.transaction_id IN ( SELECT temp.transaction_id
303: FROM hxc_ar_trans_temp temp
304: WHERE thread_id = 0 )
305: AND bkuptxn.transaction_id NOT IN ( SELECT transaction_id

Line 314: DELETE FROM hxc_transactions_ar ht

310: -- Bug 11781607
311: -- Added the NOT EXISTS condtion to take care of transactions spanning
312: -- multiple data sets.
313:
314: DELETE FROM hxc_transactions_ar ht
315: WHERE ROWID IN ( SELECT CHARTOROWID(trans_rowid)
316: FROM hxc_ar_trans_temp
317: WHERE thread_id = 0 )
318: AND NOT EXISTS ( SELECT 1

Line 440: FROM hxc_transactions_ar tr

436: hxc_transaction_details_ar ar
437: WHERE ar.time_building_block_id = temp.id
438: AND ar.time_building_block_ovn = temp.ref_ovn
439: AND EXISTS ( SELECT 1
440: FROM hxc_transactions_ar tr
441: WHERE tr.transaction_id = ar.transaction_id
442: AND tr.type = 'RETRIEVAL' )
443: AND thread_id = p_thread_id;
444:

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 459: FROM hxc_transactions_ar tr

455: hxc_transaction_details_ar ar
456: WHERE ar.time_building_block_id = temp.id
457: AND ar.time_building_block_ovn = temp.ref_ovn
458: AND EXISTS ( SELECT 1
459: FROM hxc_transactions_ar tr
460: WHERE tr.transaction_id = ar.transaction_id
461: AND tr.type = 'DEPOSIT' )
462: AND thread_id = p_thread_id;
463:

Line 1201: FROM hxc_transactions_ar bkuptxn,

1197: bkuptxn.DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,
1198: TRANSACTION_DATE,TYPE,STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,
1199: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1200: TRANSACTION_CODE
1201: FROM hxc_transactions_ar bkuptxn,
1202: hxc_archive_temp temp
1203: WHERE transaction_id = master_id
1204: AND thread_id = p_thread_id
1205: AND transaction_id NOT IN ( SELECT transaction_id

Line 1216: FROM hxc_transactions_ar bkuptxn

1212:
1213: l_trans_count := l_trans_count + SQL%ROWCOUNT;
1214:
1215: DELETE /*+ LEADING(temp) USE_NL(bkuptxn) *
1216: FROM hxc_transactions_ar bkuptxn
1217: WHERE transaction_id IN ( SELECT master_id
1218: FROM hxc_archive_temp temp
1219: WHERE thread_id = p_thread_id)
1220: AND type <> 'RETRIEVAL'

Line 1237: FROM hxc_transactions_ar bkuptxn,

1233: SELECT bkuptxn.transaction_id,
1234: p_data_set_id,
1235: p_thread_id,
1236: ROWIDTOCHAR(bkuptxn.ROWID)
1237: FROM hxc_transactions_ar bkuptxn,
1238: hxc_archive_temp temp
1239: WHERE transaction_id = master_id
1240: AND thread_id = p_thread_id
1241: AND type = 'RETRIEVAL';

Line 1361: FROM hxc_transactions_ar bkuptxn,

1357: bkuptxn.DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,
1358: TRANSACTION_DATE,TYPE,STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,
1359: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1360: TRANSACTION_CODE
1361: FROM hxc_transactions_ar bkuptxn,
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

Line 1375: FROM hxc_transactions_ar bkuptxn

1371:
1372: l_trans_count := l_trans_count + SQL%ROWCOUNT;
1373:
1374: DELETE /*+ LEADING(temp) USE_NL(bkuptxn) */
1375: FROM hxc_transactions_ar bkuptxn
1376: WHERE transaction_id IN ( SELECT master_id
1377: FROM hxc_archive_temp temp
1378: WHERE thread_id = p_thread_id)
1379: AND type = 'DEPOSIT'