[Home] [Help]
PACKAGE BODY: APPS.CSI_COUNTER_READINGS_PKG
Source
1 PACKAGE BODY CSI_COUNTER_READINGS_PKG as
2 /* $Header: csitcrdb.pls 120.3 2008/04/03 21:51:55 devijay ship $*/
3
4 G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_COUNTER_READINGS_PKG';
5 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitcrdb.pls';
6
7 PROCEDURE Insert_Row(
8 px_COUNTER_VALUE_ID IN OUT NOCOPY NUMBER
9 ,p_COUNTER_ID NUMBER
10 ,p_VALUE_TIMESTAMP DATE
11 ,p_COUNTER_READING NUMBER
12 ,p_RESET_MODE VARCHAR2
13 ,p_RESET_REASON VARCHAR2
14 ,p_ADJUSTMENT_TYPE VARCHAR2
15 ,p_ADJUSTMENT_READING NUMBER
16 ,p_OBJECT_VERSION_NUMBER NUMBER
17 ,p_LAST_UPDATE_DATE DATE
18 ,p_LAST_UPDATED_BY NUMBER
19 ,p_CREATION_DATE DATE
20 ,p_CREATED_BY NUMBER
21 ,p_LAST_UPDATE_LOGIN NUMBER
22 ,p_ATTRIBUTE1 VARCHAR2
23 ,p_ATTRIBUTE2 VARCHAR2
24 ,p_ATTRIBUTE3 VARCHAR2
25 ,p_ATTRIBUTE4 VARCHAR2
26 ,p_ATTRIBUTE5 VARCHAR2
27 ,p_ATTRIBUTE6 VARCHAR2
28 ,p_ATTRIBUTE7 VARCHAR2
29 ,p_ATTRIBUTE8 VARCHAR2
30 ,p_ATTRIBUTE9 VARCHAR2
31 ,p_ATTRIBUTE10 VARCHAR2
32 ,p_ATTRIBUTE11 VARCHAR2
33 ,p_ATTRIBUTE12 VARCHAR2
34 ,p_ATTRIBUTE13 VARCHAR2
35 ,p_ATTRIBUTE14 VARCHAR2
36 ,p_ATTRIBUTE15 VARCHAR2
37 ,p_ATTRIBUTE16 VARCHAR2
38 ,p_ATTRIBUTE17 VARCHAR2
39 ,p_ATTRIBUTE18 VARCHAR2
40 ,p_ATTRIBUTE19 VARCHAR2
41 ,p_ATTRIBUTE20 VARCHAR2
42 ,p_ATTRIBUTE21 VARCHAR2
43 ,p_ATTRIBUTE22 VARCHAR2
44 ,p_ATTRIBUTE23 VARCHAR2
45 ,p_ATTRIBUTE24 VARCHAR2
46 ,p_ATTRIBUTE25 VARCHAR2
47 ,p_ATTRIBUTE26 VARCHAR2
48 ,p_ATTRIBUTE27 VARCHAR2
49 ,p_ATTRIBUTE28 VARCHAR2
50 ,p_ATTRIBUTE29 VARCHAR2
51 ,p_ATTRIBUTE30 VARCHAR2
52 ,p_ATTRIBUTE_CATEGORY VARCHAR2
53 ,p_MIGRATED_FLAG VARCHAR2
54 ,p_COMMENTS VARCHAR2
55 ,p_LIFE_TO_DATE_READING NUMBER
56 ,p_TRANSACTION_ID NUMBER
57 ,p_AUTOMATIC_ROLLOVER_FLAG VARCHAR2
58 ,p_INCLUDE_TARGET_RESETS VARCHAR2
59 ,p_SOURCE_COUNTER_VALUE_ID NUMBER
60 ,p_NET_READING NUMBER
61 ,p_DISABLED_FLAG VARCHAR2
62 ,p_SOURCE_CODE VARCHAR2
63 ,p_SOURCE_LINE_ID NUMBER
64 ,p_INITIAL_READING_FLAG VARCHAR2
65 ) IS
66
67 CURSOR C1 IS
68 SELECT CSI_COUNTER_READINGS_S.nextval
69 FROM dual;
70 BEGIN
71 IF (px_COUNTER_VALUE_ID IS NULL) OR (px_COUNTER_VALUE_ID = FND_API.G_MISS_NUM) THEN
72 OPEN C1;
73 FETCH C1 INTO px_COUNTER_VALUE_ID;
74 CLOSE C1;
75 END IF;
76
77 INSERT INTO CSI_COUNTER_READINGS(
78 COUNTER_VALUE_ID
79 ,COUNTER_ID
80 ,VALUE_TIMESTAMP
81 ,COUNTER_READING
82 ,RESET_MODE
83 ,RESET_REASON
84 ,ADJUSTMENT_TYPE
85 ,ADJUSTMENT_READING
86 ,OBJECT_VERSION_NUMBER
87 ,LAST_UPDATE_DATE
88 ,LAST_UPDATED_BY
89 ,CREATION_DATE
90 ,CREATED_BY
91 ,LAST_UPDATE_LOGIN
92 ,ATTRIBUTE1
93 ,ATTRIBUTE2
94 ,ATTRIBUTE3
95 ,ATTRIBUTE4
96 ,ATTRIBUTE5
97 ,ATTRIBUTE6
98 ,ATTRIBUTE7
99 ,ATTRIBUTE8
100 ,ATTRIBUTE9
101 ,ATTRIBUTE10
102 ,ATTRIBUTE11
103 ,ATTRIBUTE12
104 ,ATTRIBUTE13
105 ,ATTRIBUTE14
106 ,ATTRIBUTE15
107 ,ATTRIBUTE16
108 ,ATTRIBUTE17
109 ,ATTRIBUTE18
110 ,ATTRIBUTE19
111 ,ATTRIBUTE20
112 ,ATTRIBUTE21
113 ,ATTRIBUTE22
114 ,ATTRIBUTE23
115 ,ATTRIBUTE24
116 ,ATTRIBUTE25
117 ,ATTRIBUTE26
118 ,ATTRIBUTE27
119 ,ATTRIBUTE28
120 ,ATTRIBUTE29
121 ,ATTRIBUTE30
122 ,ATTRIBUTE_CATEGORY
123 ,MIGRATED_FLAG
124 ,COMMENTS
125 ,LIFE_TO_DATE_READING
126 ,TRANSACTION_ID
127 ,AUTOMATIC_ROLLOVER_FLAG
128 ,INCLUDE_TARGET_RESETS
129 ,SOURCE_COUNTER_VALUE_ID
130 ,NET_READING
131 ,DISABLED_FLAG
132 ,SOURCE_CODE
133 ,SOURCE_LINE_ID
134 ,INITIAL_READING_FLAG
135 )
136 VALUES(
137 px_COUNTER_VALUE_ID
138 ,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
139 ,decode(p_VALUE_TIMESTAMP, FND_API.G_MISS_DATE, TO_DATE(NULL), p_VALUE_TIMESTAMP)
140 ,decode(p_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_COUNTER_READING)
141 ,decode(p_RESET_MODE, FND_API.G_MISS_CHAR, NULL, p_RESET_MODE)
142 ,decode(p_RESET_REASON, FND_API.G_MISS_CHAR, NULL, p_RESET_REASON)
143 ,decode(p_ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_ADJUSTMENT_TYPE)
144 ,decode(p_ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL, p_ADJUSTMENT_READING)
145 ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
146 ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
147 ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
148 ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
149 ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
150 ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
151 ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
152 ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
153 ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
154 ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
155 ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
156 ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
157 ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
158 ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
159 ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
160 ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
161 ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
162 ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
163 ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
164 ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
165 ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
166 ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
167 ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
168 ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
169 ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
170 ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
171 ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
172 ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
173 ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
174 ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
175 ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
176 ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
177 ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
178 ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
179 ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
180 ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
181 ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
182 ,decode(p_MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)
183 ,decode(p_COMMENTS, FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
184 ,decode(p_LIFE_TO_DATE_READING, FND_API.G_MISS_NUM, NULL, p_LIFE_TO_DATE_READING)
185 ,decode(p_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_ID)
186 ,decode(p_AUTOMATIC_ROLLOVER_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
187 ,decode(p_INCLUDE_TARGET_RESETS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_TARGET_RESETS)
188 ,decode(p_SOURCE_COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_COUNTER_VALUE_ID)
189 ,decode(p_NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
190 ,decode(p_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DISABLED_FLAG)
191 ,decode(p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
192 ,decode(p_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_ID)
193 ,decode(p_INITIAL_READING_FLAG, FND_API.G_MISS_CHAR, NULL, p_INITIAL_READING_FLAG)
194 );
195
196 END Insert_Row;
197
198 PROCEDURE Update_Row(
199 p_COUNTER_VALUE_ID NUMBER
200 ,p_COUNTER_ID NUMBER
201 ,p_VALUE_TIMESTAMP DATE
202 ,p_COUNTER_READING NUMBER
203 ,p_RESET_MODE VARCHAR2
204 ,p_RESET_REASON VARCHAR2
205 ,p_ADJUSTMENT_TYPE VARCHAR2
206 ,p_ADJUSTMENT_READING NUMBER
207 ,p_OBJECT_VERSION_NUMBER NUMBER
208 ,p_LAST_UPDATE_DATE DATE
209 ,p_LAST_UPDATED_BY NUMBER
210 ,p_CREATION_DATE DATE
211 ,p_CREATED_BY NUMBER
212 ,p_LAST_UPDATE_LOGIN NUMBER
213 ,p_ATTRIBUTE1 VARCHAR2
214 ,p_ATTRIBUTE2 VARCHAR2
215 ,p_ATTRIBUTE3 VARCHAR2
216 ,p_ATTRIBUTE4 VARCHAR2
217 ,p_ATTRIBUTE5 VARCHAR2
218 ,p_ATTRIBUTE6 VARCHAR2
219 ,p_ATTRIBUTE7 VARCHAR2
220 ,p_ATTRIBUTE8 VARCHAR2
221 ,p_ATTRIBUTE9 VARCHAR2
222 ,p_ATTRIBUTE10 VARCHAR2
223 ,p_ATTRIBUTE11 VARCHAR2
224 ,p_ATTRIBUTE12 VARCHAR2
225 ,p_ATTRIBUTE13 VARCHAR2
226 ,p_ATTRIBUTE14 VARCHAR2
227 ,p_ATTRIBUTE15 VARCHAR2
228 ,p_ATTRIBUTE16 VARCHAR2
229 ,p_ATTRIBUTE17 VARCHAR2
230 ,p_ATTRIBUTE18 VARCHAR2
231 ,p_ATTRIBUTE19 VARCHAR2
232 ,p_ATTRIBUTE20 VARCHAR2
233 ,p_ATTRIBUTE21 VARCHAR2
234 ,p_ATTRIBUTE22 VARCHAR2
235 ,p_ATTRIBUTE23 VARCHAR2
236 ,p_ATTRIBUTE24 VARCHAR2
237 ,p_ATTRIBUTE25 VARCHAR2
238 ,p_ATTRIBUTE26 VARCHAR2
239 ,p_ATTRIBUTE27 VARCHAR2
240 ,p_ATTRIBUTE28 VARCHAR2
241 ,p_ATTRIBUTE29 VARCHAR2
242 ,p_ATTRIBUTE30 VARCHAR2
243 ,p_ATTRIBUTE_CATEGORY VARCHAR2
244 ,p_MIGRATED_FLAG VARCHAR2
245 ,p_COMMENTS VARCHAR2
246 ,p_LIFE_TO_DATE_READING NUMBER
247 ,p_TRANSACTION_ID NUMBER
248 ,p_AUTOMATIC_ROLLOVER_FLAG VARCHAR2
249 ,p_INCLUDE_TARGET_RESETS VARCHAR2
250 ,p_SOURCE_COUNTER_VALUE_ID NUMBER
251 ,p_NET_READING NUMBER
252 ,p_DISABLED_FLAG VARCHAR2
253 ,p_SOURCE_CODE VARCHAR2
254 ,p_SOURCE_LINE_ID NUMBER
255 ,p_INITIAL_READING_FLAG VARCHAR2
256 ) IS
257 BEGIN
258 UPDATE CSI_COUNTER_READINGS
259 SET
260 COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
261 ,VALUE_TIMESTAMP = decode(p_VALUE_TIMESTAMP, NULL, VALUE_TIMESTAMP, FND_API.G_MISS_DATE, NULL, p_VALUE_TIMESTAMP)
262 ,COUNTER_READING = decode(p_COUNTER_READING, NULL, COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_COUNTER_READING)
263 ,RESET_MODE = decode(p_RESET_MODE, NULL, RESET_MODE, FND_API.G_MISS_CHAR, NULL, p_RESET_MODE)
264 ,RESET_REASON = decode(p_RESET_REASON, NULL, RESET_REASON, FND_API.G_MISS_CHAR, NULL, p_RESET_REASON)
265 ,ADJUSTMENT_TYPE = decode(p_ADJUSTMENT_TYPE, NULL, ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_ADJUSTMENT_TYPE)
266 ,ADJUSTMENT_READING = decode(p_ADJUSTMENT_READING, NULL, ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL, p_ADJUSTMENT_READING)
267 ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
268 ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE)
269 ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
270 ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
271 ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
272 ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
273 ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
274 ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
275 ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
276 ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
277 ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
278 ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
279 ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
280 ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
281 ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
282 ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
283 ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
284 ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
285 ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
286 ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
287 ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
288 ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
289 ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
290 ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
291 ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
292 ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
293 ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
294 ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
295 ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
296 ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
297 ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
298 ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
299 ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
300 ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
301 ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
302 ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
303 ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
304 ,MIGRATED_FLAG = decode(p_MIGRATED_FLAG, NULL, MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)
305 ,COMMENTS = decode(p_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
306 ,LIFE_TO_DATE_READING = decode(p_LIFE_TO_DATE_READING, NULL, LIFE_TO_DATE_READING, FND_API.G_MISS_NUM, NULL, p_LIFE_TO_DATE_READING)
307 ,TRANSACTION_ID = decode(p_TRANSACTION_ID, NULL, TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_TRANSACTION_ID)
308 ,AUTOMATIC_ROLLOVER_FLAG = decode(p_AUTOMATIC_ROLLOVER_FLAG, NULL, AUTOMATIC_ROLLOVER_FLAG, FND_API.G_MISS_CHAR, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
309 ,INCLUDE_TARGET_RESETS = decode(p_INCLUDE_TARGET_RESETS, NULL, INCLUDE_TARGET_RESETS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_TARGET_RESETS)
313 ,SOURCE_CODE = decode(p_SOURCE_CODE, NULL, NULL, SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
310 ,SOURCE_COUNTER_VALUE_ID = decode(p_SOURCE_COUNTER_VALUE_ID, NULL, SOURCE_COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_COUNTER_VALUE_ID)
311 ,NET_READING = decode(p_NET_READING, NULL, NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
312 ,DISABLED_FLAG = decode(p_DISABLED_FLAG, NULL, DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DISABLED_FLAG)
314 ,SOURCE_LINE_ID = decode(p_SOURCE_LINE_ID, NULL, SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_ID)
315 ,INITIAL_READING_FLAG = decode(p_INITIAL_READING_FLAG, NULL, INITIAL_READING_FLAG, FND_API.G_MISS_CHAR, NULL, p_INITIAL_READING_FLAG)
316 WHERE COUNTER_VALUE_ID = p_COUNTER_VALUE_ID;
317
318 If (SQL%NOTFOUND) then
319 RAISE NO_DATA_FOUND;
320 End If;
321 END Update_Row;
322
323 PROCEDURE Lock_Row(
324 p_COUNTER_VALUE_ID NUMBER
325 ,p_COUNTER_ID NUMBER
326 ,p_VALUE_TIMESTAMP DATE
327 ,p_COUNTER_READING NUMBER
328 ,p_RESET_MODE VARCHAR2
329 ,p_RESET_REASON VARCHAR2
330 ,p_ADJUSTMENT_TYPE VARCHAR2
331 ,p_ADJUSTMENT_READING NUMBER
332 ,p_OBJECT_VERSION_NUMBER NUMBER
333 ,p_LAST_UPDATE_DATE DATE
334 ,p_LAST_UPDATED_BY NUMBER
335 ,p_CREATION_DATE DATE
336 ,p_CREATED_BY NUMBER
337 ,p_LAST_UPDATE_LOGIN NUMBER
338 ,p_ATTRIBUTE1 VARCHAR2
339 ,p_ATTRIBUTE2 VARCHAR2
340 ,p_ATTRIBUTE3 VARCHAR2
341 ,p_ATTRIBUTE4 VARCHAR2
342 ,p_ATTRIBUTE5 VARCHAR2
343 ,p_ATTRIBUTE6 VARCHAR2
344 ,p_ATTRIBUTE7 VARCHAR2
345 ,p_ATTRIBUTE8 VARCHAR2
346 ,p_ATTRIBUTE9 VARCHAR2
347 ,p_ATTRIBUTE10 VARCHAR2
348 ,p_ATTRIBUTE11 VARCHAR2
349 ,p_ATTRIBUTE12 VARCHAR2
350 ,p_ATTRIBUTE13 VARCHAR2
351 ,p_ATTRIBUTE14 VARCHAR2
352 ,p_ATTRIBUTE15 VARCHAR2
353 ,p_ATTRIBUTE16 VARCHAR2
354 ,p_ATTRIBUTE17 VARCHAR2
355 ,p_ATTRIBUTE18 VARCHAR2
356 ,p_ATTRIBUTE19 VARCHAR2
357 ,p_ATTRIBUTE20 VARCHAR2
358 ,p_ATTRIBUTE21 VARCHAR2
359 ,p_ATTRIBUTE22 VARCHAR2
360 ,p_ATTRIBUTE23 VARCHAR2
361 ,p_ATTRIBUTE24 VARCHAR2
362 ,p_ATTRIBUTE25 VARCHAR2
363 ,p_ATTRIBUTE26 VARCHAR2
364 ,p_ATTRIBUTE27 VARCHAR2
365 ,p_ATTRIBUTE28 VARCHAR2
366 ,p_ATTRIBUTE29 VARCHAR2
367 ,p_ATTRIBUTE30 VARCHAR2
368 ,p_ATTRIBUTE_CATEGORY VARCHAR2
369 ,p_MIGRATED_FLAG VARCHAR2
370 ,p_COMMENTS VARCHAR2
371 ,p_LIFE_TO_DATE_READING NUMBER
372 ,p_TRANSACTION_ID NUMBER
373 ,p_AUTOMATIC_ROLLOVER_FLAG VARCHAR2
374 ,p_INCLUDE_TARGET_RESETS VARCHAR2
375 ,p_SOURCE_COUNTER_VALUE_ID NUMBER
376 ,p_NET_READING NUMBER
377 ,p_DISABLED_FLAG VARCHAR2
378 ,p_SOURCE_CODE VARCHAR2
379 ,p_SOURCE_LINE_ID NUMBER
380 ,p_INITIAL_READING_FLAG VARCHAR2
381 ) IS
382
383 CURSOR C1 IS
384 SELECT *
385 FROM CSI_COUNTER_READINGS
386 WHERE COUNTER_VALUE_ID = p_COUNTER_VALUE_ID
387 FOR UPDATE of COUNTER_VALUE_ID NOWAIT;
388 Recinfo C1%ROWTYPE;
389 BEGIN
390 OPEN C1;
391 FETCH C1 INTO Recinfo;
392 IF (C1%NOTFOUND) THEN
393 CLOSE C1;
394 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
395 APP_EXCEPTION.RAISE_EXCEPTION;
396 END IF;
397 CLOSE C1;
398
399 IF (
400 (Recinfo.COUNTER_VALUE_ID = p_COUNTER_VALUE_ID)
401 AND ((Recinfo.COUNTER_ID = p_COUNTER_ID) OR ((Recinfo.COUNTER_ID IS NULL) AND (p_COUNTER_ID IS NULL)))
402 AND ((Recinfo.VALUE_TIMESTAMP = p_VALUE_TIMESTAMP) OR ((Recinfo.VALUE_TIMESTAMP IS NULL) AND (p_VALUE_TIMESTAMP IS NULL)))
403 AND ((Recinfo.COUNTER_READING = p_COUNTER_READING) OR ((Recinfo.COUNTER_READING IS NULL) AND (p_COUNTER_READING IS NULL)))
404 AND ((Recinfo.RESET_MODE = p_RESET_MODE) OR ((Recinfo.RESET_MODE IS NULL) AND (p_RESET_MODE IS NULL)))
405 AND ((Recinfo.RESET_REASON = p_RESET_REASON) OR ((Recinfo.RESET_REASON IS NULL) AND (p_RESET_REASON IS NULL)))
406 AND ((Recinfo.ADJUSTMENT_TYPE = p_ADJUSTMENT_TYPE) OR ((Recinfo.ADJUSTMENT_TYPE IS NULL) AND (p_ADJUSTMENT_TYPE IS NULL)))
407 AND ((Recinfo.ADJUSTMENT_READING = p_ADJUSTMENT_READING) OR ((Recinfo.ADJUSTMENT_READING IS NULL) AND (p_ADJUSTMENT_READING IS NULL)))
408 AND ((Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER) OR ((Recinfo.OBJECT_VERSION_NUMBER IS NULL) AND (p_OBJECT_VERSION_NUMBER IS NULL)))
409 AND ((Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE) OR ((Recinfo.LAST_UPDATE_DATE IS NULL) AND (p_LAST_UPDATE_DATE IS NULL)))
410 AND ((Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY) OR ((Recinfo.LAST_UPDATED_BY IS NULL) AND (p_LAST_UPDATED_BY IS NULL)))
411 AND ((Recinfo.CREATION_DATE = p_CREATION_DATE) OR ((Recinfo.CREATION_DATE IS NULL) AND (p_CREATION_DATE IS NULL)))
415 AND ((Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2) OR ((Recinfo.ATTRIBUTE2 IS NULL) AND (p_ATTRIBUTE2 IS NULL)))
412 AND ((Recinfo.CREATED_BY = p_CREATED_BY) OR ((Recinfo.CREATED_BY IS NULL) AND (p_CREATED_BY IS NULL)))
413 AND ((Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN) OR ((Recinfo.LAST_UPDATE_LOGIN IS NULL) AND (p_LAST_UPDATE_LOGIN IS NULL)))
414 AND ((Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1) OR ((Recinfo.ATTRIBUTE1 IS NULL) AND (p_ATTRIBUTE1 IS NULL)))
416 AND ((Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3) OR ((Recinfo.ATTRIBUTE3 IS NULL) AND (p_ATTRIBUTE3 IS NULL)))
417 AND ((Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4) OR ((Recinfo.ATTRIBUTE4 IS NULL) AND (p_ATTRIBUTE4 IS NULL)))
418 AND ((Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5) OR ((Recinfo.ATTRIBUTE5 IS NULL) AND (p_ATTRIBUTE5 IS NULL)))
419 AND ((Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6) OR ((Recinfo.ATTRIBUTE6 IS NULL) AND (p_ATTRIBUTE6 IS NULL)))
420 AND ((Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7) OR ((Recinfo.ATTRIBUTE7 IS NULL) AND (p_ATTRIBUTE7 IS NULL)))
421 AND ((Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8) OR ((Recinfo.ATTRIBUTE8 IS NULL) AND (p_ATTRIBUTE8 IS NULL)))
422 AND ((Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9) OR ((Recinfo.ATTRIBUTE9 IS NULL) AND (p_ATTRIBUTE9 IS NULL)))
423 AND ((Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10) OR ((Recinfo.ATTRIBUTE10 IS NULL) AND (p_ATTRIBUTE10 IS NULL)))
424 AND ((Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11) OR ((Recinfo.ATTRIBUTE11 IS NULL) AND (p_ATTRIBUTE11 IS NULL)))
425 AND ((Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12) OR ((Recinfo.ATTRIBUTE12 IS NULL) AND (p_ATTRIBUTE12 IS NULL)))
426 AND ((Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13) OR ((Recinfo.ATTRIBUTE13 IS NULL) AND (p_ATTRIBUTE13 IS NULL)))
427 AND ((Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14) OR ((Recinfo.ATTRIBUTE14 IS NULL) AND (p_ATTRIBUTE14 IS NULL)))
428 AND ((Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15) OR ((Recinfo.ATTRIBUTE15 IS NULL) AND (p_ATTRIBUTE15 IS NULL)))
429 AND ((Recinfo.ATTRIBUTE16 = p_ATTRIBUTE16) OR ((Recinfo.ATTRIBUTE16 IS NULL) AND (p_ATTRIBUTE16 IS NULL)))
430 AND ((Recinfo.ATTRIBUTE17 = p_ATTRIBUTE17) OR ((Recinfo.ATTRIBUTE17 IS NULL) AND (p_ATTRIBUTE17 IS NULL)))
431 AND ((Recinfo.ATTRIBUTE18 = p_ATTRIBUTE18) OR ((Recinfo.ATTRIBUTE18 IS NULL) AND (p_ATTRIBUTE18 IS NULL)))
432 AND ((Recinfo.ATTRIBUTE19 = p_ATTRIBUTE19) OR ((Recinfo.ATTRIBUTE19 IS NULL) AND (p_ATTRIBUTE19 IS NULL)))
433 AND ((Recinfo.ATTRIBUTE20 = p_ATTRIBUTE20) OR ((Recinfo.ATTRIBUTE20 IS NULL) AND (p_ATTRIBUTE20 IS NULL)))
434 AND ((Recinfo.ATTRIBUTE21 = p_ATTRIBUTE21) OR ((Recinfo.ATTRIBUTE21 IS NULL) AND (p_ATTRIBUTE21 IS NULL)))
435 AND ((Recinfo.ATTRIBUTE22 = p_ATTRIBUTE22) OR ((Recinfo.ATTRIBUTE22 IS NULL) AND (p_ATTRIBUTE22 IS NULL)))
436 AND ((Recinfo.ATTRIBUTE23 = p_ATTRIBUTE23) OR ((Recinfo.ATTRIBUTE23 IS NULL) AND (p_ATTRIBUTE23 IS NULL)))
437 AND ((Recinfo.ATTRIBUTE24 = p_ATTRIBUTE24) OR ((Recinfo.ATTRIBUTE24 IS NULL) AND (p_ATTRIBUTE24 IS NULL)))
438 AND ((Recinfo.ATTRIBUTE25 = p_ATTRIBUTE25) OR ((Recinfo.ATTRIBUTE25 IS NULL) AND (p_ATTRIBUTE25 IS NULL)))
439 AND ((Recinfo.ATTRIBUTE26 = p_ATTRIBUTE26) OR ((Recinfo.ATTRIBUTE26 IS NULL) AND (p_ATTRIBUTE26 IS NULL)))
440 AND ((Recinfo.ATTRIBUTE27 = p_ATTRIBUTE27) OR ((Recinfo.ATTRIBUTE27 IS NULL) AND (p_ATTRIBUTE27 IS NULL)))
441 AND ((Recinfo.ATTRIBUTE28 = p_ATTRIBUTE28) OR ((Recinfo.ATTRIBUTE28 IS NULL) AND (p_ATTRIBUTE28 IS NULL)))
442 AND ((Recinfo.ATTRIBUTE29 = p_ATTRIBUTE29) OR ((Recinfo.ATTRIBUTE29 IS NULL) AND (p_ATTRIBUTE29 IS NULL)))
443 AND ((Recinfo.ATTRIBUTE30 = p_ATTRIBUTE30) OR ((Recinfo.ATTRIBUTE30 IS NULL) AND (p_ATTRIBUTE30 IS NULL)))
444 AND ((Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY) OR ((Recinfo.ATTRIBUTE_CATEGORY IS NULL) AND (p_ATTRIBUTE_CATEGORY IS NULL)))
445 AND ((Recinfo.MIGRATED_FLAG = p_MIGRATED_FLAG) OR ((Recinfo.MIGRATED_FLAG IS NULL) AND (p_MIGRATED_FLAG IS NULL)))
446 AND ((Recinfo.COMMENTS = p_COMMENTS) OR ((Recinfo.COMMENTS IS NULL) AND (p_COMMENTS IS NULL)))
447 AND ((Recinfo.LIFE_TO_DATE_READING = p_LIFE_TO_DATE_READING) OR ((Recinfo.LIFE_TO_DATE_READING IS NULL) AND (p_LIFE_TO_DATE_READING IS NULL)))
448 AND ((Recinfo.TRANSACTION_ID = p_TRANSACTION_ID) OR ((Recinfo.TRANSACTION_ID IS NULL) AND (p_TRANSACTION_ID IS NULL)))
449 AND ((Recinfo.AUTOMATIC_ROLLOVER_FLAG = p_AUTOMATIC_ROLLOVER_FLAG) OR ((Recinfo.AUTOMATIC_ROLLOVER_FLAG IS NULL) AND (p_AUTOMATIC_ROLLOVER_FLAG IS NULL)))
450 AND ((Recinfo.INCLUDE_TARGET_RESETS = p_INCLUDE_TARGET_RESETS) OR ((Recinfo.INCLUDE_TARGET_RESETS IS NULL) AND (p_INCLUDE_TARGET_RESETS IS NULL)))
451 AND ((Recinfo.SOURCE_COUNTER_VALUE_ID = p_SOURCE_COUNTER_VALUE_ID) OR ((Recinfo.SOURCE_COUNTER_VALUE_ID IS NULL) AND (p_SOURCE_COUNTER_VALUE_ID IS NULL)))
452 AND ((Recinfo.NET_READING = p_NET_READING) OR ((Recinfo.NET_READING IS NULL) AND (p_NET_READING IS NULL)))
453 AND ((Recinfo.DISABLED_FLAG = p_DISABLED_FLAG) OR ((Recinfo.DISABLED_FLAG IS NULL) AND (p_DISABLED_FLAG IS NULL)))
454 AND ((Recinfo.SOURCE_CODE = p_SOURCE_CODE) OR ((Recinfo.SOURCE_CODE IS NULL) AND (p_SOURCE_CODE IS NULL)))
455 AND ((Recinfo.SOURCE_LINE_ID = p_SOURCE_LINE_ID) OR ((Recinfo.SOURCE_LINE_ID IS NULL) AND (p_SOURCE_LINE_ID IS NULL)))
456 AND ((Recinfo.INITIAL_READING_FLAG = p_INITIAL_READING_FLAG) OR ((Recinfo.INITIAL_READING_FLAG IS NULL) AND (p_INITIAL_READING_FLAG IS NULL)))
457 ) THEN
458 return;
459 ELSE
460 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
461 APP_EXCEPTION.RAISE_EXCEPTION;
462 END IF;
463
464 END Lock_Row;
465
466 PROCEDURE Delete_Row(
467 p_COUNTER_VALUE_ID NUMBER
468 ) IS
469 BEGIN
470 DELETE FROM CSI_COUNTER_READINGS
471 WHERE COUNTER_VALUE_ID = p_COUNTER_VALUE_ID;
472 IF (SQL%NOTFOUND) then
473 RAISE NO_DATA_FOUND;
474 END IF;
475 END Delete_Row;
476
477 End CSI_COUNTER_READINGS_PKG;