APPS.HXC_ARCHIVE dependencies on HXC_AR_DETAIL_LOG

Line 42: FROM hxc_ar_detail_log temp2,

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

Line 58: FROM hxc_ar_detail_log temp2,

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

Line 131: DELETE FROM hxc_ar_detail_log ;

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

Line 629: INSERT INTO hxc_ar_detail_log

625: IS
626:
627: BEGIN
628: FORALL i IN tc_id_tab.FIRST..tc_id_tab.LAST
629: INSERT INTO hxc_ar_detail_log
630: (time_building_block_id,
631: object_version_number,
632: process_type,
633: thread_id,

Line 881: INSERT INTO hxc_ar_detail_log

877: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
878: END IF;
879:
880: FORALL i IN tc_id_tab.FIRST..tc_id_tab.LAST
881: INSERT INTO hxc_ar_detail_log
882: (time_building_block_id,
883: object_version_number,
884: process_type,
885: thread_id,