1 PACKAGE CS_CTR_CAPTURE_READING_PUB AUTHID CURRENT_USER as
2 -- $Header: csxpcrds.pls 115.22 2003/11/06 18:45:45 mkommuri ship $
3 -- Start of Comments
4 -- Package name : CS_CTR_CAPTURE_READING_PUB
5 -- Purpose : Capture Reading for Counters
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10 -- Default number of records fetch per call
11 --G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
12
13 /**
14 * Counter Group Log Record type
15 **/
16 TYPE CTR_GRP_LOG_Rec_Type IS RECORD
17 (
18 COUNTER_GRP_LOG_ID NUMBER := FND_API.G_MISS_NUM,
19 COUNTER_GROUP_ID NUMBER := FND_API.G_MISS_NUM,
20 VALUE_TIMESTAMP DATE := FND_API.G_MISS_DATE,
21 SOURCE_TRANSACTION_ID NUMBER := FND_API.G_MISS_NUM,
22 SOURCE_TRANSACTION_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
23 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
36 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
37 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
38 CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR
39 );
40
41 G_MISS_CTR_GRP_LOG_REC CTR_GRP_LOG_Rec_Type;
42 --TYPE CTR_GRP_LOG_Tbl_Type IS TABLE OF CTR_GRP_LOG_Rec_Type
43 -- INDEX BY BINARY_INTEGER;
44 --G_MISS_CTR_GRP_LOG_TBL CTR_GRP_LOG_Tbl_Type;
45
46 /**
47 * Counter Reading Record type
48 **/
49 TYPE CTR_RDG_Rec_Type IS RECORD
50 (
51 COUNTER_VALUE_ID NUMBER := FND_API.G_MISS_NUM,
52 COUNTER_ID NUMBER := FND_API.G_MISS_NUM,
53 VALUE_TIMESTAMP DATE := FND_API.G_MISS_DATE,
54 COUNTER_READING NUMBER := FND_API.G_MISS_NUM,
55 RESET_FLAG VARCHAR2(1) := FND_API.G_FALSE,
56 RESET_REASON VARCHAR2(255) := FND_API.G_MISS_CHAR,
57 PRE_RESET_LAST_RDG NUMBER := FND_API.G_MISS_NUM,
58 POST_RESET_FIRST_RDG NUMBER := FND_API.G_MISS_NUM,
59 MISC_READING_TYPE VARCHAR2(20) := FND_API.G_MISS_CHAR,
60 MISC_READING NUMBER := FND_API.G_MISS_NUM,
61 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM, --Required from Update Reading only
62 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
63 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
64 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
65 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77 CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
78 VALID_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
79 OVERRIDE_VALID_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
80 COMMENTS VARCHAR2(2000) := FND_API.G_MISS_CHAR,
81 FILTER_READING_COUNT NUMBER := FND_API.G_MISS_NUM
82 );
83 G_MISS_CTR_RDG_REC CTR_RDG_Rec_Type;
84 TYPE CTR_RDG_Tbl_Type IS TABLE OF CTR_RDG_Rec_Type
85 INDEX BY BINARY_INTEGER;
86 G_MISS_CTR_RDG_TBL CTR_RDG_Tbl_Type;
87
88 /**
89 * Counter Property Reading Record type
90 **/
91 TYPE PROP_RDG_Rec_Type IS RECORD
92 (
93 COUNTER_PROP_VALUE_ID NUMBER := FND_API.G_MISS_NUM,
94 COUNTER_PROPERTY_ID NUMBER := FND_API.G_MISS_NUM,
95 VALUE_TIMESTAMP DATE := FND_API.G_MISS_DATE,
96 PROPERTY_VALUE VARCHAR2(240) := FND_API.G_MISS_CHAR,
97 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM, --Required from Update Reading only
98 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
99 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
100 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
101 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
102 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
103 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
104 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
105 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
106 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
107 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
108 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
109 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
110 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
111 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
112 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
113 CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR
114 );
115
116 G_MISS_PROP_RDG_REC PROP_RDG_Rec_Type;
117 TYPE PROP_RDG_Tbl_Type IS TABLE OF PROP_RDG_Rec_Type
118 INDEX BY BINARY_INTEGER;
119 G_MISS_PROP_RDG_TBL PROP_RDG_Tbl_Type;
120
121 -- *******************************************************
122 -- Start of Comments
123 -- *******************************************************
124 -- API Name: CAPTURE_COUNTER_READING
125 -- Type : Private
126 -- Pre-Req : None
127 -- Parameters:
128 -- IN
129 -- p_api_version_number IN NUMBER Required
130 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
131 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
132 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
133 -- P_CTR_RDG_Rec IN CTR_RDG_Rec_Type Required
134 -- p_COUNTER_GRP_LOG_ID IN NUMBER Required
135 -- p_internal_level IN NUMBER Not to be passed, Internal Use.
136 -- OUT:
137 -- x_return_status OUT VARCHAR2
138 -- x_msg_count OUT NUMBER
139 -- x_msg_data OUT VARCHAR2
140 -- Version : Current version 1.0
141 -- Description :
142 -- This API is used to capture reading of a REGULAR counter. Prerequisite of this API is PRE_CAPTURE_COUNTER_READING.
143 -- You must have counter group log ID to call this API. Capture counter reading can only be called once for each
144 -- counter in the counter group of counter group log id.
145 -- End of Comments
146 --
147 PROCEDURE CAPTURE_COUNTER_READING(
148 P_Api_Version_Number IN NUMBER,
149 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
150 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
151 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
152 p_CTR_GRP_LOG_Rec IN CTR_GRP_LOG_Rec_Type := G_MISS_CTR_GRP_LOG_Rec,
153 p_CTR_RDG_Tbl IN CTR_RDG_Tbl_Type := G_MISS_CTR_RDG_TBL,
154 p_PROP_RDG_Tbl IN PROP_RDG_Tbl_Type := G_MISS_PROP_RDG_TBL,
155 X_Return_Status OUT NOCOPY VARCHAR2,
156 X_Msg_Count OUT NOCOPY NUMBER,
157 X_Msg_Data OUT NOCOPY VARCHAR2
158 );
159
160 -- *******************************************************
161 -- Start of Comments
162 -- *******************************************************
163 -- API Name: UPDATE_COUNTER_READING
164 -- Type : Private
165 -- Pre-Req : None
166 -- Parameters:
167 -- IN
168 -- p_api_version_number IN NUMBER Required
169 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
170 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
171 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
172 -- P_CTR_RDG_Rec IN CTR_RDG_Rec_Type Required
173 -- p_COUNTER_GRP_LOG_ID IN NUMBER Required
174 -- p_object_version_number IN NUMBER Required
175 -- p_internal_level IN NUMBER Not to be passed, Internal Use.
176 -- OUT:
177 -- x_return_status OUT VARCHAR2
178 -- x_msg_count OUT NUMBER
179 -- x_msg_data OUT VARCHAR2
180 -- Version : Current version 1.0
181 -- Description :
182 -- This API is used to update existing reading of a REGULAR counter. You must have counter group log ID and
183 -- object_version_number to call this API, currect counter reading view should be used to find out the
184 -- counter group log id of the counter id. Only most recent reading is allowed to be updated. If counter group
185 -- log id passed is not the most recent counter group log id of counter id then an exception is raised.
186 -- End of Comments
187 --
188 PROCEDURE UPDATE_COUNTER_READING(
189 P_Api_Version_Number IN NUMBER,
190 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
191 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
192 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
193 p_CTR_GRP_LOG_ID IN NUMBER,
194 p_CTR_RDG_Tbl IN CTR_RDG_Tbl_Type := G_MISS_CTR_RDG_TBL,
195 p_PROP_RDG_Tbl IN PROP_RDG_Tbl_Type := G_MISS_PROP_RDG_TBL,
196 X_Return_Status OUT NOCOPY VARCHAR2,
197 X_Msg_Count OUT NOCOPY NUMBER,
198 X_Msg_Data OUT NOCOPY VARCHAR2
199 );
200
201 -- *******************************************************
202 -- Start of Comments
203 -- *******************************************************
204 -- API Name: CAPTURE_COUNTER_READING
205 -- Type : Private
206 -- Pre-Req : None
207 -- Parameters:
208 -- IN
209 -- Parameters:
210 -- IN
211 -- p_api_version_number IN NUMBER Required
212 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
213 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
214 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
215 -- p_CTR_RDG_Rec IN CTR_RDG_Rec_Type Required
216 -- p_COUNTER_GRP_LOG_ID IN NUMBER Required
217 -- OUT
218 -- x_return_status OUT VARCHAR2
219 -- x_msg_count OUT NUMBER
220 -- x_msg_data OUT VARCHAR2
221 -- Version : Current version 1.0
222 -- Description :
223 -- This API is used to capture reading of a REGULAR counter. Prerequisite of this API is PRE_CAPTURE_COUNTER_READING.
224 -- You must have counter group log ID to call this API. Capture counter reading can only be called once for each
225 -- counter in the counter group of counter group log id.
226 -- End of Comments
227 --
228 PROCEDURE CAPTURE_COUNTER_READING(
229 P_Api_Version_Number IN NUMBER,
230 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
231 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
232 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
233 p_CTR_RDG_Rec IN CTR_RDG_Rec_Type := G_MISS_CTR_RDG_REC,
234 p_COUNTER_GRP_LOG_ID IN NUMBER,
235 X_Return_Status OUT NOCOPY VARCHAR2,
236 X_Msg_Count OUT NOCOPY NUMBER,
237 X_Msg_Data OUT NOCOPY VARCHAR2
238 );
239 -- *******************************************************
240 -- Start of Comments
241 -- *******************************************************
242 -- API Name: UPDATE_COUNTER_READING
243 -- Type : Private
244 -- Pre-Req : None
245 -- Parameters:
246 -- IN
247 -- p_api_version_number IN NUMBER Required
251 -- p_CTR_RDG_Rec IN CTR_RDG_Rec_Type Required
248 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
249 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
250 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
252 -- p_COUNTER_GRP_LOG_ID IN NUMBER Required
253 -- p_object_version_number IN NUMBER
254 -- OUT:
255 -- x_return_status OUT VARCHAR2
256 -- x_msg_count OUT NUMBER
257 -- x_msg_data OUT VARCHAR2
258 -- Version : Current version 1.0
259 -- Description :
260 -- This API is used to update existing reading of a REGULAR counter. You must have counter group log ID and
261 -- object_version_number to call this API, currect counter reading view should be used to find out the
262 -- counter group log id of the counter id. Only most recent reading is allowed to be updated. If counter group
263 -- log id passed is not the most recent counter group log id of counter id then an exception is raised.
264 -- End of Comments
265 --
266 PROCEDURE UPDATE_COUNTER_READING(
267 p_Api_Version_Number IN NUMBER,
268 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
269 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
270 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
271 p_CTR_RDG_Rec IN CTR_RDG_Rec_Type := G_MISS_CTR_RDG_REC,
272 p_COUNTER_GRP_LOG_ID IN NUMBER,
273 p_object_version_number IN NUMBER,
274 X_Return_Status OUT NOCOPY VARCHAR2,
275 X_Msg_Count OUT NOCOPY NUMBER,
276 X_Msg_Data OUT NOCOPY VARCHAR2
277 );
278
279 -- *******************************************************
280 -- Start of Comments
281 -- *******************************************************
282 -- API Name: PRE_CAPTURE_CTR_READING
283 -- Type : Private
284 -- Pre-Req : None
285 -- Parameters:
286 -- IN
287 -- p_api_version_number IN NUMBER Required
288 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
289 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
290 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
291 -- P_CTR_GRP_LOG_Rec IN CTR_GRP_LOG_Rec_Type Required
292 -- OUT:
293 -- x_CTR_GRP_LOG_ID OUT NUMBER
294 -- x_return_status OUT VARCHAR2
295 -- x_msg_count OUT NUMBER
296 -- x_msg_data OUT VARCHAR2
297 -- Version : Current version 1.0
298 -- Description :
299 -- This API is the first step to start capturing counter reading. This API must and only be called once
300 -- for NEW counter reading before calling any other capture reading API. This API will return a reference
301 -- (Counter Group Log ID) to counter reading group which will be used to call other capture reading APIs.
302 --
303 -- End of Comments
304 --
305 PROCEDURE PRE_CAPTURE_CTR_READING(
306 P_Api_Version_Number IN NUMBER,
307 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
308 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
309 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
310 P_CTR_GRP_LOG_Rec IN CTR_GRP_LOG_Rec_Type := G_MISS_CTR_GRP_LOG_REC,
311 X_COUNTER_GRP_LOG_ID IN OUT NOCOPY NUMBER,
312 X_Return_Status OUT NOCOPY VARCHAR2,
313 X_Msg_Count OUT NOCOPY NUMBER,
314 X_Msg_Data OUT NOCOPY VARCHAR2
315 );
316 -- *******************************************************
317 -- Start of Comments
318 -- *******************************************************
319 -- API Name: CAPTURE_CTR_PROP_READING
320 -- Type : Private
321 -- Pre-Req : None
322 -- Parameters:
323 -- IN
324 -- p_api_version_number IN NUMBER Required
325 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
326 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
327 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
328 -- P_PROP_RDG_Rec IN PROP_RDG_Rec_Type Required
329 -- p_COUNTER_GRP_LOG_ID IN NUMBER Required
330 -- OUT:
331 -- x_return_status OUT NOCOPY VARCHAR2
332 -- x_msg_count OUT NOCOPY NUMBER
333 -- x_msg_data OUT NOCOPY VARCHAR2
334 -- Version : Current version 1.0
335 -- Description :
336 -- This API is used to capture reading for properties of REGULAR counters. Prerequisite of this API is
337 -- PRE_CAPTURE_COUNTER_READING and reading of the counter must be captured before calling this API.
338 -- You must have counter group log ID to call this API. Capture counter property reading can only be
339 -- called once for each counter property in the counter.
340 --
341 -- End of Comments
342 --
343 PROCEDURE CAPTURE_CTR_PROP_READING(
344 P_Api_Version_Number IN NUMBER,
345 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
346 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
347 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
351 X_Msg_Count OUT NOCOPY NUMBER,
348 p_PROP_RDG_Rec IN PROP_RDG_Rec_Type := G_MISS_PROP_RDG_REC,
349 p_COUNTER_GRP_LOG_ID IN NUMBER,
350 X_Return_Status OUT NOCOPY VARCHAR2,
352 X_Msg_Data OUT NOCOPY VARCHAR2
353 );
354 -- *******************************************************
355 -- Start of Comments
356 -- *******************************************************
357 -- API Name: POST_CAPTURE_CTR_READING
358 -- Type : Private
359 -- Pre-Req : None
360 -- Parameters:
361 -- IN
362 -- p_api_version_number IN NUMBER Required
363 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
364 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
365 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
366 -- p_READING_UPDATED IN NUMBER Optional Default = FND_API.G_FLASE
367
368 -- p_COUNTER_GRP_LOG_ID IN NUMBER Required
369 -- OUT:
370 -- x_return_status OUT VARCHAR2
371 -- x_msg_count OUT NUMBER
372 -- x_msg_data OUT VARCHAR2
373 -- Version : Current version 1.0
374 -- Description : -- This API is used to do processing required after the all reading for one group have been captured.
375 -- This API calculates all formula/group operation counters effected from captured reading counters under
376 -- the passed counter group log id. After computing non regular counters this API calls event APIs.
377 -- End of Comments
378 --
379 PROCEDURE POST_CAPTURE_CTR_READING(
380 P_Api_Version_Number IN NUMBER,
381 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
382 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
383 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
384 p_COUNTER_GRP_LOG_ID IN NUMBER,
385 P_READING_UPDATED IN VARCHAR2 := FND_API.G_FALSE,
386 X_Return_Status OUT NOCOPY VARCHAR2,
387 X_Msg_Count OUT NOCOPY NUMBER,
388 X_Msg_Data OUT NOCOPY VARCHAR2
389 );
390 -- Start of Comments
391 -- *******************************************************
392 -- API Name: UPDATE_CTR_PROP_READING
393 -- Type : Private
394 -- Pre-Req : None
395 -- Parameters:
396 -- IN
397 -- p_api_version_number IN NUMBER Required
398 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
399 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
400 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
401 -- P_PROP_RDG_Rec IN PROP_RDG_Rec_Type Required
402 -- p_COUNTER_GRP_LOG_ID IN NUMBER Required
403 -- p_object_version_number IN NUMBER Required
404 -- OUT:
405 -- x_return_status OUT VARCHAR2
406 -- x_msg_count OUT NUMBER
407 -- x_msg_data OUT VARCHAR2
408 -- Version : Current version 1.0
409 -- Description :
410 -- This API is used to update existing value of a properties of REGULAR counter. You must have counter group log
411 -- ID and object_version_number to call this API, current counter property reading view should be used to find out the
412 -- counter group log id of the counter property. Only most recent values are allowed to be updated. If counter group
413 -- log id passed is not the most recent counter group log id of counter id then an exception is raised.
414 --
415 -- End of Comments
416 --
417 PROCEDURE UPDATE_CTR_PROP_READING(
418 P_Api_Version_Number IN NUMBER,
419 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
420 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
421 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
422 p_PROP_RDG_Rec IN PROP_RDG_Rec_Type := G_MISS_PROP_RDG_REC,
423 p_COUNTER_GRP_LOG_ID IN NUMBER,
424 p_object_version_number IN NUMBER,
425 X_Return_Status OUT NOCOPY VARCHAR2,
426 X_Msg_Count OUT NOCOPY NUMBER,
427 X_Msg_Data OUT NOCOPY VARCHAR2
428 );
429 /*
430 PROCEDURE ESTIMATE_COUNTER_READING(
431 P_Api_Version_Number IN NUMBER,
432 P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
433 P_Commit IN VARCHAR2 := FND_API.G_FALSE,
434 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
435 p_counter_id IN NUMBER,
436 p_estimation_period_start_date IN DATE,
437 p_estimation_period_end_date IN DATE,
438 p_avg_calculation_start_date IN DATE,
439 p_number_of_readings IN NUMBER,
440 x_estimated_usage_qty OUT NOCOPY NUMBER,
441 x_estimated_meter_reading OUT NOCOPY NUMBER,
442 x_estimated_period_start_rdg OUT NOCOPY NUMBER,
443 X_Return_Status OUT NOCOPY VARCHAR2,
444 X_Msg_Count OUT NOCOPY NUMBER,
445 X_Msg_Data OUT NOCOPY VARCHAR2
446 );
447 */
448
449 End CS_CTR_CAPTURE_READING_PUB;
[Home] [Help]