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

582: IS
583:
584: BEGIN
585: FORALL i IN tc_id_tab.FIRST..tc_id_tab.LAST
586: INSERT INTO hxc_ar_detail_log
587: (time_building_block_id,
588: object_version_number,
589: process_type,
590: thread_id,

Line 838: INSERT INTO hxc_ar_detail_log

834: EXIT TO_CONTINUE_TO_NEXT_CHUNK ;
835: END IF;
836:
837: FORALL i IN tc_id_tab.FIRST..tc_id_tab.LAST
838: INSERT INTO hxc_ar_detail_log
839: (time_building_block_id,
840: object_version_number,
841: process_type,
842: thread_id,