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