[Home] [Help]
PACKAGE BODY: APPS.CSI_CTR_READ_PROP_INTFACE_PKG
Source
1 PACKAGE BODY CSI_CTR_READ_PROP_INTFACE_PKG as
2 /* $Header: csitcrpb.pls 120.1 2006/07/12 22:47:36 epajaril noship $*/
3
4 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSI_CTR_READ_PROP_INTFACE_PKG';
5 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csitcrpb.pls';
6
7 PROCEDURE insert_row(
8 px_COUNTER_READ_PROP_INT_ID IN OUT NOCOPY NUMBER
9 ,p_COUNTER_INTERFACE_ID NUMBER
10 ,p_PARALLEL_WORKER_ID NUMBER
11 ,p_ERROR_TEXT VARCHAR2
12 ,p_COUNTER_PROP_VALUE_ID NUMBER
13 ,p_COUNTER_VALUE_ID NUMBER
14 ,p_COUNTER_PROPERTY_ID NUMBER
15 ,p_PROPERTY_VALUE VARCHAR2
16 ,p_VALUE_TIMESTAMP DATE
17 ,p_OBJECT_VERSION_NUMBER NUMBER
18 ,p_LAST_UPDATE_DATE DATE
19 ,p_LAST_UPDATED_BY NUMBER
20 ,p_CREATION_DATE DATE
21 ,p_CREATED_BY NUMBER
22 ,p_LAST_UPDATE_LOGIN NUMBER
23 ,p_ATTRIBUTE1 VARCHAR2
24 ,p_ATTRIBUTE2 VARCHAR2
25 ,p_ATTRIBUTE3 VARCHAR2
26 ,p_ATTRIBUTE4 VARCHAR2
27 ,p_ATTRIBUTE5 VARCHAR2
28 ,p_ATTRIBUTE6 VARCHAR2
29 ,p_ATTRIBUTE7 VARCHAR2
30 ,p_ATTRIBUTE8 VARCHAR2
31 ,p_ATTRIBUTE9 VARCHAR2
32 ,p_ATTRIBUTE10 VARCHAR2
33 ,p_ATTRIBUTE11 VARCHAR2
34 ,p_ATTRIBUTE12 VARCHAR2
35 ,p_ATTRIBUTE13 VARCHAR2
36 ,p_ATTRIBUTE14 VARCHAR2
37 ,p_ATTRIBUTE15 VARCHAR2
38 ,p_ATTRIBUTE_CATEGORY VARCHAR2
39 ,p_MIGRATED_FLAG VARCHAR2) IS
40
41 CURSOR C1 IS
42 SELECT CSI_CTR_READ_PTY_INTERFACE_S.nextval
43 FROM dual;
44 BEGIN
45 IF (px_COUNTER_READ_PROP_INT_ID IS NULL) OR (px_COUNTER_READ_PROP_INT_ID = FND_API.G_MISS_NUM) then
46 OPEN C1;
47 FETCH C1 INTO px_COUNTER_READ_PROP_INT_ID;
48 CLOSE C1;
49 END IF;
50
51 INSERT INTO CSI_CTR_READ_PROP_INTERFACE(
52 COUNTER_READ_PROP_INT_ID
53 ,COUNTER_INTERFACE_ID
54 ,PARALLEL_WORKER_ID
55 ,ERROR_TEXT
56 ,COUNTER_PROP_VALUE_ID
57 ,COUNTER_VALUE_ID
58 ,COUNTER_PROPERTY_ID
59 ,PROPERTY_VALUE
60 ,VALUE_TIMESTAMP
61 ,OBJECT_VERSION_NUMBER
62 ,LAST_UPDATE_DATE
63 ,LAST_UPDATED_BY
64 ,CREATION_DATE
65 ,CREATED_BY
66 ,LAST_UPDATE_LOGIN
67 ,ATTRIBUTE1
68 ,ATTRIBUTE2
69 ,ATTRIBUTE3
70 ,ATTRIBUTE4
71 ,ATTRIBUTE5
72 ,ATTRIBUTE6
73 ,ATTRIBUTE7
74 ,ATTRIBUTE8
75 ,ATTRIBUTE9
76 ,ATTRIBUTE10
77 ,ATTRIBUTE11
78 ,ATTRIBUTE12
79 ,ATTRIBUTE13
80 ,ATTRIBUTE14
81 ,ATTRIBUTE15
82 ,ATTRIBUTE_CATEGORY
83 ,MIGRATED_FLAG
84 )
85 VALUES
86 (px_COUNTER_READ_PROP_INT_ID
87 ,decode(p_COUNTER_INTERFACE_ID, FND_API.G_MISS_NUM, NULL,p_COUNTER_INTERFACE_ID)
88 ,decode(p_PARALLEL_WORKER_ID, FND_API.G_MISS_NUM, NULL,p_PARALLEL_WORKER_ID)
89 ,decode(p_ERROR_TEXT, FND_API.G_MISS_CHAR, NULL,p_ERROR_TEXT)
90 ,decode(p_COUNTER_PROP_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_PROP_VALUE_ID)
91 ,decode(p_COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_VALUE_ID)
92 ,decode(p_COUNTER_PROPERTY_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_PROPERTY_ID)
93 ,decode(p_PROPERTY_VALUE, FND_API.G_MISS_CHAR, NULL, p_PROPERTY_VALUE)
94 ,decode(p_VALUE_TIMESTAMP, FND_API.G_MISS_DATE, TO_DATE(NULL),p_VALUE_TIMESTAMP)
95 ,decode(p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL,p_OBJECT_VERSION_NUMBER)
96 ,decode(p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_LAST_UPDATE_DATE)
97 ,decode(p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
98 ,decode(p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),p_CREATION_DATE)
99 ,decode(p_CREATED_BY, FND_API.G_MISS_NUM, NULL,p_CREATED_BY)
100 ,decode(p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATE_LOGIN)
101 ,decode(p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE1)
102 ,decode(p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE2)
103 ,decode(p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE3)
104 ,decode(p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE4)
105 ,decode(p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE5)
106 ,decode(p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE6)
107 ,decode(p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE7)
108 ,decode(p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE8)
109 ,decode(p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE9)
110 ,decode(p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE10)
111 ,decode(p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE11)
112 ,decode(p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE12)
113 ,decode(p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE13)
114 ,decode(p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE14)
115 ,decode(p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE15)
116 ,decode(p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,p_ATTRIBUTE_CATEGORY)
117 ,decode(p_MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL,p_MIGRATED_FLAG));
118 END insert_row;
119
120
121 PROCEDURE Update_Row(
122 p_COUNTER_READ_PROP_INT_ID NUMBER
123 ,p_COUNTER_INTERFACE_ID NUMBER
124 ,p_PARALLEL_WORKER_ID NUMBER
125 ,p_ERROR_TEXT VARCHAR2
126 ,p_COUNTER_PROP_VALUE_ID NUMBER
127 ,p_COUNTER_VALUE_ID NUMBER
128 ,p_COUNTER_PROPERTY_ID NUMBER
129 ,p_PROPERTY_VALUE VARCHAR2
130 ,p_VALUE_TIMESTAMP DATE
131 ,p_OBJECT_VERSION_NUMBER NUMBER
132 ,p_LAST_UPDATE_DATE DATE
133 ,p_LAST_UPDATED_BY NUMBER
134 ,p_CREATION_DATE DATE
135 ,p_CREATED_BY NUMBER
136 ,p_LAST_UPDATE_LOGIN NUMBER
137 ,p_ATTRIBUTE1 VARCHAR2
138 ,p_ATTRIBUTE2 VARCHAR2
139 ,p_ATTRIBUTE3 VARCHAR2
140 ,p_ATTRIBUTE4 VARCHAR2
141 ,p_ATTRIBUTE5 VARCHAR2
142 ,p_ATTRIBUTE6 VARCHAR2
143 ,p_ATTRIBUTE7 VARCHAR2
144 ,p_ATTRIBUTE8 VARCHAR2
145 ,p_ATTRIBUTE9 VARCHAR2
146 ,p_ATTRIBUTE10 VARCHAR2
147 ,p_ATTRIBUTE11 VARCHAR2
148 ,p_ATTRIBUTE12 VARCHAR2
149 ,p_ATTRIBUTE13 VARCHAR2
150 ,p_ATTRIBUTE14 VARCHAR2
151 ,p_ATTRIBUTE15 VARCHAR2
152 ,p_ATTRIBUTE_CATEGORY VARCHAR2
153 ,p_MIGRATED_FLAG VARCHAR2) IS
154 BEGIN
155 UPDATE CSI_CTR_READ_PROP_INTERFACE
156 SET COUNTER_INTERFACE_ID = decode(p_COUNTER_INTERFACE_ID, NULL, COUNTER_INTERFACE_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_INTERFACE_ID)
157 ,PARALLEL_WORKER_ID = decode(p_PARALLEL_WORKER_ID, NULL, PARALLEL_WORKER_ID, FND_API.G_MISS_NUM, NULL, p_PARALLEL_WORKER_ID)
158 ,ERROR_TEXT = decode(p_ERROR_TEXT, NULL, ERROR_TEXT, FND_API.G_MISS_CHAR, NULL, p_ERROR_TEXT)
159 ,PROPERTY_VALUE = decode(p_PROPERTY_VALUE, NULL, PROPERTY_VALUE, FND_API.G_MISS_CHAR, NULL, p_PROPERTY_VALUE)
160 ,COUNTER_PROP_VALUE_ID = decode(p_COUNTER_PROP_VALUE_ID, NULL, COUNTER_PROP_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_PROP_VALUE_ID)
161 ,COUNTER_VALUE_ID = decode(p_COUNTER_VALUE_ID, NULL, COUNTER_VALUE_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_VALUE_ID)
162 ,COUNTER_PROPERTY_ID = decode(p_COUNTER_PROPERTY_ID, NULL, COUNTER_PROPERTY_ID, FND_API.G_MISS_NUM, NULL, p_COUNTER_PROPERTY_ID)
163 ,VALUE_TIMESTAMP = decode(p_VALUE_TIMESTAMP, NULL, VALUE_TIMESTAMP, FND_API.G_MISS_DATE, NULL, p_VALUE_TIMESTAMP)
164 ,OBJECT_VERSION_NUMBER = decode(p_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
165 ,LAST_UPDATE_DATE = decode(p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL,p_LAST_UPDATE_DATE)
166 ,LAST_UPDATED_BY = decode(p_LAST_UPDATED_BY, NULL,LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY)
167 ,CREATION_DATE = decode(p_CREATION_DATE, NULL, CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE)
168 ,CREATED_BY = decode(p_CREATED_BY, NULL, CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
169 ,LAST_UPDATE_LOGIN = decode(p_LAST_UPDATE_LOGIN, NULL,LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
170 ,ATTRIBUTE1 = decode(p_ATTRIBUTE1, NULL, ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
171 ,ATTRIBUTE2 = decode(p_ATTRIBUTE2, NULL, ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
172 ,ATTRIBUTE3 = decode(p_ATTRIBUTE3, NULL, ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
173 ,ATTRIBUTE4 = decode(p_ATTRIBUTE4, NULL, ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
174 ,ATTRIBUTE5 = decode(p_ATTRIBUTE5, NULL, ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
175 ,ATTRIBUTE6 = decode(p_ATTRIBUTE6, NULL, ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
176 ,ATTRIBUTE7 = decode(p_ATTRIBUTE7, NULL, ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
177 ,ATTRIBUTE8 = decode(p_ATTRIBUTE8, NULL, ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
178 ,ATTRIBUTE9 = decode(p_ATTRIBUTE9, NULL, ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
179 ,ATTRIBUTE10 = decode(p_ATTRIBUTE10, NULL, ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
180 ,ATTRIBUTE11 = decode(p_ATTRIBUTE11, NULL, ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
181 ,ATTRIBUTE12 = decode(p_ATTRIBUTE12, NULL, ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
182 ,ATTRIBUTE13 = decode(p_ATTRIBUTE13, NULL, ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
183 ,ATTRIBUTE14 = decode(p_ATTRIBUTE14, NULL, ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
184 ,ATTRIBUTE15 = decode(p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
185 ,ATTRIBUTE_CATEGORY = decode(p_ATTRIBUTE_CATEGORY, NULL, ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
186 ,MIGRATED_FLAG = decode(p_MIGRATED_FLAG, NULL, MIGRATED_FLAG, FND_API.G_MISS_CHAR, NULL, p_MIGRATED_FLAG)
187 WHERE COUNTER_READ_PROP_INT_ID = p_COUNTER_READ_PROP_INT_ID;
188 END update_row;
189
190
191 PROCEDURE lock_row(
192 p_COUNTER_READ_PROP_INT_ID NUMBER
193 ,p_COUNTER_INTERFACE_ID NUMBER
194 ,p_PARALLEL_WORKER_ID NUMBER
195 ,p_ERROR_TEXT VARCHAR2
196 ,p_COUNTER_PROP_VALUE_ID NUMBER
197 ,p_COUNTER_VALUE_ID NUMBER
198 ,p_COUNTER_PROPERTY_ID NUMBER
199 ,p_PROPERTY_VALUE VARCHAR2
200 ,p_VALUE_TIMESTAMP DATE
201 ,p_OBJECT_VERSION_NUMBER NUMBER
202 ,p_LAST_UPDATE_DATE DATE
203 ,p_LAST_UPDATED_BY NUMBER
204 ,p_CREATION_DATE DATE
205 ,p_CREATED_BY NUMBER
206 ,p_LAST_UPDATE_LOGIN NUMBER
207 ,p_ATTRIBUTE1 VARCHAR2
208 ,p_ATTRIBUTE2 VARCHAR2
209 ,p_ATTRIBUTE3 VARCHAR2
210 ,p_ATTRIBUTE4 VARCHAR2
211 ,p_ATTRIBUTE5 VARCHAR2
212 ,p_ATTRIBUTE6 VARCHAR2
213 ,p_ATTRIBUTE7 VARCHAR2
214 ,p_ATTRIBUTE8 VARCHAR2
215 ,p_ATTRIBUTE9 VARCHAR2
216 ,p_ATTRIBUTE10 VARCHAR2
217 ,p_ATTRIBUTE11 VARCHAR2
218 ,p_ATTRIBUTE12 VARCHAR2
219 ,p_ATTRIBUTE13 VARCHAR2
220 ,p_ATTRIBUTE14 VARCHAR2
221 ,p_ATTRIBUTE15 VARCHAR2
222 ,p_ATTRIBUTE_CATEGORY VARCHAR2
223 ,p_MIGRATED_FLAG VARCHAR2) IS
224
225 CURSOR C1 IS
226 SELECT *
227 FROM CSI_CTR_READ_PROP_INTERFACE
228 WHERE COUNTER_READ_PROP_INT_ID = p_COUNTER_READ_PROP_INT_ID
229 FOR UPDATE of COUNTER_INTERFACE_ID NOWAIT;
230 Recinfo C1%ROWTYPE;
231 BEGIN
232 OPEN C1;
233 FETCH C1 INTO Recinfo;
234 IF (C1%NOTFOUND) then
235 CLOSE C1;
236 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
237 APP_EXCEPTION.RAISE_EXCEPTION;
238 END IF;
239 CLOSE C1;
240
241 IF (
242 ( Recinfo.COUNTER_INTERFACE_ID = p_COUNTER_INTERFACE_ID )
243 AND ( ( Recinfo.PARALLEL_WORKER_ID = p_PARALLEL_WORKER_ID)
244 OR ( ( Recinfo.PARALLEL_WORKER_ID IS NULL )
245 AND ( p_PARALLEL_WORKER_ID IS NULL )))
246 AND ( ( Recinfo.ERROR_TEXT = p_ERROR_TEXT)
247 OR ( ( Recinfo.ERROR_TEXT IS NULL )
248 AND ( p_ERROR_TEXT IS NULL )))
249 AND ( ( Recinfo.COUNTER_PROP_VALUE_ID = p_COUNTER_PROP_VALUE_ID)
250 OR ( ( Recinfo.COUNTER_PROP_VALUE_ID IS NULL )
251 AND ( p_COUNTER_PROP_VALUE_ID IS NULL )))
252 AND ( ( Recinfo.COUNTER_VALUE_ID = p_COUNTER_VALUE_ID)
253 OR ( ( Recinfo.COUNTER_VALUE_ID IS NULL )
254 AND ( p_COUNTER_VALUE_ID IS NULL )))
255 AND ( ( Recinfo.COUNTER_PROPERTY_ID = p_COUNTER_PROPERTY_ID)
256 OR ( ( Recinfo.COUNTER_PROPERTY_ID IS NULL )
257 AND ( p_COUNTER_PROPERTY_ID IS NULL )))
258 AND ( ( Recinfo.PROPERTY_VALUE = p_PROPERTY_VALUE)
259 OR ( ( Recinfo.PROPERTY_VALUE IS NULL )
260 AND ( p_PROPERTY_VALUE IS NULL )))
261 AND ( ( Recinfo.VALUE_TIMESTAMP = p_VALUE_TIMESTAMP)
262 OR ( ( Recinfo.VALUE_TIMESTAMP IS NULL )
263 AND ( p_VALUE_TIMESTAMP IS NULL )))
264 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
265 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
266 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
267 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
268 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
269 AND ( p_LAST_UPDATE_DATE IS NULL )))
270 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
271 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
272 AND ( p_LAST_UPDATED_BY IS NULL )))
273 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
274 OR ( ( Recinfo.CREATION_DATE IS NULL )
275 AND ( p_CREATION_DATE IS NULL )))
276 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
277 OR ( ( Recinfo.CREATED_BY IS NULL )
278 AND ( p_CREATED_BY IS NULL )))
279 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
280 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
281 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
282 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
283 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
284 AND ( p_ATTRIBUTE1 IS NULL )))
285 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
286 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
287 AND ( p_ATTRIBUTE2 IS NULL )))
288 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
289 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
290 AND ( p_ATTRIBUTE3 IS NULL )))
291 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
292 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
293 AND ( p_ATTRIBUTE4 IS NULL )))
294 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
295 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
296 AND ( p_ATTRIBUTE5 IS NULL )))
297 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
298 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
299 AND ( p_ATTRIBUTE6 IS NULL )))
300 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
301 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
302 AND ( p_ATTRIBUTE7 IS NULL )))
303 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
304 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
305 AND ( p_ATTRIBUTE8 IS NULL )))
306 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
310 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
307 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
308 AND ( p_ATTRIBUTE9 IS NULL )))
309 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
311 AND ( p_ATTRIBUTE10 IS NULL )))
312 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
313 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
314 AND ( p_ATTRIBUTE11 IS NULL )))
315 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
316 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
317 AND ( p_ATTRIBUTE12 IS NULL )))
318 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
319 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
320 AND ( p_ATTRIBUTE13 IS NULL )))
321 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
322 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
323 AND ( p_ATTRIBUTE14 IS NULL )))
324 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
325 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
326 AND ( p_ATTRIBUTE15 IS NULL )))
327 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
328 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
329 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
330 AND ( ( Recinfo.MIGRATED_FLAG = p_MIGRATED_FLAG)
331 OR ( ( Recinfo.MIGRATED_FLAG IS NULL )
332 AND ( p_MIGRATED_FLAG IS NULL )))
333 ) then
334 return;
335 ELSE
336 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
337 APP_EXCEPTION.RAISE_EXCEPTION;
338 END IF;
339 END lock_row;
340
341
342 PROCEDURE delete_row(p_COUNTER_READ_PROP_INT_ID NUMBER) IS
343 BEGIN
344 DELETE FROM CSI_CTR_READ_PROP_INTERFACE
345 WHERE COUNTER_READ_PROP_INT_ID = p_COUNTER_READ_PROP_INT_ID;
346 IF (SQL%NOTFOUND) then
347 RAISE NO_DATA_FOUND;
348 END IF;
349 END delete_row;
350
351 End CSI_CTR_READ_PROP_INTFACE_PKG;