1 PACKAGE BODY CSI_COUNTER_VUHK AS
2 /* $Header: csivhcib.pls 120.0 2005/06/10 15:03:18 rktow noship $ */
3
4 -- --------------------------------------------------------
5 -- Define global variables
6 -- --------------------------------------------------------
7
8 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_COUNTER_VUHK';
9 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csivhcib.pls';
10
11 --|---------------------------------------------------
12 --| procedure name: create_counter_pre
13 --| description : procedure used to
14 --| create counter instance
15 --|---------------------------------------------------
16
17 PROCEDURE create_counter_pre
18 (
19 p_api_version IN NUMBER
20 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
21 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
22 ,p_validation_level IN NUMBER
23 ,p_counter_instance_rec IN CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
24 ,P_ctr_properties_tbl IN CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
25 ,P_counter_relationships_tbl IN CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
26 ,P_ctr_derived_filters_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
27 ,P_counter_associations_tbl IN CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl
28 ,x_return_status out NOCOPY VARCHAR2
29 ,x_msg_count out NOCOPY NUMBER
30 ,x_msg_data out NOCOPY VARCHAR2
31 ,x_ctr_id out nocopy NUMBER
32 ) IS
33 BEGIN
34 x_return_status := FND_API.G_RET_STS_SUCCESS;
35 END create_counter_pre;
36
37
38
39 --|---------------------------------------------------
40 --| procedure name: create_counter_post
41 --| description : procedure used to
42 --| create counter instance
43 --|---------------------------------------------------
44
45 PROCEDURE create_counter_post
46 (
47 p_api_version IN NUMBER
48 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
49 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
50 ,p_validation_level IN NUMBER
51 ,p_counter_instance_rec IN CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
52 ,P_ctr_properties_tbl IN CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
53 ,P_counter_relationships_tbl IN CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
54 ,P_ctr_derived_filters_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
55 ,P_counter_associations_tbl IN CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl
56 ,x_return_status out NOCOPY VARCHAR2
57 ,x_msg_count out NOCOPY NUMBER
58 ,x_msg_data out NOCOPY VARCHAR2
59 ,x_ctr_id out nocopy NUMBER
60
61 ) IS
62 BEGIN
63 x_return_status := FND_API.G_RET_STS_SUCCESS;
64 END create_counter_post;
65
66
67
68 --|---------------------------------------------------
69 --| procedure name: create_ctr_property_pre
70 --| description : procedure used to
71 --| create counter properties
72 --|---------------------------------------------------
73
74 PROCEDURE create_ctr_property_pre
75 (
76 p_api_version IN NUMBER
77 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
78 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
79 ,p_validation_level IN NUMBER
80 ,P_ctr_properties_tbl IN CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
81 ,x_return_status OUT NOCOPY VARCHAR2
82 ,x_msg_count OUT NOCOPY NUMBER
83 ,x_msg_data OUT NOCOPY VARCHAR2
84 ,x_ctr_property_id OUT NOCOPY NUMBER
85 ) IS
86 BEGIN
87 x_return_status := FND_API.G_RET_STS_SUCCESS;
88 END create_ctr_property_pre;
89
90
91
92 --|---------------------------------------------------
93 --| procedure name: create_ctr_property_post
94 --| description : procedure used to
95 --| create counter properties
96 --|---------------------------------------------------
97
98 PROCEDURE create_ctr_property_post
99 (
100 p_api_version IN NUMBER
101 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
102 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
103 ,p_validation_level IN NUMBER
104 ,P_ctr_properties_tbl IN CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
105 ,x_return_status OUT NOCOPY VARCHAR2
106 ,x_msg_count OUT NOCOPY NUMBER
107 ,x_msg_data OUT NOCOPY VARCHAR2
108 ,x_ctr_property_id OUT NOCOPY NUMBER
109 ) IS
110 BEGIN
111 x_return_status := FND_API.G_RET_STS_SUCCESS;
112 END create_ctr_property_post;
113
114
115
116 --|---------------------------------------------------
117 --| procedure name: create_ctr_associations_pre
118 --| description : procedure used to
119 --| create counter associations
120 --|---------------------------------------------------
121
122 PROCEDURE create_ctr_associations_pre
123 (
124 p_api_version IN NUMBER
125 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
126 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
127 ,p_validation_level IN NUMBER
128 ,P_counter_associations_tbl IN CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl
129 ,x_return_status OUT NOCOPY VARCHAR2
130 ,x_msg_count OUT NOCOPY NUMBER
131 ,x_msg_data OUT NOCOPY VARCHAR2
132 ,x_instance_association_id OUT NOCOPY NUMBER
133 ) IS
134 BEGIN
135 x_return_status := FND_API.G_RET_STS_SUCCESS;
136 END create_ctr_associations_pre;
137
138
139
140 --|---------------------------------------------------
141 --| procedure name: create_ctr_associations_post
142 --| description : procedure used to
143 --| create counter associations
144 --|---------------------------------------------------
145
146 PROCEDURE create_ctr_associations_post
147 (
148 p_api_version IN NUMBER
149 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
150 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
151 ,p_validation_level IN NUMBER
152 ,P_counter_associations_tbl IN CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl
153 ,x_return_status OUT NOCOPY VARCHAR2
154 ,x_msg_count OUT NOCOPY NUMBER
155 ,x_msg_data OUT NOCOPY VARCHAR2
156 ,x_instance_association_id OUT NOCOPY NUMBER
157 ) IS
158 BEGIN
159 x_return_status := FND_API.G_RET_STS_SUCCESS;
160 END create_ctr_associations_post;
161
162
163
164 --|---------------------------------------------------
165 --| procedure name: create_reading_lock_pre
166 --| description : procedure used to
167 --| create reading lock on a counter
168 --|---------------------------------------------------
169
170 PROCEDURE create_reading_lock_pre
171 (
172 p_api_version IN NUMBER
173 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
174 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
175 ,p_validation_level IN NUMBER
176 ,p_ctr_reading_lock_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_reading_lock_rec
177 ,x_return_status OUT NOCOPY VARCHAR2
178 ,x_msg_count OUT NOCOPY NUMBER
179 ,x_msg_data OUT NOCOPY VARCHAR2
180 ,x_reading_lock_id OUT NOCOPY NUMBER
181 ) IS
182 BEGIN
183 x_return_status := FND_API.G_RET_STS_SUCCESS;
184 END create_reading_lock_pre;
185
186
187
188 --|---------------------------------------------------
189 --| procedure name: create_reading_lock_post
190 --| description : procedure used to
191 --| create reading lock on a counter
192 --|---------------------------------------------------
193
194 PROCEDURE create_reading_lock_post
195 (
196 p_api_version IN NUMBER
197 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
198 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
199 ,p_validation_level IN NUMBER
200 ,p_ctr_reading_lock_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_reading_lock_rec
201 ,x_return_status OUT NOCOPY VARCHAR2
202 ,x_msg_count OUT NOCOPY NUMBER
203 ,x_msg_data OUT NOCOPY VARCHAR2
204 ,x_reading_lock_id OUT NOCOPY NUMBER
205 ) IS
206 BEGIN
207 x_return_status := FND_API.G_RET_STS_SUCCESS;
208 END create_reading_lock_post;
209
210
211
212 --|---------------------------------------------------
213 --| procedure name: create_daily_usage_pre
214 --| description : procedure used to
215 --| create daily usage
216 --|---------------------------------------------------
217
218 PROCEDURE create_daily_usage_pre
219 (
220 p_api_version IN NUMBER
221 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
222 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
223 ,p_validation_level IN NUMBER
224 ,p_ctr_usage_forecast_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_usage_forecast_rec
225 ,x_return_status OUT NOCOPY VARCHAR2
226 ,x_msg_count OUT NOCOPY NUMBER
227 ,x_msg_data OUT NOCOPY VARCHAR2
228 ,x_instance_forecast_id OUT NOCOPY NUMBER
229 ) IS
230 BEGIN
231 x_return_status := FND_API.G_RET_STS_SUCCESS;
232 END create_daily_usage_pre;
233
234
235
236 --|---------------------------------------------------
237 --| procedure name: create_daily_usage_post
238 --| description : procedure used to
239 --| create daily usage
240 --|---------------------------------------------------
241
242 PROCEDURE create_daily_usage_post
243 (
244 p_api_version IN NUMBER
245 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
246 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
247 ,p_validation_level IN NUMBER
248 ,p_ctr_usage_forecast_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_usage_forecast_rec
249 ,x_return_status OUT NOCOPY VARCHAR2
250 ,x_msg_count OUT NOCOPY NUMBER
251 ,x_msg_data OUT NOCOPY VARCHAR2
252 ,x_instance_forecast_id OUT NOCOPY NUMBER
253 ) IS
254 BEGIN
255 x_return_status := FND_API.G_RET_STS_SUCCESS;
256 END create_daily_usage_post;
257
258
259
260 --|---------------------------------------------------
261 --| procedure name: update_counter_pre
262 --| description : procedure used to
263 --| update counter
264 --|---------------------------------------------------
265
266 PROCEDURE update_counter_pre
267 (
268 p_api_version IN NUMBER
269 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
270 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
271 ,p_validation_level IN NUMBER
272 ,p_counter_instance_rec IN CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
273 ,P_ctr_properties_tbl IN CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
274 ,P_counter_relationships_tbl IN CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
275 ,P_ctr_derived_filters_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
276 ,x_return_status out NOCOPY VARCHAR2
277 ,x_msg_count out NOCOPY NUMBER
278 ,x_msg_data out NOCOPY VARCHAR2
279 ) IS
280 BEGIN
281 x_return_status := FND_API.G_RET_STS_SUCCESS;
282 END update_counter_pre;
283
284
285
286 --|---------------------------------------------------
287 --| procedure name: update_counter_post
288 --| description : procedure used to
289 --| update counter
290 --|---------------------------------------------------
291
292 PROCEDURE update_counter_post
293 (
294 p_api_version IN NUMBER
295 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
299 ,P_ctr_properties_tbl IN CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
296 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
297 ,p_validation_level IN NUMBER
298 ,p_counter_instance_rec IN CSI_CTR_DATASTRUCTURES_PUB.Counter_instance_rec
300 ,P_counter_relationships_tbl IN CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
301 ,P_ctr_derived_filters_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
302 ,x_return_status out NOCOPY VARCHAR2
303 ,x_msg_count out NOCOPY NUMBER
304 ,x_msg_data out NOCOPY VARCHAR2
305 ) IS
306 BEGIN
307 x_return_status := FND_API.G_RET_STS_SUCCESS;
308 END update_counter_post;
309
310
311
312 --|---------------------------------------------------
313 --| procedure name: update_ctr_property_pre
314 --| description : procedure used to
315 --| update counter properties
316 --|---------------------------------------------------
317
318 PROCEDURE update_ctr_property_pre
319 (
320 p_api_version IN NUMBER
321 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
322 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
323 ,p_validation_level IN NUMBER
324 ,P_ctr_properties_tbl IN CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
325 ,x_return_status OUT NOCOPY VARCHAR2
326 ,x_msg_count OUT NOCOPY NUMBER
327 ,x_msg_data OUT NOCOPY VARCHAR2
328 ) IS
329 BEGIN
330 x_return_status := FND_API.G_RET_STS_SUCCESS;
331 END update_ctr_property_pre;
332
333
334
335 --|---------------------------------------------------
336 --| procedure name: update_ctr_property_post
337 --| description : procedure used to
338 --| update counter properties
339 --|---------------------------------------------------
340
341 PROCEDURE update_ctr_property_post
342 (
343 p_api_version IN NUMBER
344 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
345 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
346 ,p_validation_level IN NUMBER
347 ,P_ctr_properties_tbl IN CSI_CTR_DATASTRUCTURES_PUB.Ctr_properties_tbl
348 ,x_return_status OUT NOCOPY VARCHAR2
349 ,x_msg_count OUT NOCOPY NUMBER
350 ,x_msg_data OUT NOCOPY VARCHAR2
351 ) IS
352 BEGIN
353 x_return_status := FND_API.G_RET_STS_SUCCESS;
354 END update_ctr_property_post;
355
356
357
358 --|---------------------------------------------------
359 --| procedure name: update_ctr_associations_pre
360 --| description : procedure used to
361 --| update counter associations
362 --|---------------------------------------------------
363
364 PROCEDURE update_ctr_associations_pre
365 (
366 p_api_version IN NUMBER
367 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
368 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
369 ,p_validation_level IN NUMBER
370 ,P_counter_associations_tbl IN CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl
371 ,x_return_status OUT NOCOPY VARCHAR2
372 ,x_msg_count OUT NOCOPY NUMBER
373 ,x_msg_data OUT NOCOPY VARCHAR2
374 ) IS
375 BEGIN
376 x_return_status := FND_API.G_RET_STS_SUCCESS;
377 END update_ctr_associations_pre;
378
379
380
381 --|---------------------------------------------------
382 --| procedure name: update_ctr_associations_post
383 --| description : procedure used to
384 --| update counter associations
385 --|---------------------------------------------------
386
387 PROCEDURE update_ctr_associations_post
388 (
389 p_api_version IN NUMBER
390 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
391 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
392 ,p_validation_level IN NUMBER
393 ,P_counter_associations_tbl IN CSI_CTR_DATASTRUCTURES_PUB.counter_associations_tbl
394 ,x_return_status OUT NOCOPY VARCHAR2
395 ,x_msg_count OUT NOCOPY NUMBER
396 ,x_msg_data OUT NOCOPY VARCHAR2
397 ) IS
398 BEGIN
399 x_return_status := FND_API.G_RET_STS_SUCCESS;
400 END update_ctr_associations_post;
401
402
403
404 --|---------------------------------------------------
405 --| procedure name: update_reading_lock_pre
406 --| description : procedure used to
407 --| update reading lock on a counter
408 --|---------------------------------------------------
409
410 PROCEDURE update_reading_lock_pre
411 (
412 p_api_version IN NUMBER
413 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
414 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
415 ,p_validation_level IN NUMBER
416 ,p_ctr_reading_lock_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_reading_lock_rec
417 ,x_return_status OUT NOCOPY VARCHAR2
418 ,x_msg_count OUT NOCOPY NUMBER
419 ,x_msg_data OUT NOCOPY VARCHAR2
420 ) IS
421 BEGIN
422 x_return_status := FND_API.G_RET_STS_SUCCESS;
423 END update_reading_lock_pre;
424
425
426
427 --|---------------------------------------------------
428 --| procedure name: update_reading_lock_post
429 --| description : procedure used to
430 --| update reading lock on a counter
431 --|---------------------------------------------------
432
436 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
433 PROCEDURE update_reading_lock_post
434 (
435 p_api_version IN NUMBER
437 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
438 ,p_validation_level IN NUMBER
439 ,p_ctr_reading_lock_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_reading_lock_rec
440 ,x_return_status OUT NOCOPY VARCHAR2
441 ,x_msg_count OUT NOCOPY NUMBER
442 ,x_msg_data OUT NOCOPY VARCHAR2
443 ) IS
444 BEGIN
445 x_return_status := FND_API.G_RET_STS_SUCCESS;
446 END update_reading_lock_post;
447
448
449
450 --|---------------------------------------------------
451 --| procedure name: update_daily_usage_pre
452 --| description : procedure used to
453 --| update daily usage
454 --|---------------------------------------------------
455
456 PROCEDURE update_daily_usage_pre
457 (
458 p_api_version IN NUMBER
459 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
460 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
461 ,p_validation_level IN NUMBER
462 ,p_ctr_usage_forecast_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_usage_forecast_rec
463 ,x_return_status OUT NOCOPY VARCHAR2
464 ,x_msg_count OUT NOCOPY NUMBER
465 ,x_msg_data OUT NOCOPY VARCHAR2
466 ) IS
467 BEGIN
468 x_return_status := FND_API.G_RET_STS_SUCCESS;
469 END update_daily_usage_pre;
470
471
472
473 --|---------------------------------------------------
474 --| procedure name: update_daily_usage_post
475 --| description : procedure used to
476 --| update daily usage
477 --|---------------------------------------------------
478
479 PROCEDURE update_daily_usage_post
480 (
481 p_api_version IN NUMBER
482 ,p_commit IN VARCHAR2 := FND_API.G_FALSE
483 ,p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
484 ,p_validation_level IN NUMBER
485 ,p_ctr_usage_forecast_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_usage_forecast_rec
486 ,x_return_status OUT NOCOPY VARCHAR2
487 ,x_msg_count OUT NOCOPY NUMBER
488 ,x_msg_data OUT NOCOPY VARCHAR2
489 ) IS
490 BEGIN
491 x_return_status := FND_API.G_RET_STS_SUCCESS;
492 END update_daily_usage_post;
493
494 END CSI_COUNTER_VUHK;