APPS.HXC_ARCHIVE dependencies on HXC_TRANSACTIONS_AR

Line 313: -- to hxc_transactions_ar if they are not present already.

309: UPDATE hxc_ar_trans_temp
310: SET thread_id = 0 ;
311:
312: -- Not much processing left, just insert the records from hxc_transacitons
313: -- to hxc_transactions_ar if they are not present already.
314:
315: INSERT INTO hxc_transactions_ar
316: (DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,TRANSACTION_DATE,TYPE,
317: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,

Line 315: INSERT INTO hxc_transactions_ar

311:
312: -- Not much processing left, just insert the records from hxc_transacitons
313: -- to hxc_transactions_ar if they are not present already.
314:
315: INSERT INTO hxc_transactions_ar
316: (DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,TRANSACTION_DATE,TYPE,
317: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
318: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TRANSACTION_CODE)
319: SELECT /*+ INDEX(bkuptxn hxc_transactions_pk) */

Line 329: FROM hxc_transactions_ar hxc

325: WHERE bkuptxn.transaction_id IN ( SELECT temp.transaction_id
326: FROM hxc_ar_trans_temp temp
327: WHERE thread_id = 0 )
328: AND bkuptxn.transaction_id NOT IN ( SELECT transaction_id
329: FROM hxc_transactions_ar hxc
330: WHERE bkuptxn.transaction_id = hxc.transaction_id)
331: ;
332:
333: -- Delete those records from hxc_transactions.

Line 668: -- insert into hxc_transactions_ar table.

664: -- hxc_transaction_details_ar.
665: -- Delete the records from hxc_transaction_details_ar using the ROWID.
666: -- Delete duplicate transaction ids from hxc_archive_temp.
667: -- Select all deposit transaction records from hxc_transactions table and
668: -- insert into hxc_transactions_ar table.
669: -- Select all retrieval transaction ids and insert into hxc_ar_trans_temp
670: -- table for the parent thread to process.
671: -- Delete all transaction records from hxc_transactions table, if the transaction
672: -- id is present in hxc_archive_temp.

Line 1206: FROM hxc_transactions_ar

1202: CLOSE get_dup_trans;
1203:
1204: DELETE FROM hxc_archive_temp
1205: WHERE EXISTS ( SELECT 1
1206: FROM hxc_transactions_ar
1207: WHERE transaction_id = master_id )
1208: AND thread_id = p_thread_id ;
1209:
1210: INSERT INTO hxc_transactions_ar

Line 1210: INSERT INTO hxc_transactions_ar

1206: FROM hxc_transactions_ar
1207: WHERE transaction_id = master_id )
1208: AND thread_id = p_thread_id ;
1209:
1210: INSERT INTO hxc_transactions_ar
1211: (DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,TRANSACTION_DATE,TYPE,
1212: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1213: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TRANSACTION_CODE)
1214: SELECT /*+ LEADING(temp) USE_NL(bkuptxn) */

Line 1224: FROM hxc_transactions_ar hxc

1220: hxc_archive_temp temp
1221: WHERE transaction_id = master_id
1222: AND thread_id = p_thread_id
1223: AND transaction_id NOT IN ( SELECT transaction_id
1224: FROM hxc_transactions_ar hxc
1225: WHERE bkuptxn.transaction_id = hxc.transaction_id)
1226: AND type <> 'RETRIEVAL'
1227: ;
1228: