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