421: transaction_detail_id,
422: transaction_id,
423: ROWIDTOCHAR(ar.ROWID)
424: FROM hxc_temp_timecard_chunks temp,
425: hxc_transaction_details_ar ar
426: WHERE ar.time_building_block_id = temp.id
427: AND ar.time_building_block_ovn = temp.ref_ovn
428: AND thread_id = p_thread_id ;
429:
1038: bkuptxnd.DATA_SET_ID,TRANSACTION_DETAIL_ID,TIME_BUILDING_BLOCK_ID,TRANSACTION_ID,
1039: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1040: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TIME_BUILDING_BLOCK_OVN
1041: FROM hxc_archive_temp temp,
1042: hxc_transaction_details_ar bkuptxnd
1043: WHERE CHARTOROWID(temp.ref_rowid) = bkuptxnd.ROWID
1044: AND thread_id = p_thread_id
1045: AND bkuptxnd.data_set_id = p_data_set_id;
1046:
1048: l_td_count := l_td_count + SQL%ROWCOUNT;
1049:
1050:
1051: FORALL i IN td_rowid_tab.FIRST..td_rowid_tab.LAST
1052: DELETE FROM hxc_transaction_details_ar
1053: WHERE ROWID = CHARTOROWID(td_rowid_tab(i))
1054: AND data_set_id = p_data_set_id ;
1055:
1056: