[Home] [Help]
PACKAGE: APPS.CS_COUNTERS_PUB
Source
1 PACKAGE CS_Counters_PUB AS
2 /* $Header: cspctrs.pls 120.2.12000000.1 2007/01/17 01:54:01 appldev ship $ */
3
4 -- ---------------------------------------------------------
5 -- Declare Data Types
6 -- ---------------------------------------------------------
7
8 TYPE CtrGrp_Rec_Type IS RECORD
9 (
10 name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
11 description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
12 association_type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
13 start_date_active DATE, -- := FND_API.G_MISS_DATE,
14 end_date_active DATE, -- := FND_API.G_MISS_DATE,
15 desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type
16 );
17
18 TYPE Ctr_Rec_Type IS RECORD
19 (
20 ctr_tbl_index NUMBER , -- := FND_API.G_MISS_NUM,
21 counter_group_id NUMBER , -- := FND_API.G_MISS_NUM,
22 name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
23 description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
24 type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
25 step_value NUMBER, -- := FND_API.G_MISS_NUM,
26 initial_reading NUMBER, -- := FND_API.G_MISS_NUM,
27 rollover_last_reading NUMBER, -- := FND_API.G_MISS_NUM,
28 rollover_first_reading NUMBER, -- := FND_API.G_MISS_NUM,
29 uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
30 tolerance_plus NUMBER, -- := FND_API.G_MISS_NUM,
31 tolerance_minus NUMBER, -- := FND_API.G_MISS_NUM,
32 derive_function VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
33 derive_counter_id NUMBER, -- := FND_API.G_MISS_NUM,
34 derive_property_id NUMBER, -- := FND_API.G_MISS_NUM,
35 formula_text VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,
36 comments VARCHAR2(1996), -- := FND_API.G_MISS_CHAR,
37 usage_item_id NUMBER , -- := FND_API.G_MISS_NUM,
38 start_date_active DATE, -- := FND_API.G_MISS_DATE,
39 end_date_active DATE, -- := FND_API.G_MISS_DATE,
40 desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
41 customer_view VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
42 duration NUMBER, -- := FND_API.G_MISS_NUM,
43 duration_uom VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
44 direction VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
45 filter_reading_count NUMBER , -- := FND_API.G_MISS_NUM,
46 filter_type VARCHAR2(1) , -- := FND_API.G_MISS_CHAR,
47 filter_time_uom VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
48 estimation_id NUMBER -- := FND_API.G_MISS_NUM
49 );
50
51 TYPE Ctr_Prop_Rec_Type IS RECORD
52 (
53 ctr_tbl_index NUMBER , -- := FND_API.G_MISS_NUM,
54 counter_id NUMBER, -- := FND_API.G_MISS_NUM,
55 name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
56 description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
57 property_data_type VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
58 is_nullable VARCHAR2(1), -- := FND_API.G_MISS_CHAR,
59 default_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
60 minimum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
61 maximum_value VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
62 uom_code VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
63 start_date_active DATE, -- := FND_API.G_MISS_DATE,
64 end_date_active DATE, -- := FND_API.G_MISS_DATE,
65 desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
66 property_lov_type VARCHAR2(30) -- := FND_API.G_MISS_CHAR
67 );
68
69 TYPE CTR_Estimation_Rec_Type IS RECORD
70 (
71 estimation_name VARCHAR2(30), -- := FND_API.G_MISS_CHAR,
72 estimation_description VARCHAR2(240), -- := FND_API.G_MISS_CHAR,
73 estimation_type VARCHAR2(10), -- := FND_API.G_MISS_CHAR,
74 estimation_avg_type VARCHAR2(3), -- := FND_API.G_MISS_CHAR,
75 fixed_Value NUMBER , -- := FND_API.G_MISS_NUM,
76 Usage_Markup NUMBER , -- := FND_API.G_MISS_NUM,
77 Default_Value NUMBER , -- := FND_API.G_MISS_NUM,
78 Counter_Group_id NUMBER , -- := FND_API.G_MISS_NUM,
79 Counter_id NUMBER , -- := FND_API.G_MISS_NUM,
80 start_date_active DATE , -- := FND_API.G_MISS_DATE,
81 end_date_active DATE , -- := FND_API.G_MISS_DATE,
82 ATTRIBUTE1 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
83 ATTRIBUTE2 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
84 ATTRIBUTE3 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
85 ATTRIBUTE4 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
86 ATTRIBUTE5 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
87 ATTRIBUTE6 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
88 ATTRIBUTE7 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
89 ATTRIBUTE8 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
90 ATTRIBUTE9 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
91 ATTRIBUTE10 VARCHAR2(150) , -- := FND_API.G_MISS_CHAR,
92 ATTRIBUTE11 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
93 ATTRIBUTE12 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
94 ATTRIBUTE13 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
95 ATTRIBUTE14 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
96 ATTRIBUTE15 VARCHAR2(150), -- := FND_API.G_MISS_CHAR,
97 ATTRIBUTE_CATEGORY VARCHAR2(30) -- := FND_API.G_MISS_CHAR
98 );
99
100 TYPE Ctr_Association_Rec_Type IS RECORD
101 (
102 counter_group_id NUMBER, -- := FND_API.G_MISS_NUM,
103 source_object_id NUMBER, -- := FND_API.G_MISS_NUM,
104 desc_flex CS_COUNTERS_EXT_PVT.DFF_Rec_Type
105 );
106
107 --
108 --
109 -------------------------------------------------------------------------------
110 --
111 -- Program Units
112 --
113 -------------------------------------------------------------------------------
114 --
115
116 FUNCTION Ctr_Grp_Template_Exists
117 (
118 p_item_id NUMBER
119 ) RETURN BOOLEAN;
120
121
122 PROCEDURE Create_Ctr_Grp_Template
123 (
124 p_api_version IN NUMBER,
125 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
126 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
127 x_return_status OUT NOCOPY VARCHAR2,
128 x_msg_count OUT NOCOPY NUMBER,
129 x_msg_data OUT NOCOPY VARCHAR2,
130 p_ctr_grp_rec IN CS_COUNTERS_PUB.CtrGrp_Rec_Type,
131 x_ctr_grp_id IN OUT NOCOPY NUMBER,
132 x_object_version_number OUT NOCOPY NUMBER
133 );
134
135 PROCEDURE Create_Ctr_Grp_Instance
136 (
137 p_api_version IN NUMBER,
138 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
139 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
140 x_return_status OUT NOCOPY VARCHAR2,
141 x_msg_count OUT NOCOPY NUMBER,
142 x_msg_data OUT NOCOPY VARCHAR2,
143 p_ctr_grp_rec IN CS_COUNTERS_PUB.CtrGrp_Rec_Type,
144 p_source_object_cd IN VARCHAR2,
145 p_source_object_id IN NUMBER,
146 x_ctr_grp_id IN OUT NOCOPY NUMBER,
147 x_object_version_number OUT NOCOPY NUMBER
148 );
149
150 PROCEDURE Create_Counter
151 (
152 p_api_version IN NUMBER,
153 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
154 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
155 x_return_status OUT NOCOPY VARCHAR2,
156 x_msg_count OUT NOCOPY NUMBER,
157 x_msg_data OUT NOCOPY VARCHAR2,
158 p_ctr_rec IN CS_COUNTERS_PUB.Ctr_Rec_Type,
159 x_ctr_id IN OUT NOCOPY NUMBER,
160 x_object_version_number OUT NOCOPY NUMBER
161 );
162
163 PROCEDURE Create_Ctr_Prop
164 (
165 p_api_version IN NUMBER,
166 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
167 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171 p_ctr_prop_rec IN Ctr_Prop_Rec_Type,
172 x_ctr_prop_id IN OUT NOCOPY NUMBER,
173 x_object_version_number OUT NOCOPY NUMBER
174 );
175
176 PROCEDURE Create_Formula_Ref
177 (
178 p_api_version IN NUMBER,
179 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
180 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
181 x_return_status OUT NOCOPY VARCHAR2,
182 x_msg_count OUT NOCOPY NUMBER,
183 x_msg_data OUT NOCOPY VARCHAR2,
184 p_counter_id IN NUMBER,
185 p_bind_var_name IN VARCHAR2,
186 p_mapped_item_id IN NUMBER default null,
187 p_mapped_counter_id IN NUMBER,
188 p_desc_flex IN CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
189 x_ctr_formula_bvar_id IN OUT NOCOPY NUMBER,
190 x_object_version_number OUT NOCOPY NUMBER,
191 p_reading_type IN VARCHAR2
192 );
193
194 PROCEDURE Create_GrpOp_Filter
195 (
196 p_api_version IN NUMBER,
197 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
198 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
199 x_return_status OUT NOCOPY VARCHAR2,
200 x_msg_count OUT NOCOPY NUMBER,
201 x_msg_data OUT NOCOPY VARCHAR2,
202 p_seq_no IN NUMBER DEFAULT null,
203 p_counter_id IN NUMBER,
204 p_left_paren IN VARCHAR2,
205 p_ctr_prop_id IN NUMBER,
206 p_rel_op IN VARCHAR2,
207 p_right_val IN VARCHAR2,
208 p_right_paren IN VARCHAR2,
209 p_log_op IN VARCHAR2,
210 p_desc_flex IN CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
211 x_ctr_der_filter_id IN OUT NOCOPY NUMBER,
212 x_object_version_number OUT NOCOPY NUMBER
213 );
214
215 PROCEDURE Create_Ctr_Association
216 (
217 p_api_version IN NUMBER,
218 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
219 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
220 x_return_status OUT NOCOPY VARCHAR2,
221 x_msg_count OUT NOCOPY NUMBER,
222 x_msg_data OUT NOCOPY VARCHAR2,
223 p_ctr_grp_id IN NUMBER,
224 p_source_object_id IN NUMBER,
225 p_desc_flex IN CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
226 x_ctr_association_id OUT NOCOPY NUMBER,
227 x_object_version_number OUT NOCOPY NUMBER
228 );
229
230 PROCEDURE AutoInstantiate_Counters
231 (
232 p_api_version IN NUMBER,
233 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
234 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
235 x_return_status OUT NOCOPY VARCHAR2,
236 x_msg_count OUT NOCOPY NUMBER,
237 x_msg_data OUT NOCOPY VARCHAR2,
238 p_source_object_id_template IN NUMBER,
239 p_source_object_id_instance IN NUMBER,
240 x_ctr_grp_id_template IN OUT NOCOPY NUMBER,
241 x_ctr_grp_id_instance IN OUT NOCOPY NUMBER,
242 p_organization_id IN NUMBER DEFAULT cs_std.get_item_valdn_orgzn_id
243 );
244
245 PROCEDURE Update_Ctr_Grp
246 (
247 p_api_version IN NUMBER,
248 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
249 p_commit IN VARCHAR2 DEFAULT 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_ctr_grp_id IN NUMBER,
254 p_object_version_number IN NUMBER,
255 p_ctr_grp_rec IN CS_COUNTERS_PUB.CtrGrp_Rec_Type,
256 p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
257 x_object_version_number OUT NOCOPY NUMBER
258 );
259
260 PROCEDURE Update_Counter
261 (
262 p_api_version IN NUMBER,
263 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
264 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
265 x_return_status OUT NOCOPY VARCHAR2,
266 x_msg_count OUT NOCOPY NUMBER,
267 x_msg_data OUT NOCOPY VARCHAR2,
268 p_ctr_id IN NUMBER,
269 p_object_version_number IN NUMBER,
270 p_ctr_rec IN CS_COUNTERS_PUB.Ctr_Rec_Type,
271 p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
272 x_object_version_number OUT NOCOPY NUMBER
273 );
274
275 PROCEDURE Update_Ctr_Prop
276 (
277 p_api_version IN NUMBER,
278 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
279 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
280 x_return_status OUT NOCOPY VARCHAR2,
281 x_msg_count OUT NOCOPY NUMBER,
282 x_msg_data OUT NOCOPY VARCHAR2,
283 p_ctr_prop_id IN NUMBER,
284 p_object_version_number IN NUMBER,
285 p_ctr_prop_rec IN Ctr_Prop_Rec_Type,
286 p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
287 x_object_version_number OUT NOCOPY NUMBER
288 );
289
290 PROCEDURE Update_Formula_Ref
291 (
292 p_api_version IN NUMBER,
293 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
294 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
295 x_return_status OUT NOCOPY VARCHAR2,
296 x_msg_count OUT NOCOPY NUMBER,
297 x_msg_data OUT NOCOPY VARCHAR2,
298 p_ctr_formula_bvar_id IN NUMBER,
299 p_object_version_number IN NUMBER,
300 p_counter_id IN NUMBER,
301 p_bind_var_name IN VARCHAR2,
302 p_mapped_item_id IN NUMBER default null,
303 p_mapped_counter_id IN NUMBER,
304 p_desc_flex IN CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
305 p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
306 x_object_version_number OUT NOCOPY NUMBER,
307 p_reading_type IN VARCHAR2
308 );
309
310 PROCEDURE Update_GrpOp_Filter
311 (
312 p_api_version IN NUMBER,
313 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
314 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
315 x_return_status OUT NOCOPY VARCHAR2,
316 x_msg_count OUT NOCOPY NUMBER,
317 x_msg_data OUT NOCOPY VARCHAR2,
318 p_ctr_der_filter_id IN NUMBER,
319 p_object_version_number IN NUMBER,
320 p_seq_no IN NUMBER DEFAULT null,
321 p_counter_id IN NUMBER,
322 p_left_paren IN VARCHAR2,
323 p_ctr_prop_id IN NUMBER,
324 p_rel_op IN VARCHAR2,
325 p_right_val IN VARCHAR2,
326 p_right_paren IN VARCHAR2,
327 p_log_op IN VARCHAR2,
328 p_desc_flex IN CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
329 p_cascade_upd_to_instances IN VARCHAR2 DEFAULT FND_API.G_FALSE,
330 x_object_version_number OUT NOCOPY NUMBER
331 );
332
333 PROCEDURE Update_Ctr_Association
334 (
335 p_api_version IN NUMBER,
336 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
337 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
338 x_return_status OUT NOCOPY VARCHAR2,
339 x_msg_count OUT NOCOPY NUMBER,
340 x_msg_data OUT NOCOPY VARCHAR2,
341 p_ctr_association_id IN NUMBER,
342 p_object_version_number IN NUMBER,
343 p_ctr_grp_id IN NUMBER,
344 p_source_object_id IN NUMBER,
345 p_desc_flex IN CS_COUNTERS_EXT_PVT.DFF_Rec_Type,
346 x_object_version_number OUT NOCOPY NUMBER
347 );
348
349 PROCEDURE Delete_Counter
350 (
351 p_api_version IN NUMBER,
352 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
353 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
354 x_return_status OUT NOCOPY VARCHAR2,
355 x_msg_count OUT NOCOPY NUMBER,
356 x_msg_data OUT NOCOPY VARCHAR2,
357 p_ctr_id IN NUMBER
358 );
359
360 PROCEDURE Delete_Ctr_Prop
361 (
362 p_api_version IN NUMBER,
363 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
364 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
365 x_return_status OUT NOCOPY VARCHAR2,
366 x_msg_count OUT NOCOPY NUMBER,
367 x_msg_data OUT NOCOPY VARCHAR2,
368 p_ctr_prop_id IN NUMBER
369 );
370
371 PROCEDURE Delete_Formula_Ref
372 (
373 p_api_version IN NUMBER,
374 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
375 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
376 x_return_status OUT NOCOPY VARCHAR2,
377 x_msg_count OUT NOCOPY NUMBER,
378 x_msg_data OUT NOCOPY VARCHAR2,
379 p_ctr_formula_bvar_id IN NUMBER
380 );
381
382 PROCEDURE Delete_GrpOp_Filter
383 (
384 p_api_version IN NUMBER,
385 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
386 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
387 x_return_status OUT NOCOPY VARCHAR2,
388 x_msg_count OUT NOCOPY NUMBER,
389 x_msg_data OUT NOCOPY VARCHAR2,
390 p_ctr_der_filter_id IN NUMBER
391 );
392
396 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
393 PROCEDURE Delete_Ctr_Association
394 (
395 p_api_version IN NUMBER,
397 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
398 x_return_status OUT NOCOPY VARCHAR2,
399 x_msg_count OUT NOCOPY NUMBER,
400 x_msg_data OUT NOCOPY VARCHAR2,
401 p_ctr_association_id IN NUMBER
402 );
403
404 PROCEDURE Instantiate_Counters
405 (
406 p_api_version IN NUMBER,
407 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
408 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
409 x_return_status OUT NOCOPY VARCHAR2,
410 x_msg_count OUT NOCOPY NUMBER,
411 x_msg_data OUT NOCOPY VARCHAR2,
412 p_counter_group_id_template IN NUMBER,
413 p_source_object_code_instance IN VARCHAR2,
414 p_source_object_id_instance IN NUMBER,
415 x_ctr_grp_id_template OUT NOCOPY NUMBER,
416 x_ctr_grp_id_instance OUT NOCOPY NUMBER
417 );
418
419 PROCEDURE DELETE_COUNTER_INSTANCE(
420 p_Api_Version IN NUMBER,
421 p_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
422 p_commit IN VARCHAR2 := FND_API.G_FALSE,
423 p_SOURCE_OBJECT_ID IN NUMBER,
424 p_SOURCE_OBJECT_CODE IN VARCHAR2,
425 x_Return_status OUT NOCOPY VARCHAR2,
426 x_Msg_Count OUT NOCOPY NUMBER,
427 x_Msg_Data OUT NOCOPY VARCHAR2,
428 x_delete_status OUT NOCOPY VARCHAR2
429 );
430
431 PROCEDURE Instantiate_single_Ctr
432 (
433 p_api_version IN NUMBER,
434 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
435 p_commit IN VARCHAR2 := FND_API.G_FALSE,
436 x_return_status OUT NOCOPY VARCHAR2,
437 x_msg_count OUT NOCOPY NUMBER,
438 x_msg_data OUT NOCOPY VARCHAR2,
439 p_counter_id_template IN NUMBER,
440 p_source_object_code_instance IN VARCHAR2,
441 p_source_object_id_instance IN NUMBER,
442 x_ctr_id_instance OUT NOCOPY NUMBER
443 );
444
445 PROCEDURE Create_Estimation_Method
446 (
447 p_api_version IN NUMBER,
448 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
449 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
450 x_return_status OUT NOCOPY VARCHAR2,
451 x_msg_count OUT NOCOPY NUMBER,
452 x_msg_data OUT NOCOPY VARCHAR2,
453 p_ctr_estimation_rec IN CS_COUNTERS_PUB.Ctr_Estimation_Rec_Type,
454 x_estimation_id IN OUT NOCOPY NUMBER,
455 x_object_version_number OUT NOCOPY NUMBER
456 );
457
458 PROCEDURE Update_Estimation_Method
459 (
460 p_api_version IN NUMBER,
461 p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
462 p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
463 x_return_status OUT NOCOPY VARCHAR2,
464 x_msg_count OUT NOCOPY NUMBER,
465 x_msg_data OUT NOCOPY VARCHAR2,
466 p_estimation_id IN NUMBER,
467 p_object_version_number IN NUMBER,
468 p_ctr_estimation_rec IN CS_COUNTERS_PUB.Ctr_Estimation_Rec_Type,
469 x_object_version_number OUT NOCOPY NUMBER
470 );
471
472 END CS_Counters_PUB;