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