[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,
1292: WHERE scope IN ( 'TIMECARD', 'DAY','APPLICATION_PERIOD')
1293: AND thread_id = p_thread_id ;
1294:
1295:
1296: INSERT INTO hxc_ap_detail_links
1297: (application_period_id,
1298: time_building_block_id,
1299: time_building_block_ovn)
1300: SELECT /*+ INDEX( adlbkup HXC_AP_DETAIL_LINKS_AR_FK1) */
1296: INSERT INTO hxc_ap_detail_links
1297: (application_period_id,
1298: time_building_block_id,
1299: time_building_block_ovn)
1300: SELECT /*+ INDEX( adlbkup HXC_AP_DETAIL_LINKS_AR_FK1) */
1301: application_period_id, time_building_block_id, time_building_block_ovn
1302: FROM hxc_temp_timecard_chunks temp,
1303: hxc_ap_detail_links_ar adlbkup
1304: WHERE temp.id = adlbkup.time_building_block_id
1299: time_building_block_ovn)
1300: SELECT /*+ INDEX( adlbkup HXC_AP_DETAIL_LINKS_AR_FK1) */
1301: application_period_id, time_building_block_id, time_building_block_ovn
1302: FROM hxc_temp_timecard_chunks temp,
1303: hxc_ap_detail_links_ar adlbkup
1304: WHERE temp.id = adlbkup.time_building_block_id
1305: AND temp.ref_ovn = adlbkup.time_building_block_ovn
1306: AND temp.scope = ('DETAIL')
1307: AND thread_id = p_thread_id ;
1308:
1309: l_adl_count := SQL%ROWCOUNT;
1310:
1311:
1312: DELETE FROM hxc_ap_detail_links_ar
1313: WHERE (time_building_block_id,time_building_block_ovn)
1314: IN ( SELECT id,
1315: ref_ovn
1316: FROM hxc_temp_timecard_chunks