[Home] [Help]
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%'
48: ORDER BY temp2.thread_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%'
65: ORDER BY temp2.thread_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:
138: COMMIT;
148: BULK COLLECT INTO l_tc_tab LIMIT 500;
149:
150: EXIT WHEN l_tc_tab.COUNT = 0;
151:
152: -- Insert these 500 records into hxc_ar_tc_ids_temp
153: FORALL i IN l_tc_tab.FIRST..l_tc_tab.LAST
154: INSERT INTO hxc_ar_tc_ids_temp
155: VALUES l_tc_tab(i) ;
156:
150: EXIT WHEN l_tc_tab.COUNT = 0;
151:
152: -- Insert these 500 records into hxc_ar_tc_ids_temp
153: FORALL i IN l_tc_tab.FIRST..l_tc_tab.LAST
154: INSERT INTO hxc_ar_tc_ids_temp
155: VALUES l_tc_tab(i) ;
156:
157: -- Loop thru the timecard records fetched
158: -- and record the time_building_block_ids
411:
412: CURSOR get_tcs
413: IS SELECT time_building_block_id,
414: object_version_number
415: FROM hxc_ar_tc_ids_temp
416: WHERE time_building_block_id >= p_from_id
417: AND time_building_block_id < p_to_id ;
418:
419: CURSOR get_transactions