PACKAGE: APPS.EDW_SRC_DANG_RECOVERY

Source

1 package EDW_SRC_DANG_RECOVERY AUTHID CURRENT_USER as
2 /*$Header: EDWSRDTS.pls 115.4 2002/12/12 20:29:44 vsurendr noship $*/
3 Type varcharTableType is Table of varchar2(400) index by binary_integer;
4 Type L_varcharTableType is Table of varchar2(4000) index by binary_integer;
5 Type LL_varcharTableType is Table of varchar2(10000) index by binary_integer;
6 Type LLL_varcharTableType is Table of varchar2(20000) index by binary_integer;
7 Type numberTableType is Table of number index by binary_integer;
8 Type dateTableType is Table of date index by binary_integer;
9 Type booleanTableType is Table of boolean index by binary_integer;
10 Type rowidTableType is Table of rowid index by binary_integer;
11 
12 g_status_message varchar2(4000);
13 g_object_name varchar2(400);
14 g_object_id number;
15 g_db_link varchar2(400);
16 g_db_link_stmt varchar2(400);--this is @g_db_link. it will be null for single instance
17 g_src_op_table_space varchar2(400);
18 g_src_parallel number;
19 g_src_bis_owner varchar2(400);
20 g_debug boolean;
21 g_instance varchar2(100);
22 g_read_cfig_options boolean;
23 g_auto_dang_flag boolean;
24 g_dang_table varchar2(400);
25 g_wh_dang_table varchar2(400);
26 g_wh_dang_table_cols varcharTableType;
27 g_number_wh_dang_table_cols number;
28 g_dang_table_count number;
29 g_new_dang_table varchar2(400);
30 g_new_dang_table_count number;
31 g_level_table varchar2(400);--holds the ltc name and ltc id
32 g_src_same_wh_flag boolean;
33 g_missing_key_view varchar2(400);
34 g_pk_view varchar2(400);
35 g_pk_view_cols varcharTableType;
36 g_number_pk_view_cols number;
37 g_profile_options varcharTableType;
38 g_number_profile_options number;
39 g_pk_porfile_number numberTableType;
40 g_pk_cols varcharTableType;--from the profile option
41 g_number_pk_cols number;
42 g_err_rec_flag boolean;
43 function get_dangling_keys(p_dim_name varchar2,p_db_link varchar2,
44 p_pk_view varchar2 default null,p_missing_key_view varchar2 default null) return boolean ;
45 function get_dangling_keys return boolean ;
46 function get_ll_keys_from_wh return boolean ;
47 function init_all return boolean ;
48 procedure write_to_log_file(p_message varchar2) ;
49 procedure write_to_log_file_n(p_message varchar2) ;
50 function get_time return varchar2;
51 function get_dim_id(p_object_name varchar2) return number;
52 function get_db_user(p_product varchar2) return varchar2;
53 function get_this_instance return varchar2 ;
54 function get_default_tablespace return varchar2 ;
55 function read_profile_options return boolean ;
56 function read_cfig_options return boolean ;
57 function get_src_option(p_option_code varchar2) return varchar2 ;
58 function drop_table (p_table_name varchar2,p_owner varchar2 default null) return boolean ;
59 function check_table(p_table varchar2, p_owner varchar2 default null) return boolean ;
60 function get_hl_keys_from_view return boolean ;
61 function get_db_columns_for_table(
62     p_table varchar2,
63     p_columns OUT NOCOPY varcharTableType,
64     p_number_columns OUT NOCOPY number,
65     p_owner varchar2 default null) return boolean;
66 procedure analyze_table_stats(p_table varchar2, p_owner varchar2) ;
67 function get_pk_structure return boolean ;
68 function value_in_table(
69     p_table varcharTableType,
70     l_number_table number,
71     p_value varchar2) return boolean ;
72 function get_pk_for_level(p_level_prefix varchar2) return varchar2 ;
73 function does_table_have_data(p_table varchar2, p_where varchar2 default null) return number;
74 function create_missing_key_view return boolean ;
75 procedure truncate_dang_table;
76 END EDW_SRC_DANG_RECOVERY;