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