DBA Data[Home] [Help]

APPS.HXC_ARCHIVE dependencies on HXC_DEP_TRANSACTION_DETAILS

Line 493: hxc_dep_transaction_details ar

489: transaction_detail_id,
490: transaction_id,
491: ROWIDTOCHAR(ar.ROWID)
492: FROM hxc_temp_timecard_chunks temp,
493: hxc_dep_transaction_details ar
494: WHERE ar.time_building_block_id = temp.id
495: AND ar.time_building_block_ovn = temp.ref_ovn
496: AND thread_id = p_thread_id ;
497:

Line 1393: hxc_dep_transaction_details bkuptxnd

1389: p_data_set_id,TRANSACTION_DETAIL_ID,TIME_BUILDING_BLOCK_ID,TRANSACTION_ID,
1390: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1391: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TIME_BUILDING_BLOCK_OVN
1392: FROM hxc_archive_temp temp,
1393: hxc_dep_transaction_details bkuptxnd
1394: WHERE CHARTOROWID(temp.ref_rowid) = bkuptxnd.ROWID
1395: AND thread_id = p_thread_id ;
1396:
1397: l_td_count := l_td_count + SQL%ROWCOUNT;

Line 1400: DELETE FROM hxc_dep_transaction_details

1396:
1397: l_td_count := l_td_count + SQL%ROWCOUNT;
1398:
1399: FORALL i IN td_rowid_tab.FIRST..td_rowid_tab.LAST
1400: DELETE FROM hxc_dep_transaction_details
1401: WHERE ROWID = CHARTOROWID(td_rowid_tab(i));
1402:
1403: l_td_del_count := l_td_del_count + SQL%ROWCOUNT;
1404: