APPS.HXC_RESTORE dependencies on HXC_TRANSACTIONS

Line 290: INSERT INTO hxc_transactions

286: THEN
287: UPDATE hxc_ar_trans_temp
288: SET thread_id = 0 ;
289:
290: INSERT INTO hxc_transactions
291: (DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,TRANSACTION_DATE,TYPE,
292: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
293: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TRANSACTION_CODE)
294: SELECT bkuptxn.DATA_SET_ID,bkuptxn.TRANSACTION_ID,TRANSACTION_PROCESS_ID,

Line 298: FROM hxc_transactions_ar bkuptxn

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

Line 303: FROM hxc_transactions hxc

299: WHERE bkuptxn.transaction_id IN ( SELECT temp.transaction_id
300: FROM hxc_ar_trans_temp temp
301: WHERE thread_id = 0 )
302: AND bkuptxn.transaction_id NOT IN ( SELECT transaction_id
303: FROM hxc_transactions hxc
304: WHERE bkuptxn.transaction_id = hxc.transaction_id)
305: AND bkuptxn.data_set_id = p_data_set_id
306: ;
307:

Line 308: DELETE FROM hxc_transactions_ar

304: WHERE bkuptxn.transaction_id = hxc.transaction_id)
305: AND bkuptxn.data_set_id = p_data_set_id
306: ;
307:
308: DELETE FROM hxc_transactions_ar
309: WHERE ROWID IN ( SELECT CHARTOROWID(trans_rowid)
310: FROM hxc_ar_trans_temp
311: WHERE thread_id = 0 )
312: AND data_set_id = p_data_set_id ;

Line 1081: FROM hxc_transactions

1077: CLOSE get_dup_trans;
1078:
1079: DELETE FROM hxc_archive_temp
1080: WHERE EXISTS ( SELECT 1
1081: FROM hxc_transactions
1082: WHERE transaction_id = master_id )
1083: AND thread_id = p_thread_id ;
1084:
1085: INSERT INTO hxc_transactions

Line 1085: INSERT INTO hxc_transactions

1081: FROM hxc_transactions
1082: WHERE transaction_id = master_id )
1083: AND thread_id = p_thread_id ;
1084:
1085: INSERT INTO hxc_transactions
1086: (DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,TRANSACTION_DATE,TYPE,
1087: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1088: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TRANSACTION_CODE)
1089: SELECT /*+ LEADING(temp) USE_NL(bkuptxn) */

Line 1094: FROM hxc_transactions_ar bkuptxn,

1090: bkuptxn.DATA_SET_ID,TRANSACTION_ID,TRANSACTION_PROCESS_ID,
1091: TRANSACTION_DATE,TYPE,STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,
1092: CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,
1093: TRANSACTION_CODE
1094: FROM hxc_transactions_ar bkuptxn,
1095: hxc_archive_temp temp
1096: WHERE transaction_id = master_id
1097: AND thread_id = p_thread_id
1098: AND transaction_id NOT IN ( SELECT transaction_id

Line 1099: FROM hxc_transactions hxc

1095: hxc_archive_temp temp
1096: WHERE transaction_id = master_id
1097: AND thread_id = p_thread_id
1098: AND transaction_id NOT IN ( SELECT transaction_id
1099: FROM hxc_transactions hxc
1100: WHERE bkuptxn.transaction_id = hxc.transaction_id)
1101: AND type <> 'RETRIEVAL'
1102: AND bkuptxn.data_set_id = p_data_set_id
1103: ;

Line 1108: FROM hxc_transactions_ar bkuptxn

1104:
1105: l_trans_count := l_trans_count + SQL%ROWCOUNT;
1106:
1107: DELETE /*+ LEADING(temp) USE_NL(bkuptxn) */
1108: FROM hxc_transactions_ar bkuptxn
1109: WHERE transaction_id IN ( SELECT master_id
1110: FROM hxc_archive_temp temp
1111: WHERE thread_id = p_thread_id)
1112: AND type <> 'RETRIEVAL'

Line 1123: FROM hxc_transactions_ar bkuptxn,

1119: SELECT bkuptxn.transaction_id,
1120: p_data_set_id,
1121: p_thread_id,
1122: ROWIDTOCHAR(bkuptxn.ROWID)
1123: FROM hxc_transactions_ar bkuptxn,
1124: hxc_archive_temp temp
1125: WHERE transaction_id = master_id
1126: AND thread_id = p_thread_id
1127: AND type = 'RETRIEVAL'