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