PACKAGE: APPS.EDW_DUPLICATE_CLEAN

Source

1 package EDW_DUPLICATE_CLEAN AUTHID CURRENT_USER AS
2 /*$Header: EDWDCLNS.pls 115.7 2003/11/05 22:17:29 vsurendr noship $*/
3 g_dim_name varchar2(400);
4 g_dim_pk varchar2(400);
5 g_dim_pk_key varchar2(400);
6 g_ltc_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
7 g_ltc_pk EDW_OWB_COLLECTION_UTIL.varcharTableType;
8 g_ltc_pk_key EDW_OWB_COLLECTION_UTIL.varcharTableType;
9 g_number_ltc number;
10 g_bis_owner varchar2(100);
11 g_parallel number;
12 g_fact_name varchar2(400);
13 g_fact_pk varchar2(400);
14 g_fact_pk_key varchar2(400);
15 
16 g_status_message varchar2(2000);
17 g_status boolean;
18 g_op_table_space varchar2(400);
19 
20 function clean_dimension_duplicates(p_dim_name varchar2) return boolean;
21 function clean_fact_duplicates(p_fact_name varchar2) return boolean;
22 function clean_dimension_duplicates return boolean ;
23 function clean_fact_duplicates return boolean ;
24 function get_dimension_pks return boolean ;
25 function get_fact_pks return boolean ;
26 function get_ltc_tables return boolean ;
27 function get_ltc_pks  return boolean ;
28 function get_table_pks(p_table varchar2,p_pk out NOCOPY varchar2,p_pk_key out NOCOPY varchar2,
29 p_option varchar2) return boolean ;
30 function delete_dim_duplicates return boolean ;
31 function delete_fact_duplicates return boolean ;
32 function delete_table_duplicates(p_table varchar2,p_pk varchar2,p_pk_key varchar2) return boolean ;
33 procedure init_all ;
34 procedure write_to_log_file(p_message varchar2) ;
35 procedure write_to_log_file_n(p_message varchar2) ;
36 function get_time return varchar2 ;
37 function get_short_name_for_long(p_name varchar2) return varchar2;
38 procedure clean_up_object(Errbuf out NOCOPY varchar2,Retcode out NOCOPY varchar2,p_object_name in varchar2);
39 function is_dimension(p_object_name varchar2) return boolean ;
40 function get_fact_fk_for_dim(
41 p_dim_name varchar2,
42 p_fact out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
43 p_fact_fk out nocopy EDW_OWB_COLLECTION_UTIL.varcharTableType,
44 p_number_fact_fk out nocopy number
45 )return boolean;
46 function delete_dim_duplicate_data(
47 p_dim_name varchar2,
48 p_dim_pk varchar2,
49 p_dim_pk_key varchar2
50 )return boolean;
51 END EDW_DUPLICATE_CLEAN;