DBA Data[Home] [Help]

PACKAGE: APPS.EDW_ANALYZE_OBJECT

Source


1 package EDW_ANALYZE_OBJECT AUTHID CURRENT_USER AS
2 /*$Header: EDWANYZS.pls 115.5 2002/11/23 00:08:56 vsurendr noship $*/
3 g_dim EDW_OWB_COLLECTION_UTIL.varcharTableType;
4 g_dim_long EDW_OWB_COLLECTION_UTIL.varcharTableType;
5 g_number_dim number;
6 g_fact EDW_OWB_COLLECTION_UTIL.varcharTableType;
7 g_fact_long EDW_OWB_COLLECTION_UTIL.varcharTableType;
8 g_number_fact number;
9 g_parallel number;
10 g_status boolean;
11 g_status_message varchar2(4000);
12 g_mode number;
13 procedure Analyze_Dimension(Errbuf out NOCOPY varchar2,Retcode out NOCOPY varchar2,
14 p_dim_name in varchar2,p_mode number);
15 procedure Analyze_Fact(Errbuf out NOCOPY varchar2,Retcode out NOCOPY varchar2,
16 p_fact_name in varchar2,p_mode number);
17 function analyze_dimension(p_dim_name varchar2) return boolean;
18 function get_dims(p_dim_name varchar2) return boolean;
19 function analyze_dims return boolean;
20 function analyze_fact(p_fact_name varchar2) return boolean;
21 function get_facts(p_fact_name varchar2) return boolean;
22 function analyze_facts return boolean;
23 procedure analyze_table(p_object varchar2);
24 procedure init_all;
25 function get_time return varchar2;
26 procedure write_to_log_file(p_message varchar2);
27 procedure write_to_log_file_n(p_message varchar2);
28 procedure write_to_out_file(p_message varchar2);
29 procedure write_to_out_file_n(p_message varchar2);
30 function analyze_dims_lstg return boolean ;
31 function analyze_facts_fstg return boolean ;
32 END EDW_ANALYZE_OBJECT;