APPS.HXC_RESTORE dependencies on HXC_TRANSACTION_DETAILS

Line 319: FROM hxc_transaction_details_ar htd

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) ;
321:
322:
323: DELETE FROM hxc_ar_trans_temp

Line 436: hxc_transaction_details_ar ar

432: transaction_detail_id,
433: transaction_id,
434: ROWIDTOCHAR(ar.ROWID)
435: FROM hxc_temp_timecard_chunks temp,
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

Line 455: hxc_transaction_details_ar ar

451: transaction_detail_id,
452: transaction_id,
453: ROWIDTOCHAR(ar.ROWID)
454: FROM hxc_temp_timecard_chunks temp,
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

Line 1128: INSERT INTO hxc_transaction_details

1124: trans_tab(i),
1125: td_rowid_tab(i),
1126: p_thread_id );
1127:
1128: INSERT INTO hxc_transaction_details
1129: (DATA_SET_ID,TRANSACTION_DETAIL_ID,TIME_BUILDING_BLOCK_ID,TRANSACTION_ID,
1130: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1131: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TIME_BUILDING_BLOCK_OVN)
1132: SELECT /*+ LEADING(temp) USE_NL(bkuptxnd) */

Line 1137: hxc_transaction_details_ar bkuptxnd

1133: bkuptxnd.DATA_SET_ID,TRANSACTION_DETAIL_ID,TIME_BUILDING_BLOCK_ID,TRANSACTION_ID,
1134: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1135: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TIME_BUILDING_BLOCK_OVN
1136: FROM hxc_archive_temp temp,
1137: hxc_transaction_details_ar bkuptxnd
1138: WHERE CHARTOROWID(temp.ref_rowid) = bkuptxnd.ROWID
1139: AND thread_id = p_thread_id
1140: AND bkuptxnd.data_set_id = p_data_set_id;
1141:

Line 1147: DELETE FROM hxc_transaction_details_ar

1143: l_td_count := l_td_count + SQL%ROWCOUNT;
1144:
1145:
1146: FORALL i IN td_rowid_tab.FIRST..td_rowid_tab.LAST
1147: DELETE FROM hxc_transaction_details_ar
1148: WHERE ROWID = CHARTOROWID(td_rowid_tab(i))
1149: AND data_set_id = p_data_set_id ;
1150:
1151:

Line 1272: -- hxc_transaction_details_ar, and hxc_dep_txn_details_ar are scanned here.

1268:
1269:
1270: -- Bug 8888813
1271: -- Added the below two cursor processing to pick up DEPOSIT transactions.
1272: -- hxc_transaction_details_ar, and hxc_dep_txn_details_ar are scanned here.
1273: -- so that the process works fine irrespective of the upgrade.
1274:
1275: IF get_old_transactions%ISOPEN
1276: THEN

Line 1309: hxc_transaction_details_ar bkuptxnd

1305: bkuptxnd.DATA_SET_ID,TRANSACTION_DETAIL_ID,TIME_BUILDING_BLOCK_ID,TRANSACTION_ID,
1306: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1307: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TIME_BUILDING_BLOCK_OVN
1308: FROM hxc_archive_temp temp,
1309: hxc_transaction_details_ar bkuptxnd
1310: WHERE CHARTOROWID(temp.ref_rowid) = bkuptxnd.ROWID
1311: AND thread_id = p_thread_id
1312: AND bkuptxnd.data_set_id = p_data_set_id;
1313:

Line 1319: DELETE FROM hxc_transaction_details_ar

1315: l_td_count := l_td_count + SQL%ROWCOUNT;
1316:
1317:
1318: FORALL i IN td_rowid_tab.FIRST..td_rowid_tab.LAST
1319: DELETE FROM hxc_transaction_details_ar
1320: WHERE ROWID = CHARTOROWID(td_rowid_tab(i))
1321: AND data_set_id = p_data_set_id ;
1322:
1323: