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 642: INSERT INTO hxc_ar_detail_log

638: IS
639:
640: BEGIN
641: FORALL i IN tc_id_tab.FIRST..tc_id_tab.LAST
642: INSERT INTO hxc_ar_detail_log
643: (time_building_block_id,
644: object_version_number,
645: process_type,
646: thread_id,

Line 787: INSERT INTO hxc_ar_detail_log

783: END IF;
784:
785:
786: FORALL i IN tc_id_tab.FIRST..tc_id_tab.LAST
787: INSERT INTO hxc_ar_detail_log
788: (time_building_block_id,
789: object_version_number,
790: process_type,
791: thread_id,