APPS.HXC_RESTORE dependencies on HXC_AR_DETAIL_LOG

Line 43: FROM hxc_ar_detail_log temp2,

39: IS SELECT temp1.resource_id,
40: temp1.start_time,
41: temp1.time_building_block_id tc_id,
42: temp2.thread_id||'('||temp2.chunk_number||')' detail
43: FROM hxc_ar_detail_log temp2,
44: hxc_ar_tc_ids_temp temp1
45: WHERE temp1.time_building_block_id = temp2.time_building_block_id
46: AND temp1.object_version_number = temp2.object_version_number
47: AND temp2.process_type NOT LIKE '%INCOMPLETE%'

Line 60: FROM hxc_ar_detail_log temp2,

56: IS SELECT temp1.resource_id,
57: temp1.start_time,
58: temp1.time_building_block_id tc_id,
59: temp2.thread_id||'('||temp2.chunk_number||')' detail
60: FROM hxc_ar_detail_log temp2,
61: hxc_ar_tc_ids_temp temp1
62: WHERE temp1.time_building_block_id = temp2.time_building_block_id
63: AND temp1.object_version_number = temp2.object_version_number
64: AND temp2.process_type LIKE '%INCOMPLETE%'

Line 133: DELETE FROM hxc_ar_detail_log ;

129: WHERE data_set_id = p_data_set_id;
130:
131: -- Delete from the temp tables, if there is any left over data.
132:
133: DELETE FROM hxc_ar_detail_log ;
134: DELETE FROM hxc_ar_tc_ids_temp;
135: DELETE FROM hxc_ar_trans_temp;
136: DELETE FROM hxc_data_set_details;
137:

Line 547: INSERT INTO hxc_ar_detail_log

543: IS
544:
545: BEGIN
546: FORALL i IN tc_id_tab.FIRST..tc_id_tab.LAST
547: INSERT INTO hxc_ar_detail_log
548: (time_building_block_id,
549: object_version_number,
550: process_type,
551: thread_id,

Line 692: INSERT INTO hxc_ar_detail_log

688: END IF;
689:
690:
691: FORALL i IN tc_id_tab.FIRST..tc_id_tab.LAST
692: INSERT INTO hxc_ar_detail_log
693: (time_building_block_id,
694: object_version_number,
695: process_type,
696: thread_id,