eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.EDW_SUMMARY_COLLECT

Source


1 package EDW_SUMMARY_COLLECT AUTHID CURRENT_USER AS
2 /*$Header: EDWSCOLS.pls 115.26 2004/04/06 16:37:33 vsurendr ship $*/
3 
4 g_all_done boolean;
5 g_max_fk_density number;
6 g_dim_direct_load boolean;
7 g_exec_flag boolean;
8 g_slow_flag boolean:=true;
9 g_debug boolean:=true;
10 g_thread_type varchar2(40);
11 g_max_threads number;
12 g_job_status_table varchar2(80);
13 g_job_id number;
14 g_jobid_stmt varchar2(400);
15 g_dim_name varchar2(400);
16 g_dim_pk varchar2(400);
17 g_dim_user_pk varchar2(400);
18 g_ltc_pk varchar2(400); --the ltc value of g_dim_pk
19 g_ltc_user_pk varchar2(400);
20 g_dim_name_temp varchar2(400);--the temp table
21 g_dim_name_temp_int varchar2(400);--the temp table intermediate
22 g_dim_kl_table varchar2(400); --contains the key lookup. used in slow change
23 g_dim_kl_table_temp varchar2(400);
24 g_dim_name_hold varchar2(400);--the hole table, used only for star update
25 g_dim_name_rowid_hold varchar2(400);--will hold row_id from g_dim_name_hold
26 g_dim_id number;
27 g_dim_map_name varchar2(400);
28 g_dim_map_id number;
29 g_dim_name_with_slow varchar2(400);--a temp table that holds the dim pk, rowid and slow change cols
30 g_read_cfig_options boolean;
31 g_number_rows_inserted number;
32 g_number_rows_updated number;
33 g_number_rows_processed number;
34 g_dim_count number;
35 g_big_table number;--simply to demarcate a big table from a small table
36 g_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
37 g_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType;
38 g_levels_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
39 g_levels_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
40 g_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType;
41 g_level_status EDW_OWB_COLLECTION_UTIL.varcharTableType;
42 g_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType;
43 g_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType;
44 g_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
45 g_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
46 g_number_levels integer;
47 /*
48 store the format of child level, its alias, fk, parent, its alias and its pk
49 */
50 g_fk_pk_child_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
51 g_fk_pk_child_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
52 g_fk_pk_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType;
53 g_fk_pk_parent_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
54 g_fk_pk_parent_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
55 g_fk_pk_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
56 g_fk_pk_number number;
57 
58 g_level_map_id EDW_OWB_COLLECTION_UTIL.numberTableType;
59 g_level_primary_src EDW_OWB_COLLECTION_UTIL.numberTableType;
60 g_level_primary_target EDW_OWB_COLLECTION_UTIL.numberTableType;
61 g_dim_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
62 g_level_name EDW_OWB_COLLECTION_UTIL.varcharTableType;
63 g_level_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
64 g_number_mapping number;
65 g_flag boolean;
66 g_dim_empty_flag boolean;
67 g_all_level varchar2(500);
68 g_all_level_index number;
69 g_ilog varchar2(400);--the name of the ilog table
70 g_ilog_main_name varchar2(80);--used in multi threading
71 g_update_type varchar2(400);--what scheme should update follow...mass, row by row, delete insert...
72 
73 g_status boolean;
74 g_status_message varchar2(4000);
75 
76 G_SLOW_IMPLEMENTED boolean;
77 g_slow_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
78 g_slow_level EDW_OWB_COLLECTION_UTIL.varcharTableType;
79 g_slow_level_alias EDW_OWB_COLLECTION_UTIL.varcharTableType;
80 g_slow_level_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
81 g_number_slow_cols number;
82 
83 g_seq_name varchar2(400);
84 
85 g_temp_insert_stmt varchar2(30000);
86 g_temp_update_stmt varchar2(30000);
87 g_temp_int_tm_stmt varchar2(30000);--moves data from the int temp to the temp table
88 g_temp_pk_update_stmt varchar2(30000);
89 g_temp_rowid_update_stmt varchar2(30000);
90 g_insert_stmt_star varchar2(30000);
91 g_update_stmt_star varchar2(30000);
92 g_update_stmt_star_row varchar2(30000);
93 g_hold_insert_stmt  varchar2(30000);
94 g_forall_size number;
95 g_conc_id number;
96 g_conc_name varchar2(400);
97 g_object_type varchar2(200);
98 g_consider_snapshot EDW_OWB_COLLECTION_UTIL.booleanTableType;
99 g_slow_is_name varchar2(400); --name of the itemset containing the columns for the slow change dim
100 g_lowest_level varchar2(400);
101 g_lowest_level_index number;
102 g_lowest_level_global varchar2(400);
103 g_lowest_level_id number;
104 g_lowest_level_alias varchar2(40);
105 g_stmt varchar2(30000);
106 g_bis_owner varchar2(400);
107 g_parallel number;
108 g_collection_size number;
109 g_table_owner varchar2(400);
110 /*
111 the stmts to denormalize
112 g_from_stmt for example is the from all ltc tables with alias
113 */
114 g_insert_stmt_nopk  varchar2(30000);--insert for all cols except the pk and user pk
115 g_select_stmt varchar2(30000);
116 g_select_stmt_nopk varchar2(30000);--select from all ltc but no pk and user pk
117 g_from_stmt  varchar2(30000);
118 g_from_stmt_global  varchar2(30000);
119 g_from_stmt_ilog  varchar2(30000);--for ilog
120 g_where_stmt  varchar2(30000);
121 g_where_snplog_stmt varchar2(30000);
122 g_where_snplog_stmt_ilog varchar2(30000);
123 g_update_star_flag boolean;
124 g_insert_star_flag boolean;
125 
126 g_levels_I EDW_OWB_COLLECTION_UTIL.varcharTableType; /*to enhance perf of insert into ilog, we
127 first create copy of the LTC table with only the rowid, pk and fk. these hold the names*/
128 g_levels_copy EDW_OWB_COLLECTION_UTIL.varcharTableType; /*these hold the changes records from the
129 level tables that need to be denormalized*/
130 g_snplogs_L EDW_OWB_COLLECTION_UTIL.varcharTableType;/* similarly for the snapshot logs*/
131 g_snplogs_LT EDW_OWB_COLLECTION_UTIL.varcharTableType;/* similarly for the snapshot logs, temp*/
132 g_considered_parent EDW_OWB_COLLECTION_UTIL.varcharTableType;/* If a parent level is considered to see if
133 any rowids of the child need to go, it need not be considered in any other hierarchy again.*/
134 g_number_considered_parent number;
135 g_level_change boolean;--means the same as incremental collection
136 
137 ------skipping-------------------------------------
138 g_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType;
139 g_number_skip_cols number;
140 g_skip_item EDW_OWB_COLLECTION_UTIL.booleanTableType;
141 ---------------------------------------------------
142 g_load_pk number;
143 g_dim_next_extent number;--storage parameter
144 g_fresh_restart boolean;
145 g_op_table_space varchar2(400);
146 g_rollback varchar2(400);
147 g_dim_derv_col EDW_OWB_COLLECTION_UTIL.varcharTableType;
148 g_dim_derv_col_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType;--the corresponding ltc table
149 g_dim_derv_col_map EDW_OWB_COLLECTION_UTIL.numberTableType;
150 g_number_dim_derv_col number;
151 g_dim_derv_col_map_all EDW_OWB_COLLECTION_UTIL.numberTableType;
152 g_num_dim_derv_col_map_all number;
153 g_dim_derv_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;--what pk_key is needed for higher levels.
154 g_number_dim_derv_pk_key number;
155 g_dim_derv_map_id EDW_OWB_COLLECTION_UTIL.numberTableType;
156 g_derv_fact_id EDW_OWB_COLLECTION_UTIL.numberTableType;
157 g_derv_fact_full_id EDW_OWB_COLLECTION_UTIL.numberTableType;--for full refresh
158 g_number_derv_fact_full_id number;
159 g_src_fact_id EDW_OWB_COLLECTION_UTIL.numberTableType;
160 g_dim_derv_map_refresh EDW_OWB_COLLECTION_UTIL.booleanTableType;
161 g_dim_derv_map_full_refresh EDW_OWB_COLLECTION_UTIL.booleanTableType; --does it need full refresh
162 g_number_dim_derv_map_id number;
163 g_before_update_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
164 g_before_update_table_final varchar2(80);--passed to children
165 g_number_before_update_table number;
166 g_before_update_table_name varchar2(200);
167 g_before_update_load_pk number;
168 g_derv_snp_change_flag boolean;--is there snspshot log change for the cols of interest
169 g_count_dim_name_hold number;
170 -------------protection tables------------
171 g_insert_prot_table varchar2(200);
172 g_insert_prot_table_active varchar2(200);
173 g_bu_insert_prot_table varchar2(200);
174 g_bu_insert_prot_table_active varchar2(200);
175 -------------------------------------------
176 g_error_rec_flag boolean;
177 g_ilog_prev varchar2(400);
178 g_type_ilog_generation varchar2(400);
179 g_skip_ilog_update boolean;
180 g_ilog_small varchar2(400);
181 g_ll_snplog_has_pk boolean;--does the lowest level snapshot log have the pk_key column in it
182 g_consider_level EDW_OWB_COLLECTION_UTIL.booleanTableType;
183 g_consider_col EDW_OWB_COLLECTION_UTIL.booleanTableType;--which cols in the dimension to consider.if there is
184 --no change to the levels, then why consider those cols
185 g_insert_stmt_nopk_ins  varchar2(32000);--insert for all cols except the pk and user pk
186 g_select_stmt_ins varchar2(32000);
187 g_select_stmt_nopk_ins varchar2(32000);--select from all ltc but no pk and user pk
188 g_from_stmt_ins  varchar2(32000);
189 g_from_stmt_global_ins  varchar2(32000);
190 g_where_stmt_ins  varchar2(32000);
191 g_called_ltc_ilog_create boolean;
192 g_use_ltc_ilog EDW_OWB_COLLECTION_UTIL.booleanTableType;
193 g_src_fk_table EDW_OWB_COLLECTION_UTIL.varcharTableType;
194 g_src_fk  EDW_OWB_COLLECTION_UTIL.varcharTableType;
195 g_number_src_fk_table number;
196 g_ltc_merge_use_nl boolean;
197 g_hold_insert_stmt_row varchar2(32000);
198 g_from_stmt_hd_row varchar2(8000);
199 g_levels_copy_low_hd_ins varchar2(400);--used if g_ltc_merge_use_nl is set to true
200 g_insert_stmt_star_row varchar2(32000);
201 g_from_stmt_ins_row  varchar2(8000);
202 g_dim_inc_refresh_derv boolean;
203 g_check_fk_change boolean;
204 g_objects_to_drop EDW_OWB_COLLECTION_UTIL.varcharTableType;
205 g_number_objects_to_drop number;
206 g_ok_switch_update number; --when to swith to update for ok table
207 g_join_nl_percentage number;--below this %, create index to help NL
208 G_MIN_JOB_LOAD_SIZE number;
209 G_SLEEP_TIME number;
210 G_HASH_AREA_SIZE number;
211 G_SORT_AREA_SIZE number;
212 G_TRACE boolean;
213 g_level_count EDW_OWB_COLLECTION_UTIL.numberTableType;--number of rows in the level tables
214 g_analyze_freq number;
215 g_parallel_drill_down boolean;
216 g_dd_status_table varchar2(100);
217 procedure collect_dimension(
218     p_conc_id number,
219 	p_conc_name varchar2,
220 	p_dim_name varchar2,
221 	p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
222 	p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
223 	p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
224 	p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
225 	p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
226     p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,
227 	p_number_levels number,
228 	p_debug boolean,
229     p_exec_flag boolean,
230     p_bis_owner varchar2,
231     p_parallel number,
232     p_collection_size number,
233     p_table_owner varchar2,
234     p_forall_size number,
235     p_update_type varchar2,
236     p_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
237     p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
238     p_number_skip_cols number,
239     p_load_pk number,
240     p_fresh_restart boolean,
241     p_op_table_space varchar2,
242     p_rollback varchar2,
243     p_ltc_merge_use_nl boolean,
244     p_dim_inc_refresh_derv boolean,
245     p_check_fk_change boolean,
246     p_ok_switch_update number,
247     p_join_nl_percentage number,
248     p_read_cfig_options boolean,
249     p_max_fk_density number,
250     p_analyze_frequency number
251     ) ;
252 procedure init_all(p_job_id number);
253 procedure get_dim_map_ids ;
254 Procedure get_lvl_relations ;
255 Procedure make_temp_insert_sql;
256 function check_error return boolean ;
257 Function get_status_message return varchar2 ;
258 Procedure execute_temp_insert_sql;
259 PROCEDURE identify_slow_cols;
260 PROCEDURE make_insert_update_stmt_star;
261 
262 PROCEDURE execute_insert_update_star(p_count number);
263 
264 PROCEDURE truncate_ltc_snapshot_logs;
265 PROCEDURE insert_into_star ;
266 function initial_insert_into_star(p_multi_thread boolean) return boolean;
267 PROCEDURE check_dim_star_empty;
268 function get_number_rows_inserted return number;
269 function get_number_rows_updated return number;
270 function get_number_rows_processed return number;
271 function check_snapshot_logs return boolean;
272 function get_time return varchar2 ;
273 procedure write_to_log_file(p_message varchar2) ;
274 procedure write_to_log_file_n(p_message varchar2) ;
275 procedure count_temp_table_records ;
276 procedure make_select_from_where_stmt ;
277 procedure collect_dimension;
278 procedure collect_dim_via_temp ;
279 function set_gilog_status return number;
280 function delete_gilog_status return boolean ;
281 procedure insert_into_ilog(p_multi_thread boolean) ;
282 function create_temp_table return boolean ;
283 procedure clean_up ;
284 function recover_from_previous_error return boolean ;
285 procedure analyze_snplogs ;
286 procedure make_level_alias ;
287 function get_level_alias(p_level varchar2) return varchar2 ;
288 /*
289 check_temp_table_for_update and check_temp_table_for_insert are to boost performance
290 */
291 function check_temp_table_for_status(p_status varchar2) return boolean ;
292 procedure execute_hold_insert_stmt;
293 procedure make_hold_insert_stmt;
294 function create_ilog_table return boolean ;
295 function get_snapshot_log return boolean ;
296 function create_temp_table_int return boolean ;
297 function create_index_temp_int return boolean ;
298 function drop_index_temp_int return boolean ;
299 function create_kl_table return boolean ;
300 procedure make_temp_int_to_tm_stmt ;
301 function create_index_temp return boolean ;
302 function drop_index_temp return boolean ;
303 procedure execute_temp_int_to_tm_stmt ;
304 function create_gilog_T(p_snp_log varchar2,p_ilog_temp varchar2) return boolean;
305 function execute_update_stmt return number;
306 function create_ltc_ilog_table(p_mode varchar2) return boolean ;
307 function drill_down_net_change(p_multi_thread boolean) return boolean ;
308 function create_snp_L_tables return boolean ;
309 function insert_into_LT(p_child_level varchar2, p_parent_level varchar2,p_mode varchar2) return boolean ;
310 function find_rowid_parent_change(p_level varchar2) return boolean ;
311 function insert_into_ilog_from_L(p_multi_thread boolean) return boolean ;
312 function create_ltc_copies(p_mode varchar2) return boolean ;
313 function find_rowid_child_change(p_level varchar2,p_mode varchar2) return boolean ;
314 function drill_up_net_change(p_mode varchar2) return boolean ;
315 function recreate_from_stmt return boolean ;
316 function drop_L_tables return boolean ;
317 function drop_I_tables return boolean ;
318 function drop_ltc_copies return boolean ;
319 function create_L_from_ilog return boolean ;
320 function name_op_tables(p_job_id number) return boolean;
321 function create_g_dim_name_with_slow return boolean;
322 function create_hold_index return boolean ;
323 function create_dim_name_rowid_hold return boolean ;
324 function reset_profiles return boolean;
325 procedure insert_into_load_progress(p_load_fk number,p_object_name varchar2,p_load_progress varchar2,
326   p_start_date date,p_end_date date,p_category varchar2, p_operation varchar2,p_seq_id varchar2,p_flag varchar2);
327 procedure insert_into_load_progress_d(p_load_fk number,p_object_name varchar2,p_load_progress varchar2,
328   p_start_date date,p_end_date date,p_category varchar2, p_operation varchar2,p_seq_id varchar2,p_flag varchar2);
329 procedure analyze_star_table ;
330 function get_dim_storage return boolean ;
331 function is_dim_in_derv_map return boolean ;
332 function get_derv_fact_map_details(p_mapping_id number) return boolean;
333 function log_before_update_data return boolean ;
334 function create_before_update_table return boolean ;
335 function get_ltc_for_dim_col(p_col varchar2) return varchar2 ;
336 function get_max_fk_density(p_dim_id number,p_src_fact_id number,p_dim_derv_map_id number) return number;
337 function create_prot_table(p_table varchar2,p_table_active varchar2) return boolean ;
338 function drop_prot_table(p_table varchar2,p_table_active varchar2) return boolean ;
339 function drop_restart_tables return boolean;
340 function create_gilog_small return boolean;
341 function create_dummy_ilog return boolean;
342 function check_ll_snplog_col return number;
343 procedure make_select_from_where_ins ;
344 function set_level_I_flag return boolean ;
345 function create_ltc_copy_low_hd_ins(p_mode varchar2) return boolean;
346 function create_hold_table return boolean ;
347 function execute_insert_stmt return boolean ;
348 function reset_temp_opcode return boolean;
349 function find_all_affected_levels(
350 p_job_id number,
351 p_affected_levels out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType,
352 p_number_affected_levels out NOCOPY number) return boolean ;
353 function get_parent(p_child_level varchar2,p_parent_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType,
354 p_child_ltc EDW_OWB_COLLECTION_UTIL.varcharTableType, p_number_hier number,
355 p_parent out NOCOPY EDW_OWB_COLLECTION_UTIL.varcharTableType, p_number_parent out NOCOPY number) return boolean ;
356 function set_g_type_ilog_generation return boolean;
357 function log_pk_into_insert_prot return boolean ;
358 function log_pk_into_bu_insert_prot return boolean ;
359 function get_before_update_table_name return boolean;
360 function read_options_table(p_table_name varchar2) return boolean;
361 procedure clean_up_job;
362 function make_ok_from_main_ok(
363 p_main_ok_table_name varchar2,
364 p_low_end number,
365 p_high_end number
366 ) return boolean;
367 procedure collect_dimension_main(
368     p_conc_id number,
369     p_conc_name varchar2,
370     p_dim_name varchar2,
371     p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
372     p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
373     p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
374     p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
375     p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
376     p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,
377     p_number_levels number,
378     p_debug boolean,
379     p_exec_flag boolean,
380     p_bis_owner varchar2,
381     p_parallel number,
382     p_collection_size number,
383     p_table_owner varchar2,
384     p_forall_size number,
385     p_update_type varchar2,
386     p_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
387     p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
388     p_number_skip_cols number,
389     p_load_pk number,
390     p_fresh_restart boolean,
391     p_op_table_space varchar2,
392     p_rollback varchar2,
393     p_ltc_merge_use_nl boolean,
394     p_dim_inc_refresh_derv boolean,
395     p_check_fk_change boolean,
396     p_ok_switch_update number,
397     p_join_nl_percentage number,
398     p_thread_type varchar2,
399     p_max_threads number,
400     p_min_job_load_size number,
401     p_sleep_time number,
402     p_job_status_table varchar2,
403     p_hash_area_size number,
404     p_sort_area_size number,
405     p_trace boolean,
406     p_read_cfig_options boolean,
407     p_max_fk_density number,
408     p_analyze_frequency number,
409     p_parallel_drill_down boolean,
410     p_dd_status_table varchar2
411     ) ;
412 procedure collect_dimension_multi_thread(
413     p_conc_id number,
414     p_conc_name varchar2,
415     p_dim_name varchar2,
416     p_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
417     p_child_level_number EDW_OWB_COLLECTION_UTIL.numberTableType,
418     p_child_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
419     p_child_fk EDW_OWB_COLLECTION_UTIL.varcharTableType,
420     p_parent_pk EDW_OWB_COLLECTION_UTIL.varcharTableType,
421     p_level_snapshot_logs EDW_OWB_COLLECTION_UTIL.varcharTableType,
422     p_number_levels number,
423     p_debug boolean,
424     p_exec_flag boolean,
425     p_bis_owner varchar2,
426     p_parallel number,
427     p_collection_size number,
428     p_table_owner varchar2,
429     p_forall_size number,
430     p_update_type varchar2,
431     p_level_order EDW_OWB_COLLECTION_UTIL.varcharTableType,
432     p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
433     p_number_skip_cols number,
434     p_load_pk number,
435     p_fresh_restart boolean,
436     p_op_table_space varchar2,
437     p_rollback varchar2,
438     p_ltc_merge_use_nl boolean,
439     p_dim_inc_refresh_derv boolean,
440     p_check_fk_change boolean,
441     p_ok_switch_update number,
442     p_join_nl_percentage number,
443     p_thread_type varchar2,
444     p_max_threads number,
445     p_min_job_load_size number,
446     p_sleep_time number,
447     p_job_status_table varchar2,
448     p_hash_area_size number,
449     p_sort_area_size number,
450     p_trace boolean,
451     p_read_cfig_options boolean,
452     p_max_fk_density number,
453     p_analyze_frequency number,
454     p_parallel_drill_down boolean,
455     p_dd_status_table varchar2
456     ) ;
457 function initial_set_up(
458 p_table_name varchar2,
459 p_max_threads number,
460 p_debug boolean,
461 p_ok_table out nocopy varchar2) return boolean;
462 procedure COLLECT_DIMENSION(
463 errbuf out nocopy varchar2,
464 retcode out nocopy varchar2,
465 p_dim_name varchar2,
466 p_table_name varchar2,--input table
467 p_job_id number,
468 p_ok_low_end number,
469 p_ok_high_end number
470 );
471 procedure COLLECT_DIMENSION(
472 p_dim_name varchar2,
473 p_table_name varchar2,--input table
474 p_job_id number,
475 p_ok_low_end number,
476 p_ok_high_end number
477 );
478 function COLLECT_DIMENSION(
479 p_table_name varchar2,--input table
480 p_ok_low_end number,
481 p_ok_high_end number
482 ) return boolean;
483 function drop_input_tables(p_table_name varchar2) return boolean;
484 function set_session_parameters return boolean ;
485 function put_rownum_in_ok_table return boolean;
486 function create_conc_program(
487 p_temp_conc_name varchar2,
488 p_temp_conc_short_name varchar2,
489 p_temp_exe_name varchar2,
490 p_bis_short_name varchar2
491 ) return boolean;
492 function insert_L_ilog_parallel_dd(p_multi_thread boolean) return boolean;
493 END EDW_SUMMARY_COLLECT;