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 811: hxc_tc_ap_links_ar talbkup

807: 'APPLICATION_PERIOD',
808: ROWIDTOCHAR(talbkup.ROWID),
809: thread_id
810: FROM hxc_temp_timecard_chunks temp,
811: hxc_tc_ap_links_ar talbkup
812: WHERE temp.id = talbkup.timecard_id
813: AND temp.scope IN ('TIMECARD')
814: AND thread_id = p_thread_id ;
815:

Line 817: INSERT INTO hxc_tc_ap_links

813: AND temp.scope IN ('TIMECARD')
814: AND thread_id = p_thread_id ;
815:
816:
817: INSERT INTO hxc_tc_ap_links
818: ( timecard_id,
819: application_period_id)
820: SELECT timecard_id,
821: application_period_id

Line 823: hxc_tc_ap_links_ar talbkup

819: application_period_id)
820: SELECT timecard_id,
821: application_period_id
822: FROM hxc_temp_timecard_chunks temp,
823: hxc_tc_ap_links_ar talbkup
824: WHERE temp.ref_rowid = talbkup.ROWID
825: AND temp.scope = ('APPLICATION_PERIOD')
826: AND thread_id = p_thread_id ;
827:

Line 831: DELETE FROM hxc_tc_ap_links_ar

827:
828:
829: l_tal_count := SQL%ROWCOUNT;
830:
831: DELETE FROM hxc_tc_ap_links_ar
832: WHERE ROWID IN ( SELECT CHARTOROWID(ref_rowid)
833: FROM hxc_temp_timecard_chunks
834: WHERE scope = 'APPLICATION_PERIOD'
835: AND thread_id = p_thread_id );