[Home] [Help]
4: -- Procedure Name : restore_process
5: -- Description : This procedure is called durINg Restore Data Set process.
6: -- For a given data set, it copies the records FROM archive
7: -- tables to base tables AND deletes the records IN archive table.
8: -- It restores the links IN hxc_tc_ap_links AND hxc_ap_detail_links.
9: -- It starts the approval process agaIN for eligible
10: -- application period ids. This process is done IN chunks.
11: ----------------------------------------------------------------------------
12: PROCEDURE restore_process(p_data_set_id NUMBER,
1791: END IF;
1792:
1793:
1794:
1795: INSERT INTO hxc_ap_detail_links
1796: (application_period_id,
1797: time_building_block_id,
1798: time_building_block_ovn)
1799: SELECT /*+ INDEX( adlbkup HXC_AP_DETAIL_LINKS_AR_FK1) */
1795: INSERT INTO hxc_ap_detail_links
1796: (application_period_id,
1797: time_building_block_id,
1798: time_building_block_ovn)
1799: SELECT /*+ INDEX( adlbkup HXC_AP_DETAIL_LINKS_AR_FK1) */
1800: application_period_id, time_building_block_id, time_building_block_ovn
1801: FROM hxc_temp_timecard_chunks temp,
1802: hxc_ap_detail_links_ar adlbkup
1803: WHERE temp.id = adlbkup.time_building_block_id
1798: time_building_block_ovn)
1799: SELECT /*+ INDEX( adlbkup HXC_AP_DETAIL_LINKS_AR_FK1) */
1800: application_period_id, time_building_block_id, time_building_block_ovn
1801: FROM hxc_temp_timecard_chunks temp,
1802: hxc_ap_detail_links_ar adlbkup
1803: WHERE temp.id = adlbkup.time_building_block_id
1804: AND temp.ref_ovn = adlbkup.time_building_block_ovn
1805: AND temp.scope = ('DETAIL')
1806: AND thread_id = p_thread_id ;
1807:
1808: l_adl_count := SQL%ROWCOUNT;
1809:
1810:
1811: DELETE FROM hxc_ap_detail_links_ar
1812: WHERE (time_building_block_id,time_building_block_ovn)
1813: IN ( SELECT id,
1814: ref_ovn
1815: FROM hxc_temp_timecard_chunks