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