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: -- Bug 11781607
291: -- Removed Data set id condition.

Line 303: FROM hxc_ar_trans_temp temp

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

Line 316: FROM hxc_ar_trans_temp

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
319: FROM hxc_transaction_details_ar htd
320: WHERE htd.transaction_id = ht.transaction_id) ;

Line 323: DELETE FROM hxc_ar_trans_temp

319: FROM hxc_transaction_details_ar htd
320: WHERE htd.transaction_id = ht.transaction_id) ;
321:
322:
323: DELETE FROM hxc_ar_trans_temp
324: WHERE thread_id = 0 ;
325:
326: COMMIT;
327: ELSE

Line 1231: INSERT INTO hxc_ar_trans_temp

1227: -- Bug 11781607
1228: -- Removed data set id condition to take care of
1229: -- transactions spanning data sets.
1230:
1231: INSERT INTO hxc_ar_trans_temp
1232: ( transaction_id, data_set_id, thread_id, trans_rowid )
1233: SELECT bkuptxn.transaction_id,
1234: p_data_set_id,
1235: p_thread_id,