APPS.HXC_RESTORE dependencies on HXC_AR_TRANS_TEMP

Line 135: DELETE FROM hxc_ar_trans_temp;

131: -- Delete from the temp tables, if there is any left over data.
132:
133: DELETE FROM hxc_ar_detail_log ;
134: DELETE FROM hxc_ar_tc_ids_temp;
135: DELETE FROM hxc_ar_trans_temp;
136: DELETE FROM hxc_data_set_details;
137:
138: COMMIT;
139: l_bb_ctr := 0;

Line 282: FROM hxc_ar_trans_temp

278: END LOOP;
279:
280: SELECT count(1)
281: INTO trans_count
282: FROM hxc_ar_trans_temp
283: WHERE rownum < 2;
284:
285: IF trans_count >= 1
286: THEN

Line 287: UPDATE hxc_ar_trans_temp

283: WHERE rownum < 2;
284:
285: IF trans_count >= 1
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,

Line 300: FROM hxc_ar_trans_temp temp

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
303: FROM hxc_transactions hxc
304: WHERE bkuptxn.transaction_id = hxc.transaction_id)

Line 310: FROM hxc_ar_trans_temp

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 ;
313:
314:

Line 315: DELETE FROM hxc_ar_trans_temp

311: WHERE thread_id = 0 )
312: AND data_set_id = p_data_set_id ;
313:
314:
315: DELETE FROM hxc_ar_trans_temp
316: WHERE thread_id = 0 ;
317:
318: COMMIT;
319: ELSE

Line 1117: INSERT INTO hxc_ar_trans_temp

1113: AND data_set_id = p_data_set_id ;
1114:
1115: l_trans_del_count := l_trans_del_count + SQL%ROWCOUNT;
1116:
1117: INSERT INTO hxc_ar_trans_temp
1118: ( transaction_id, data_set_id, thread_id, trans_rowid )
1119: SELECT bkuptxn.transaction_id,
1120: p_data_set_id,
1121: p_thread_id,