1 PACKAGE CSI_COUNTER_TEMPLATE_CUHK AS
2 /* $Header: csichcts.pls 120.3 2005/09/19 13:03:12 epajaril noship $ */
3
4 -- --------------------------------------------------------
5 -- Define global variables
6 -- --------------------------------------------------------
7
8 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_COUNTER_TEMPLATE_CUHK';
9 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csichcts.pls';
10
11 --|---------------------------------------------------
12 --| procedure name: create_counter_group_pre
13 --| description : procedure used to
14 --| create counter group
15 --|---------------------------------------------------
16
17 PROCEDURE create_counter_group_pre
18 (p_api_version IN NUMBER
19 ,p_commit IN VARCHAR2
20 ,p_init_msg_list IN VARCHAR2
21 ,p_validation_level IN NUMBER
22 ,p_counter_groups_rec IN CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec
23 ,p_ctr_item_associations_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl
24 ,x_return_status OUT NOCOPY VARCHAR2
25 ,x_msg_count OUT NOCOPY NUMBER
26 ,x_msg_data OUT NOCOPY VARCHAR2
27 );
28
29
30
31 --|---------------------------------------------------
32 --| procedure name: create_counter_group_post
33 --| description : procedure used to
34 --| create counter group
35 --|---------------------------------------------------
36
37 PROCEDURE create_counter_group_post
38 (p_api_version IN NUMBER
39 ,p_commit IN VARCHAR2
40 ,p_init_msg_list IN VARCHAR2
41 ,p_validation_level IN NUMBER
42 ,p_counter_groups_rec IN CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec
43 ,p_ctr_item_associations_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl
44 ,x_return_status OUT NOCOPY VARCHAR2
45 ,x_msg_count OUT NOCOPY NUMBER
46 ,x_msg_data OUT NOCOPY VARCHAR2
47 );
48
49
50
51 --|---------------------------------------------------
52 --| procedure name: create_item_association_pre
53 --| description : procedure used to
54 --| create item association to
55 --| counter group or counters
56 --|---------------------------------------------------
57
58 PROCEDURE create_item_association_pre
59 (
60 p_api_version IN NUMBER
61 ,p_commit IN VARCHAR2
62 ,p_init_msg_list IN VARCHAR2
63 ,p_validation_level IN NUMBER
64 ,p_ctr_item_associations_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec
65 ,x_return_status OUT NOCOPY VARCHAR2
66 ,x_msg_count OUT NOCOPY NUMBER
67 ,x_msg_data OUT NOCOPY VARCHAR2
68 );
69
70
71
72 --|---------------------------------------------------
73 --| procedure name: create_item_association_post
74 --| description : procedure used to
75 --| create item association to
76 --| counter group or counters
77 --|---------------------------------------------------
78
79 PROCEDURE create_item_association_post
80 (
81 p_api_version IN NUMBER
82 ,p_commit IN VARCHAR2
83 ,p_init_msg_list IN VARCHAR2
84 ,p_validation_level IN NUMBER
85 ,p_ctr_item_associations_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec
86 ,x_return_status OUT NOCOPY VARCHAR2
87 ,x_msg_count OUT NOCOPY NUMBER
88 ,x_msg_data OUT NOCOPY VARCHAR2
89 );
90
91
92
93 --|---------------------------------------------------
94 --| procedure name: create_counter_template_pre
95 --| description : procedure used to
96 --| create counter template
97 --|---------------------------------------------------
98
99 PROCEDURE create_counter_template_pre
100 (
101 p_api_version IN NUMBER
102 ,p_commit IN VARCHAR2
103 ,p_init_msg_list IN VARCHAR2
104 ,p_validation_level IN NUMBER
105 ,p_counter_template_rec IN CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec
106 ,p_ctr_item_associations_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl
107 ,p_ctr_property_template_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl
108 ,p_counter_relationships_tbl IN CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
109 ,p_ctr_derived_filters_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
110 ,x_return_status OUT NOCOPY VARCHAR2
111 ,x_msg_count OUT NOCOPY NUMBER
112 ,x_msg_data OUT NOCOPY VARCHAR2
113 );
114
115
116
117 --|---------------------------------------------------
118 --| procedure name: create_counter_template_post
119 --| description : procedure used to
120 --| create counter template
121 --|---------------------------------------------------
122
123 PROCEDURE create_counter_template_post
124 (
125 p_api_version IN NUMBER
126 ,p_commit IN VARCHAR2
127 ,p_init_msg_list IN VARCHAR2
128 ,p_validation_level IN NUMBER
129 ,p_counter_template_rec IN CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec
130 ,p_ctr_item_associations_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl
131 ,p_ctr_property_template_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl
132 ,p_counter_relationships_tbl IN CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
133 ,p_ctr_derived_filters_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
134 ,x_return_status OUT NOCOPY VARCHAR2
135 ,x_msg_count OUT NOCOPY NUMBER
136 ,x_msg_data OUT NOCOPY VARCHAR2
137 );
138
139
140
141 --|---------------------------------------------------
142 --| procedure name: create_ctr_prop_template_pre
143 --| description : procedure used to
144 --| create counter properties
145 --|---------------------------------------------------
146
147 PROCEDURE create_ctr_prop_template_pre
148 (
149 p_api_version IN NUMBER
150 ,p_commit IN VARCHAR2
151 ,p_init_msg_list IN VARCHAR2
152 ,p_validation_level IN NUMBER
153 ,p_ctr_property_template_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec
154 ,x_return_status OUT NOCOPY VARCHAR2
155 ,x_msg_count OUT NOCOPY NUMBER
156 ,x_msg_data OUT NOCOPY VARCHAR2
157 );
158
159
160
161 --|---------------------------------------------------
162 --| procedure name: create_ctr_prop_template_post
163 --| description : procedure used to
164 --| create counter properties
165 --|---------------------------------------------------
166
167 PROCEDURE create_ctr_prop_template_post
168 (
169 p_api_version IN NUMBER
170 ,p_commit IN VARCHAR2
171 ,p_init_msg_list IN VARCHAR2
172 ,p_validation_level IN NUMBER
173 ,p_ctr_property_template_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec
174 ,x_return_status OUT NOCOPY VARCHAR2
175 ,x_msg_count OUT NOCOPY NUMBER
176 ,x_msg_data OUT NOCOPY VARCHAR2
177 );
178
179
180
181 --|---------------------------------------------------
182 --| procedure name: create_ctr_relationship_pre
183 --| description : procedure used to
184 --| create counter relationship
185 --|---------------------------------------------------
186
187 PROCEDURE create_ctr_relationship_pre
188 (
189 p_api_version IN NUMBER
190 ,p_commit IN VARCHAR2
191 ,p_init_msg_list IN VARCHAR2
192 ,p_validation_level IN NUMBER
193 ,p_counter_relationships_rec IN CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec
194 ,x_return_status OUT NOCOPY VARCHAR2
195 ,x_msg_count OUT NOCOPY NUMBER
196 ,x_msg_data OUT NOCOPY VARCHAR2
197 );
198
199
200
201 --|---------------------------------------------------
202 --| procedure name: create_ctr_relationship_post
203 --| description : procedure used to
204 --| create counter relationship
205 --|---------------------------------------------------
206
207 PROCEDURE create_ctr_relationship_post
208 (
209 p_api_version IN NUMBER
210 ,p_commit IN VARCHAR2
211 ,p_init_msg_list IN VARCHAR2
212 ,p_validation_level IN NUMBER
213 ,p_counter_relationships_rec IN CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec
214 ,x_return_status OUT NOCOPY VARCHAR2
215 ,x_msg_count OUT NOCOPY NUMBER
216 ,x_msg_data OUT NOCOPY VARCHAR2
217 );
218
219
220
221 --|---------------------------------------------------
222 --| procedure name: create_derived_filters_pre
223 --| description : procedure used to
224 --| create derived filters
225 --|---------------------------------------------------
226
227 PROCEDURE create_derived_filters_pre
228 (
229 p_api_version IN NUMBER
230 ,p_commit IN VARCHAR2
231 ,p_init_msg_list IN VARCHAR2
232 ,p_validation_level IN NUMBER
233 ,p_ctr_derived_filters_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
234 ,x_return_status OUT NOCOPY VARCHAR2
235 ,x_msg_count OUT NOCOPY NUMBER
236 ,x_msg_data OUT NOCOPY VARCHAR2
237 );
238
239
240
241 --|---------------------------------------------------
242 --| procedure name: create_derived_filters_post
243 --| description : procedure used to
244 --| create derived filters
245 --|---------------------------------------------------
246
247 PROCEDURE create_derived_filters_post
248 (
249 p_api_version IN NUMBER
250 ,p_commit IN VARCHAR2
251 ,p_init_msg_list IN VARCHAR2
252 ,p_validation_level IN NUMBER
253 ,p_ctr_derived_filters_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
254 ,x_return_status OUT NOCOPY VARCHAR2
255 ,x_msg_count OUT NOCOPY NUMBER
256 ,x_msg_data OUT NOCOPY VARCHAR2
257 );
258
259
260
261 --|---------------------------------------------------
262 --| procedure name: update_counter_group_pre
263 --| description : procedure used to
264 --| update counter group
265 --|---------------------------------------------------
266
267 PROCEDURE update_counter_group_pre
268 (
269 p_api_version IN NUMBER
270 ,p_commit IN VARCHAR2
271 ,p_init_msg_list IN VARCHAR2
272 ,p_validation_level IN NUMBER
273 ,p_counter_groups_rec IN CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec
274 ,p_ctr_item_associations_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl
275 ,x_return_status OUT NOCOPY VARCHAR2
276 ,x_msg_count OUT NOCOPY NUMBER
277 ,x_msg_data OUT NOCOPY VARCHAR2
278 );
279
280
281
282 --|---------------------------------------------------
283 --| procedure name: update_counter_group_post
284 --| description : procedure used to
285 --| update counter group
286 --|---------------------------------------------------
287
288 PROCEDURE update_counter_group_post
289 (
290 p_api_version IN NUMBER
291 ,p_commit IN VARCHAR2
292 ,p_init_msg_list IN VARCHAR2
293 ,p_validation_level IN NUMBER
294 ,p_counter_groups_rec IN CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec
295 ,p_ctr_item_associations_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl
296 ,x_return_status OUT NOCOPY VARCHAR2
297 ,x_msg_count OUT NOCOPY NUMBER
298 ,x_msg_data OUT NOCOPY VARCHAR2
299 );
300
301
302
303 --|---------------------------------------------------
304 --| procedure name: update_item_association_pre
305 --| description : procedure used to
306 --| update item association to
307 --| counter group or counters
308 --|---------------------------------------------------
309
310 PROCEDURE update_item_association_pre
311 (
312 p_api_version IN NUMBER
313 ,p_commit IN VARCHAR2
314 ,p_init_msg_list IN VARCHAR2
315 ,p_validation_level IN NUMBER
316 ,p_ctr_item_associations_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec
317 ,x_return_status OUT NOCOPY VARCHAR2
318 ,x_msg_count OUT NOCOPY NUMBER
319 ,x_msg_data OUT NOCOPY VARCHAR2
320 );
321
322
323
324 --|---------------------------------------------------
325 --| procedure name: update_item_association_post
326 --| description : procedure used to
327 --| update item association to
328 --| counter group or counters
329 --|---------------------------------------------------
330
331 PROCEDURE update_item_association_post
332 (
333 p_api_version IN NUMBER
334 ,p_commit IN VARCHAR2
335 ,p_init_msg_list IN VARCHAR2
336 ,p_validation_level IN NUMBER
337 ,p_ctr_item_associations_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec
338 ,x_return_status OUT NOCOPY VARCHAR2
339 ,x_msg_count OUT NOCOPY NUMBER
340 ,x_msg_data OUT NOCOPY VARCHAR2
341 );
342
343
344
345 --|---------------------------------------------------
346 --| procedure name: update_counter_template_pre
347 --| description : procedure used to
348 --| update counter template
349 --|---------------------------------------------------
350
351 PROCEDURE update_counter_template_pre
352 (
353 p_api_version IN NUMBER
354 ,p_commit IN VARCHAR2
355 ,p_init_msg_list IN VARCHAR2
356 ,p_validation_level IN NUMBER
357 ,p_counter_template_rec IN CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec
358 ,p_ctr_item_associations_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl
359 ,p_ctr_property_template_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl
360 ,p_counter_relationships_tbl IN CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
361 ,p_ctr_derived_filters_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
362 ,x_return_status OUT NOCOPY VARCHAR2
363 ,x_msg_count OUT NOCOPY NUMBER
364 ,x_msg_data OUT NOCOPY VARCHAR2
365 );
366
367
368
369 --|---------------------------------------------------
370 --| procedure name: update_counter_template_post
371 --| description : procedure used to
372 --| update counter template
373 --|---------------------------------------------------
374
375 PROCEDURE update_counter_template_post
376 (
377 p_api_version IN NUMBER
378 ,p_commit IN VARCHAR2
379 ,p_init_msg_list IN VARCHAR2
380 ,p_validation_level IN NUMBER
381 ,p_counter_template_rec IN CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec
382 ,p_ctr_item_associations_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl
383 ,p_ctr_property_template_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl
384 ,p_counter_relationships_tbl IN CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl
385 ,p_ctr_derived_filters_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
386 ,x_return_status OUT NOCOPY VARCHAR2
387 ,x_msg_count OUT NOCOPY NUMBER
388 ,x_msg_data OUT NOCOPY VARCHAR2
389 );
390
391
392
393 --|---------------------------------------------------
394 --| procedure name: update_ctr_prop_template_pre
395 --| description : procedure used to
396 --| create counter properties
397 --|---------------------------------------------------
398
399 PROCEDURE update_ctr_prop_template_pre
400 (
401 p_api_version IN NUMBER
402 ,p_commit IN VARCHAR2
403 ,p_init_msg_list IN VARCHAR2
404 ,p_validation_level IN NUMBER
405 ,p_ctr_property_template_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec
406 ,x_return_status OUT NOCOPY VARCHAR2
407 ,x_msg_count OUT NOCOPY NUMBER
411
408 ,x_msg_data OUT NOCOPY VARCHAR2
409 );
410
412
413 --|---------------------------------------------------
414 --| procedure name: update_ctr_prop_template_post
415 --| description : procedure used to
416 --| create counter properties
417 --|---------------------------------------------------
418
419 PROCEDURE update_ctr_prop_template_post
420 (
421 p_api_version IN NUMBER
422 ,p_commit IN VARCHAR2
423 ,p_init_msg_list IN VARCHAR2
424 ,p_validation_level IN NUMBER
425 ,p_ctr_property_template_rec IN CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec
426 ,x_return_status OUT NOCOPY VARCHAR2
427 ,x_msg_count OUT NOCOPY NUMBER
428 ,x_msg_data OUT NOCOPY VARCHAR2
429 );
430
431
432
433 --|---------------------------------------------------
434 --| procedure name: update_ctr_relationship_pre
435 --| description : procedure used to
436 --| update counter relationship
437 --|---------------------------------------------------
438
439 PROCEDURE update_ctr_relationship_pre
440 (
441 p_api_version IN NUMBER
442 ,p_commit IN VARCHAR2
443 ,p_init_msg_list IN VARCHAR2
444 ,p_validation_level IN NUMBER
445 ,p_counter_relationships_rec IN CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec
446 ,x_return_status OUT NOCOPY VARCHAR2
447 ,x_msg_count OUT NOCOPY NUMBER
448 ,x_msg_data OUT NOCOPY VARCHAR2
449 );
450
451
452
453 --|---------------------------------------------------
454 --| procedure name: update_ctr_relationship_post
455 --| description : procedure used to
456 --| update counter relationship
457 --|---------------------------------------------------
458
459 PROCEDURE update_ctr_relationship_post
460 (
461 p_api_version IN NUMBER
462 ,p_commit IN VARCHAR2
463 ,p_init_msg_list IN VARCHAR2
464 ,p_validation_level IN NUMBER
465 ,p_counter_relationships_rec IN CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec
466 ,x_return_status OUT NOCOPY VARCHAR2
467 ,x_msg_count OUT NOCOPY NUMBER
468 ,x_msg_data OUT NOCOPY VARCHAR2
469 );
470
471
472
473 --|---------------------------------------------------
474 --| procedure name: update_derived_filters_pre
475 --| description : procedure used to
476 --| update derived filters
477 --|---------------------------------------------------
478
479 PROCEDURE update_derived_filters_pre
480 (
481 p_api_version IN NUMBER
482 ,p_commit IN VARCHAR2
483 ,p_init_msg_list IN VARCHAR2
484 ,p_validation_level IN NUMBER
485 ,p_ctr_derived_filters_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
486 ,x_return_status OUT NOCOPY VARCHAR2
487 ,x_msg_count OUT NOCOPY NUMBER
488 ,x_msg_data OUT NOCOPY VARCHAR2
489 );
490
491
492
493 --|---------------------------------------------------
494 --| procedure name: update_derived_filters_post
495 --| description : procedure used to
496 --| update derived filters
497 --|---------------------------------------------------
498
499 PROCEDURE update_derived_filters_post
500 (
501 p_api_version IN NUMBER
502 ,p_commit IN VARCHAR2
503 ,p_init_msg_list IN VARCHAR2
504 ,p_validation_level IN NUMBER
505 ,p_ctr_derived_filters_tbl IN CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl
506 ,x_return_status OUT NOCOPY VARCHAR2
507 ,x_msg_count OUT NOCOPY NUMBER
508 ,x_msg_data OUT NOCOPY VARCHAR2
509 );
510
511
512
513 PROCEDURE Create_Estimation_Method_pre
514 (
515 p_api_version IN NUMBER
516 ,p_init_msg_list IN VARCHAR2
517 ,p_commit IN VARCHAR2
518 ,p_validation_level IN VARCHAR2
519 ,x_return_status OUT NOCOPY VARCHAR2
520 ,x_msg_count OUT NOCOPY NUMBER
521 ,x_msg_data OUT NOCOPY VARCHAR2
522 ,p_ctr_estimation_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec
523 );
524
525
526
527 PROCEDURE Create_Estimation_Method_post
528 (
529 p_api_version IN NUMBER
530 ,p_init_msg_list IN VARCHAR2
531 ,p_commit IN VARCHAR2
532 ,p_validation_level IN VARCHAR2
533 ,x_return_status OUT NOCOPY VARCHAR2
534 ,x_msg_count OUT NOCOPY NUMBER
535 ,x_msg_data OUT NOCOPY VARCHAR2
536 ,p_ctr_estimation_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec
537 );
538
539
540
541 PROCEDURE Update_Estimation_Method_pre
542 (
543 p_api_version IN NUMBER
544 ,p_init_msg_list IN VARCHAR2
545 ,p_commit IN VARCHAR2
546 ,p_validation_level IN VARCHAR2
547 ,x_return_status OUT NOCOPY VARCHAR2
548 ,x_msg_count OUT NOCOPY NUMBER
549 ,x_msg_data OUT NOCOPY VARCHAR2
553
550 ,p_ctr_estimation_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec
551 );
552
554
555 PROCEDURE Update_Estimation_Method_post
556 (
557 p_api_version IN NUMBER
558 ,p_init_msg_list IN VARCHAR2
559 ,p_commit IN VARCHAR2
560 ,p_validation_level IN VARCHAR2
561 ,x_return_status OUT NOCOPY VARCHAR2
562 ,x_msg_count OUT NOCOPY NUMBER
563 ,x_msg_data OUT NOCOPY VARCHAR2
564 ,p_ctr_estimation_rec IN OUT NOCOPY CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec
565 );
566
567
568
569 PROCEDURE AutoInstantiate_Counters_pre
570 (
571 p_api_version IN NUMBER
572 ,p_init_msg_list IN VARCHAR2
573 ,p_commit IN VARCHAR2
574 ,x_return_status OUT NOCOPY VARCHAR2
575 ,x_msg_count OUT NOCOPY NUMBER
576 ,x_msg_data OUT NOCOPY VARCHAR2
577 ,p_source_object_id_template IN NUMBER
578 ,p_source_object_id_instance IN NUMBER
579 ,x_ctr_id_template IN CSI_COUNTER_TEMPLATE_PUB.ctr_template_autoinst_tbl
580 ,x_ctr_id_instance IN CSI_COUNTER_TEMPLATE_PUB.counter_autoinstantiate_tbl
581 ,x_ctr_grp_id_template IN NUMBER
582 ,x_ctr_grp_id_instance IN NUMBER
583 ,p_organization_id IN NUMBER
584 );
585
586
587
588 PROCEDURE AutoInstantiate_Counters_post
589 (
590 p_api_version IN NUMBER
591 ,p_init_msg_list IN VARCHAR2
592 ,p_commit IN VARCHAR2
593 ,x_return_status OUT NOCOPY VARCHAR2
594 ,x_msg_count OUT NOCOPY NUMBER
595 ,x_msg_data OUT NOCOPY VARCHAR2
596 ,p_source_object_id_template IN NUMBER
597 ,p_source_object_id_instance IN NUMBER
598 ,x_ctr_id_template IN CSI_COUNTER_TEMPLATE_PUB.ctr_template_autoinst_tbl
599 ,x_ctr_id_instance IN CSI_COUNTER_TEMPLATE_PUB.counter_autoinstantiate_tbl
600 ,x_ctr_grp_id_template IN NUMBER
601 ,x_ctr_grp_id_instance IN NUMBER
602 ,p_organization_id IN NUMBER
603 );
604
605
606
607 PROCEDURE Instantiate_Counters_pre
608 (
609 p_api_version IN NUMBER
610 ,p_init_msg_list IN VARCHAR2
611 ,p_commit IN VARCHAR2
612 ,x_return_status OUT NOCOPY VARCHAR2
613 ,x_msg_count OUT NOCOPY NUMBER
614 ,x_msg_data OUT NOCOPY VARCHAR2
615 ,p_counter_id_template IN NUMBER
616 ,p_source_object_code_instance IN VARCHAR2
617 ,p_source_object_id_instance IN NUMBER
618 ,x_ctr_id_template OUT NOCOPY NUMBER
619 ,x_ctr_id_instance OUT NOCOPY NUMBER
620 );
621
622
623
624 PROCEDURE Instantiate_Counters_post
625 (
626 p_api_version IN NUMBER
627 ,p_init_msg_list IN VARCHAR2
628 ,p_commit IN VARCHAR2
629 ,x_return_status OUT NOCOPY VARCHAR2
630 ,x_msg_count OUT NOCOPY NUMBER
631 ,x_msg_data OUT NOCOPY VARCHAR2
632 ,p_counter_id_template IN NUMBER
633 ,p_source_object_code_instance IN VARCHAR2
634 ,p_source_object_id_instance IN NUMBER
635 ,x_ctr_id_template OUT NOCOPY NUMBER
636 ,x_ctr_id_instance OUT NOCOPY NUMBER
637 );
638
639 PROCEDURE delete_item_association_pre
640 (
641 p_api_version IN NUMBER
642 ,p_commit IN VARCHAR2
643 ,p_init_msg_list IN VARCHAR2
644 ,p_validation_level IN NUMBER
645 ,p_ctr_associations_id IN NUMBER
646 ,x_return_status OUT NOCOPY VARCHAR2
647 ,x_msg_count OUT NOCOPY NUMBER
648 ,x_msg_data OUT NOCOPY VARCHAR2
649 );
650
651 PROCEDURE delete_item_association_post
652 (
653 p_api_version IN NUMBER
654 ,p_commit IN VARCHAR2
655 ,p_init_msg_list IN VARCHAR2
656 ,p_validation_level IN NUMBER
657 ,p_ctr_associations_id IN NUMBER
658 ,x_return_status OUT NOCOPY VARCHAR2
659 ,x_msg_count OUT NOCOPY NUMBER
660 ,x_msg_data OUT NOCOPY VARCHAR2
661 );
662
663 END CSI_COUNTER_TEMPLATE_CUHK;