1 PACKAGE BSC_BIA_WRAPPER AS
2 /* $Header: BSCBIAWS.pls 120.1 2006/04/19 11:36:20 meastmon noship $ */
3
4 -- bug 3835059
5 -- adding it here instead of bsc_metadata_optimizer_pkg as this
6 -- may need to be backported to 5.1.1 and 5.1.1.1 wherein VB
7 -- will call this API (in these versions bsc_metadata_optimizer_pkg
8 -- does not exist)
9
10 MAX_ALLOWED_LEVELS constant number := 8;
11
12 --Fix bug#5069433
13 g_projection_kpis BSC_UPDATE_UTIL.t_array_of_number;
14 g_projection_kpis_set BOOLEAN := FALSE;
15
16
17 /*===========================================================================+
18 |
19 | Name: Analyze_Table
20 |
21 | Description: Analyze the given table.
22
23 | Notes:
24 |
25 +============================================================================*/
26 PROCEDURE Analyze_Table(
27 p_table_name IN VARCHAR2
28 );
29
30 /*===========================================================================+
31 |
32 | Name: Do_Analyze
33 |
34 | Description: This function returns TRUE if we want to Analyze the MVs
35 | after refresh
36 |
37 | Notes:
38 |
39 +============================================================================*/
40 FUNCTION Do_Analyze RETURN BOOLEAN;
41
42
43 /*===========================================================================+
44 |
45 | Name: Drop_Rpt_Key_Table
46 |
47 | Description: Drop the tables bsc_rpt_keys_%
48 |
49 | Notes:
50 |
51 +============================================================================*/
52 FUNCTION Drop_Rpt_Key_Table(
53 p_user_id NUMBER,
54 x_error_message OUT NOCOPY VARCHAR2
55 ) RETURN BOOLEAN;
56
57
58 /*===========================================================================+
59 |
60 | Name: Drop_Rpt_Key_Table_VB
61 |
62 | Description: Drop the tables bsc_rpt_keys_%
63 | This procedure is to be called from Metadata optmizer.
64 | In case of error it insert the error in BSC_MESSAGE_LOGS
65 | Notes:
66 |
67 +============================================================================*/
68 PROCEDURE Drop_Rpt_Key_Table_VB(
69 p_user_id NUMBER
70 );
71
72
73 /*===========================================================================+
74 |
75 | Name: Drop_Summary_MV
76 |
77 | Description: This function drops the give MV.
78 | Returns False in case of error along with the error
79 | message in x_error_message
80 |
81 | Notes:
82 |
83 +============================================================================*/
84 FUNCTION Drop_Summary_MV(
85 p_mv IN VARCHAR2,
86 x_error_message OUT NOCOPY VARCHAR2
87 ) RETURN BOOLEAN;
88
89
90 /*===========================================================================+
91 |
92 | Name: Drop_Summary_MV_VB
93 |
94 | Description: This function drops the give MV.
95 | This procedure is to be called from Metadata optmizer.
96 | In case of error it insert the error in BSC_MESSAGE_LOGS
97 |
98 | Notes:
99 |
100 +============================================================================*/
101 PROCEDURE Drop_Summary_MV_VB(
102 p_mv IN VARCHAR2
103 );
104
105
106 /*===========================================================================+
107 |
108 | Name: Get_Sum_Table_MV_Name
109 |
110 | Description: Returns the MV name of the given summary table
111 |
112 | Notes:
113 |
114 +============================================================================*/
115 FUNCTION Get_Sum_Table_MV_Name(
116 p_table_name IN VARCHAR2
117 ) RETURN VARCHAR2;
118 PRAGMA RESTRICT_REFERENCES(Get_Sum_Table_MV_Name, WNDS);
119
120
121 /*===========================================================================+
122 |
123 | Name: Implement_Bsc_MV
124 |
125 | Description: This function creates all the MVs required for the given kpi.
126 | Returns False in case of error along with the error
127 | message in x_error_message
128 |
129 | Notes:
130 |
131 +============================================================================*/
132 FUNCTION Implement_Bsc_MV(
133 p_kpi IN NUMBER,
134 p_adv_sum_level IN NUMBER,
135 p_reset_mv_levels IN BOOLEAN,
136 x_error_message OUT NOCOPY VARCHAR2
137 ) RETURN BOOLEAN;
138
139
140 /*===========================================================================+
141 |
142 | Name: Indicator_Has_Projection
143 |
144 | Description: This procedure returns TRUE is any measure of the Kpi
145 | needs projection.
146 |
147 | Notes:
148 |
149 +============================================================================*/
150 FUNCTION Indicator_Has_Projection(
151 p_kpi IN NUMBER
152 ) RETURN BOOLEAN;
153
154
155 /*===========================================================================+
156 |
157 | Name: Implement_Bsc_MV_VB
158 |
159 | Description: This procedure creates all the MVs required for the given kpi.
160 | This procedure is to be called from Metadata optmizer.
161 | In case of error it insert the error in BSC_MESSAGE_LOGS
162 |
163 | Notes:
164 |
165 +============================================================================*/
166 PROCEDURE Implement_Bsc_MV_VB(
167 p_kpi IN NUMBER,
168 p_adv_sum_level IN NUMBER,
169 p_reset_mv_levels IN BOOLEAN
170 );
171
172
173 /*===========================================================================+
174 |
175 | Name: Load_Reporting_Calendar
176 |
177 | Description: This function will populate the reporting calendar.
178 |
179 | Notes:
180 |
181 +============================================================================*/
182 FUNCTION Load_Reporting_Calendar(
183 x_error_message OUT NOCOPY VARCHAR2
184 ) RETURN BOOLEAN;
185
186 --Fix bug#4027813: Add this function to load reporting calendar for only
187 -- the specified calendar id
188 FUNCTION Load_Reporting_Calendar(
189 x_calendar_id IN NUMBER,
190 x_error_message OUT NOCOPY VARCHAR2
191 ) RETURN BOOLEAN;
192
193 --LOCKING: new function
194 FUNCTION Load_Reporting_Calendar_AT(
195 x_calendar_id IN NUMBER,
196 x_error_message OUT NOCOPY VARCHAR2
197 ) RETURN BOOLEAN;
198
199
200 /*===========================================================================+
201 |
202 | Name: Load_Reporting_Calendar_VB
203 |
204 | Description: This function will populate the reporting calendar.
205 | This procedure is to be called from Metadata optmizer.
206 | In case of error it insert the error in BSC_MESSAGE_LOGS
207
208 | Notes:
209 |
210 +============================================================================*/
211 PROCEDURE Load_Reporting_Calendar_VB;
212
213
214 /*===========================================================================+
215 |
216 | Name: Refresh_Summary_MV
217 |
218 | Description: This function refreshes the given MV.
219 | Returns False in case of error along with the error
220 | message in x_error_message
221 |
222 | Notes:
223 |
224 +============================================================================*/
225 FUNCTION Refresh_Summary_MV(
226 p_mv IN VARCHAR2,
227 x_error_message OUT NOCOPY VARCHAR2
228 ) RETURN BOOLEAN;
229
230 --LOCKING: new function
231 FUNCTION Refresh_Summary_MV_AT(
232 p_mv IN VARCHAR2,
233 x_error_message OUT NOCOPY VARCHAR2
234 ) RETURN BOOLEAN;
235
236 END BSC_BIA_WRAPPER;