[Home] [Help]
PACKAGE BODY: APPS.AS_LEAD_OBSTACLES_PKG
Source
1 PACKAGE BODY AS_LEAD_OBSTACLES_PKG as
2 /* $Header: asxtobsb.pls 115.6 2004/01/13 10:08:44 gbatra ship $ */
3 -- Start of Comments
4 -- Package name : AS_LEAD_OBSTACLES_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_LEAD_OBSTACLES_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxtobsb.pls';
13
14 PROCEDURE Insert_Row(
15 px_LEAD_OBSTACLE_ID IN OUT NOCOPY NUMBER,
16 p_LAST_UPDATE_DATE DATE,
17 p_LAST_UPDATED_BY NUMBER,
18 p_CREATION_DATE DATE,
19 p_CREATED_BY NUMBER,
20 p_LAST_UPDATE_LOGIN NUMBER,
21 p_REQUEST_ID NUMBER,
22 p_PROGRAM_APPLICATION_ID NUMBER,
23 p_PROGRAM_ID NUMBER,
24 p_PROGRAM_UPDATE_DATE DATE,
25 p_LEAD_ID NUMBER,
26 p_OBSTACLE_CODE VARCHAR2,
27 p_OBSTACLE VARCHAR2,
28 p_OBSTACLE_STATUS VARCHAR2,
29 p_COMMENTS VARCHAR2,
30 p_ATTRIBUTE_CATEGORY VARCHAR2,
31 p_ATTRIBUTE1 VARCHAR2,
32 p_ATTRIBUTE2 VARCHAR2,
33 p_ATTRIBUTE3 VARCHAR2,
34 p_ATTRIBUTE4 VARCHAR2,
35 p_ATTRIBUTE5 VARCHAR2,
36 p_ATTRIBUTE6 VARCHAR2,
37 p_ATTRIBUTE7 VARCHAR2,
38 p_ATTRIBUTE8 VARCHAR2,
39 p_ATTRIBUTE9 VARCHAR2,
40 p_ATTRIBUTE10 VARCHAR2,
41 p_ATTRIBUTE11 VARCHAR2,
42 p_ATTRIBUTE12 VARCHAR2,
43 p_ATTRIBUTE13 VARCHAR2,
44 p_ATTRIBUTE14 VARCHAR2,
45 p_ATTRIBUTE15 VARCHAR2)
46
47 IS
48 CURSOR C2 IS SELECT AS_LEAD_OBSTACLES_S.nextval FROM sys.dual;
49 BEGIN
50 If (px_LEAD_OBSTACLE_ID IS NULL) OR (px_LEAD_OBSTACLE_ID = FND_API.G_MISS_NUM) then
51 OPEN C2;
52 FETCH C2 INTO px_LEAD_OBSTACLE_ID;
53 CLOSE C2;
54 End If;
55 INSERT INTO AS_LEAD_OBSTACLES(
56 LEAD_OBSTACLE_ID,
57 LAST_UPDATE_DATE,
58 LAST_UPDATED_BY,
59 CREATION_DATE,
60 CREATED_BY,
61 LAST_UPDATE_LOGIN,
62 REQUEST_ID,
63 PROGRAM_APPLICATION_ID,
64 PROGRAM_ID,
65 PROGRAM_UPDATE_DATE,
66 LEAD_ID,
67 OBSTACLE_CODE,
68 OBSTACLE,
69 OBSTACLE_STATUS,
70 COMMENTS,
71 ATTRIBUTE_CATEGORY,
72 ATTRIBUTE1,
73 ATTRIBUTE2,
74 ATTRIBUTE3,
75 ATTRIBUTE4,
76 ATTRIBUTE5,
77 ATTRIBUTE6,
78 ATTRIBUTE7,
79 ATTRIBUTE8,
80 ATTRIBUTE9,
81 ATTRIBUTE10,
82 ATTRIBUTE11,
83 ATTRIBUTE12,
84 ATTRIBUTE13,
85 ATTRIBUTE14,
86 ATTRIBUTE15
87 --SECURITY_GROUP_ID
88 ) VALUES (
89 px_LEAD_OBSTACLE_ID,
90 decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
91 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
92 decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
93 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
94 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
95 decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
96 decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
97 decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
98 decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
99 decode( p_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_LEAD_ID),
100 decode( p_OBSTACLE_CODE, FND_API.G_MISS_CHAR, NULL, p_OBSTACLE_CODE),
101 decode( p_OBSTACLE, FND_API.G_MISS_CHAR, NULL, p_OBSTACLE),
102 decode( p_OBSTACLE_STATUS, FND_API.G_MISS_CHAR, NULL, p_OBSTACLE_STATUS),
103 decode( p_COMMENTS, FND_API.G_MISS_CHAR, NULL, p_COMMENTS),
104 decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
105 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
106 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
107 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
108 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
109 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
110 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
111 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
112 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
113 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
114 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
115 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
116 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
117 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
118 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
119 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
120 --decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SECURITY_GROUP_ID)
121 );
122 End Insert_Row;
123
124 PROCEDURE Update_Row(
125 p_LEAD_OBSTACLE_ID NUMBER,
126 p_LAST_UPDATE_DATE DATE,
127 p_LAST_UPDATED_BY NUMBER,
128 p_CREATION_DATE DATE,
129 p_CREATED_BY NUMBER,
130 p_LAST_UPDATE_LOGIN NUMBER,
131 p_REQUEST_ID NUMBER,
132 p_PROGRAM_APPLICATION_ID NUMBER,
133 p_PROGRAM_ID NUMBER,
134 p_PROGRAM_UPDATE_DATE DATE,
135 p_LEAD_ID NUMBER,
136 p_OBSTACLE_CODE VARCHAR2,
137 p_OBSTACLE VARCHAR2,
138 p_OBSTACLE_STATUS VARCHAR2,
139 p_COMMENTS VARCHAR2,
140 p_ATTRIBUTE_CATEGORY VARCHAR2,
141 p_ATTRIBUTE1 VARCHAR2,
142 p_ATTRIBUTE2 VARCHAR2,
143 p_ATTRIBUTE3 VARCHAR2,
144 p_ATTRIBUTE4 VARCHAR2,
145 p_ATTRIBUTE5 VARCHAR2,
146 p_ATTRIBUTE6 VARCHAR2,
147 p_ATTRIBUTE7 VARCHAR2,
148 p_ATTRIBUTE8 VARCHAR2,
149 p_ATTRIBUTE9 VARCHAR2,
150 p_ATTRIBUTE10 VARCHAR2,
151 p_ATTRIBUTE11 VARCHAR2,
152 p_ATTRIBUTE12 VARCHAR2,
153 p_ATTRIBUTE13 VARCHAR2,
154 p_ATTRIBUTE14 VARCHAR2,
155 p_ATTRIBUTE15 VARCHAR2
156 --p_SECURITY_GROUP_ID NUMBER
157 )
158
159 IS
160 BEGIN
161 Update AS_LEAD_OBSTACLES
162 SET object_version_number = nvl(object_version_number,0) + 1,
163 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
164 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
165 CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
166 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
167 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
168 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
169 PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
170 PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
171 PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
172 LEAD_ID = decode( p_LEAD_ID, FND_API.G_MISS_NUM, LEAD_ID, p_LEAD_ID),
173 OBSTACLE_CODE = decode( p_OBSTACLE_CODE, FND_API.G_MISS_CHAR, OBSTACLE_CODE, p_OBSTACLE_CODE),
174 OBSTACLE = decode( p_OBSTACLE, FND_API.G_MISS_CHAR, OBSTACLE, p_OBSTACLE),
175 OBSTACLE_STATUS = decode( p_OBSTACLE_STATUS, FND_API.G_MISS_CHAR, OBSTACLE_STATUS, p_OBSTACLE_STATUS),
176 COMMENTS = decode( p_COMMENTS, FND_API.G_MISS_CHAR, COMMENTS, p_COMMENTS),
177 ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
178 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
179 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
180 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
181 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
182 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
183 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
184 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
185 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
186 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
187 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
188 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
189 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
190 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
191 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
192 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
193 -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM,
194 -- SECURITY_GROUP_ID, p_SECURITY_GROUP_ID)
195 where LEAD_OBSTACLE_ID = p_LEAD_OBSTACLE_ID;
196
197 If (SQL%NOTFOUND) then
198 RAISE NO_DATA_FOUND;
199 End If;
200 END Update_Row;
201
202 PROCEDURE Delete_Row(
203 p_LEAD_OBSTACLE_ID NUMBER)
204 IS
205 BEGIN
206 DELETE FROM AS_LEAD_OBSTACLES
207 WHERE LEAD_OBSTACLE_ID = p_LEAD_OBSTACLE_ID;
208 If (SQL%NOTFOUND) then
209 RAISE NO_DATA_FOUND;
210 End If;
211 END Delete_Row;
212
213 PROCEDURE Lock_Row(
214 p_LEAD_OBSTACLE_ID NUMBER,
215 p_LAST_UPDATE_DATE DATE,
216 p_LAST_UPDATED_BY NUMBER,
217 p_CREATION_DATE DATE,
218 p_CREATED_BY NUMBER,
219 p_LAST_UPDATE_LOGIN NUMBER,
220 p_REQUEST_ID NUMBER,
221 p_PROGRAM_APPLICATION_ID NUMBER,
222 p_PROGRAM_ID NUMBER,
223 p_PROGRAM_UPDATE_DATE DATE,
224 p_LEAD_ID NUMBER,
225 p_OBSTACLE_CODE VARCHAR2,
226 p_OBSTACLE VARCHAR2,
227 p_OBSTACLE_STATUS VARCHAR2,
228 p_COMMENTS VARCHAR2,
229 p_ATTRIBUTE_CATEGORY VARCHAR2,
230 p_ATTRIBUTE1 VARCHAR2,
231 p_ATTRIBUTE2 VARCHAR2,
232 p_ATTRIBUTE3 VARCHAR2,
233 p_ATTRIBUTE4 VARCHAR2,
234 p_ATTRIBUTE5 VARCHAR2,
235 p_ATTRIBUTE6 VARCHAR2,
236 p_ATTRIBUTE7 VARCHAR2,
237 p_ATTRIBUTE8 VARCHAR2,
238 p_ATTRIBUTE9 VARCHAR2,
239 p_ATTRIBUTE10 VARCHAR2,
240 p_ATTRIBUTE11 VARCHAR2,
241 p_ATTRIBUTE12 VARCHAR2,
242 p_ATTRIBUTE13 VARCHAR2,
243 p_ATTRIBUTE14 VARCHAR2,
244 p_ATTRIBUTE15 VARCHAR2
245 -- p_SECURITY_GROUP_ID NUMBER
246 )
247
248 IS
249 CURSOR C IS
250 SELECT *
251 FROM AS_LEAD_OBSTACLES
252 WHERE LEAD_OBSTACLE_ID = p_LEAD_OBSTACLE_ID
253 FOR UPDATE of LEAD_OBSTACLE_ID NOWAIT;
254 Recinfo C%ROWTYPE;
255 BEGIN
256 OPEN C;
257 FETCH C INTO Recinfo;
258 If (C%NOTFOUND) then
259 CLOSE C;
260 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
261 APP_EXCEPTION.RAISE_EXCEPTION;
262 End If;
263 CLOSE C;
264 if (
265 ( Recinfo.LEAD_OBSTACLE_ID = p_LEAD_OBSTACLE_ID)
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.CREATION_DATE = p_CREATION_DATE)
273 OR ( ( Recinfo.CREATION_DATE IS NULL )
274 AND ( p_CREATION_DATE IS NULL )))
278 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
275 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
276 OR ( ( Recinfo.CREATED_BY IS NULL )
277 AND ( p_CREATED_BY IS NULL )))
279 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
280 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
281 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
282 OR ( ( Recinfo.REQUEST_ID IS NULL )
283 AND ( p_REQUEST_ID IS NULL )))
284 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
285 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
286 AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
287 AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
288 OR ( ( Recinfo.PROGRAM_ID IS NULL )
289 AND ( p_PROGRAM_ID IS NULL )))
290 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
291 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
292 AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
293 AND ( ( Recinfo.LEAD_ID = p_LEAD_ID)
294 OR ( ( Recinfo.LEAD_ID IS NULL )
295 AND ( p_LEAD_ID IS NULL )))
296 AND ( ( Recinfo.OBSTACLE_CODE = p_OBSTACLE_CODE)
297 OR ( ( Recinfo.OBSTACLE_CODE IS NULL )
298 AND ( p_OBSTACLE_CODE IS NULL )))
299 AND ( ( Recinfo.OBSTACLE = p_OBSTACLE)
300 OR ( ( Recinfo.OBSTACLE IS NULL )
301 AND ( p_OBSTACLE IS NULL )))
302 AND ( ( Recinfo.OBSTACLE_STATUS = p_OBSTACLE_STATUS)
303 OR ( ( Recinfo.OBSTACLE_STATUS IS NULL )
304 AND ( p_OBSTACLE_STATUS IS NULL )))
305 AND ( ( Recinfo.COMMENTS = p_COMMENTS)
306 OR ( ( Recinfo.COMMENTS IS NULL )
307 AND ( p_COMMENTS IS NULL )))
308 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
309 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
310 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
311 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
312 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
313 AND ( p_ATTRIBUTE1 IS NULL )))
314 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
315 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
316 AND ( p_ATTRIBUTE2 IS NULL )))
317 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
318 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
319 AND ( p_ATTRIBUTE3 IS NULL )))
320 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
321 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
322 AND ( p_ATTRIBUTE4 IS NULL )))
323 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
324 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
325 AND ( p_ATTRIBUTE5 IS NULL )))
326 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
327 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
328 AND ( p_ATTRIBUTE6 IS NULL )))
329 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
330 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
331 AND ( p_ATTRIBUTE7 IS NULL )))
332 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
333 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
334 AND ( p_ATTRIBUTE8 IS NULL )))
335 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
336 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
337 AND ( p_ATTRIBUTE9 IS NULL )))
338 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
339 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
340 AND ( p_ATTRIBUTE10 IS NULL )))
341 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
342 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
343 AND ( p_ATTRIBUTE11 IS NULL )))
344 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
345 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
346 AND ( p_ATTRIBUTE12 IS NULL )))
347 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
348 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
349 AND ( p_ATTRIBUTE13 IS NULL )))
350 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
351 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
352 AND ( p_ATTRIBUTE14 IS NULL )))
353 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
354 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
355 AND ( p_ATTRIBUTE15 IS NULL )))
356 -- AND ( ( Recinfo.SECURITY_GROUP_ID = p_SECURITY_GROUP_ID)
357 -- OR ( ( Recinfo.SECURITY_GROUP_ID IS NULL )
358 -- AND ( p_SECURITY_GROUP_ID IS NULL )))
359 ) then
360 return;
361 else
362 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
363 APP_EXCEPTION.RAISE_EXCEPTION;
364 End If;
365 END Lock_Row;
366
367 End AS_LEAD_OBSTACLES_PKG;