PACKAGE: APPS.BSC_MV_ADAPTER

Source

1 package BSC_MV_ADAPTER AS
2 /*$Header: BSCMVLDS.pls 120.1 2005/08/10 16:51:27 arsantha noship $*/
3 
4 --program runtime parameters
5 g_debug boolean;
6 g_status boolean;
7 g_stmt varchar2(32000);
8 g_apps_origin varchar2(100);
9 g_parallel number;
10 g_status_message varchar2(2000);
11 g_bsc_owner varchar2(100);
12 g_all_levels_mv boolean;
13 g_kpi varchar2(200);--to improve perf and reduce hits on the DB
14 --functions--------------------------------------------------------
15 function get_time return varchar2 ;
16 function init_all return boolean;
17 function create_mv_normal(
18 p_kpi varchar2,
19 p_mv_name varchar2,
20 p_mv_owner varchar2,
21 p_child_mv BSC_IM_UTILS.varchar_tabletype,
22 p_number_child_mv number,
23 p_options BSC_IM_UTILS.varchar_tabletype,
24 p_number_options number,
25 p_apps_origin varchar2,
26 p_type varchar2,
27 p_create_non_unique_index boolean
28 )return boolean;
29 function create_mv_kpi(
30 p_kpi varchar2,
31 p_apps_origin varchar2,
32 p_options BSC_IM_UTILS.varchar_tabletype,
33 p_number_options number
34 ) return boolean ;
35 function create_mv_synonym(
36 p_level varchar2,
37 p_mv_name varchar2,
38 p_mv_owner varchar2
39 )return boolean;
40 function alter_mv_to_refresh_demand(
41 p_mv_name varchar2,
42 p_mv_owner varchar2
43 )return boolean;
44 function create_mv_log_on_table(
45 p_object varchar2,
46 p_apps_origin varchar2,
47 p_options BSC_IM_UTILS.varchar_tabletype,
48 p_number_options number,
49 p_snplog_created out nocopy boolean
50 )return boolean;
51 function refresh_mv_kpi(
52 p_kpi varchar2,
53 p_apps_origin varchar2,
54 p_options BSC_IM_UTILS.varchar_tabletype,
55 p_number_options number
56 ) return boolean;
57 function drop_mv_kpi(
58 p_kpi varchar2,
59 p_apps_origin varchar2,
60 p_options BSC_IM_UTILS.varchar_tabletype,
61 p_number_options number
62 ) return boolean;
63 function drop_summary_objects(
64 p_mv_list varchar2,
65 p_synonym_list varchar2,
66 p_options varchar2,
67 p_error_message out nocopy varchar2
68 ) return boolean;
69 function get_ordered_mv_list(
70 p_kpi varchar2,
71 p_apps_origin varchar2,
72 p_parent_summary_mv out nocopy BSC_IM_UTILS.varchar_tabletype,
73 p_child_summary_mv out nocopy BSC_IM_UTILS.varchar_tabletype,
74 p_number_pc_mv out nocopy number,
75 p_ordered_summary_mv out nocopy BSC_IM_UTILS.varchar_tabletype,
76 p_ordered_summary_mv_rank out nocopy BSC_IM_UTILS.number_tabletype,
77 p_number_ordered_summary_mv out nocopy number,
78 p_max_rank out nocopy number
79 )return boolean ;
80 function create_dummy_mv(
81 p_b_tables BSC_IM_UTILS.varchar_tabletype,
82 p_number_b_tables number,
83 p_mv_name varchar2,
84 p_mv_owner varchar2
85 )return boolean;
86 function get_dummy_mv(
87 p_mv_name varchar2,
88 p_mv_owner varchar2,
89 p_dummy_mv out nocopy BSC_IM_UTILS.varchar_tabletype,
90 p_number_dummy_mv out nocopy number
91 )return boolean ;
92 function create_mv_index(
93 p_mv_name varchar2,
94 p_mv_owner varchar2,
95 p_kpi varchar2,
96 p_apps_origin varchar2,
97 p_tablespace varchar2,
98 p_storage varchar2,
99 p_create_non_unique_index boolean,
100 p_called_from_refresh boolean default false
101 )return boolean;
102 function refresh_mv(
103 p_mv varchar2,
104 p_kpi varchar2,
105 p_options BSC_IM_UTILS.varchar_tabletype,
106 p_number_options number
107 ) return boolean;
108 function drop_mv(
109 p_mv varchar2,
110 p_options BSC_IM_UTILS.varchar_tabletype,
111 p_number_options number
112 )return boolean;
113 function create_zero_code_mv_kpi(
114 p_kpi varchar2,
115 p_apps_origin varchar2,
116 p_options BSC_IM_UTILS.varchar_tabletype,
117 p_number_options number,
118 p_max_rank number,
119 p_bsc_owner varchar2,
120 p_max_mv_levels number,
121 p_ordered_summary_mv BSC_IM_UTILS.varchar_tabletype,
122 p_ordered_summary_mv_rank BSC_IM_UTILS.number_tabletype,
123 p_number_ordered_summary_mv number
124 ) return boolean ;
125 function object_index_validation(
126 p_object varchar2,
127 p_owner varchar2,
128 p_kpi varchar2,
129 p_apps_origin varchar2,
130 p_options BSC_IM_UTILS.varchar_tabletype,
131 p_number_options number,
132 p_create_non_unique_index boolean
133 )return boolean;
134 function check_old_mv_view(
135 p_mv_name varchar2,
136 p_mv_owner varchar2,
137 p_type varchar2,
138 p_options BSC_IM_UTILS.varchar_tabletype,
139 p_number_options number
140 )return varchar2;
141 --procedures-------------------------------------------------------
142 procedure write_to_log_file(p_message varchar2);
143 procedure write_to_log_file_n(p_message varchar2);
144 procedure write_to_debug_n(p_message varchar2);
145 procedure write_to_debug(p_message varchar2);
146 procedure set_globals(p_debug boolean);
147 -------------------------------------------------------------------
148 
149 END BSC_MV_ADAPTER;