APPS.HXC_RESTORE dependencies on HXC_TC_AP_LINKS

Line 8: -- It restores the links IN hxc_tc_ap_links AND hxc_ap_detail_links.

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,

Line 716: hxc_tc_ap_links_ar talbkup

712: 'APPLICATION_PERIOD',
713: ROWIDTOCHAR(talbkup.ROWID),
714: thread_id
715: FROM hxc_temp_timecard_chunks temp,
716: hxc_tc_ap_links_ar talbkup
717: WHERE temp.id = talbkup.timecard_id
718: AND temp.scope IN ('TIMECARD')
719: AND thread_id = p_thread_id ;
720:

Line 722: INSERT INTO hxc_tc_ap_links

718: AND temp.scope IN ('TIMECARD')
719: AND thread_id = p_thread_id ;
720:
721:
722: INSERT INTO hxc_tc_ap_links
723: ( timecard_id,
724: application_period_id)
725: SELECT timecard_id,
726: application_period_id

Line 728: hxc_tc_ap_links_ar talbkup

724: application_period_id)
725: SELECT timecard_id,
726: application_period_id
727: FROM hxc_temp_timecard_chunks temp,
728: hxc_tc_ap_links_ar talbkup
729: WHERE temp.ref_rowid = talbkup.ROWID
730: AND temp.scope = ('APPLICATION_PERIOD')
731: AND thread_id = p_thread_id ;
732:

Line 736: DELETE FROM hxc_tc_ap_links_ar

732:
733:
734: l_tal_count := SQL%ROWCOUNT;
735:
736: DELETE FROM hxc_tc_ap_links_ar
737: WHERE ROWID IN ( SELECT CHARTOROWID(ref_rowid)
738: FROM hxc_temp_timecard_chunks
739: WHERE scope = 'APPLICATION_PERIOD'
740: AND thread_id = p_thread_id );