[Home] [Help]
524: CURSOR get_latest_details
525: IS SELECT det.time_building_block_id,
526: ROWIDTOCHAR(det.ROWID)
527: FROM hxc_temp_timecard_chunks temp,
528: hxc_latest_details det
529: WHERE temp.scope = 'DETAIL'
530: AND temp.id = det.time_building_block_id ;
531:
532:
732: -- * Select from hxc_ap_detail_links table, the records corresponding to the
733: -- details and insert into hxc_ap_detail_links_ar table.
734: -- * Delete from hxc_ap_detail_links table the above records.
735: -- * Delete from hxc_temp_timecard_chunks all records except the latest ovns.
736: -- * Insert these records into hxc_latest_details.
737: -- * COMMIT and pick up the next chunk.
738: --
739: -- Technical points to look for.
740: -- 1. Simulated Continue with each chunk check.
1792: BULK COLLECT INTO latest_id_tab,
1793: latest_rowid_tab LIMIT 500;
1794: EXIT WHEN latest_id_tab.COUNT = 0;
1795: FORALL i IN latest_id_Tab.FIRST..latest_id_Tab.last
1796: DELETE FROM hxc_latest_details
1797: WHERE ROWID = CHARTOROWID(latest_rowid_tab(i)) ;
1798:
1799: latest_rowid_tab.DELETE;
1800: latest_id_tab.DELETE;