1 PACKAGE CS_COUNTERS_VUHK AUTHID CURRENT_USER as
2 /* $Header: csxictrs.pls 115.4 2002/11/01 21:14:57 mkommuri noship $*/
3 -- Start of Comments
4 -- Package name : CS_COUNTERS_VUHK
5 -- Purpose : Vertical Hookup for Counters
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 PROCEDURE CREATE_CTR_GRP_TEMPLATE_PRE(
11 P_Api_Version IN NUMBER,
12 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
13 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
14 X_Return_Status OUT NOCOPY VARCHAR2,
15 X_Msg_Count OUT NOCOPY NUMBER,
16 X_Msg_Data OUT NOCOPY VARCHAR2,
17 p_ctr_grp_rec IN CS_COUNTERS_PUB.CtrGrp_Rec_Type,
18 x_ctr_grp_id IN NUMBER,
19 x_object_version_number OUT NOCOPY NUMBER
20 );
21
22 PROCEDURE CREATE_CTR_GRP_TEMPLATE_POST(
23 P_Api_Version IN NUMBER,
24 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
25 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
26 X_Return_Status OUT NOCOPY VARCHAR2,
27 X_Msg_Count OUT NOCOPY NUMBER,
28 X_Msg_Data OUT NOCOPY VARCHAR2,
29 p_ctr_grp_rec IN CS_COUNTERS_PUB.CtrGrp_Rec_Type,
30 x_ctr_grp_id IN NUMBER,
31 x_object_version_number OUT NOCOPY NUMBER
32 );
33
34 PROCEDURE CREATE_CTR_GRP_INSTANCE_PRE(
35 P_Api_Version IN NUMBER,
36 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
37 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
38 X_Return_Status OUT NOCOPY VARCHAR2,
39 X_Msg_Count OUT NOCOPY NUMBER,
40 X_Msg_Data OUT NOCOPY VARCHAR2,
41 p_ctr_grp_rec IN CS_COUNTERS_PUB.CtrGrp_Rec_Type,
42 p_source_object_cd IN VARCHAR2,
43 p_source_object_id IN NUMBER,
44 x_ctr_grp_id IN NUMBER,
45 x_object_version_number OUT NOCOPY NUMBER
46 );
47
48 PROCEDURE CREATE_CTR_GRP_INSTANCE_POST(
49 P_Api_Version IN NUMBER,
50 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
51 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
52 X_Return_Status OUT NOCOPY VARCHAR2,
53 X_Msg_Count OUT NOCOPY NUMBER,
54 X_Msg_Data OUT NOCOPY VARCHAR2,
55 p_ctr_grp_rec IN CS_COUNTERS_PUB.CtrGrp_Rec_Type,
56 p_source_object_cd IN VARCHAR2,
57 p_source_object_id IN NUMBER,
58 x_ctr_grp_id IN NUMBER,
59 x_object_version_number OUT NOCOPY NUMBER
60 );
61
62 PROCEDURE CREATE_COUNTER_PRE(
63 P_Api_Version IN NUMBER,
64 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
65 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
66 X_Return_Status OUT NOCOPY VARCHAR2,
67 X_Msg_Count OUT NOCOPY NUMBER,
68 X_Msg_Data OUT NOCOPY VARCHAR2,
69 p_ctr_rec IN CS_COUNTERS_PUB.Ctr_Rec_Type,
70 x_ctr_id IN NUMBER,
71 x_object_version_number OUT NOCOPY NUMBER
72 );
73
74 PROCEDURE CREATE_COUNTER_POST(
75 P_Api_Version IN NUMBER,
76 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
77 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
78 X_Return_Status OUT NOCOPY VARCHAR2,
79 X_Msg_Count OUT NOCOPY NUMBER,
80 X_Msg_Data OUT NOCOPY VARCHAR2,
81 p_ctr_rec IN CS_COUNTERS_PUB.Ctr_Rec_Type,
82 x_ctr_id IN NUMBER,
83 x_object_version_number OUT NOCOPY NUMBER
84 );
85
86 PROCEDURE CREATE_CTR_PROP_PRE(
87 P_Api_Version IN NUMBER,
88 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
89 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
90 X_Return_Status OUT NOCOPY VARCHAR2,
91 X_Msg_Count OUT NOCOPY NUMBER,
92 X_Msg_Data OUT NOCOPY VARCHAR2,
93 p_ctr_prop_rec IN CS_COUNTERS_PUB.Ctr_Prop_Rec_Type,
94 x_ctr_prop_id IN NUMBER,
95 x_object_version_number OUT NOCOPY NUMBER
96 );
97
98 PROCEDURE CREATE_CTR_PROP_POST(
99 P_Api_Version IN NUMBER,
100 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
101 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
102 X_Return_Status OUT NOCOPY VARCHAR2,
103 X_Msg_Count OUT NOCOPY NUMBER,
104 X_Msg_Data OUT NOCOPY VARCHAR2,
105 p_ctr_prop_rec IN CS_COUNTERS_PUB.Ctr_Prop_Rec_Type,
106 x_ctr_prop_id IN NUMBER,
107 x_object_version_number OUT NOCOPY NUMBER
108 );
109
110 PROCEDURE CREATE_FORMULA_REF_PRE(
111 P_Api_Version IN NUMBER,
112 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
113 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
114 X_Return_Status OUT NOCOPY VARCHAR2,
115 X_Msg_Count OUT NOCOPY NUMBER,
116 X_Msg_Data OUT NOCOPY VARCHAR2,
117 p_counter_id IN NUMBER,
118 p_bind_var_name IN VARCHAR2,
119 p_mapped_item_id IN NUMBER default null,
120 p_mapped_counter_id IN NUMBER,
121 x_ctr_formula_bvar_id IN NUMBER,
122 x_object_version_number OUT NOCOPY NUMBER,
123 p_reading_type IN VARCHAR2
124 );
125
126 PROCEDURE CREATE_FORMULA_REF_POST(
127 P_Api_Version IN NUMBER,
128 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
129 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
130 X_Return_Status OUT NOCOPY VARCHAR2,
131 X_Msg_Count OUT NOCOPY NUMBER,
132 X_Msg_Data OUT NOCOPY VARCHAR2,
133 p_counter_id IN NUMBER,
134 p_bind_var_name IN VARCHAR2,
135 p_mapped_item_id IN NUMBER default null,
136 p_mapped_counter_id IN NUMBER,
137 x_ctr_formula_bvar_id IN NUMBER,
138 x_object_version_number OUT NOCOPY NUMBER,
139 p_reading_type IN VARCHAR2
140 );
141
142 PROCEDURE CREATE_GRPOP_FILTER_PRE(
143 P_Api_Version IN NUMBER,
144 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
145 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
146 X_Return_Status OUT NOCOPY VARCHAR2,
147 X_Msg_Count OUT NOCOPY NUMBER,
148 X_Msg_Data OUT NOCOPY VARCHAR2,
149 p_seq_no IN NUMBER,
150 p_counter_id IN NUMBER,
151 p_left_paren IN VARCHAR2,
152 p_ctr_prop_id IN NUMBER,
153 p_rel_op IN VARCHAR2,
154 p_right_val IN VARCHAR2,
155 p_right_paren IN VARCHAR2,
156 p_log_op IN VARCHAR2,
157 x_ctr_der_filter_id IN NUMBER,
158 x_object_version_number OUT NOCOPY NUMBER
159 );
160
161 PROCEDURE CREATE_GRPOP_FILTER_POST(
162 P_Api_Version IN NUMBER,
163 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
164 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
165 X_Return_Status OUT NOCOPY VARCHAR2,
166 X_Msg_Count OUT NOCOPY NUMBER,
167 X_Msg_Data OUT NOCOPY VARCHAR2,
168 p_seq_no IN NUMBER,
169 p_counter_id IN NUMBER,
170 p_left_paren IN VARCHAR2,
171 p_ctr_prop_id IN NUMBER,
172 p_rel_op IN VARCHAR2,
173 p_right_val IN VARCHAR2,
174 p_right_paren IN VARCHAR2,
175 p_log_op IN VARCHAR2,
176 x_ctr_der_filter_id IN NUMBER,
177 x_object_version_number OUT NOCOPY NUMBER
178 );
179
180 PROCEDURE CREATE_CTR_ASSOCIATION_PRE(
181 P_Api_Version IN NUMBER,
182 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
183 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
184 X_Return_Status OUT NOCOPY VARCHAR2,
185 X_Msg_Count OUT NOCOPY NUMBER,
186 X_Msg_Data OUT NOCOPY VARCHAR2,
187 p_ctr_grp_id IN NUMBER,
188 p_source_object_id IN NUMBER,
189 x_ctr_association_id IN NUMBER,
190 x_object_version_number OUT NOCOPY NUMBER
191 );
192
193 PROCEDURE CREATE_CTR_ASSOCIATION_POST(
194 P_Api_Version IN NUMBER,
195 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
196 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
197 X_Return_Status OUT NOCOPY VARCHAR2,
198 X_Msg_Count OUT NOCOPY NUMBER,
199 X_Msg_Data OUT NOCOPY VARCHAR2,
200 p_ctr_grp_id IN NUMBER,
201 p_source_object_id IN NUMBER,
202 x_ctr_association_id IN NUMBER,
203 x_object_version_number OUT NOCOPY NUMBER
204 );
205
206 PROCEDURE AUTOINSTANTIATE_COUNTERS_PRE(
207 P_Api_Version IN NUMBER,
208 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
209 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
210 X_Return_Status OUT NOCOPY VARCHAR2,
211 X_Msg_Count OUT NOCOPY NUMBER,
212 X_Msg_Data OUT NOCOPY VARCHAR2,
213 p_source_object_id_template IN NUMBER,
214 p_source_object_id_instance IN NUMBER,
215 x_ctr_grp_id_template IN NUMBER,
216 x_ctr_grp_id_instance IN NUMBER
217 );
218
219 PROCEDURE AUTOINSTANTIATE_COUNTERS_POST(
220 P_Api_Version IN NUMBER,
221 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
222 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
223 X_Return_Status OUT NOCOPY VARCHAR2,
224 X_Msg_Count OUT NOCOPY NUMBER,
225 X_Msg_Data OUT NOCOPY VARCHAR2,
226 p_source_object_id_template IN NUMBER,
227 p_source_object_id_instance IN NUMBER,
228 x_ctr_grp_id_template IN NUMBER,
229 x_ctr_grp_id_instance IN NUMBER
230 );
231
232 PROCEDURE INSTANTIATE_COUNTERS_PRE(
233 P_Api_Version IN NUMBER,
234 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
235 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
236 X_Return_Status OUT NOCOPY VARCHAR2,
237 X_Msg_Count OUT NOCOPY NUMBER,
238 X_Msg_Data OUT NOCOPY VARCHAR2,
239 p_counter_group_id_template IN NUMBER,
240 p_source_object_code_instance IN VARCHAR2,
241 p_source_object_id_instance IN NUMBER,
242 x_ctr_grp_id_template IN NUMBER,
243 x_ctr_grp_id_instance IN NUMBER
244 );
245
246 PROCEDURE INSTANTIATE_COUNTERS_POST(
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 X_Return_Status OUT NOCOPY VARCHAR2,
251 X_Msg_Count OUT NOCOPY NUMBER,
252 X_Msg_Data OUT NOCOPY VARCHAR2,
253 p_counter_group_id_template IN NUMBER,
254 p_source_object_code_instance IN VARCHAR2,
255 p_source_object_id_instance IN NUMBER,
256 x_ctr_grp_id_template IN NUMBER,
257 x_ctr_grp_id_instance IN NUMBER
258 );
259
260 PROCEDURE UPDATE_CTR_GRP_PRE(
261 P_Api_Version IN NUMBER,
262 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
263 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
264 X_Return_Status OUT NOCOPY VARCHAR2,
265 X_Msg_Count OUT NOCOPY NUMBER,
266 X_Msg_Data OUT NOCOPY VARCHAR2,
267 p_ctr_grp_id IN NUMBER,
268 p_object_version_number IN NUMBER,
269 p_ctr_grp_rec IN CS_COUNTERS_PUB.CtrGrp_Rec_Type,
270 p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
271 x_object_version_number OUT NOCOPY NUMBER
272 );
273
274 PROCEDURE UPDATE_CTR_GRP_POST(
275 P_Api_Version IN NUMBER,
276 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
277 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
278 X_Return_Status OUT NOCOPY VARCHAR2,
279 X_Msg_Count OUT NOCOPY NUMBER,
280 X_Msg_Data OUT NOCOPY VARCHAR2,
281 p_ctr_grp_id IN NUMBER,
282 p_object_version_number IN NUMBER,
283 p_ctr_grp_rec IN CS_COUNTERS_PUB.CtrGrp_Rec_Type,
284 p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
285 x_object_version_number OUT NOCOPY NUMBER
286 );
287
288 PROCEDURE UPDATE_COUNTER_PRE(
289 P_Api_Version IN NUMBER,
290 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
291 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
292 X_Return_Status OUT NOCOPY VARCHAR2,
293 X_Msg_Count OUT NOCOPY NUMBER,
294 X_Msg_Data OUT NOCOPY VARCHAR2,
295 p_ctr_id IN NUMBER,
296 p_object_version_number IN NUMBER,
297 p_ctr_rec IN CS_COUNTERS_PUB.Ctr_Rec_Type,
298 p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
299 x_object_version_number OUT NOCOPY NUMBER
300 );
301
302 PROCEDURE UPDATE_COUNTER_POST(
303 P_Api_Version IN NUMBER,
304 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
305 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
306 X_Return_Status OUT NOCOPY VARCHAR2,
307 X_Msg_Count OUT NOCOPY NUMBER,
308 X_Msg_Data OUT NOCOPY VARCHAR2,
309 p_ctr_id IN NUMBER,
310 p_object_version_number IN NUMBER,
311 p_ctr_rec IN CS_COUNTERS_PUB.Ctr_Rec_Type,
312 p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
313 x_object_version_number OUT NOCOPY NUMBER
314 );
315
316 PROCEDURE UPDATE_CTR_PROP_PRE(
317 P_Api_Version IN NUMBER,
318 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
319 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
320 X_Return_Status OUT NOCOPY VARCHAR2,
321 X_Msg_Count OUT NOCOPY NUMBER,
322 X_Msg_Data OUT NOCOPY VARCHAR2,
323 p_ctr_prop_id IN NUMBER,
324 p_object_version_number IN NUMBER,
325 p_ctr_prop_rec IN CS_COUNTERS_PUB.Ctr_Prop_Rec_Type,
326 p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
327 x_object_version_number OUT NOCOPY NUMBER
328 );
329
330 PROCEDURE UPDATE_CTR_PROP_POST(
331 P_Api_Version IN NUMBER,
332 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
333 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
334 X_Return_Status OUT NOCOPY VARCHAR2,
335 X_Msg_Count OUT NOCOPY NUMBER,
336 X_Msg_Data OUT NOCOPY VARCHAR2,
337 p_ctr_prop_id IN NUMBER,
338 p_object_version_number IN NUMBER,
339 p_ctr_prop_rec IN CS_COUNTERS_PUB.Ctr_Prop_Rec_Type,
340 p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
341 x_object_version_number OUT NOCOPY NUMBER
342 );
343
344 PROCEDURE UPDATE_FORMULA_REF_PRE(
345 P_Api_Version IN NUMBER,
346 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
347 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
348 X_Return_Status OUT NOCOPY VARCHAR2,
349 X_Msg_Count OUT NOCOPY NUMBER,
350 X_Msg_Data OUT NOCOPY VARCHAR2,
351 p_ctr_formula_bvar_id IN NUMBER,
352 p_object_version_number IN NUMBER,
353 p_counter_id IN NUMBER,
354 p_bind_var_name IN VARCHAR2,
355 p_mapped_item_id IN NUMBER,
356 p_mapped_counter_id IN NUMBER,
357 p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
358 x_object_version_number OUT NOCOPY NUMBER,
359 p_reading_type IN VARCHAR2
360 );
361
362 PROCEDURE UPDATE_FORMULA_REF_POST(
363 P_Api_Version IN NUMBER,
364 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
365 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
366 X_Return_Status OUT NOCOPY VARCHAR2,
367 X_Msg_Count OUT NOCOPY NUMBER,
368 X_Msg_Data OUT NOCOPY VARCHAR2,
369 p_ctr_formula_bvar_id IN NUMBER,
370 p_object_version_number IN NUMBER,
371 p_counter_id IN NUMBER,
372 p_bind_var_name IN VARCHAR2,
373 p_mapped_item_id IN NUMBER,
374 p_mapped_counter_id IN NUMBER,
375 p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
376 x_object_version_number OUT NOCOPY NUMBER,
377 p_reading_type IN VARCHAR2
378 );
379
380 PROCEDURE UPDATE_GRPOP_FILTER_PRE(
381 P_Api_Version IN NUMBER,
382 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
383 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
384 X_Return_Status OUT NOCOPY VARCHAR2,
385 X_Msg_Count OUT NOCOPY NUMBER,
386 X_Msg_Data OUT NOCOPY VARCHAR2,
387 p_ctr_der_filter_id IN NUMBER,
388 p_object_version_number IN NUMBER,
389 p_seq_no IN NUMBER DEFAULT null,
390 p_counter_id IN NUMBER,
391 p_left_paren IN VARCHAR2,
392 p_ctr_prop_id IN NUMBER,
393 p_rel_op IN VARCHAR2,
394 p_right_val IN VARCHAR2,
395 p_right_paren IN VARCHAR2,
396 p_log_op IN VARCHAR2,
397 p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
398 x_object_version_number OUT NOCOPY NUMBER
399 );
400
401 PROCEDURE UPDATE_GRPOP_FILTER_POST(
402 P_Api_Version IN NUMBER,
403 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
404 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
405 X_Return_Status OUT NOCOPY VARCHAR2,
406 X_Msg_Count OUT NOCOPY NUMBER,
407 X_Msg_Data OUT NOCOPY VARCHAR2,
408 p_ctr_der_filter_id IN NUMBER,
409 p_object_version_number IN NUMBER,
410 p_seq_no IN NUMBER DEFAULT null,
411 p_counter_id IN NUMBER,
412 p_left_paren IN VARCHAR2,
413 p_ctr_prop_id IN NUMBER,
414 p_rel_op IN VARCHAR2,
415 p_right_val IN VARCHAR2,
416 p_right_paren IN VARCHAR2,
417 p_log_op IN VARCHAR2,
418 p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
419 x_object_version_number OUT NOCOPY NUMBER
420 );
421
422 PROCEDURE UPDATE_CTR_ASSOCIATION_PRE(
423 P_Api_Version IN NUMBER,
424 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
425 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
426 X_Return_Status OUT NOCOPY VARCHAR2,
427 X_Msg_Count OUT NOCOPY NUMBER,
428 X_Msg_Data OUT NOCOPY VARCHAR2,
429 p_ctr_association_id IN NUMBER,
430 p_object_version_number IN NUMBER,
431 p_ctr_grp_id IN NUMBER,
432 p_source_object_id IN NUMBER,
433 x_object_version_number OUT NOCOPY NUMBER
434 );
435
436 PROCEDURE UPDATE_CTR_ASSOCIATION_POST(
437 P_Api_Version IN NUMBER,
438 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
439 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
440 X_Return_Status OUT NOCOPY VARCHAR2,
441 X_Msg_Count OUT NOCOPY NUMBER,
442 X_Msg_Data OUT NOCOPY VARCHAR2,
443 p_ctr_association_id IN NUMBER,
444 p_object_version_number IN NUMBER,
445 p_ctr_grp_id IN NUMBER,
446 p_source_object_id IN NUMBER,
447 x_object_version_number OUT NOCOPY NUMBER
448 );
449
450 PROCEDURE DELETE_COUNTER_PRE(
451 P_Api_Version IN NUMBER,
452 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
453 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
454 X_Return_Status OUT NOCOPY VARCHAR2,
455 X_Msg_Count OUT NOCOPY NUMBER,
456 X_Msg_Data OUT NOCOPY VARCHAR2,
457 p_ctr_id IN NUMBER
458 );
459
460 PROCEDURE DELETE_COUNTER_POST(
461 P_Api_Version IN NUMBER,
462 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
463 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
464 X_Return_Status OUT NOCOPY VARCHAR2,
465 X_Msg_Count OUT NOCOPY NUMBER,
466 X_Msg_Data OUT NOCOPY VARCHAR2,
467 p_ctr_id IN NUMBER
468 );
469
470 PROCEDURE DELETE_CTR_PROP_PRE(
471 P_Api_Version IN NUMBER,
472 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
473 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
474 X_Return_Status OUT NOCOPY VARCHAR2,
475 X_Msg_Count OUT NOCOPY NUMBER,
476 X_Msg_Data OUT NOCOPY VARCHAR2,
477 p_ctr_prop_id IN NUMBER
478 );
479 PROCEDURE DELETE_CTR_PROP_POST(
480 P_Api_Version IN NUMBER,
481 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
482 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
483 X_Return_Status OUT NOCOPY VARCHAR2,
484 X_Msg_Count OUT NOCOPY NUMBER,
485 X_Msg_Data OUT NOCOPY VARCHAR2,
486 p_ctr_prop_id IN NUMBER
487 );
488
489 PROCEDURE DELETE_FORMULA_REF_PRE(
490 P_Api_Version IN NUMBER,
491 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
492 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
493 X_Return_Status OUT NOCOPY VARCHAR2,
494 X_Msg_Count OUT NOCOPY NUMBER,
495 X_Msg_Data OUT NOCOPY VARCHAR2,
496 p_ctr_formula_bvar_id IN NUMBER
497 );
498
499 PROCEDURE DELETE_FORMULA_REF_POST(
500 P_Api_Version IN NUMBER,
501 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
502 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
503 X_Return_Status OUT NOCOPY VARCHAR2,
504 X_Msg_Count OUT NOCOPY NUMBER,
505 X_Msg_Data OUT NOCOPY VARCHAR2,
506 p_ctr_formula_bvar_id IN NUMBER
507 );
508
509 PROCEDURE DELETE_GRPOP_FILTER_PRE(
510 P_Api_Version IN NUMBER,
511 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
512 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
513 X_Return_Status OUT NOCOPY VARCHAR2,
514 X_Msg_Count OUT NOCOPY NUMBER,
515 X_Msg_Data OUT NOCOPY VARCHAR2,
516 p_ctr_der_filter_id IN NUMBER
517 );
518
519 PROCEDURE DELETE_GRPOP_FILTER_POST(
520 P_Api_Version IN NUMBER,
521 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
522 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
523 X_Return_Status OUT NOCOPY VARCHAR2,
524 X_Msg_Count OUT NOCOPY NUMBER,
525 X_Msg_Data OUT NOCOPY VARCHAR2,
526 p_ctr_der_filter_id IN NUMBER
527 );
528
529 PROCEDURE DELETE_CTR_ASSOCIATION_PRE(
530 P_Api_Version IN NUMBER,
531 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
532 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
533 X_Return_Status OUT NOCOPY VARCHAR2,
534 X_Msg_Count OUT NOCOPY NUMBER,
535 X_Msg_Data OUT NOCOPY VARCHAR2,
536 p_ctr_association_id IN NUMBER
537 );
538 PROCEDURE DELETE_CTR_ASSOCIATION_POST(
539 P_Api_Version IN NUMBER,
540 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
541 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
542 X_Return_Status OUT NOCOPY VARCHAR2,
543 X_Msg_Count OUT NOCOPY NUMBER,
544 X_Msg_Data OUT NOCOPY VARCHAR2,
545 p_ctr_association_id IN NUMBER
546 );
547
548 PROCEDURE DELETE_COUNTER_INSTANCE_PRE (
549 p_api_version IN NUMBER,
550 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
551 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
552 p_SOURCE_OBJECT_ID IN NUMBER,
553 p_SOURCE_OBJECT_CODE IN VARCHAR2,
554 x_Return_status OUT NOCOPY VARCHAR2,
555 x_Msg_Count OUT NOCOPY NUMBER,
556 x_Msg_Data OUT NOCOPY VARCHAR2
557 );
558
559 PROCEDURE DELETE_COUNTER_INSTANCE_POST (
560 p_api_version IN NUMBER,
561 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
562 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
563 p_SOURCE_OBJECT_ID IN NUMBER,
564 p_SOURCE_OBJECT_CODE IN VARCHAR2,
565 x_Return_status OUT NOCOPY VARCHAR2,
566 x_Msg_Count OUT NOCOPY NUMBER,
567 x_Msg_Data OUT NOCOPY VARCHAR2
568 );
569
570 End CS_COUNTERS_VUHK;