1 PACKAGE BSC_UPDATE_BASE_V2 AS
2 /* $Header: BSCDBV2S.pls 120.0 2005/10/25 14:07:57 eperkov noship $ */
3
4 --
5 -- Procedures and Fuctions
6 --
7
8 FUNCTION Calculate_Base_Table (
9 x_base_table IN VARCHAR2,
10 x_input_table IN VARCHAR2,
11 x_correction_flag IN BOOLEAN,
12 x_aw_flag IN BOOLEAN
13 ) RETURN BOOLEAN;
14
15 FUNCTION Calculate_Base_Table_AT (
16 x_base_table IN VARCHAR2,
17 x_input_table IN VARCHAR2,
18 x_correction_flag IN BOOLEAN,
19 x_aw_flag IN BOOLEAN
20 ) RETURN BOOLEAN;
21
22 PROCEDURE Calc_New_Period_Input_Table(
23 x_input_table IN VARCHAR2,
24 x_periodicity IN NUMBER,
25 x_current_fy IN NUMBER,
26 x_period OUT NOCOPY NUMBER,
27 x_return_status OUT NOCOPY VARCHAR2,
28 x_error_message OUT NOCOPY VARCHAR2
29 );
30
31 PROCEDURE Calc_New_Period_Base_Table(
32 x_base_table IN VARCHAR2,
33 x_periodicity IN NUMBER,
34 x_current_fy IN NUMBER,
35 x_per_input_table IN NUMBER,
36 x_current_per_base_table OUT NOCOPY NUMBER,
37 x_per_base_table OUT NOCOPY NUMBER,
38 x_return_status OUT NOCOPY VARCHAR2,
39 x_error_message OUT NOCOPY VARCHAR2
40 );
41
42 PROCEDURE Calc_Projection(
43 x_base_table IN VARCHAR2,
44 x_proj_table IN VARCHAR2,
45 x_aw_flag IN BOOLEAN,
46 x_change_vector_value IN NUMBER,
47 x_periodicity IN NUMBER,
48 x_calendar_id IN NUMBER,
49 x_current_period IN NUMBER,
50 x_current_fy IN NUMBER,
51 x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
52 x_num_key_columns IN NUMBER,
53 x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
54 x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,
55 x_num_data_columns IN NUMBER,
56 x_partition_name IN VARCHAR2,
57 x_batch_value IN NUMBER,
58 x_parallel_jobs IN VARCHAR2,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_error_message OUT NOCOPY VARCHAR2
61 );
62
63 FUNCTION Create_Generic_Temp_Tables
64 RETURN BOOLEAN;
65
66 FUNCTION Create_Generic_Temp_Tables_AT
67 RETURN BOOLEAN;
68
69 PROCEDURE Create_Proc_Load_Tbl_MV(
70 x_proc_name IN VARCHAR2,
71 x_base_table IN VARCHAR2,
72 x_input_table IN VARCHAR2,
73 x_periodicity IN NUMBER,
74 x_calendar_id IN NUMBER,
75 x_current_period IN NUMBER,
76 x_old_current_period IN NUMBER,
77 x_current_fy IN NUMBER,
78 x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
79 x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
80 x_num_key_columns IN NUMBER,
81 x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
82 x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
83 x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
84 x_num_data_columns IN NUMBER,
85 x_partition_name IN VARCHAR2,
86 x_batch_value IN NUMBER,
87 x_num_partitions IN NUMBER,
88 x_parallel_jobs IN VARCHAR2,
89 x_rowid_table IN VARCHAR2,
90 x_num_loads IN NUMBER,
91 x_return_status OUT NOCOPY VARCHAR2,
92 x_error_message OUT NOCOPY VARCHAR2
93 );
94
95 PROCEDURE Create_Proc_Load_Tbl_SUM_AW(
96 x_proc_name IN VARCHAR2,
97 x_base_table IN VARCHAR2,
98 x_input_table IN VARCHAR2,
99 x_aw_flag IN BOOLEAN,
100 x_change_vector_value IN NUMBER,
101 x_periodicity IN NUMBER,
102 x_calendar_id IN NUMBER,
103 x_current_period IN NUMBER,
104 x_current_fy IN NUMBER,
105 x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
106 x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
107 x_num_key_columns IN NUMBER,
108 x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
109 x_num_data_columns IN NUMBER,
110 x_partition_name IN VARCHAR2,
111 x_batch_value IN NUMBER,
112 x_num_partitions IN NUMBER,
113 x_parallel_jobs IN VARCHAR2,
114 x_rowid_table IN VARCHAR2,
115 x_num_loads IN NUMBER,
116 x_return_status OUT NOCOPY VARCHAR2,
117 x_error_message OUT NOCOPY VARCHAR2
118 );
119
120 PROCEDURE Create_Types_For_MV_Load(
121 x_base_table IN VARCHAR2,
122 x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
123 x_num_key_columns IN NUMBER,
124 x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
125 x_num_data_columns IN NUMBER,
126 x_return_status OUT NOCOPY VARCHAR2,
127 x_error_message OUT NOCOPY VARCHAR2
128 );
129
130 FUNCTION Get_Base_Proj_Tbl_Name(
131 x_base_table IN VARCHAR2
132 ) RETURN VARCHAR2;
133
134 PROCEDURE Init_Bsc_Db_Calendar_Temp(
135 x_base_table IN VARCHAR2,
136 x_periodicity IN NUMBER,
137 x_calendar_id IN NUMBER,
138 x_current_period IN NUMBER,
139 x_current_fy IN NUMBER,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_error_message OUT NOCOPY VARCHAR2
142 );
143
144 PROCEDURE Init_Bsc_Db_Calendar_Temp_Proj(
145 x_base_table IN VARCHAR2,
146 x_periodicity IN NUMBER,
147 x_calendar_id IN NUMBER,
148 x_current_period IN NUMBER,
149 x_current_fy IN NUMBER,
150 x_return_status OUT NOCOPY VARCHAR2,
151 x_error_message OUT NOCOPY VARCHAR2
152 );
153
154 PROCEDURE Load_Input_Table_Inc(
155 x_base_table IN VARCHAR2,
156 x_input_table IN VARCHAR2,
157 x_aw_flag IN BOOLEAN,
158 x_change_vector_value IN NUMBER,
159 x_periodicity IN NUMBER,
160 x_calendar_id IN NUMBER,
161 x_current_period IN NUMBER,
162 x_old_current_period IN NUMBER,
163 x_current_fy IN NUMBER,
164 x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
165 x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
166 x_num_key_columns IN NUMBER,
167 x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
168 x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
169 x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
170 x_num_data_columns IN NUMBER,
171 x_partition_name IN VARCHAR2,
172 x_batch_value IN NUMBER,
173 x_num_partitions IN NUMBER,
174 x_parallel_jobs IN VARCHAR2,
175 x_rowid_table IN VARCHAR2,
176 x_num_loads IN NUMBER,
177 x_return_status OUT NOCOPY VARCHAR2,
178 x_error_message OUT NOCOPY VARCHAR2
179 );
180
181 PROCEDURE Load_Input_Table_Initial(
182 x_base_table IN VARCHAR2,
183 x_input_table IN VARCHAR2,
184 x_aw_flag IN BOOLEAN,
185 x_change_vector_value IN NUMBER,
186 x_periodicity IN NUMBER,
187 x_calendar_id IN NUMBER,
188 x_current_period IN NUMBER,
189 x_current_fy IN NUMBER,
190 x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
191 x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
192 x_num_key_columns IN NUMBER,
193 x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
194 x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
195 x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
196 x_num_data_columns IN NUMBER,
197 x_partition_name IN VARCHAR2,
198 x_batch_value IN NUMBER,
199 x_num_partitions IN NUMBER,
200 x_parallel_jobs IN VARCHAR2,
201 x_return_status OUT NOCOPY VARCHAR2,
202 x_error_message OUT NOCOPY VARCHAR2
203 );
204
205 PROCEDURE Calc_Higher_Periodicities(
206 x_base_table IN VARCHAR2,
207 x_periodicity IN NUMBER,
208 x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
209 x_num_key_columns IN NUMBER,
210 x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
211 x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
212 x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
213 x_num_data_columns IN NUMBER,
214 x_partition_name IN VARCHAR2,
215 x_batch_value IN NUMBER,
216 x_parallel_jobs IN VARCHAR2,
217 x_return_status OUT NOCOPY VARCHAR2,
218 x_error_message OUT NOCOPY VARCHAR2
219 );
220
221 PROCEDURE Update_Base_Table_Job (
222 x_base_table IN VARCHAR2,
223 x_input_table IN VARCHAR2,
224 x_correction_flag IN BOOLEAN,
225 x_aw_flag IN BOOLEAN,
226 x_change_vector_value IN NUMBER,
227 x_periodicity IN NUMBER,
228 x_calendar_id IN NUMBER,
229 x_current_fy IN NUMBER,
230 x_current_period IN NUMBER,
231 x_old_current_period IN NUMBER,
232 x_proj_table IN VARCHAR2,
233 x_rowid_table IN VARCHAR2,
234 x_partition_name IN VARCHAR2,
235 x_batch_value IN NUMBER,
236 x_num_partitions IN NUMBER,
237 x_num_loads IN NUMBER,
238 x_job_name IN VARCHAR2
239 );
240
241 PROCEDURE Update_Base_Table (
242 x_base_table IN VARCHAR2,
243 x_input_table IN VARCHAR2,
244 x_correction_flag IN BOOLEAN,
245 x_aw_flag IN BOOLEAN,
246 x_change_vector_value IN NUMBER,
247 x_periodicity IN NUMBER,
248 x_calendar_id IN NUMBER,
249 x_current_fy IN NUMBER,
250 x_current_period IN NUMBER,
251 x_old_current_period IN NUMBER,
252 x_key_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
253 x_key_dim_tables IN BSC_UPDATE_UTIL.t_array_of_varchar2,
254 x_num_key_columns IN NUMBER,
255 x_data_columns IN BSC_UPDATE_UTIL.t_array_of_varchar2,
256 x_data_formulas IN BSC_UPDATE_UTIL.t_array_of_varchar2,
257 x_data_proj_methods IN BSC_UPDATE_UTIL.t_array_of_number,
258 x_data_measure_types IN BSC_UPDATE_UTIL.t_array_of_number,
259 x_num_data_columns IN NUMBER,
260 x_proj_table IN VARCHAR2,
261 x_rowid_table IN VARCHAR2,
262 x_partition_name IN VARCHAR2,
263 x_batch_value IN NUMBER,
264 x_num_partitions IN NUMBER,
265 x_num_loads IN NUMBER,
266 x_parallel_jobs IN VARCHAR2,
267 x_return_status OUT NOCOPY VARCHAR2,
268 x_error_message OUT NOCOPY VARCHAR2
269 );
270
271
272 END BSC_UPDATE_BASE_V2;
[Home] [Help]