[Home] [Help]
503: CURSOR get_latest_details
504: IS SELECT det.time_building_block_id,
505: ROWIDTOCHAR(det.ROWID)
506: FROM hxc_temp_timecard_chunks temp,
507: hxc_latest_details det
508: WHERE temp.scope = 'DETAIL'
509: AND temp.id = det.time_building_block_id ;
510:
511:
689: -- * Select from hxc_ap_detail_links table, the records corresponding to the
690: -- details and insert into hxc_ap_detail_links_ar table.
691: -- * Delete from hxc_ap_detail_links table the above records.
692: -- * Delete from hxc_temp_timecard_chunks all records except the latest ovns.
693: -- * Insert these records into hxc_latest_details.
694: -- * COMMIT and pick up the next chunk.
695: --
696: -- Technical points to look for.
697: -- 1. Simulated Continue with each chunk check.
1443: BULK COLLECT INTO latest_id_tab,
1444: latest_rowid_tab LIMIT 500;
1445: EXIT WHEN latest_id_tab.COUNT = 0;
1446: FORALL i IN latest_id_Tab.FIRST..latest_id_Tab.last
1447: DELETE FROM hxc_latest_details
1448: WHERE ROWID = CHARTOROWID(latest_rowid_tab(i)) ;
1449:
1450: latest_rowid_tab.DELETE;
1451: latest_id_tab.DELETE;