[Home] [Help]
PACKAGE: APPS.EDW_OWB_COLLECTION_UTIL
Source
1 package EDW_OWB_COLLECTION_UTIL AS
2 /*$Header: EDWCOLUS.pls 120.0 2005/06/01 18:03:59 appldev noship $*/
3
4 Type varcharTableType is Table of varchar2(400) index by binary_integer;
5 Type L_varcharTableType is Table of varchar2(4000) index by binary_integer;
6 Type LL_varcharTableType is Table of varchar2(10000) index by binary_integer;
7 Type LLL_varcharTableType is Table of varchar2(20000) index by binary_integer;
8 Type numberTableType is Table of number index by binary_integer;
9 Type dateTableType is Table of date index by binary_integer;
10 Type booleanTableType is Table of boolean index by binary_integer;
11 Type rowidTableType is Table of rowid index by binary_integer;
12
13 g_conc_log_index number;
14 g_conc_id_log numberTableType;
15 g_conc_program_name_log varcharTableType;
16 g_object_type_log varcharTableType;
17 g_log_date_log dateTableType;
18 g_status_log varcharTableType;
19 g_message_log L_varcharTableType;
20 g_file utl_file.file_type;
21 g_file_flag boolean;
22 g_debug boolean;
23 g_parallel number;
24 g_conc_program_id number;
25 g_status_message varchar2(8000);
26 g_status boolean;
27 g_read_cfig_options boolean;
28 g_sqlcode number;
29 g_fnd_log_module varchar2(200);
30 ------------------------------
31 g_oracle_apps_version varchar2(200);
32 g_version_GT_1159 boolean;--is version greater than 11.5.9
33 g_db_version varchar2(40);
34 ------------------------------
35 /*
36 variables for use
37 */
38 g_lowest_level varchar2(400);
39 g_lowest_level_id number;
40 g_metedata_version varchar2(80);
41 g_stmt varchar2(30000);
42 g_session_id number;
43
44 PROCEDURE set_up(p_dimension_name in varchar2) ;
45
46 procedure Get_Level_Relations(
47 p_levels out NOCOPY varcharTableType,
48 p_level_status out NOCOPY varcharTableType,
49 p_child_level_number out NOCOPY numberTableType,
50 p_child_levels out NOCOPY varcharTableType,
51 p_child_fk out NOCOPY varcharTableType,
52 p_parent_pk out NOCOPY varcharTableType,
53 p_number_levels out NOCOPY integer) ;
54
55 procedure get_lowest_level(
56 p_level out NOCOPY varchar2,
57 p_level_id out NOCOPY number);
58
59 PROCEDURE Get_lvl_dim_mapping(
60 p_dim_col out NOCOPY varcharTableType,
61 p_level_name out NOCOPY varcharTableType,
62 p_level_col out NOCOPY varcharTableType,
63 p_number_mapping out NOCOPY integer,
64 p_flag in integer) ;
65
66 PROCEDURE Get_mapping_ids(p_level_map_id out NOCOPY numberTableType,
67 p_level_primary_src out NOCOPY numberTableType,
68 p_level_primary_target out NOCOPY numberTableType);
69
70 PROCEDURE Get_Fact_Ids(
71 p_fact_name in varchar2,
72 p_fact_map_id out NOCOPY number,
73 p_fact_src out NOCOPY number,
74 p_fact_target out NOCOPY number) ;
75 function get_log_for_table(p_table varchar2, p_log varchar2) return varchar2;
76 function get_columns_for_table(
77 p_table varchar2,
78 p_columns out NOCOPY varcharTableType,
79 p_number_columns out NOCOPY number) return boolean ;
80 function get_db_columns_for_table(
81 p_table varchar2,
82 p_columns out NOCOPY varcharTableType,
83 p_number_columns out NOCOPY number,
84 p_owner varchar2) return boolean;
85 function get_db_columns_for_table(
86 p_table varchar2,
87 p_columns out NOCOPY varcharTableType,
88 p_data_type out NOCOPY varcharTableType,
89 p_number_columns out NOCOPY number,
90 p_owner varchar2) return boolean ;
91 function get_db_columns_for_table(
92 p_table varchar2,
93 p_columns out NOCOPY varcharTableType,
94 p_data_type out NOCOPY varcharTableType,
95 p_data_length out NOCOPY varcharTableType,
96 p_num_distinct out NOCOPY numberTableType,
97 p_num_nulls out NOCOPY numberTableType,
98 p_avg_col_length out NOCOPY numberTableType,
99 p_number_columns out NOCOPY number,
100 p_owner varchar2) return boolean;
101 function get_table_snapshot_log(p_table varchar2) return varchar2;
102 function delete_table(p_table varchar2) return boolean ;
103 function truncate_table(p_table varchar2) return boolean ;
104 function truncate_table(p_table varchar2,p_owner varchar2) return boolean ;
105 function get_fks_for_table(
106 p_table varchar2,
107 p_fks out NOCOPY varcharTableType,
108 p_number_fks out NOCOPY number) return boolean ;
109 function get_fks_for_table(
110 p_table varchar2,
111 p_parent_table out NOCOPY varcharTableType,
112 p_fks out NOCOPY varcharTableType,
113 p_number_fks out NOCOPY number) return boolean;
114 function value_in_table(
115 p_table varcharTableType,
116 l_number_table number,
117 p_value varchar2) return boolean;
118 function value_in_table(
119 p_table numberTableType,
120 l_number_table number,
121 p_value number) return boolean ;
122 function value_in_table(
123 p_table1 varcharTableType,
124 p_table2 varcharTableType,
125 l_number_table number,
126 p_value1 varchar2,
127 p_value2 varchar2) return boolean ;
128 procedure setup_conc_program_log ;
129 procedure setup_conc_program_log(p_object_name varchar2) ;
130 procedure set_conc_program_id(p_conc_program_id number) ;
131 procedure commit_conc_program_log ;
132 PROCEDURE Write_to_conc_prog_log(
133 p_conc_id number,
134 p_conc_name varchar2,
135 p_object_type varchar2,
136 p_conc_status varchar2,
137 p_conc_message varchar2);
138 procedure write_to_log_file(p_message varchar2);
139 procedure write_to_log_file(p_message varchar2,p_severity number);
140 procedure write_to_log_file_n(p_message varchar2) ;
141 procedure write_to_log_file_n(p_message varchar2,p_severity number);
142 procedure write_to_out_file(p_message varchar2);
143 procedure print_stmt(l_stmt in varchar2);
144
145 FUNCTION get_wh_language return VARCHAR2 ;
146 FUNCTION get_wh_lookup_value(p_lookup_type IN VARCHAR2,
147 p_lookup_code in varchar2) return VARCHAR2 ;
148
149 /************************************************************
150 for VBH
151 ************************************************************/
152 function get_vbh_mapping(
153 p_src_name varchar2,
154 p_tgt_name varchar2,
155 p_map varchar2,
156 p_src_table out NOCOPY varcharTableType,
157 p_src_col out NOCOPY varcharTableType,
158 p_tgt_table out NOCOPY varcharTableType,
159 p_tgt_col out NOCOPY varcharTableType,
160 p_number_maps out NOCOPY number,
161 p_debug boolean) return boolean;
162
163 /**************************************************************/
164
165 procedure set_debug(p_debug boolean);
166 function get_time return varchar2;
167 function is_slowly_changing_dimension(p_dim_name varchar2) return varchar2;
168 function write_to_collection_log(
169 p_object varchar2,
170 p_object_id number,
171 p_object_type varchar2,
172 p_conc_program_id number,
173 p_start_date date,
174 p_end_date date,
175 p_rows_ready number,
176 p_rows_processed number,
177 p_rows_collected number,/*not same as p_rows_processed when duplicate collect is yes*/
178 p_number_insert number,
179 p_number_update number,
180 p_number_delete number,
181 p_collection_message varchar2,
182 p_status varchar2,
183 p_load_pk number) return boolean;
184
185 function write_to_general_log
186 (OBJECT_NAME VARCHAR2,
187 OBJECT_TYPE VARCHAR2,
188 LOG_TYPE VARCHAR2,
189 CONCURRENT_ID NUMBER,
190 START_DATE DATE,
191 END_DATE DATE,
192 MESSAGE VARCHAR2,
193 STATUS VARCHAR2) return boolean;
194 function write_to_error_log
195 (OBJECT_NAME VARCHAR2,
196 OBJECT_TYPE VARCHAR2,
197 ERROR_TYPE VARCHAR2,
198 CONCURRENT_ID NUMBER,
199 START_DATE DATE,
200 END_DATE DATE,
201 MESSAGE VARCHAR2,
202 STATUS VARCHAR2,
203 RESP_ID NUMBER) return boolean;
204
205 function insert_temp_log_table(
206 p_object_name varchar2,
207 p_object_type varchar2,
208 p_concurrent_req_id number,
209 p_ins_instance_name varcharTableType,
210 p_ins_request_id_table numberTableType,
211 p_ins_rows_ready numberTableType,
212 p_ins_rows_processed numberTableType,
213 p_ins_rows_collected numberTableType,
214 p_ins_rows_dangling numberTableType,
215 p_ins_rows_duplicate numberTableType,
216 p_ins_rows_error numberTableType,
217 p_number_ready number,
218 p_number_insert number,
219 p_number_update number,
220 p_number_delete number,
221 p_number_ins_req_coll number) return boolean;
222 function check_table(p_table varchar2) return boolean ;
223 function check_table(p_table varchar2, p_owner varchar2) return boolean ;
224 function check_iv_trigger(p_iv varchar2) return boolean;
225 function get_all_derived_facts(
226 p_object varchar2,
227 p_derived_facts out NOCOPY varcharTableType,
228 p_derived_fact_ids out NOCOPY numberTableType,
229 p_map_id out NOCOPY numberTableType,
230 p_number_derived_facts out NOCOPY number) return boolean ;
231 function create_table(
232 p_table_name varchar2,
233 p_table_owner varchar2,
234 p_table_cols varcharTableType,
235 p_table_data_type varcharTableType,
236 p_number_table_cols number,
237 p_table_storage varchar2) return boolean ;
238 function drop_table(p_table_name varchar2) return boolean;
239 function drop_table(
240 p_table_name varchar2,
241 p_owner varchar2) return boolean ;
242 function get_db_user(p_product varchar2) return varchar2;
243 procedure analyze_table_stats(
244 p_table varchar2);
245 procedure analyze_table_stats(
246 p_table varchar2,
247 p_owner varchar2);
248 procedure analyze_table_stats(
249 p_table varchar2,
250 p_owner varchar2,
251 p_percentage number);
252 function get_table_owner(p_table varchar2) return varchar2 ;
253 function record_coll_progress(
254 p_object_name varchar2,
255 p_object_type varchar2,
256 p_number_rows_processed number,
257 p_status varchar2,
258 p_action varchar2) return boolean;
259 function is_another_coll_running(p_object_name varchar2, p_object_type varchar2) return number ;
260 procedure alter_session(p_param varchar2) ;
261 procedure alter_session(p_param varchar2,p_value varchar2);
262 function does_table_have_data(p_table varchar2) return number ;
263 function does_table_have_data(p_table varchar2, p_where varchar2) return number ;
264 function does_table_have_only_n_row(p_table varchar2,p_row_count number) return number ;
265 function does_table_have_only_n_row(p_table varchar2, p_where varchar2,p_row_count number) return number ;
266 function is_object_a_source(p_object_name varchar2) return boolean ;
267 function create_dim_key_lookup(p_dim_name varchar2, p_dim_user_pk varchar2, p_dim_pk varchar2,
268 p_lookup_table varchar2, p_parallel number,p_mode varchar2,
269 p_op_table_space varchar2) return boolean;
270 function get_dims_slow_change(p_dim_names varcharTableType,p_number_dims number,
271 p_dim_list out NOCOPY varcharTableType ,p_number_dim_list out NOCOPY number)
272 return boolean;
273 function get_dims_slow_change(p_dim_names varcharTableType,p_number_dims number,
274 p_dim_list out NOCOPY varcharTableType ,p_number_dim_list out NOCOPY number,
275 p_is_name varchar2)
276 return boolean;
277 function is_slow_change_implemented(p_dim_name varchar2) return boolean ;
278 function is_slow_change_implemented(p_dim_name varchar2,p_is_name varchar2) return boolean ;
279 function execute_stmt(p_stmt varchar2) return boolean ;
280 function get_table_surr_pk(p_table varchar2, p_pk out NOCOPY varchar2) return boolean;
281 function get_user_key(p_key varchar2) return varchar2 ;
282 function is_push_down_implemented(p_dim varchar2) return boolean ;
283 function is_inc_refresh_implemented(p_fact varchar2) return boolean;
284 procedure set_parallel(p_parallel number) ;
285 function is_delete_trigger_imp(p_object varchar2, p_owner varchar2) return boolean ;
286 function insert_into_coll_progress(
287 OBJECT_NAME VARCHAR2
288 , OBJECT_TYPE VARCHAR2
289 , STATUS VARCHAR2
290 , NUMBER_PROCESSED NUMBER) return boolean;
291 function get_sec_source_info(
292 p_map_id number,
293 p_sec_source out NOCOPY varcharTableType,
294 p_sec_source_id out NOCOPY numberTableType,
295 p_sec_source_child out NOCOPY varcharTableType,
296 p_sec_source_child_id out NOCOPY numberTableType,
297 p_pk out NOCOPY varcharTableType,
298 p_fk out NOCOPY varcharTableType,
299 p_sec_source_usage out NOCOPY numberTableType,
300 p_sec_source_usage_name out NOCOPY varcharTableType,
301 p_sec_source_child_usage out NOCOPY numberTableType,
302 p_sec_source_number out NOCOPY number) return boolean;
303 function bubble_sort(p_input numberTableType,p_input_number number, p_output out NOCOPY numberTableType)
304 return boolean ;
305 function make_transforms_rec(
306 p_hold_func varcharTableType,
307 p_hold_func_category varcharTableType,
308 p_hold_item varcharTableType,
309 p_hold_item_id numberTableType,
310 p_hold_item_is_fk booleanTableType,
311 p_hold_relation numberTableType,
312 p_hold_relation_usage numberTableType,
313 p_hold_item_usage numberTableType,
314 p_hold_aggregatefunction varcharTableType,
315 p_hold_is_distinct numberTableType,
316 p_hold_relation_name varcharTableType,
317 p_hold_func_usage numberTableType,
318 p_hold_func_position numberTableType,
319 p_hold_func_dvalue varcharTableType,
320 p_sec_sources varcharTableType,
321 p_number_sec_sources number,
322 p_target_id number,
323 p_src_object varchar2,
324 p_hold_number number,
325 p_index number,
326 p_agg_flag out NOCOPY varchar2
327 ) return varchar2;
328 function is_source_for_inc_derived_fact(p_fact varchar2) return number ;
329 function index_in_table(
330 p_table varcharTableType,
331 l_number_table number,
335 p_table2 varcharTableType,
332 p_value varchar2) return number;
333 function index_in_table(
334 p_table1 varcharTableType,
336 l_number_table number,
337 p_value1 varchar2,
338 p_value2 varchar2) return number ;
339 procedure insert_into_load_progress(p_load_fk number,p_object_name varchar2,p_object_id number,
340 p_load_progress varchar2,p_start_date date,p_end_date date,p_category varchar2, p_operation varchar2,
341 p_seq_id varchar2,p_flag varchar2,p_obj_id number) ;
342 function get_item_set_cols(p_cols out NOCOPY varcharTableType, p_number_cols out NOCOPY number,
343 p_object varchar2,p_item_set varchar2) return boolean ;
344 function get_level_prefix(p_level varchar2) return varchar2 ;
345 function get_obj_obj_map_details(p_src_object varchar2,p_tgt_object varchar2,p_map_name varchar2,
346 p_src_cols out NOCOPY varcharTableType, p_tgt_cols out NOCOPY varcharTableType, p_number_cols out NOCOPY number) return boolean ;
347 function get_table_index_col(p_table varchar2,p_owner varchar2,
348 p_index out NOCOPY varcharTableType,p_ind_col out NOCOPY varcharTableType,p_ind_col_pos out NOCOPY numberTableType,
349 p_number_index out NOCOPY number) return boolean ;
350 function get_object_id(p_object varchar2) return number;
351 function last_analyzed_date(p_table varchar2) return date;
352 function last_analyzed_date(p_table varchar2,p_owner varchar2) return date;
353 function get_table_count(p_table varchar2) return number ;
354 function get_table_count(p_table varchar2,p_where varchar2) return number ;
355 function get_table_next_extent(p_table varchar2,p_owner varchar2,p_next_extent out NOCOPY number) return boolean ;
356 function get_user_pk(p_table varchar2) return varchar2 ;
357 function is_column_in_table(p_table varchar2,p_column varchar2) return boolean;
358 function is_column_in_table(p_table varchar2,p_column varchar2,p_owner varchar2) return boolean;
359 function get_table_space(p_owner varchar2) return varchar2;
360 function index_present(p_table varchar2,p_owner varchar2,p_key varchar2,
361 p_type varchar2) return boolean ;
362 function get_mapping_details(
363 p_mapping_id number
364 ,p_hold_func out NOCOPY varcharTableType
365 ,p_hold_func_category out NOCOPY varcharTableType
366 ,p_hold_item out NOCOPY varcharTableType
367 ,p_hold_item_id out NOCOPY numberTableType
368 ,p_hold_item_usage out NOCOPY numberTableType
369 ,p_hold_aggregatefunction out NOCOPY varcharTableType
370 ,p_hold_is_distinct out NOCOPY numberTableType
371 ,p_hold_relation out NOCOPY numberTableType
372 ,p_hold_relation_name out NOCOPY varcharTableType
373 ,p_hold_relation_usage out NOCOPY numberTableType
374 ,p_hold_relation_type out NOCOPY varcharTableType
375 ,p_hold_func_usage out NOCOPY numberTableType
376 ,p_hold_func_position out NOCOPY numberTableType
377 ,p_hold_func_dvalue out NOCOPY varcharTableType
378 ,p_hold_number out NOCOPY number
379 ,p_metedata_version varchar2
380 ) return boolean ;
381 function get_mapid_dim_in_derv_map(
382 p_dim varchar2,
383 p_mapid out NOCOPY numberTableType,
384 p_derv_fact_id out NOCOPY numberTableType,
385 p_src_fact_id out NOCOPY numberTableType,
386 p_number_mapid out NOCOPY number,
387 p_type varchar2) return boolean;
388 function get_dim_fk_summary_fact(
389 p_fact_id number,
390 p_dim_id number,
391 p_dim_fk out NOCOPY varcharTableType,
392 p_number_dim_fk out NOCOPY number
393 ) return boolean ;
394 function get_object_name(p_object_id number) return varchar2 ;
395 function inc_g_load_pk return number ;
396 function get_column_stats(
397 p_owner varchar2,
398 p_object varchar2,
399 p_fk varchar2,
400 p_distcnt out NOCOPY number,
401 p_density out NOCOPY number,
402 p_nullcnt out NOCOPY number,
403 p_srec out NOCOPY DBMS_STATS.StatRec,
404 p_avgclen out NOCOPY number
405 ) return boolean;
406 function get_table_stats(
407 p_owner varchar2,
408 p_object varchar2,
409 p_numrows out NOCOPY number,
410 p_numblks out NOCOPY number,
411 p_avgrlen out NOCOPY number
412 ) return boolean;
413 function get_fk_pk(p_child number,p_parent number,p_map_id number,
414 p_fk out NOCOPY varcharTableType,p_pk out NOCOPY varcharTableType,
415 p_number_fk out NOCOPY number) return boolean;
416 function create_prot_table(p_table varchar2,p_op_table_space varchar2) return boolean ;
417 function drop_prot_table(p_table varchar2) return boolean;
418 function get_all_maps_for_tgt(p_object_id number,p_maps out NOCOPY numberTableType,p_number_maps out NOCOPY number)
419 return boolean ;
420 function get_table_avg_row_len(p_table varchar2,p_owner varchar2,p_avg_row_len out NOCOPY number)
421 return boolean;
422 function get_table_storage(p_table varchar2,p_owner varchar2,p_table_space out NOCOPY varchar2,
423 p_initial_extent out NOCOPY number,p_next_extent out NOCOPY number,p_pct_free out NOCOPY number,p_pct_used out NOCOPY number,
424 p_pct_increase out NOCOPY number, p_max_extents out NOCOPY number,p_avg_row_len out NOCOPY number) return boolean;
425 function create_table(p_table varchar2,p_stmt varchar2,p_count out NOCOPY number) return boolean ;
426 function is_itemset_implemented(p_object_name varchar2,
427 p_item_set varchar2)
428 return varchar2;
429 function is_itemset_implemented(p_object_name varchar2,
430 p_item_set varchar2,
431 p_object_id number)
432 return varchar2;
433 function get_DA_table(p_object varchar2) return varchar2;
434 function get_DA_table(p_object varchar2,p_owner varchar2) return varchar2;
438 function log_into_cdi_results_table(
435 function get_PP_table(p_object varchar2) return varchar2;
436 function get_PP_table(p_object varchar2,p_owner varchar2) return varchar2;
437 function get_master_instance(p_object_name varchar2) return varchar2 ;
439 p_object varchar2
440 ,p_object_type varchar2
441 ,p_object_id number
442 ,p_interface_table varchar2
443 ,p_interface_table_id number
444 ,p_interface_table_pk varchar2
445 ,p_interface_table_pk_id number
446 ,p_interface_table_fk varchar2
447 ,p_interface_table_fk_id number
448 ,p_parent_table varchar2
449 ,p_parent_table_id number
450 ,p_parent_table_pk varchar2
451 ,p_parent_table_pk_id number
452 ,p_number_dangling number
453 ,p_number_duplicate number
454 ,p_number_error number
455 ,p_total_records number
456 ,p_error_type varchar2) return boolean ;
457 function log_into_cdi_dang_table(p_key_id number,p_table_id number,p_parent_table_id number,
458 p_key_value varchar2,p_number_key_value number,p_instance varchar2,p_bad_key varchar2) return boolean;
459 function get_column_id(p_column varchar2,p_table varchar2) return number ;
460 function get_instance_col(p_table varchar2) return varchar2;
461 function create_synonym(p_synonym varchar2,p_table varchar2) return boolean ;
462 procedure create_bad_key_table(p_table varchar2,p_op_table_space varchar2,p_wh_parallel number);
463 function is_src_of_custom_inc_derv_fact(p_fact varchar2) return number;
464 function get_pk_view(p_dim varchar2,p_db_link varchar2) return varchar2 ;
465 function get_logical_name(p_obj_id number) return varchar2 ;
466 function parse_names(p_list varchar2,p_names out NOCOPY varcharTableType,p_number_names out NOCOPY number)
467 return boolean ;
468 function parse_names(
469 p_list varchar2,
470 p_separator varchar2,
471 p_names out NOCOPY varcharTableType,
472 p_number_names out NOCOPY number)
473 return boolean;
474 function get_status_message return varchar2;
475 procedure set_rollback(p_rollback varchar2) ;
476 function get_ltc_fact_unique_key(p_object_id number,p_object_name varchar2,
477 p_unique_key out NOCOPY varchar2,p_pk_key out NOCOPY varchar2) return boolean ;
478 function get_col_col_in_map(
479 p_map_id number,
480 p_object varchar2,
481 p_src_tables out NOCOPY varcharTableType,
482 p_src_cols out NOCOPY varcharTableType,
483 p_tgt_tables out NOCOPY varcharTableType,
484 p_tgt_cols out NOCOPY varcharTableType,
485 p_number_cols out NOCOPY number) return boolean ;
486 function get_fks_in_map(p_tgt varchar2,p_src out NOCOPY varcharTableType,
487 p_fk out NOCOPY varcharTableType,p_number_src out NOCOPY number) return boolean ;
488 function get_fks_in_dim(p_tgt varchar2,p_src out NOCOPY varcharTableType,
489 p_fk out NOCOPY varcharTableType,p_number_src out NOCOPY number) return boolean ;
490 function get_app_version(p_instance varchar2) return varchar2 ;
491 function get_app_version(p_instance varchar2,p_db_link varchar2) return varchar2 ;
492 function check_table_column(p_table varchar2,p_col varchar2) return boolean ;
493 function add_column_to_table(p_table varchar2,p_owner varchar2,p_col varchar2,
494 p_datatype varchar2) return boolean ;
495 function get_dim_id(p_object varchar2) return number ;
496 procedure set_g_read_cfig_options(p_read_cfig_options boolean) ;
497 function check_pk_pkkey_index(p_table varchar2,p_owner varchar2,p_pk varchar2,p_pk_key varchar2) return boolean ;
498 function check_load_status(p_object varchar2) return boolean ;
499 function get_message(p_message varchar2) return varchar2 ;
500 function get_message(p_message varchar2,p_product varchar2) return varchar2 ;
501 function get_object_type(p_object_name varchar2) return varchar2 ;
502 function get_ltc_lstg(p_object_name varchar2,p_lstg out NOCOPY varcharTableType,
503 p_ltc out NOCOPY varcharTableType,p_number_ltc out NOCOPY number) return boolean ;
504 function is_auto_dang_implemented(p_dim_name varchar2) return boolean;
505 function create_auto_dang_table(p_dim_auto_dang_table varchar2,
506 p_pk_cols varcharTableType,p_number_pk_cols number) return boolean;
507 function get_lowest_level_table(p_dim varchar2,p_lowest_level_table out NOCOPY varchar2,
508 p_lowest_level_table_id out NOCOPY number) return boolean;
509 function get_all_lowest_level_tables(
510 p_dim_in varchar2,
511 p_dim out NOCOPY varcharTableType,
512 p_level_table out NOCOPY varcharTableType,
513 p_level_table_id out NOCOPY numberTableType,
514 p_number_dim out NOCOPY number) return boolean ;
515 function get_lowest_level_table(p_dim varchar2) return varchar2 ;
516 function get_lowest_level_table(p_dim varchar2,p_dim_id number) return varchar2 ;
517 function get_db_link_for_instance(p_instance varchar2) return varchar2 ;
518 function test_db_link(p_db_link varchar2) return boolean;
519 function get_dim_pk_structure(p_parent_table_name varchar2,p_instance varchar2,
520 p_dim_pk_structure out NOCOPY varcharTableType,p_number_dim_pk_structure out NOCOPY number) return boolean;
521 function parse_pk_structure(p_dim_pk_structure varchar2,p_pk_cols out NOCOPY varcharTableType,
522 p_number_pk_cols out NOCOPY number) return boolean ;
523 function get_dim_pk(p_dim_name varchar2) return varchar2 ;
524 function get_dim_pk(p_dim_name varchar2,p_dim_id number) return varchar2 ;
525 procedure truncate_table(p_table varchar2) ;
526 function get_dim_lvl_pk_keys(p_dim_name varchar2,p_dim_id number,
527 p_pk_key out NOCOPY varcharTableType,
528 p_number_pk_key out NOCOPY number) return boolean ;
529 function get_dim_lvl_name_cols(p_dim_name varchar2,p_dim_id number,
530 p_name out NOCOPY varcharTableType,
531 p_number_name out NOCOPY number) return boolean ;
535 function get_object_unique_key(p_object varchar2,p_object_id number,
532 function get_table_seq(p_table varchar2,p_table_id number) return varchar2 ;
533 function get_lookup_code(p_lookup_type varchar2,p_lookup_code out NOCOPY varcharTableType,
534 p_number_lookup_code out NOCOPY number) return boolean ;
536 p_pk out NOCOPY varcharTableType,p_number_pk out NOCOPY number) return boolean ;
537 function get_table_count_stats(p_table varchar2,p_owner varchar2) return number ;
538 function get_src_tgt_map_details(
539 p_mapping_id number,
540 p_primary_target number,
541 p_primary_src number,
542 p_factPKNameKey varchar2,
543 p_dimTableName varcharTableType,
544 p_numberOfDimTables number,
545 p_fact_mapping_columns out NOCOPY varcharTableType,
546 p_fstg_mapping_columns out NOCOPY varcharTableType,
547 p_num_ff_map_cols out NOCOPY number,
548 p_groupby_cols out NOCOPY varcharTableType,
549 p_number_groupby_cols out NOCOPY number,
550 p_instance_column out NOCOPY varchar2,
551 p_groupby_on out NOCOPY boolean,
552 p_pk_key_seq_pos out NOCOPY number,
553 p_pk_key_seq out NOCOPY varchar2) return boolean ;
554 function get_src_tgt_map_details_owb(
555 p_mapping_id number,
556 p_primary_target number,
557 p_primary_src number,
558 p_factPKNameKey varchar2,
559 p_dimTableName varcharTableType,
560 p_numberOfDimTables number,
561 p_fact_mapping_columns out NOCOPY varcharTableType,
562 p_fstg_mapping_columns out NOCOPY varcharTableType,
563 p_num_ff_map_cols out NOCOPY number,
564 p_groupby_cols out NOCOPY varcharTableType,
565 p_number_groupby_cols out NOCOPY number,
566 p_instance_column out NOCOPY varchar2,
567 p_groupby_on out NOCOPY boolean,
568 p_pk_key_seq_pos out NOCOPY number,
569 p_pk_key_seq out NOCOPY varchar2,
570 p_metedata_version varchar2) return boolean ;
571 function get_src_tgt_map_details_edw(
572 p_mapping_id number,
573 p_primary_target number,
574 p_primary_src number,
575 p_factPKNameKey varchar2,
576 p_dimTableName varcharTableType,
577 p_numberOfDimTables number,
578 p_fact_mapping_columns out NOCOPY varcharTableType,
579 p_fstg_mapping_columns out NOCOPY varcharTableType,
580 p_num_ff_map_cols out NOCOPY number,
581 p_groupby_cols out NOCOPY varcharTableType,
582 p_number_groupby_cols out NOCOPY number,
583 p_instance_column out NOCOPY varchar2,
584 p_groupby_on out NOCOPY boolean,
585 p_pk_key_seq_pos out NOCOPY number,
586 p_pk_key_seq out NOCOPY varchar2) return boolean;
587 function find_metadata_version return varchar2;
588 function get_derv_mapping_details(
589 p_mapping_id number,
590 p_src_object_id number,
591 p_number_skip_cols number,
592 p_skip_cols varcharTableType,
593 p_fact_fks varcharTableType,
594 p_number_fact_fks number,
595 p_src_fks varcharTableType,
596 p_number_src_fks number,
597 p_fact_id number,
598 p_src_object varchar2,
599 p_temp_fact_name_temp in out NOCOPY varchar2,
600 p_number_sec_sources out NOCOPY number,
601 p_sec_sources out NOCOPY varcharTableType,
602 p_sec_sources_alias out NOCOPY varcharTableType,
603 p_number_sec_key out NOCOPY number,
604 p_sec_sources_pk out NOCOPY varcharTableType,
605 p_sec_sources_fk out NOCOPY varcharTableType,
606 p_groupby_stmt out NOCOPY varchar2,
607 p_hold_number out NOCOPY number,
608 p_number_group_by_cols out NOCOPY number,
609 p_hold_relation out NOCOPY varcharTableType,
610 p_hold_item out NOCOPY varcharTableType,
611 p_group_by_cols out NOCOPY varcharTableType,
612 p_output_group_by_cols out NOCOPY varcharTableType,
613 p_number_input_params out NOCOPY number,
614 p_output_params out NOCOPY varcharTableType,
615 p_input_params out NOCOPY varcharTableType,
616 p_filter_stmt out NOCOPY varchar2
617 ) return boolean;
618 function get_derv_mapping_details_owb(
619 p_mapping_id number,
620 p_src_object_id number,
621 p_number_skip_cols number,
622 p_skip_cols varcharTableType,
623 p_fact_fks varcharTableType,
624 p_number_fact_fks number,
625 p_src_fks varcharTableType,
626 p_number_src_fks number,
627 p_fact_id number,
628 p_src_object varchar2,
629 p_temp_fact_name_temp in out NOCOPY varchar2,
630 p_number_sec_sources out NOCOPY number,
631 p_sec_sources out NOCOPY varcharTableType,
632 p_sec_sources_alias out NOCOPY varcharTableType,
633 p_number_sec_key out NOCOPY number,
634 p_sec_sources_pk out NOCOPY varcharTableType,
635 p_sec_sources_fk out NOCOPY varcharTableType,
636 p_groupby_stmt out NOCOPY varchar2,
637 p_hold_number out NOCOPY number,
638 p_number_group_by_cols out NOCOPY number,
639 p_hold_relation out NOCOPY varcharTableType,
640 p_hold_item out NOCOPY varcharTableType,
641 p_group_by_cols out NOCOPY varcharTableType,
642 p_output_group_by_cols out NOCOPY varcharTableType,
643 p_number_input_params out NOCOPY number,
644 p_output_params out NOCOPY varcharTableType,
645 p_input_params out NOCOPY varcharTableType,
646 p_filter_stmt out NOCOPY varchar2,
647 p_metedata_version varchar2
648 ) return boolean ;
649 function get_derv_mapping_details_edw(
650 p_mapping_id number,
651 p_src_object_id number,
652 p_number_skip_cols number,
653 p_skip_cols varcharTableType,
654 p_fact_fks varcharTableType,
655 p_number_fact_fks number,
656 p_src_fks varcharTableType,
657 p_number_src_fks number,
658 p_fact_id number,
659 p_src_object varchar2,
660 p_temp_fact_name_temp in out NOCOPY varchar2,
661 p_number_sec_sources out NOCOPY number,
662 p_sec_sources out NOCOPY varcharTableType,
663 p_sec_sources_alias out NOCOPY varcharTableType,
667 p_groupby_stmt out NOCOPY varchar2,
664 p_number_sec_key out NOCOPY number,
665 p_sec_sources_pk out NOCOPY varcharTableType,
666 p_sec_sources_fk out NOCOPY varcharTableType,
668 p_hold_number out NOCOPY number,
669 p_number_group_by_cols out NOCOPY number,
670 p_hold_relation out NOCOPY varcharTableType,
671 p_hold_item out NOCOPY varcharTableType,
672 p_group_by_cols out NOCOPY varcharTableType,
673 p_output_group_by_cols out NOCOPY varcharTableType,
674 p_number_input_params out NOCOPY number,
675 p_output_params out NOCOPY varcharTableType,
676 p_input_params out NOCOPY varcharTableType,
677 p_filter_stmt out NOCOPY varchar2
678 ) return boolean ;
679 function is_src_fk(p_fk varchar2,p_src_fks varcharTableType,p_number_src_fks number) return boolean ;
680 function get_metadata_version return varchar2;
681 function get_dim_hier_levels(p_dim_name varchar2,
682 p_hier out NOCOPY varcharTableType,
683 p_parent_ltc out NOCOPY varcharTableType,
684 p_parent_ltc_id out NOCOPY numberTableType,
685 p_child_ltc out NOCOPY varcharTableType,
686 p_child_ltc_id out NOCOPY numberTableType,
687 p_number_hier out NOCOPY number) return boolean ;
688 function get_target_map(p_object_id number,p_object_name varchar2) return number ;
689 function get_last_analyzed_date(p_table varchar2) return date ;
690 function get_last_analyzed_date(p_table varchar2, p_owner varchar2) return date ;
691 function create_load_input_table(
692 p_table_name varchar2,
693 p_object_name in varchar2,
694 p_mapping_id in number,
695 p_map_type in varchar2,
696 p_primary_src in number,
697 p_primary_target in number,
698 p_primary_target_name varchar2,
699 p_object_type varchar2,
700 p_conc_id in number,
701 p_conc_program_name in varchar2,
702 p_fact_audit boolean,
703 p_net_change boolean,
704 p_fact_audit_name varchar2,
705 p_net_change_name varchar2,
706 p_fact_audit_is_name varchar2,
707 p_net_change_is_name varchar2,
708 p_debug boolean,
709 p_duplicate_collect boolean,
710 p_execute_flag boolean,
711 p_request_id number,
712 p_collection_size number,
713 p_parallel number,
714 p_table_owner varchar2,
715 p_bis_owner varchar2,
716 p_temp_log boolean,
717 p_forall_size number,
718 p_update_type varchar2,
719 p_mode varchar2,
720 p_explain_plan_check boolean,
721 p_fact_dlog varchar2,
722 p_key_set number,
723 p_instance_type varchar2,
724 p_load_pk number,
725 p_skip_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
726 p_number_skip_cols number,
727 p_fresh_restart boolean,
728 p_op_table_space varchar2,
729 p_da_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
730 p_number_da_cols number,
731 p_da_table varchar2,
732 p_pp_table varchar2,
733 p_master_instance varchar2,
734 p_rollback varchar2,
735 p_skip_levels EDW_OWB_COLLECTION_UTIL.varcharTableType,
736 p_number_skip_levels number,
737 p_smart_update boolean,
738 p_fk_use_nl number,
739 p_fact_smart_update number,
740 p_auto_dang_table_extn varchar2,
741 p_log_dang_keys boolean,
742 p_create_parent_table_records boolean,
743 p_smart_update_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
744 p_number_smart_update_cols number,
745 p_check_fk_change boolean,
746 p_stg_join_nl_percentage number,
747 p_ok_switch_update number,
748 p_stg_make_copy_percentage number,
749 p_ok_table varchar2,
750 p_hash_area_size number,
751 p_sort_area_size number,
752 p_trace boolean,
753 p_read_cfig_options boolean,
754 p_job_status_table varchar2,
755 p_max_round number,
756 p_update_dlog_lookup_table varchar2,
757 p_dlog_has_data boolean,
758 p_sleep_time number,
759 p_parallel_drill_down boolean
760 ) return boolean ;
761 function create_da_load_input_table(
762 p_da_cols_table varchar2,
763 p_op_table_space varchar2,
764 p_da_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
765 p_stg_da_cols EDW_OWB_COLLECTION_UTIL.varcharTableType,
766 p_number_da_cols number
767 ) return boolean;
768 function update_load_input_table(
769 p_table_name varchar2,
770 p_ok_table varchar2,
771 p_max_round number,
772 p_update_dlog_lookup_table varchar2,
773 p_dlog_has_data boolean,
774 p_total_records number,
775 p_stg_copy_table_flag boolean
776 )return boolean;
777 function check_job_status(p_job_id number) return varchar2 ;
778 function wait_on_jobs(
779 p_job_id number,
780 p_sleep_time number,
781 p_thread_type varchar2
782 ) return boolean;
783 function wait_on_jobs(
784 p_job_id numberTableType,
785 p_number_jobs number,
786 p_sleep_time number,
787 p_thread_type varchar2
788 ) return boolean ;
789 function terminate_jobs(
790 p_job_id numberTableType,
791 p_number_jobs number
792 )return boolean;
793 procedure dummy_proc;
794 function get_sid_for_job(p_job_id number) return number;
795 function get_session_parameters(
796 p_sid number,
797 p_serial out nocopy number
798 ) return boolean;
799 function kill_session(
800 p_sid number,
801 p_serial number
802 )return boolean;
803 function remove_job(p_job_id number) return boolean ;
804 function find_ok_distribution(
805 p_ok_table varchar2,
806 p_table_owner varchar2,
807 p_max_threads number,
808 p_min_job_load_size number,
812 ) return boolean;
809 p_ok_low_end out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
810 p_ok_high_end out NOCOPY EDW_OWB_COLLECTION_UTIL.numberTableType,
811 p_ok_end_count out NOCOPY integer
813 function create_job_status_table(
814 p_table varchar2,
815 p_op_table_space varchar2
816 ) return boolean ;
817 function get_join_nl(
818 p_load_size number,
819 p_total_records number,
820 p_cut_off_percentage number
821 ) return boolean;
822 function set_session_parameters(
823 p_hash_area_size number,
824 p_sort_area_size number,
825 p_trace boolean,
826 p_parallel number
827 )return boolean;
828 function log_into_job_status_table(
829 p_table varchar2,
830 p_object_name varchar2,
831 p_id number,
832 p_status varchar2,
833 p_message varchar2
834 )return boolean ;
835 function log_into_job_status_table(
836 p_table varchar2,
837 p_object_name varchar2,
838 p_id number,
839 p_status varchar2,
840 p_message varchar2,
841 p_measure1 number,
842 p_measure2 number,
843 p_measure3 number,
844 p_measure4 number,
845 p_measure5 number
846 )return boolean ;
847 function check_all_child_jobs(
848 p_job_status_table varchar2,
849 p_job_id numberTableType,
850 p_number_jobs number,
851 p_object_name varchar2
852 ) return boolean;
853 function create_dim_load_input_table(
854 p_dim_name varchar2,
855 p_table varchar2,
856 p_conc_id number,
857 p_conc_name varchar2,
858 p_levels varcharTableType,
859 p_child_level_number numberTableType,
860 p_child_levels varcharTableType,
861 p_child_fk varcharTableType,
862 p_parent_pk varcharTableType,
863 p_level_snapshot_logs varcharTableType,
864 p_number_levels number,
865 p_debug boolean,
866 p_exec_flag boolean,
867 p_bis_owner varchar2,
868 p_parallel number,
869 p_collection_size number,
870 p_table_owner varchar2,
871 p_forall_size number,
872 p_update_type varchar2,
873 p_level_order varcharTableType,
874 p_skip_cols varcharTableType,
875 p_number_skip_cols number,
876 p_load_pk number,
877 p_fresh_restart boolean,
878 p_op_table_space varchar2,
879 p_rollback varchar2,
880 p_ltc_merge_use_nl boolean,
881 p_dim_inc_refresh_derv boolean,
882 p_check_fk_change boolean,
883 p_ok_switch_update number,
884 p_join_nl_percentage number,
885 p_max_threads number,
886 p_min_job_load_size number,
887 p_sleep_time number,
888 p_job_status_table varchar2,
889 p_hash_area_size number,
890 p_sort_area_size number,
891 p_trace boolean,
892 p_read_cfig_options boolean,
893 p_max_fk_density number
894 ) return boolean ;
895 function update_dim_load_input_table(
896 p_input_table varchar2,
897 p_ilog_table varchar2,
898 p_skip_ilog_update boolean,
899 p_level_change boolean,
900 p_dim_empty_flag boolean,
901 p_before_update_table_final varchar2,
902 p_error_rec_flag boolean,
903 p_consider_snapshot booleanTableType,
904 p_levels_I varcharTableType,
905 p_use_ltc_ilog booleanTableType,
906 p_number_levels number
907 )return boolean ;
908 function create_derv_fact_inp_table(
909 p_fact_name varchar2,
910 p_input_table varchar2,
911 p_fact_id number,
912 p_mapping_id number,
913 p_src_object varchar2,
914 p_src_object_id number,
915 p_fact_fks varcharTableType,
916 p_higher_level booleanTableType,
917 p_parent_dim varcharTableType,
918 p_parent_level varcharTableType,
919 p_level_prefix varcharTableType,
920 p_level_pk varcharTableType,
921 p_level_pk_key varcharTableType,
922 p_dim_pk_key varcharTableType,
923 p_number_fact_fks number,
924 p_conc_id number,
925 p_conc_program_name varchar2,
926 p_debug boolean,
927 p_collection_size number,
928 p_parallel number,
929 p_bis_owner varchar2,
930 p_table_owner varchar2,
931 p_full_refresh boolean,
932 p_forall_size number,
933 p_update_type varchar2,
934 p_fact_dlog varchar2,
935 p_skip_cols varcharTableType,
936 p_number_skip_cols number,
937 p_load_fk number,
938 p_fresh_restart boolean,
939 p_op_table_space varchar2,
940 p_bu_tables varcharTableType,--before update tables.prop dim change to derv
941 p_bu_dimensions varcharTableType,
942 p_number_bu_tables number,
943 p_bu_src_fact varchar2,--what table to look at as the src fact. if null, scan full the src fact
944 p_load_mode varchar2,
945 p_rollback varchar2,
946 p_src_join_nl_percentage number,
947 p_max_threads number,
948 p_min_job_load_size number,
949 p_sleep_time number,
950 p_job_status_table varchar2,
951 p_hash_area_size number,
952 p_sort_area_size number,
953 p_trace boolean,
954 p_read_cfig_options boolean
955 ) return boolean;
956 function update_derv_fact_input_table(
957 p_input_table varchar2,
958 p_ilog_table varchar2,
959 p_dlog_table varchar2,
960 p_skip_ilog_update boolean,
961 p_skip_dlog_update boolean,
962 p_skip_ilog boolean,
963 p_load_mode varchar2,
964 p_full_refresh boolean,
965 p_src_object_ilog varchar2,
966 p_src_object_dlog varchar2,
967 p_src_snplog_has_pk boolean,
968 p_err_rec_flag boolean,
969 p_err_rec_flag_d boolean
970 ) return boolean;
974 p_ilog_table2 varchar2,
971 function merge_all_ilog_tables (
972 p_ilog_pattern varchar2,
973 p_ilog_table varchar2,
975 p_ilog_table_extn varchar2,
976 p_op_table_space varchar2,
977 p_bis_owner varchar2,
978 p_parallel number
979 )return boolean;
980 function merge_all_prot_tables(
981 p_prot_table varchar2,
982 p_prot_table_extn varchar2,
983 p_op_table_space varchar2,
984 p_bis_owner varchar2,
985 p_parallel number
986 )return boolean ;
987 function put_rownum_in_ilog_table(
988 p_ilog varchar2,
989 p_ilog_old varchar2,
990 p_op_table_space varchar2,
991 p_parallel number
992 )return boolean;
993 function get_ilog_tables_from_db(
994 p_ilog_table varchar2,
995 p_ilog_table_extn varchar2,
996 p_bis_owner varchar2,
997 p_ilog_tables out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
998 p_number_ilog_tables out nocopy number
999 )return boolean ;
1000 function drop_prot_tables(
1001 p_prot_table varchar2,
1002 p_prot_table_extn varchar2,
1003 p_bis_owner varchar2
1004 ) return boolean ;
1005 function drop_ilog_tables(
1006 p_ilog_table varchar2,
1007 p_ilog_table_extn varchar2,
1008 p_bis_owner varchar2
1009 ) return boolean ;
1010 function check_conc_process_status(p_conc_id number) return varchar2;
1011 function update_inp_table_jobid(
1012 p_input_table varchar2,
1013 p_job_id number
1014 )return boolean ;
1015 function find_skip_attributes(
1016 p_object_name varchar2,
1017 p_object_type varchar2,
1018 p_skip_cols out NOCOPY varcharTableType,
1019 p_number_skip_cols out NOCOPY number
1020 ) return boolean;
1021 function log_collection_start(
1022 p_object_name varchar2,
1023 p_object_id number,
1024 p_object_type varchar2,
1025 p_start_date date,
1026 p_conc_program_id number,
1027 p_load_pk number
1028 ) return boolean ;
1029 function get_temp_log_data(
1030 p_object_name varchar2,
1031 p_object_type varchar2,
1032 p_load_pk number,
1033 p_ins_rows_ready out nocopy number,
1034 p_ins_rows_processed out nocopy number,
1035 p_ins_rows_collected out nocopy number,
1036 p_ins_rows_dangling out nocopy number,
1037 p_ins_rows_duplicate out nocopy number,
1038 p_ins_rows_error out nocopy number,
1039 p_ins_rows_insert out nocopy number,
1040 p_ins_rows_update out nocopy number,
1041 p_ins_rows_delete out nocopy number,
1042 p_ins_instance_name out nocopy varchar2,
1043 p_ins_request_id_table out nocopy varchar2
1044 ) return boolean ;
1045 function get_child_job_status(
1046 p_job_status_table varchar2,
1047 p_object_name varchar2,
1048 p_id out nocopy numberTableType,
1049 p_job_id out nocopy numberTableType,
1050 p_status out nocopy varcharTableType,
1051 p_message out nocopy varcharTableType,
1052 p_number_jobs out nocopy number
1053 )return boolean ;
1054 function get_job_queue_processes return number;
1055 function get_app_long_name(
1056 p_app_name varchar2,
1057 p_app_long_name out nocopy varchar2
1058 ) return boolean ;
1059 function update_inp_table_concid(
1060 p_input_table varchar2,
1061 p_conc_id number
1062 )return boolean ;
1063 function check_table_column(p_table varchar2,p_owner varchar2,p_col varchar2) return boolean;
1064 function get_max_in_array(p_array numberTableType,p_number_array number,
1065 p_index out nocopy number) return number;
1066 function get_min_in_array(p_array numberTableType,p_number_array number,
1067 p_index out nocopy number) return number;
1068 function create_input_table_push_down(
1069 p_input_table varchar2,
1070 p_dim_name varchar2,
1071 p_dim_id number,
1072 p_levels varcharTableType,
1073 p_child_level_number numberTableType,
1074 p_child_levels varcharTableType,
1075 p_child_fk varcharTableType,
1076 p_parent_pk varcharTableType,
1077 p_number_levels number,
1078 p_level_order varcharTableType,
1079 p_level_snapshot_logs varcharTableType,
1080 p_level_ilog varcharTableType,
1081 p_level_consider booleanTableType,
1082 p_level_full_insert booleanTableType,
1083 p_debug boolean,
1084 p_parallel number,
1085 p_collection_size number,
1086 p_bis_owner varchar2,
1087 p_table_owner varchar2,
1088 p_full_refresh boolean,
1089 p_forall_size number,
1090 p_update_type varchar2,
1091 p_load_pk number,
1092 p_op_table_space varchar2,
1093 p_rollback varchar2,
1094 p_max_threads number,
1095 p_min_job_load_size number,
1096 p_sleep_time number,
1097 p_hash_area_size number,
1098 p_sort_area_size number,
1099 p_trace boolean,
1100 p_read_cfig_options boolean,
1101 p_join_nl_percentage number
1102 ) return boolean;
1103 function make_ilog_from_main_ilog(
1104 p_ilog_rowid_table varchar2,
1105 p_ilog_table varchar2,
1106 p_low_end number,
1107 p_high_end number,
1108 p_op_table_space varchar2,
1109 p_bis_owner varchar2,
1110 p_parallel number,
1111 p_ilog_rowid_number out nocopy number
1112 ) return boolean;
1113 function check_index_on_column(
1114 p_table varchar2,
1115 p_owner varchar2,
1116 p_column varchar2
1117 )return boolean;
1118 procedure create_status_table(p_table varchar2,p_op_table_space varchar2,
1119 p_status varchar2,p_count number);
1120 function drop_seq(p_seq varchar2,p_owner varchar2) return boolean;
1121 function create_sequence(
1122 p_seq varchar2,
1123 p_owner varchar2,
1124 p_start_with number,
1125 p_flag varchar2
1126 ) return boolean;
1127 function get_seq_nextval(p_seq varchar2) return number;
1128 function get_max_value(p_table varchar2,p_col varchar2) return number;
1129 function get_stg_map_fk_details(
1130 p_fstg_usage_id number,
1131 p_fstg_id number,
1132 p_mapping_id number,
1133 p_job_id number,
1134 p_op_tablespace varchar2,
1135 p_bis_owner varchar2,
1136 p_dimTableName out nocopy varcharTableType,
1137 p_dim_row_count out nocopy numberTableType,
1138 p_dimTableId out nocopy numberTableType,
1139 p_dimUserPKName out nocopy varcharTableType,
1140 p_fstgUserFKName out nocopy varcharTableType,
1141 p_factFKName out nocopy varcharTableType,
1142 p_numberOfDimTables out nocopy number
1143 )return boolean;
1144 function get_stg_map_pk_params(
1145 p_mapping_id number,
1146 p_fstgTableUsageId out nocopy number,
1147 p_fstgTableId out nocopy number,
1148 p_fstgTableName out nocopy varchar2,
1149 p_factTableUsageId out nocopy number,
1150 p_factTableId out nocopy number,
1151 p_factTableName out nocopy varchar2,
1152 p_fstgPKName out nocopy varchar2,
1153 p_factPKName out nocopy varchar2
1154 ) return boolean ;
1155 function create_conc_program(
1156 p_conc_name varchar2,
1157 p_conc_short_name varchar2,
1158 p_exe_name varchar2,
1159 p_exe_file_name varchar2,
1160 p_bis_short_name varchar2,
1161 p_parameter varcharTableType,
1162 p_parameter_value_set varcharTableType,
1163 p_number_parameters number
1164 ) return boolean;
1165 function delete_conc_program(
1166 p_conc_name varchar2,
1167 p_exe_name varchar2,
1168 p_bis_name varchar2,
1169 p_name_type varchar2
1170 ) return boolean;
1171 procedure write_to_fnd_log(
1172 p_message varchar2,
1173 p_severity number);
1174 function is_oracle_apps_GT_1159 return boolean;
1175 procedure write_to_conc_log_file(p_message varchar2);
1176 procedure init_all(
1177 p_object_name varchar2,
1178 p_debug boolean,
1179 p_fnd_log_module varchar2
1180 );
1181 function get_parameter_value(
1182 p_name varchar2
1183 )return varchar2;
1184 function get_db_version return varchar2;
1185 function is_db_version_gt(p_db_version varchar2,p_version varchar2) return boolean;
1186 function drop_stg_map_fk_details(
1187 p_bis_owner varchar2,
1188 p_mapping_id number
1189 )return boolean;
1190 function get_job_execute_time(p_job_id number) return varchar2;
1191 function query_table_cols(
1192 p_table varchar2,
1193 p_col varchar2,
1194 p_where varchar2,
1195 p_output out nocopy varcharTableType,
1196 p_num_output out nocopy number
1197 ) return boolean;
1198 function terminate_job(p_job_id number) return boolean;
1199 procedure dump_mem_stats;
1200 procedure dump_parallel_stats;
1201 function check_and_wait_for_job(
1202 p_job_id number,
1203 p_status_table varchar2,
1204 p_where varchar2,
1205 p_sleep_time number,
1206 p_status out nocopy varchar2,
1207 p_message out nocopy varchar2
1208 )return boolean;
1209 function get_tables_matching_pattern(
1210 p_pattern varchar2,
1211 p_owner varchar2,
1212 p_table in out nocopy varcharTableType,
1213 p_num_table in out nocopy number
1214 )return boolean;
1215 function update_status_table(
1216 p_table varchar2,
1217 p_col varchar2,
1218 p_value varchar2,
1219 p_where varchar2
1220 ) return boolean;
1221 function create_dd_status_table(
1222 p_table varchar2,
1223 p_level_order varcharTableType,
1224 p_number_levels number
1225 ) return boolean;
1226 function is_table_partitioned(p_table varchar2,p_owner varchar2) return varchar2;
1227 function drop_level_UL_tables(
1228 p_dim_id number,
1229 p_bis_owner varchar2
1230 ) return boolean;
1231 function is_source_for_fast_refresh_mv(
1232 p_object varchar2,
1233 p_owner varchar2
1234 ) return number;
1235 function drop_tables_like(p_string varchar2,p_owner varchar2)return boolean;
1236 procedure create_rownum_index_ilog(
1237 p_ilog varchar2,
1238 p_op_table_space varchar2,
1239 p_parallel number
1243 p_derived_facts out NOCOPY varcharTableType,
1240 );
1241 function get_all_derived_facts_inc(
1242 p_object varchar2,
1244 p_derived_fact_ids out NOCOPY numberTableType,
1245 p_map_id out NOCOPY numberTableType,
1246 p_number_derived_facts out NOCOPY number) return boolean;
1247 function get_fact_dfact_ilog(
1248 p_bis_owner varchar2,
1249 p_src_fact_id number,
1250 p_derived_fact_id number) return varchar2;
1251 function get_fact_dfact_dlog(
1252 p_bis_owner varchar2,
1253 p_src_fact_id number,
1254 p_derived_fact_id number) return varchar2;
1255 function clean_ilog_dlog_base_fact(
1256 p_fact varchar2,
1257 p_owner varchar2,
1258 p_bis_owner varchar2,
1259 p_fact_id number,
1260 p_fact_dlog varchar2
1261 )return boolean ;
1262 procedure create_iot_index(
1263 p_table varchar2,
1264 p_column varchar2,
1265 p_tablespace varchar2,
1266 p_parallel number);
1267 FUNCTION get_apps_schema_name RETURN VARCHAR2;
1268 END EDW_OWB_COLLECTION_UTIL;