PACKAGE: APPS.EDW_CLEAN_OBJECT

Source

1 package EDW_CLEAN_OBJECT AUTHID CURRENT_USER AS
2 /*$Header: EDWOCLNS.pls 115.5 2002/11/23 00:09:34 vsurendr noship $*/
3 
4 g_object_name varchar2(400);
5 g_dim varchar2(400);
6 g_dim_ilog varchar2(400);
7 g_dim_owner varchar2(400);
8 g_bis_owner varchar2(400);
9 g_ltc_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
10 g_lstg_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
11 g_ltc_snplogs EDW_OWB_COLLECTION_UTIL.varcharTableType;
12 g_number_ltc number;
13 g_op_tables EDW_OWB_COLLECTION_UTIL.varcharTableType;
14 g_number_op_tables number;
15 
16 g_status_message varchar2(4000);
17 g_status boolean;
18 g_truncate_stg varchar2(40);
19 
20 g_fstg_table varchar2(400);
21 g_fact_snplog varchar2(400);
22 g_fact_dlog varchar2(400);
23 g_fact_ilog varchar2(400);
24 g_fact_ok_table varchar2(400);
25 g_base_fact_ilog EDW_OWB_COLLECTION_UTIL.varcharTableType;
26 g_base_fact_dlog EDW_OWB_COLLECTION_UTIL.varcharTableType;
27 g_number_ilog number;
28 g_derv_fact_ilog EDW_OWB_COLLECTION_UTIL.varcharTableType;
29 g_derv_fact_dlog EDW_OWB_COLLECTION_UTIL.varcharTableType;
30 g_derv_number_ilog number;
31 
32 
33 procedure clean_up_object(
34 Errbuf out NOCOPY varchar2,
35 Retcode out NOCOPY varchar2,
36 p_object_name in varchar2,
37 p_truncate_stg in varchar2);
38 procedure init_all;
39 function clean_up_dimension(p_dim varchar2) return boolean;
40 function clean_up_fact(p_fact varchar2) return boolean;
41 function read_metadata(p_dim varchar2) return boolean ;
42 procedure write_to_log_file(p_message varchar2);
43 function clean_dim_objects return boolean ;
44 function execute_stmt(p_stmt varchar2) return boolean;
45 function is_dimension(p_object_name varchar2) return boolean ;
46 function read_fact_metadata(p_fact varchar2) return boolean ;
47 function get_short_name_for_long(p_name varchar2) return varchar2 ;
48 END EDW_CLEAN_OBJECT;