[Home] [Help]
340: WHERE ROWID IN ( SELECT CHARTOROWID(trans_rowid)
341: FROM hxc_ar_trans_temp
342: WHERE thread_id = 0 )
343: AND NOT EXISTS( SELECT 1
344: FROM hxc_transaction_details htd
345: WHERE htd.transaction_id = ht.transaction_id);
346:
347:
348: -- Clear all the records, which are processed.
475: transaction_detail_id,
476: transaction_id,
477: ROWIDTOCHAR(ar.ROWID)
478: FROM hxc_temp_timecard_chunks temp,
479: hxc_transaction_details ar
480: WHERE ar.time_building_block_id = temp.id
481: AND ar.time_building_block_ovn = temp.ref_ovn
482: AND thread_id = p_thread_id ;
483:
703: -- Pick up transaction detail records for the records in hxc_temp_timecard_chunks
704: -- as of now. ( detail_id, transaction_id, detail_rowid ), and insert into
705: -- hxc_archive_temp.
706: -- Using the rowids, insert the transaction detail records into
707: -- hxc_transaction_details_ar.
708: -- Delete the records from hxc_transaction_details_ar using the ROWID.
709: -- Delete duplicate transaction ids from hxc_archive_temp.
710: -- Select all deposit transaction records from hxc_transactions table and
711: -- insert into hxc_transactions_ar table.
704: -- as of now. ( detail_id, transaction_id, detail_rowid ), and insert into
705: -- hxc_archive_temp.
706: -- Using the rowids, insert the transaction detail records into
707: -- hxc_transaction_details_ar.
708: -- Delete the records from hxc_transaction_details_ar using the ROWID.
709: -- Delete duplicate transaction ids from hxc_archive_temp.
710: -- Select all deposit transaction records from hxc_transactions table and
711: -- insert into hxc_transactions_ar table.
712: -- Select all retrieval transaction ids and insert into hxc_ar_trans_temp
719: -- as of now. ( usage_id, attribute_id, usage_rowid ), and insert into
720: -- hxc_archive_temp.
721: -- Using the rowids, insert the attribute usage records into
722: -- hxc_attribute_usages_ar.
723: -- Delete the records from hxc_transaction_details_ar using the ROWID.
724: -- Delete all records from hxc_archive_temp if attribute_id is
725: -- present in hxc_time_attributes_ar
726: -- Select all attribute records from hxc_time_attributes table and
727: -- insert into hxc_time_attributes_ar table.
1202: trans_tab(i),
1203: td_rowid_tab(i),
1204: p_thread_id );
1205:
1206: INSERT INTO hxc_transaction_details_ar
1207: (DATA_SET_ID,TRANSACTION_DETAIL_ID,TIME_BUILDING_BLOCK_ID,TRANSACTION_ID,
1208: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1209: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TIME_BUILDING_BLOCK_OVN)
1210: SELECT /*+ LEADING(temp) USE_NL(bkuptxnd) */
1211: p_data_set_id,TRANSACTION_DETAIL_ID,TIME_BUILDING_BLOCK_ID,TRANSACTION_ID,
1212: STATUS,EXCEPTION_DESCRIPTION,OBJECT_VERSION_NUMBER,CREATED_BY,CREATION_DATE,
1213: LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,TIME_BUILDING_BLOCK_OVN
1214: FROM hxc_archive_temp temp,
1215: hxc_transaction_details bkuptxnd
1216: WHERE CHARTOROWID(temp.ref_rowid) = bkuptxnd.ROWID
1217: AND thread_id = p_thread_id ;
1218:
1219: l_td_count := l_td_count + SQL%ROWCOUNT;
1218:
1219: l_td_count := l_td_count + SQL%ROWCOUNT;
1220:
1221: FORALL i IN td_rowid_tab.FIRST..td_rowid_tab.LAST
1222: DELETE FROM hxc_transaction_details
1223: WHERE ROWID = CHARTOROWID(td_rowid_tab(i));
1224:
1225: l_td_del_count := l_td_del_count + SQL%ROWCOUNT;
1226:
1257: */
1258:
1259: -- Bug 8888813
1260: -- If the upgrade for Deposit Transaction is not completed,
1261: -- ( Bug 8888811 ), hxc_transactions and hxc_transaction_details
1262: -- might still contain DEPOSIT transactions. Process them.
1263: IF NOT hxc_upgrade_pkg.txn_upgrade_completed
1264: THEN
1265: