APPS.HXC_RESTORE dependencies on HXC_DEP_TXN_DETAILS_AR

Line 471: hxc_dep_txn_details_ar ar

467: transaction_detail_id,
468: transaction_id,
469: ROWIDTOCHAR(ar.ROWID)
470: FROM hxc_temp_timecard_chunks temp,
471: hxc_dep_txn_details_ar ar
472: WHERE ar.time_building_block_id = temp.id
473: AND ar.time_building_block_ovn = temp.ref_ovn
474: AND thread_id = p_thread_id ;
475:

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 1426: hxc_dep_txn_details_ar bkuptxnd

1422: bkuptxnd.DATA_SET_ID,TRANSACTION_DETAIL_ID,TIME_BUILDING_BLOCK_ID,TRANSACTION_ID,
1423: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1424: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TIME_BUILDING_BLOCK_OVN
1425: FROM hxc_archive_temp temp,
1426: hxc_dep_txn_details_ar bkuptxnd
1427: WHERE CHARTOROWID(temp.ref_rowid) = bkuptxnd.ROWID
1428: AND thread_id = p_thread_id
1429: AND bkuptxnd.data_set_id = p_data_set_id;
1430:

Line 1436: DELETE FROM hxc_dep_txn_details_ar

1432: l_td_count := l_td_count + SQL%ROWCOUNT;
1433:
1434:
1435: FORALL i IN td_rowid_tab.FIRST..td_rowid_tab.LAST
1436: DELETE FROM hxc_dep_txn_details_ar
1437: WHERE ROWID = CHARTOROWID(td_rowid_tab(i))
1438: AND data_set_id = p_data_set_id ;
1439:
1440: