[Home] [Help]
PACKAGE BODY: APPS.CSI_CTR_READING_INTERFACE_PKG
Source
1 PACKAGE BODY CSI_CTR_READING_INTERFACE_PKG as
2 /* $Header: csitcrib.pls 120.0 2005/06/09 21:38:04 epajaril noship $*/
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_CTR_READING_INTERFACE_PKG';
5 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitcrib.pls';
6
7 PROCEDURE insert_row(
8 px_COUNTER_INTERFACE_ID IN OUT NOCOPY NUMBER
9 ,p_PARALLEL_WORKER_ID NUMBER
10 ,p_BATCH_NAME VARCHAR2
11 ,p_SOURCE_TRANSACTION_DATE DATE
12 ,p_PROCESS_STATUS VARCHAR2
13 ,p_ERROR_TEXT VARCHAR2
14 ,px_COUNTER_VALUE_ID IN OUT NOCOPY NUMBER
15 ,p_COUNTER_ID NUMBER
16 ,p_VALUE_TIMESTAMP DATE
17 ,p_COUNTER_READING NUMBER
18 ,p_RESET_MODE VARCHAR2
19 ,p_RESET_REASON VARCHAR2
20 ,p_ADJUSTMENT_TYPE VARCHAR2
21 ,p_ADJUSTMENT_READING NUMBER
22 ,p_OBJECT_VERSION_NUMBER NUMBER
23 ,p_LAST_UPDATE_DATE DATE
24 ,p_LAST_UPDATED_BY NUMBER
25 ,p_CREATION_DATE DATE
26 ,p_CREATED_BY NUMBER
27 ,p_LAST_UPDATE_LOGIN NUMBER
28 ,p_ATTRIBUTE1 VARCHAR2
29 ,p_ATTRIBUTE2 VARCHAR2
30 ,p_ATTRIBUTE3 VARCHAR2
31 ,p_ATTRIBUTE4 VARCHAR2
32 ,p_ATTRIBUTE5 VARCHAR2
33 ,p_ATTRIBUTE6 VARCHAR2
34 ,p_ATTRIBUTE7 VARCHAR2
35 ,p_ATTRIBUTE8 VARCHAR2
36 ,p_ATTRIBUTE9 VARCHAR2
37 ,p_ATTRIBUTE10 VARCHAR2
38 ,p_ATTRIBUTE11 VARCHAR2
39 ,p_ATTRIBUTE12 VARCHAR2
40 ,p_ATTRIBUTE13 VARCHAR2
41 ,p_ATTRIBUTE14 VARCHAR2
42 ,p_ATTRIBUTE15 VARCHAR2
43 ,p_ATTRIBUTE16 VARCHAR2
44 ,p_ATTRIBUTE17 VARCHAR2
45 ,p_ATTRIBUTE18 VARCHAR2
46 ,p_ATTRIBUTE19 VARCHAR2
47 ,p_ATTRIBUTE20 VARCHAR2
48 ,p_ATTRIBUTE21 VARCHAR2
49 ,p_ATTRIBUTE22 VARCHAR2
50 ,p_ATTRIBUTE23 VARCHAR2
51 ,p_ATTRIBUTE24 VARCHAR2
52 ,p_ATTRIBUTE25 VARCHAR2
53 ,p_ATTRIBUTE26 VARCHAR2
54 ,p_ATTRIBUTE27 VARCHAR2
55 ,p_ATTRIBUTE28 VARCHAR2
56 ,p_ATTRIBUTE29 VARCHAR2
57 ,p_ATTRIBUTE30 VARCHAR2
58 ,p_ATTRIBUTE_CATEGORY VARCHAR2
59 ,p_DISABLED_FLAG VARCHAR2
60 ,p_COMMENTS VARCHAR2
61 ,p_SOURCE_TRANSACTION_TYPE_ID NUMBER
62 ,p_SOURCE_TRANSACTION_ID NUMBER
63 ,p_SOURCE_CODE VARCHAR2
64 ,p_SOURCE_LINE_ID NUMBER
65 ,p_COUNTER_NAME VARCHAR2
66 ,p_AUTOMATIC_ROLLOVER_FLAG VARCHAR2
67 ,p_INCLUDE_TARGET_RESETS VARCHAR2
68 ,p_RESET_COUNTER_READING NUMBER
69 ,p_NET_READING NUMBER
70 ,p_LIFE_TO_DATE_READING NUMBER
71 ,p_SOURCE_COUNTER_VALUE_ID NUMBER
72 ) IS
73
74 CURSOR C1 IS
75 SELECT CSI_CTR_READINGS_INTERFACE_S.nextval
76 FROM dual;
77
78 CURSOR C2 IS
79 SELECT CSI_COUNTER_READINGS_S.nextval
80 FROM dual;
81 BEGIN
82 IF (px_COUNTER_INTERFACE_ID IS NULL) OR (px_COUNTER_INTERFACE_ID = FND_API.G_MISS_NUM) then
83 OPEN C1;
84 FETCH C1 INTO px_COUNTER_INTERFACE_ID;
85 CLOSE C1;
86 END IF;
87
88 IF (px_COUNTER_VALUE_ID IS NULL) OR (px_COUNTER_VALUE_ID = FND_API.G_MISS_NUM) then
89 OPEN c2;
90 FETCH c2 INTO px_COUNTER_VALUE_ID;
91 CLOSE c2;
92 END IF;
93
94 INSERT INTO CSI_CTR_READINGS_INTERFACE(
95 COUNTER_INTERFACE_ID
96 ,PARALLEL_WORKER_ID
97 ,BATCH_NAME
98 ,SOURCE_TRANSACTION_DATE
99 ,PROCESS_STATUS
100 ,ERROR_TEXT
101 ,COUNTER_VALUE_ID
102 ,COUNTER_ID
103 ,VALUE_TIMESTAMP
104 ,COUNTER_READING
105 ,RESET_MODE
106 ,RESET_REASON
107 ,ADJUSTMENT_TYPE
108 ,ADJUSTMENT_READING
109 ,OBJECT_VERSION_NUMBER
110 ,LAST_UPDATE_DATE
111 ,LAST_UPDATED_BY
112 ,CREATION_DATE
113 ,CREATED_BY
114 ,LAST_UPDATE_LOGIN
115 ,ATTRIBUTE1
116 ,ATTRIBUTE2
117 ,ATTRIBUTE3
118 ,ATTRIBUTE4
119 ,ATTRIBUTE5
120 ,ATTRIBUTE6
121 ,ATTRIBUTE7
122 ,ATTRIBUTE8
123 ,ATTRIBUTE9
124 ,ATTRIBUTE10
125 ,ATTRIBUTE11
126 ,ATTRIBUTE12
127 ,ATTRIBUTE13
128 ,ATTRIBUTE14
129 ,ATTRIBUTE15
130 ,ATTRIBUTE16
131 ,ATTRIBUTE17
132 ,ATTRIBUTE18
133 ,ATTRIBUTE19
134 ,ATTRIBUTE20
135 ,ATTRIBUTE21
136 ,ATTRIBUTE22
137 ,ATTRIBUTE23
138 ,ATTRIBUTE24
139 ,ATTRIBUTE25
140 ,ATTRIBUTE26
141 ,ATTRIBUTE27
142 ,ATTRIBUTE28
143 ,ATTRIBUTE29
144 ,ATTRIBUTE30
145 ,ATTRIBUTE_CATEGORY
146 ,DISABLED_FLAG
147 ,COMMENTS
148 ,SOURCE_TRANSACTION_TYPE_ID
149 ,SOURCE_TRANSACTION_ID
150 ,SOURCE_CODE
151 ,SOURCE_LINE_ID
152 ,COUNTER_NAME
153 ,AUTOMATIC_ROLLOVER_FLAG
154 ,INCLUDE_TARGET_RESETS
155 ,RESET_COUNTER_READING
156 ,NET_READING
157 ,LIFE_TO_DATE_READING
158 ,SOURCE_COUNTER_VALUE_ID
159 )
160 VALUES
161 (px_COUNTER_INTERFACE_ID
162 ,decode(p_PARALLEL_WORKER_ID, FND_API.G_MISS_NUM, NULL,p_PARALLEL_WORKER_ID)
163 ,decode(p_BATCH_NAME, FND_API.G_MISS_CHAR, NULL,p_BATCH_NAME)
164 ,decode(p_SOURCE_TRANSACTION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_SOURCE_TRANSACTION_DATE)
165 ,decode(p_PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL,p_PROCESS_STATUS)
166 ,decode(p_ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
167 ,px_COUNTER_VALUE_ID
168 ,decode(p_COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
169 ,decode(p_VALUE_TIMESTAMP, FND_API.G_MISS_DATE, TO_DATE(NULL),p_VALUE_TIMESTAMP)
170 ,decode(p_COUNTER_READING, FND_API.G_MISS_NUM, NULL,p_COUNTER_READING)
171 ,decode(p_RESET_MODE, FND_API.G_MISS_CHAR, NULL,p_RESET_MODE)
172 ,decode(p_RESET_REASON, FND_API.G_MISS_CHAR, NULL,p_RESET_REASON)
173 ,decode(p_ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL,p_ADJUSTMENT_TYPE)
174 ,decode(p_ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL,p_ADJUSTMENT_READING)
175 ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)
176 ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_LAST_UPDATE_DATE)
177 ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
178 ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_CREATION_DATE)
179 ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
180 ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
181 ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)
182 ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)
183 ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)
184 ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)
185 ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)
186 ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)
187 ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)
188 ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)
189 ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)
190 ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)
191 ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)
192 ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)
193 ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)
194 ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)
195 ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)
196 ,decode(p_ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE16)
197 ,decode(p_ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE17)
198 ,decode(p_ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE18)
199 ,decode(p_ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE19)
200 ,decode(p_ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE20)
201 ,decode(p_ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE21)
202 ,decode(p_ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE22)
203 ,decode(p_ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE23)
204 ,decode(p_ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE24)
205 ,decode(p_ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE25)
206 ,decode(p_ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE26)
207 ,decode(p_ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE27)
208 ,decode(p_ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE28)
209 ,decode(p_ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE29)
210 ,decode(p_ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE30)
211 ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)
212 ,decode(p_DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL,p_DISABLED_FLAG)
213 ,decode(p_COMMENTS, FND_API.G_MISS_CHAR, NULL,p_COMMENTS)
214 ,decode(p_SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_TYPE_ID)
215 ,decode(p_SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_TRANSACTION_ID)
216 ,decode(p_SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
217 ,decode(p_SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL,p_SOURCE_LINE_ID)
218 ,decode(p_COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
219 ,decode(p_AUTOMATIC_ROLLOVER_FLAG,FND_API.G_MISS_CHAR, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
220 ,decode(p_INCLUDE_TARGET_RESETS,FND_API.G_MISS_CHAR, NULL, p_INCLUDE_TARGET_RESETS)
221 ,decode(p_RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)
222 ,decode(p_NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
223 ,decode(p_LIFE_TO_DATE_READING, FND_API.G_MISS_NUM, NULL, p_LIFE_TO_DATE_READING)
224 ,decode(p_SOURCE_COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_COUNTER_VALUE_ID));
225 END insert_row;
226
227
228 PROCEDURE Update_Row(
229 p_COUNTER_INTERFACE_ID NUMBER
230 ,p_PARALLEL_WORKER_ID NUMBER
231 ,p_BATCH_NAME VARCHAR2
232 ,p_SOURCE_TRANSACTION_DATE DATE
233 ,p_PROCESS_STATUS VARCHAR2
234 ,p_ERROR_TEXT VARCHAR2
235 ,p_COUNTER_VALUE_ID NUMBER
236 ,p_COUNTER_ID NUMBER
237 ,p_VALUE_TIMESTAMP DATE
238 ,p_COUNTER_READING NUMBER
239 ,p_RESET_MODE VARCHAR2
240 ,p_RESET_REASON VARCHAR2
241 ,p_ADJUSTMENT_TYPE VARCHAR2
242 ,p_ADJUSTMENT_READING NUMBER
243 ,p_OBJECT_VERSION_NUMBER NUMBER
244 ,p_LAST_UPDATE_DATE DATE
245 ,p_LAST_UPDATED_BY NUMBER
246 ,p_CREATION_DATE DATE
247 ,p_CREATED_BY NUMBER
248 ,p_LAST_UPDATE_LOGIN NUMBER
249 ,p_ATTRIBUTE1 VARCHAR2
250 ,p_ATTRIBUTE2 VARCHAR2
251 ,p_ATTRIBUTE3 VARCHAR2
252 ,p_ATTRIBUTE4 VARCHAR2
253 ,p_ATTRIBUTE5 VARCHAR2
254 ,p_ATTRIBUTE6 VARCHAR2
255 ,p_ATTRIBUTE7 VARCHAR2
256 ,p_ATTRIBUTE8 VARCHAR2
257 ,p_ATTRIBUTE9 VARCHAR2
258 ,p_ATTRIBUTE10 VARCHAR2
259 ,p_ATTRIBUTE11 VARCHAR2
260 ,p_ATTRIBUTE12 VARCHAR2
261 ,p_ATTRIBUTE13 VARCHAR2
262 ,p_ATTRIBUTE14 VARCHAR2
263 ,p_ATTRIBUTE15 VARCHAR2
264 ,p_ATTRIBUTE16 VARCHAR2
265 ,p_ATTRIBUTE17 VARCHAR2
266 ,p_ATTRIBUTE18 VARCHAR2
267 ,p_ATTRIBUTE19 VARCHAR2
268 ,p_ATTRIBUTE20 VARCHAR2
269 ,p_ATTRIBUTE21 VARCHAR2
270 ,p_ATTRIBUTE22 VARCHAR2
271 ,p_ATTRIBUTE23 VARCHAR2
272 ,p_ATTRIBUTE24 VARCHAR2
273 ,p_ATTRIBUTE25 VARCHAR2
274 ,p_ATTRIBUTE26 VARCHAR2
275 ,p_ATTRIBUTE27 VARCHAR2
276 ,p_ATTRIBUTE28 VARCHAR2
277 ,p_ATTRIBUTE29 VARCHAR2
278 ,p_ATTRIBUTE30 VARCHAR2
279 ,p_ATTRIBUTE_CATEGORY VARCHAR2
280 ,p_DISABLED_FLAG VARCHAR2
281 ,p_COMMENTS VARCHAR2
282 ,p_SOURCE_TRANSACTION_TYPE_ID NUMBER
283 ,p_SOURCE_TRANSACTION_ID NUMBER
284 ,p_SOURCE_CODE VARCHAR2
285 ,p_SOURCE_LINE_ID NUMBER
286 ,p_COUNTER_NAME VARCHAR2
287 ,p_AUTOMATIC_ROLLOVER_FLAG VARCHAR2
288 ,p_INCLUDE_TARGET_RESETS VARCHAR2
289 ,p_RESET_COUNTER_READING NUMBER
290 ,p_NET_READING NUMBER
291 ,p_LIFE_TO_DATE_READING NUMBER
292 ,p_SOURCE_COUNTER_VALUE_ID NUMBER) IS
293 BEGIN
294 UPDATE CSI_CTR_READINGS_INTERFACE
295 SET PARALLEL_WORKER_ID = decode(p_PARALLEL_WORKER_ID, NULL, PARALLEL_WORKER_ID, FND_API.G_MISS_NUM, NULL, p_PARALLEL_WORKER_ID)
296 ,BATCH_NAME = decode(p_BATCH_NAME, NULL, BATCH_NAME,FND_API.G_MISS_CHAR, NULL, p_BATCH_NAME)
297 ,SOURCE_TRANSACTION_DATE = decode(p_SOURCE_TRANSACTION_DATE, NULL, SOURCE_TRANSACTION_DATE, FND_API.G_MISS_DATE, NULL, p_SOURCE_TRANSACTION_DATE)
298 ,PROCESS_STATUS = decode(p_PROCESS_STATUS, NULL, PROCESS_STATUS, FND_API.G_MISS_CHAR, NULL, p_PROCESS_STATUS)
299 ,ERROR_TEXT = decode(p_ERROR_TEXT, NULL, ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
300 ,COUNTER_VALUE_ID = decode(p_COUNTER_VALUE_ID, NULL, COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_VALUE_ID)
301 ,COUNTER_ID = decode(p_COUNTER_ID, NULL, COUNTER_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_ID)
302 ,VALUE_TIMESTAMP = decode(p_VALUE_TIMESTAMP, NULL, VALUE_TIMESTAMP, FND_API.G_MISS_DATE, NULL, p_VALUE_TIMESTAMP)
303 ,COUNTER_READING = decode(p_COUNTER_READING, NULL, COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_COUNTER_READING)
304 ,RESET_MODE = decode(p_RESET_MODE, NULL, RESET_MODE, FND_API.G_MISS_CHAR, NULL, p_RESET_MODE)
305 ,RESET_REASON = decode(p_RESET_REASON, NULL, RESET_REASON, FND_API.G_MISS_CHAR, NULL, p_RESET_REASON)
306
307 ,ADJUSTMENT_TYPE = decode(p_ADJUSTMENT_TYPE, NULL, ADJUSTMENT_TYPE, FND_API.G_MISS_CHAR, NULL, p_ADJUSTMENT_TYPE)
308 ,ADJUSTMENT_READING = decode(p_ADJUSTMENT_READING, NULL, ADJUSTMENT_READING, FND_API.G_MISS_NUM, NULL, p_ADJUSTMENT_READING)
309 ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER,p_OBJECT_VERSION_NUMBER)
310 ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE)
311 ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
312 ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE)
313 ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
314 ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
315 ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
316 ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
317 ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
318 ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
319 ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
320 ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
321 ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
322 ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
323 ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
324 ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
325 ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
326 ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
330 ,ATTRIBUTE16 = decode(p_ATTRIBUTE16, NULL, ATTRIBUTE16, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE16)
327 ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
328 ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
329 ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
331 ,ATTRIBUTE17 = decode(p_ATTRIBUTE17, NULL, ATTRIBUTE17, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE17)
332 ,ATTRIBUTE18 = decode(p_ATTRIBUTE18, NULL, ATTRIBUTE18, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE18)
333 ,ATTRIBUTE19 = decode(p_ATTRIBUTE19, NULL, ATTRIBUTE19, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE19)
334 ,ATTRIBUTE20 = decode(p_ATTRIBUTE20, NULL, ATTRIBUTE20, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE20)
335 ,ATTRIBUTE21 = decode(p_ATTRIBUTE21, NULL, ATTRIBUTE21, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE21)
336 ,ATTRIBUTE22 = decode(p_ATTRIBUTE22, NULL, ATTRIBUTE22, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE22)
337 ,ATTRIBUTE23 = decode(p_ATTRIBUTE23, NULL, ATTRIBUTE23, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE23)
338 ,ATTRIBUTE24 = decode(p_ATTRIBUTE24, NULL, ATTRIBUTE24, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE24)
339 ,ATTRIBUTE25 = decode(p_ATTRIBUTE25, NULL, ATTRIBUTE25, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE25)
340 ,ATTRIBUTE26 = decode(p_ATTRIBUTE26, NULL, ATTRIBUTE26, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE26)
341 ,ATTRIBUTE27 = decode(p_ATTRIBUTE27, NULL, ATTRIBUTE27, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE27)
342 ,ATTRIBUTE28 = decode(p_ATTRIBUTE28, NULL, ATTRIBUTE28, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE28)
343 ,ATTRIBUTE29 = decode(p_ATTRIBUTE29, NULL, ATTRIBUTE29, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE29)
344 ,ATTRIBUTE30 = decode(p_ATTRIBUTE30, NULL, ATTRIBUTE30, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE30)
345 ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
346 ,DISABLED_FLAG = decode(p_DISABLED_FLAG, NULL, DISABLED_FLAG, FND_API.G_MISS_CHAR, NULL, p_DISABLED_FLAG)
347 ,COMMENTS = decode(p_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, p_COMMENTS)
348 ,SOURCE_TRANSACTION_TYPE_ID = decode(p_SOURCE_TRANSACTION_TYPE_ID, NULL, SOURCE_TRANSACTION_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_TYPE_ID)
349 ,SOURCE_TRANSACTION_ID = decode(p_SOURCE_TRANSACTION_ID, NULL, SOURCE_TRANSACTION_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_TRANSACTION_ID)
350 ,SOURCE_CODE = decode(p_SOURCE_CODE, NULL, SOURCE_CODE, FND_API.G_MISS_CHAR, NULL, p_SOURCE_CODE)
351 ,SOURCE_LINE_ID = decode(p_SOURCE_LINE_ID, NULL, SOURCE_LINE_ID, FND_API.G_MISS_NUM, NULL, p_SOURCE_LINE_ID)
352 ,COUNTER_NAME = decode(p_COUNTER_NAME, NULL, COUNTER_NAME, FND_API.G_MISS_CHAR, NULL, p_COUNTER_NAME)
353 ,AUTOMATIC_ROLLOVER_FLAG = decode(p_AUTOMATIC_ROLLOVER_FLAG, NULL, AUTOMATIC_ROLLOVER_FLAG, FND_API.G_MISS_NUM, NULL, p_AUTOMATIC_ROLLOVER_FLAG)
354 ,INCLUDE_TARGET_RESETS = decode(p_INCLUDE_TARGET_RESETS, NULL, INCLUDE_TARGET_RESETS, FND_API.G_MISS_NUM, NULL, p_INCLUDE_TARGET_RESETS)
355 ,RESET_COUNTER_READING = decode(p_RESET_COUNTER_READING, NULL, RESET_COUNTER_READING, FND_API.G_MISS_NUM, NULL, p_RESET_COUNTER_READING)
356 ,NET_READING = decode(p_NET_READING, NULL, NET_READING, FND_API.G_MISS_NUM, NULL, p_NET_READING)
357 ,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)
358 ,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)
359 WHERE COUNTER_INTERFACE_ID = p_COUNTER_INTERFACE_ID;
360 END update_row;
361
362
363 PROCEDURE lock_row(
364 p_COUNTER_INTERFACE_ID NUMBER
365 ,p_PARALLEL_WORKER_ID NUMBER
366 ,p_BATCH_NAME VARCHAR2
367 ,p_SOURCE_TRANSACTION_DATE DATE
368 ,p_PROCESS_STATUS VARCHAR2
369 ,p_ERROR_TEXT VARCHAR2
370 ,p_COUNTER_VALUE_ID NUMBER
371 ,p_COUNTER_ID NUMBER
372 ,p_VALUE_TIMESTAMP DATE
373 ,p_COUNTER_READING NUMBER
374 ,p_RESET_MODE VARCHAR2
375 ,p_RESET_REASON VARCHAR2
376 ,p_ADJUSTMENT_TYPE VARCHAR2
377 ,p_ADJUSTMENT_READING NUMBER
378 ,p_OBJECT_VERSION_NUMBER NUMBER
379 ,p_LAST_UPDATE_DATE DATE
380 ,p_LAST_UPDATED_BY NUMBER
381 ,p_CREATION_DATE DATE
382 ,p_CREATED_BY NUMBER
383 ,p_LAST_UPDATE_LOGIN NUMBER
384 ,p_ATTRIBUTE1 VARCHAR2
385 ,p_ATTRIBUTE2 VARCHAR2
386 ,p_ATTRIBUTE3 VARCHAR2
387 ,p_ATTRIBUTE4 VARCHAR2
388 ,p_ATTRIBUTE5 VARCHAR2
389 ,p_ATTRIBUTE6 VARCHAR2
390 ,p_ATTRIBUTE7 VARCHAR2
391 ,p_ATTRIBUTE8 VARCHAR2
392 ,p_ATTRIBUTE9 VARCHAR2
393 ,p_ATTRIBUTE10 VARCHAR2
394 ,p_ATTRIBUTE11 VARCHAR2
395 ,p_ATTRIBUTE12 VARCHAR2
396 ,p_ATTRIBUTE13 VARCHAR2
397 ,p_ATTRIBUTE14 VARCHAR2
398 ,p_ATTRIBUTE15 VARCHAR2
399 ,p_ATTRIBUTE16 VARCHAR2
400 ,p_ATTRIBUTE17 VARCHAR2
401 ,p_ATTRIBUTE18 VARCHAR2
402 ,p_ATTRIBUTE19 VARCHAR2
403 ,p_ATTRIBUTE20 VARCHAR2
404 ,p_ATTRIBUTE21 VARCHAR2
405 ,p_ATTRIBUTE22 VARCHAR2
406 ,p_ATTRIBUTE23 VARCHAR2
407 ,p_ATTRIBUTE24 VARCHAR2
408 ,p_ATTRIBUTE25 VARCHAR2
412 ,p_ATTRIBUTE29 VARCHAR2
409 ,p_ATTRIBUTE26 VARCHAR2
410 ,p_ATTRIBUTE27 VARCHAR2
411 ,p_ATTRIBUTE28 VARCHAR2
413 ,p_ATTRIBUTE30 VARCHAR2
414 ,p_ATTRIBUTE_CATEGORY VARCHAR2
415 ,p_DISABLED_FLAG VARCHAR2
416 ,p_COMMENTS VARCHAR2
417 ,p_SOURCE_TRANSACTION_TYPE_ID NUMBER
418 ,p_SOURCE_TRANSACTION_ID NUMBER
419 ,p_SOURCE_CODE VARCHAR2
420 ,p_SOURCE_LINE_ID NUMBER
421 ,p_COUNTER_NAME VARCHAR2
422 ,p_AUTOMATIC_ROLLOVER_FLAG VARCHAR2
423 ,p_INCLUDE_TARGET_RESETS VARCHAR2
424 ,p_RESET_COUNTER_READING NUMBER
425 ,p_NET_READING NUMBER
426 ,p_LIFE_TO_DATE_READING NUMBER
427 ,p_SOURCE_COUNTER_VALUE_ID NUMBER) IS
428
429 CURSOR C1 IS
430 SELECT *
431 FROM CSI_CTR_READINGS_INTERFACE
432 WHERE COUNTER_INTERFACE_ID = p_COUNTER_INTERFACE_ID
433 FOR UPDATE of COUNTER_INTERFACE_ID NOWAIT;
434 Recinfo C1%ROWTYPE;
435 BEGIN
436 OPEN C1;
437 FETCH C1 INTO Recinfo;
438 IF (C1%NOTFOUND) then
439 CLOSE C1;
440 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
441 APP_EXCEPTION.RAISE_EXCEPTION;
442 END IF;
443 CLOSE C1;
444
445 IF (
446 ( Recinfo.COUNTER_INTERFACE_ID = p_COUNTER_INTERFACE_ID )
447 AND ( ( Recinfo.PARALLEL_WORKER_ID = p_PARALLEL_WORKER_ID)
448 OR ( ( Recinfo.PARALLEL_WORKER_ID IS NULL )
449 AND ( p_PARALLEL_WORKER_ID IS NULL )))
450 AND ( ( Recinfo.BATCH_NAME = p_BATCH_NAME)
451 OR ( ( Recinfo.BATCH_NAME IS NULL )
452 AND ( p_BATCH_NAME IS NULL )))
453 AND ( ( Recinfo.ERROR_TEXT = p_ERROR_TEXT)
454 OR ( ( Recinfo.ERROR_TEXT IS NULL )
455 AND ( p_ERROR_TEXT IS NULL )))
456 AND ( ( Recinfo.SOURCE_TRANSACTION_DATE = p_SOURCE_TRANSACTION_DATE)
457 OR ( ( Recinfo.SOURCE_TRANSACTION_DATE IS NULL )
458 AND ( p_SOURCE_TRANSACTION_DATE IS NULL )))
459 AND ( ( Recinfo.PROCESS_STATUS = p_PROCESS_STATUS)
460 OR ( ( Recinfo.PROCESS_STATUS IS NULL )
461 AND ( p_PROCESS_STATUS IS NULL )))
462 AND ( ( Recinfo.COUNTER_VALUE_ID = p_COUNTER_VALUE_ID)
463 OR ( ( Recinfo.COUNTER_VALUE_ID IS NULL )
464 AND ( p_COUNTER_VALUE_ID IS NULL )))
465 AND ( ( Recinfo.COUNTER_ID = p_COUNTER_ID)
466 OR ( ( Recinfo.COUNTER_ID IS NULL )
467 AND ( p_COUNTER_ID IS NULL )))
468 AND ( ( Recinfo.VALUE_TIMESTAMP = p_VALUE_TIMESTAMP)
469 OR ( ( Recinfo.VALUE_TIMESTAMP IS NULL )
470 AND ( p_VALUE_TIMESTAMP IS NULL )))
471 AND ( ( Recinfo.COUNTER_READING = p_COUNTER_READING)
472 OR ( ( Recinfo.COUNTER_READING IS NULL )
473 AND ( p_COUNTER_READING IS NULL )))
474 AND ( ( Recinfo.RESET_MODE = p_RESET_MODE)
475 OR ( ( Recinfo.RESET_MODE IS NULL )
476 AND ( p_RESET_MODE IS NULL )))
477 AND ( ( Recinfo.RESET_REASON = p_RESET_REASON)
478 OR ( ( Recinfo.RESET_REASON IS NULL )
479 AND ( p_RESET_REASON IS NULL )))
480 AND ( ( Recinfo.ADJUSTMENT_TYPE = p_ADJUSTMENT_TYPE)
481 OR ( ( Recinfo.ADJUSTMENT_TYPE IS NULL )
482 AND ( p_ADJUSTMENT_TYPE IS NULL )))
483 AND ( ( Recinfo.ADJUSTMENT_READING = p_ADJUSTMENT_READING)
484 OR ( ( Recinfo.ADJUSTMENT_READING IS NULL )
485 AND ( p_ADJUSTMENT_READING IS NULL )))
486 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
487 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
488 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
489 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
490 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
491 AND ( p_LAST_UPDATE_DATE IS NULL )))
492 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
493 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
494 AND ( p_LAST_UPDATED_BY IS NULL )))
495 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
496 OR ( ( Recinfo.CREATION_DATE IS NULL )
497 AND ( p_CREATION_DATE IS NULL )))
498 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
499 OR ( ( Recinfo.CREATED_BY IS NULL )
500 AND ( p_CREATED_BY IS NULL )))
501 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
502 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
503 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
504 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
505 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
506 AND ( p_ATTRIBUTE1 IS NULL )))
507 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
508 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
509 AND ( p_ATTRIBUTE2 IS NULL )))
510 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
511 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
512 AND ( p_ATTRIBUTE3 IS NULL )))
513 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
514 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
515 AND ( p_ATTRIBUTE4 IS NULL )))
516 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
517 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
518 AND ( p_ATTRIBUTE5 IS NULL )))
519 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
520 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
524 AND ( p_ATTRIBUTE7 IS NULL )))
521 AND ( p_ATTRIBUTE6 IS NULL )))
522 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
523 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
525 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
526 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
527 AND ( p_ATTRIBUTE8 IS NULL )))
528 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
529 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
530 AND ( p_ATTRIBUTE9 IS NULL )))
531 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
532 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
533 AND ( p_ATTRIBUTE10 IS NULL )))
534 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
535 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
536 AND ( p_ATTRIBUTE11 IS NULL )))
537 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
538 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
539 AND ( p_ATTRIBUTE12 IS NULL )))
540 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
541 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
542 AND ( p_ATTRIBUTE13 IS NULL )))
543 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
544 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
545 AND ( p_ATTRIBUTE14 IS NULL )))
546 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
547 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
548 AND ( p_ATTRIBUTE15 IS NULL )))
549 AND ( ( Recinfo.ATTRIBUTE16 = p_ATTRIBUTE16)
550 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
551 AND ( p_ATTRIBUTE16 IS NULL )))
552 AND ( ( Recinfo.ATTRIBUTE16 = p_ATTRIBUTE15)
553 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
554 AND ( p_ATTRIBUTE17 IS NULL )))
555 AND ( ( Recinfo.ATTRIBUTE17 = p_ATTRIBUTE17)
556 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
557 AND ( p_ATTRIBUTE17 IS NULL )))
558 AND ( ( Recinfo.ATTRIBUTE18 = p_ATTRIBUTE18)
559 OR ( ( Recinfo.ATTRIBUTE18 IS NULL )
560 AND ( p_ATTRIBUTE18 IS NULL )))
561 AND ( ( Recinfo.ATTRIBUTE19 = p_ATTRIBUTE19)
562 OR ( ( Recinfo.ATTRIBUTE19 IS NULL )
563 AND ( p_ATTRIBUTE19 IS NULL )))
564 AND ( ( Recinfo.ATTRIBUTE20 = p_ATTRIBUTE20)
565 OR ( ( Recinfo.ATTRIBUTE20 IS NULL )
566 AND ( p_ATTRIBUTE20 IS NULL )))
567 AND ( ( Recinfo.ATTRIBUTE21 = p_ATTRIBUTE21)
568 OR ( ( Recinfo.ATTRIBUTE21 IS NULL )
569 AND ( p_ATTRIBUTE21 IS NULL )))
570 AND ( ( Recinfo.ATTRIBUTE22 = p_ATTRIBUTE22)
571 OR ( ( Recinfo.ATTRIBUTE22 IS NULL )
572 AND ( p_ATTRIBUTE22 IS NULL )))
573 AND ( ( Recinfo.ATTRIBUTE23 = p_ATTRIBUTE23)
574 OR ( ( Recinfo.ATTRIBUTE23 IS NULL )
575 AND ( p_ATTRIBUTE23 IS NULL )))
576 AND ( ( Recinfo.ATTRIBUTE24 = p_ATTRIBUTE24)
577 OR ( ( Recinfo.ATTRIBUTE24 IS NULL )
578 AND ( p_ATTRIBUTE24 IS NULL )))
579 AND ( ( Recinfo.ATTRIBUTE25 = p_ATTRIBUTE25)
580 OR ( ( Recinfo.ATTRIBUTE25 IS NULL )
581 AND ( p_ATTRIBUTE25 IS NULL )))
582 AND ( ( Recinfo.ATTRIBUTE26 = p_ATTRIBUTE26)
583 OR ( ( Recinfo.ATTRIBUTE26 IS NULL )
584 AND ( p_ATTRIBUTE26 IS NULL )))
585 AND ( ( Recinfo.ATTRIBUTE27 = p_ATTRIBUTE27)
586 OR ( ( Recinfo.ATTRIBUTE27 IS NULL )
587 AND ( p_ATTRIBUTE27 IS NULL )))
588 AND ( ( Recinfo.ATTRIBUTE28 = p_ATTRIBUTE28)
589 OR ( ( Recinfo.ATTRIBUTE28 IS NULL )
590 AND ( p_ATTRIBUTE28 IS NULL )))
591 AND ( ( Recinfo.ATTRIBUTE29 = p_ATTRIBUTE29)
592 OR ( ( Recinfo.ATTRIBUTE29 IS NULL )
593 AND ( p_ATTRIBUTE29 IS NULL )))
594 AND ( ( Recinfo.ATTRIBUTE30 = p_ATTRIBUTE30)
595 OR ( ( Recinfo.ATTRIBUTE30 IS NULL )
596 AND ( p_ATTRIBUTE30 IS NULL )))
597 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
598 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
599 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
600 AND ( ( Recinfo.DISABLED_FLAG = p_DISABLED_FLAG)
601 OR ( ( Recinfo.DISABLED_FLAG IS NULL )
602 AND ( p_DISABLED_FLAG IS NULL )))
603 AND ( ( Recinfo.COMMENTS = p_COMMENTS)
604 OR ( ( Recinfo.COMMENTS IS NULL )
605 AND ( p_COMMENTS IS NULL )))
606 AND ( ( Recinfo.SOURCE_TRANSACTION_TYPE_ID = p_SOURCE_TRANSACTION_TYPE_ID)
607 OR ( ( Recinfo.SOURCE_TRANSACTION_TYPE_ID IS NULL )
608 AND ( p_SOURCE_TRANSACTION_TYPE_ID IS NULL )))
609 AND ( ( Recinfo.SOURCE_TRANSACTION_ID = p_SOURCE_TRANSACTION_ID)
610 OR ( ( Recinfo.SOURCE_TRANSACTION_ID IS NULL )
611 AND ( p_SOURCE_TRANSACTION_ID IS NULL )))
612 AND ( ( Recinfo.SOURCE_CODE = p_SOURCE_CODE)
613 OR ( ( Recinfo.SOURCE_CODE IS NULL )
614 AND ( p_SOURCE_CODE IS NULL )))
615 AND ( ( Recinfo.SOURCE_LINE_ID = p_SOURCE_LINE_ID)
616 OR ( ( Recinfo.SOURCE_LINE_ID IS NULL )
617 AND ( p_SOURCE_LINE_ID IS NULL )))
618 AND ( ( Recinfo.COUNTER_NAME = p_COUNTER_NAME)
619 OR ( ( Recinfo.COUNTER_NAME IS NULL )
620 AND ( p_COUNTER_NAME IS NULL )))
621 AND ( ( Recinfo.NET_READING = p_NET_READING)
622 OR ( ( Recinfo.NET_READING IS NULL )
623 AND ( p_NET_READING IS NULL )))
624 AND ( ( Recinfo.LIFE_TO_DATE_READING = p_LIFE_TO_DATE_READING)
625 OR ( ( Recinfo.LIFE_TO_DATE_READING IS NULL )
626 AND ( p_LIFE_TO_DATE_READING IS NULL )))
630 ) then
627 AND ( ( Recinfo.SOURCE_COUNTER_VALUE_ID = p_SOURCE_COUNTER_VALUE_ID)
628 OR ( ( Recinfo.SOURCE_COUNTER_VALUE_ID IS NULL )
629 AND ( p_SOURCE_COUNTER_VALUE_ID IS NULL )))
631 return;
632 ELSE
633 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
634 APP_EXCEPTION.RAISE_EXCEPTION;
635 END IF;
636 END lock_row;
637
638
639 PROCEDURE delete_row(p_COUNTER_INTERFACE_ID NUMBER) IS
640 BEGIN
641 DELETE FROM CSI_CTR_READINGS_INTERFACE
642 WHERE COUNTER_INTERFACE_ID = p_COUNTER_INTERFACE_ID;
643 IF (SQL%NOTFOUND) then
644 RAISE NO_DATA_FOUND;
645 END IF;
646 END delete_row;
647
648 End CSI_CTR_READING_INTERFACE_PKG;