[Home] [Help]
PACKAGE BODY: APPS.AS_SALES_LEAD_OPP_PKG
Source
1 PACKAGE BODY AS_SALES_LEAD_OPP_PKG as
2 /* $Header: asxtslob.pls 120.1 2006/02/09 21:11:40 subabu noship $ */
3 -- Start of Comments
4 -- Package name : AS_SALES_LEAD_OPP_PKG
5 -- Purpose : Table handlers for AS_SALES_LEAD_OPPORTUNITY and
6 -- AS_SALES_LEAD_OPP_LINES
7 -- NOTE :
8 -- History : 04/09/2001 FFANG Created
9 --
10 -- End of Comments
11
12
13 G_PKG_NAME CONSTANT VARCHAR2(30):= 'AS_SALES_LEAD_OPP_PKG';
14 G_FILE_NAME CONSTANT VARCHAR2(12) := 'asxtslob.pls';
15
16
17 PROCEDURE LEAD_OPPORTUNITY_Insert_Row(
18 px_LEAD_OPPORTUNITY_ID IN OUT NOCOPY NUMBER,
19 p_SALES_LEAD_ID NUMBER,
20 p_OPPORTUNITY_ID NUMBER,
21 p_LAST_UPDATE_DATE DATE,
22 p_LAST_UPDATED_BY NUMBER,
23 p_CREATION_DATE DATE,
24 p_CREATED_BY NUMBER,
25 p_LAST_UPDATE_LOGIN NUMBER,
26 p_REQUEST_ID NUMBER,
27 p_PROGRAM_APPLICATION_ID NUMBER,
28 p_PROGRAM_ID NUMBER,
29 p_PROGRAM_UPDATE_DATE DATE,
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 -- p_SECURITY_GROUP_ID NUMBER)
47
48 IS
49 CURSOR C2 IS SELECT AS_SALES_LEAD_OPP_S.nextval FROM sys.dual;
50 BEGIN
51 If (px_LEAD_OPPORTUNITY_ID IS NULL) OR (px_LEAD_OPPORTUNITY_ID = FND_API.G_MISS_NUM) then
52 OPEN C2;
53 FETCH C2 INTO px_LEAD_OPPORTUNITY_ID;
54 CLOSE C2;
55 End If;
56 INSERT INTO AS_SALES_LEAD_OPPORTUNITY(
57 LEAD_OPPORTUNITY_ID,
58 SALES_LEAD_ID,
59 OPPORTUNITY_ID,
60 LAST_UPDATE_DATE,
61 LAST_UPDATED_BY,
62 CREATION_DATE,
63 CREATED_BY,
64 LAST_UPDATE_LOGIN,
65 REQUEST_ID,
66 PROGRAM_APPLICATION_ID,
67 PROGRAM_ID,
68 PROGRAM_UPDATE_DATE,
69 ATTRIBUTE_CATEGORY,
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 -- SECURITY_GROUP_ID
86 ) VALUES (
87 px_LEAD_OPPORTUNITY_ID,
88 decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_SALES_LEAD_ID),
89 decode( p_OPPORTUNITY_ID, FND_API.G_MISS_NUM, NULL, p_OPPORTUNITY_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_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
100 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
101 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
102 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
103 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
104 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
105 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
106 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
107 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
108 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
109 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
110 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
111 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
112 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
113 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
114 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
115 -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,
116 -- p_SECURITY_GROUP_ID));
117 End LEAD_OPPORTUNITY_Insert_Row;
118
119
120 PROCEDURE LEAD_OPPORTUNITY_Update_Row(
121 p_LEAD_OPPORTUNITY_ID NUMBER,
122 p_SALES_LEAD_ID NUMBER,
123 p_OPPORTUNITY_ID NUMBER,
124 p_LAST_UPDATE_DATE DATE,
125 p_LAST_UPDATED_BY NUMBER,
126 p_CREATION_DATE DATE,
127 p_CREATED_BY NUMBER,
128 p_LAST_UPDATE_LOGIN NUMBER,
129 p_REQUEST_ID NUMBER,
130 p_PROGRAM_APPLICATION_ID NUMBER,
131 p_PROGRAM_ID NUMBER,
132 p_PROGRAM_UPDATE_DATE DATE,
133 p_ATTRIBUTE_CATEGORY VARCHAR2,
134 p_ATTRIBUTE1 VARCHAR2,
135 p_ATTRIBUTE2 VARCHAR2,
136 p_ATTRIBUTE3 VARCHAR2,
137 p_ATTRIBUTE4 VARCHAR2,
138 p_ATTRIBUTE5 VARCHAR2,
139 p_ATTRIBUTE6 VARCHAR2,
140 p_ATTRIBUTE7 VARCHAR2,
141 p_ATTRIBUTE8 VARCHAR2,
142 p_ATTRIBUTE9 VARCHAR2,
143 p_ATTRIBUTE10 VARCHAR2,
144 p_ATTRIBUTE11 VARCHAR2,
145 p_ATTRIBUTE12 VARCHAR2,
146 p_ATTRIBUTE13 VARCHAR2,
147 p_ATTRIBUTE14 VARCHAR2,
148 p_ATTRIBUTE15 VARCHAR2)
149 -- p_SECURITY_GROUP_ID NUMBER)
150
151 IS
152 BEGIN
153 Update AS_SALES_LEAD_OPPORTUNITY
154 SET
155 LEAD_OPPORTUNITY_ID = decode( p_LEAD_OPPORTUNITY_ID, FND_API.G_MISS_NUM,
156 LEAD_OPPORTUNITY_ID, p_LEAD_OPPORTUNITY_ID),
157 SALES_LEAD_ID = decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM,
158 SALES_LEAD_ID, p_SALES_LEAD_ID),
159 OPPORTUNITY_ID = decode( p_OPPORTUNITY_ID, FND_API.G_MISS_NUM,
160 OPPORTUNITY_ID, p_OPPORTUNITY_ID),
161 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
162 LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
163 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
164 LAST_UPDATED_BY, p_LAST_UPDATED_BY),
165 CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,
166 CREATION_DATE, p_CREATION_DATE),
167 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,
168 p_CREATED_BY),
169 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,
170 LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
171 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID,
172 p_REQUEST_ID),
173 PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID,
174 FND_API.G_MISS_NUM,
175 PROGRAM_APPLICATION_ID,
176 p_PROGRAM_APPLICATION_ID),
177 PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID,
178 p_PROGRAM_ID),
179 PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,
180 PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
181 ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,
182 ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
183 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1,
184 p_ATTRIBUTE1),
185 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,
186 p_ATTRIBUTE2),
187 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,
188 p_ATTRIBUTE3),
189 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,
190 p_ATTRIBUTE4),
191 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,
192 p_ATTRIBUTE5),
193 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,
194 p_ATTRIBUTE6),
195 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,
196 p_ATTRIBUTE7),
197 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,
198 p_ATTRIBUTE8),
199 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,
200 p_ATTRIBUTE9),
201 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,
202 p_ATTRIBUTE10),
203 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,
204 p_ATTRIBUTE11),
205 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,
206 p_ATTRIBUTE12),
207 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,
208 p_ATTRIBUTE13),
209 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14,
210 p_ATTRIBUTE14),
211 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15,
212 p_ATTRIBUTE15)
213 -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM,
214 -- SECURITY_GROUP_ID, p_SECURITY_GROUP_ID)
215 where LEAD_OPPORTUNITY_ID = p_LEAD_OPPORTUNITY_ID;
216
217 If (SQL%NOTFOUND) then
218 RAISE NO_DATA_FOUND;
219 End If;
220 END LEAD_OPPORTUNITY_Update_Row;
221
222 PROCEDURE LEAD_OPPORTUNITY_Delete_Row(
223 p_LEAD_OPPORTUNITY_ID NUMBER)
224 IS
225 BEGIN
226 DELETE FROM AS_SALES_LEAD_OPPORTUNITY
227 WHERE LEAD_OPPORTUNITY_ID = p_LEAD_OPPORTUNITY_ID;
228 If (SQL%NOTFOUND) then
229 RAISE NO_DATA_FOUND;
230 End If;
231 END LEAD_OPPORTUNITY_Delete_Row;
232
233 PROCEDURE LEAD_OPPORTUNITY_Lock_Row(
234 p_LEAD_OPPORTUNITY_ID NUMBER,
235 p_SALES_LEAD_ID NUMBER,
236 p_OPPORTUNITY_ID NUMBER,
237 p_LAST_UPDATE_DATE DATE,
238 p_LAST_UPDATED_BY NUMBER,
239 p_CREATION_DATE DATE,
240 p_CREATED_BY NUMBER,
241 p_LAST_UPDATE_LOGIN NUMBER,
242 p_REQUEST_ID NUMBER,
243 p_PROGRAM_APPLICATION_ID NUMBER,
244 p_PROGRAM_ID NUMBER,
245 p_PROGRAM_UPDATE_DATE DATE,
246 p_ATTRIBUTE_CATEGORY VARCHAR2,
247 p_ATTRIBUTE1 VARCHAR2,
248 p_ATTRIBUTE2 VARCHAR2,
249 p_ATTRIBUTE3 VARCHAR2,
250 p_ATTRIBUTE4 VARCHAR2,
251 p_ATTRIBUTE5 VARCHAR2,
252 p_ATTRIBUTE6 VARCHAR2,
253 p_ATTRIBUTE7 VARCHAR2,
254 p_ATTRIBUTE8 VARCHAR2,
255 p_ATTRIBUTE9 VARCHAR2,
256 p_ATTRIBUTE10 VARCHAR2,
257 p_ATTRIBUTE11 VARCHAR2,
258 p_ATTRIBUTE12 VARCHAR2,
259 p_ATTRIBUTE13 VARCHAR2,
260 p_ATTRIBUTE14 VARCHAR2,
261 p_ATTRIBUTE15 VARCHAR2)
262 -- p_SECURITY_GROUP_ID NUMBER)
263
264 IS
265 CURSOR C IS
266 SELECT *
267 FROM AS_SALES_LEAD_OPPORTUNITY
268 WHERE LEAD_OPPORTUNITY_ID = p_LEAD_OPPORTUNITY_ID
269 FOR UPDATE of LEAD_OPPORTUNITY_ID NOWAIT;
270 Recinfo C%ROWTYPE;
271 BEGIN
272 OPEN C;
273 FETCH C INTO Recinfo;
274 If (C%NOTFOUND) then
275 CLOSE C;
276 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
277 APP_EXCEPTION.RAISE_EXCEPTION;
278 End If;
279 CLOSE C;
280 if (
281 ( Recinfo.LEAD_OPPORTUNITY_ID = p_LEAD_OPPORTUNITY_ID)
282 AND ( ( Recinfo.SALES_LEAD_ID = p_SALES_LEAD_ID)
283 OR ( ( Recinfo.SALES_LEAD_ID IS NULL )
284 AND ( p_SALES_LEAD_ID IS NULL )))
285 AND ( ( Recinfo.OPPORTUNITY_ID = p_OPPORTUNITY_ID)
286 OR ( ( Recinfo.OPPORTUNITY_ID IS NULL )
287 AND ( p_OPPORTUNITY_ID IS NULL )))
288 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
289 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
290 AND ( p_LAST_UPDATE_DATE IS NULL )))
291 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
292 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
293 AND ( p_LAST_UPDATED_BY IS NULL )))
294 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
295 OR ( ( Recinfo.CREATION_DATE IS NULL )
296 AND ( p_CREATION_DATE IS NULL )))
297 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
298 OR ( ( Recinfo.CREATED_BY IS NULL )
299 AND ( p_CREATED_BY IS NULL )))
300 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
301 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
302 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
303 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
304 OR ( ( Recinfo.REQUEST_ID IS NULL )
305 AND ( p_REQUEST_ID IS NULL )))
306 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
307 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
308 AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
309 AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
310 OR ( ( Recinfo.PROGRAM_ID IS NULL )
311 AND ( p_PROGRAM_ID IS NULL )))
312 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
313 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
314 AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
315 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
316 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
317 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
318 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
319 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
320 AND ( p_ATTRIBUTE1 IS NULL )))
321 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
322 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
323 AND ( p_ATTRIBUTE2 IS NULL )))
324 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
325 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
326 AND ( p_ATTRIBUTE3 IS NULL )))
327 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
328 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
329 AND ( p_ATTRIBUTE4 IS NULL )))
330 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
331 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
332 AND ( p_ATTRIBUTE5 IS NULL )))
333 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
334 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
335 AND ( p_ATTRIBUTE6 IS NULL )))
336 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
337 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
338 AND ( p_ATTRIBUTE7 IS NULL )))
339 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
340 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
341 AND ( p_ATTRIBUTE8 IS NULL )))
342 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
343 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
347 AND ( p_ATTRIBUTE10 IS NULL )))
344 AND ( p_ATTRIBUTE9 IS NULL )))
345 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
346 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
348 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
349 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
350 AND ( p_ATTRIBUTE11 IS NULL )))
351 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
352 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
353 AND ( p_ATTRIBUTE12 IS NULL )))
354 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
355 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
356 AND ( p_ATTRIBUTE13 IS NULL )))
357 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
358 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
359 AND ( p_ATTRIBUTE14 IS NULL )))
360 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
361 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
362 AND ( p_ATTRIBUTE15 IS NULL )))
363 -- AND ( ( Recinfo.SECURITY_GROUP_ID = p_SECURITY_GROUP_ID)
364 -- OR ( ( Recinfo.SECURITY_GROUP_ID IS NULL )
365 -- AND ( p_SECURITY_GROUP_ID IS NULL )))
366 ) then
367 return;
368 else
369 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
370 APP_EXCEPTION.RAISE_EXCEPTION;
371 End If;
372 END LEAD_OPPORTUNITY_Lock_Row;
373
374 PROCEDURE LEAD_OPP_LINES_Insert_Row(
375 px_LEAD_OPP_LINE_ID IN OUT NOCOPY NUMBER,
376 p_SALES_LEAD_LINE_ID NUMBER,
377 p_OPP_LINE_ID NUMBER,
378 p_LAST_UPDATE_DATE DATE,
379 p_LAST_UPDATED_BY NUMBER,
380 p_CREATION_DATE DATE,
381 p_CREATED_BY NUMBER,
382 p_LAST_UPDATE_LOGIN NUMBER,
383 p_REQUEST_ID NUMBER,
384 p_PROGRAM_APPLICATION_ID NUMBER,
385 p_PROGRAM_ID NUMBER,
386 p_PROGRAM_UPDATE_DATE DATE,
387 p_ATTRIBUTE_CATEGORY VARCHAR2,
388 p_ATTRIBUTE1 VARCHAR2,
389 p_ATTRIBUTE2 VARCHAR2,
390 p_ATTRIBUTE3 VARCHAR2,
391 p_ATTRIBUTE4 VARCHAR2,
392 p_ATTRIBUTE5 VARCHAR2,
393 p_ATTRIBUTE6 VARCHAR2,
394 p_ATTRIBUTE7 VARCHAR2,
395 p_ATTRIBUTE8 VARCHAR2,
396 p_ATTRIBUTE9 VARCHAR2,
397 p_ATTRIBUTE10 VARCHAR2,
398 p_ATTRIBUTE11 VARCHAR2,
399 p_ATTRIBUTE12 VARCHAR2,
400 p_ATTRIBUTE13 VARCHAR2,
401 p_ATTRIBUTE14 VARCHAR2,
402 p_ATTRIBUTE15 VARCHAR2)
403 -- p_SECURITY_GROUP_ID NUMBER)
404
405 IS
406 CURSOR C2 IS SELECT AS_SALES_LEAD_OPP_LINES_S.nextval FROM sys.dual;
407 BEGIN
408 If (px_LEAD_OPP_LINE_ID IS NULL) OR (px_LEAD_OPP_LINE_ID = FND_API.G_MISS_NUM
409 ) then
410 OPEN C2;
411 FETCH C2 INTO px_LEAD_OPP_LINE_ID;
412 CLOSE C2;
413 End If;
414
415 INSERT INTO AS_SALES_LEAD_OPP_LINES(
416 LEAD_OPP_LINE_ID,
417 SALES_LEAD_LINE_ID,
418 OPP_LINE_ID,
419 LAST_UPDATE_DATE,
420 LAST_UPDATED_BY,
421 CREATION_DATE,
422 CREATED_BY,
423 LAST_UPDATE_LOGIN,
424 REQUEST_ID,
425 PROGRAM_APPLICATION_ID,
426 PROGRAM_ID,
427 PROGRAM_UPDATE_DATE,
428 ATTRIBUTE_CATEGORY,
429 ATTRIBUTE1,
430 ATTRIBUTE2,
431 ATTRIBUTE3,
432 ATTRIBUTE4,
433 ATTRIBUTE5,
434 ATTRIBUTE6,
435 ATTRIBUTE7,
436 ATTRIBUTE8,
437 ATTRIBUTE9,
438 ATTRIBUTE10,
439 ATTRIBUTE11,
440 ATTRIBUTE12,
441 ATTRIBUTE13,
442 ATTRIBUTE14,
443 ATTRIBUTE15
444 -- SECURITY_GROUP_ID
445 ) VALUES (
446 px_LEAD_OPP_LINE_ID,
447 decode( p_SALES_LEAD_LINE_ID, FND_API.G_MISS_NUM, NULL,
448 p_SALES_LEAD_LINE_ID),
449 decode( p_OPP_LINE_ID, FND_API.G_MISS_NUM, NULL, p_OPP_LINE_ID),
450 decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
451 p_LAST_UPDATE_DATE),
452 decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,
453 p_LAST_UPDATED_BY),
454 decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
455 p_CREATION_DATE),
456 decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
457 decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL,
458 p_LAST_UPDATE_LOGIN),
459 decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
460 decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL,
461 p_PROGRAM_APPLICATION_ID),
462 decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
463 decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),
464 p_PROGRAM_UPDATE_DATE),
465 decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL,
466 p_ATTRIBUTE_CATEGORY),
467 decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
468 decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
472 decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
469 decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
470 decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
471 decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
473 decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
474 decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
475 decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
476 decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
477 decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
478 decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
479 decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
480 decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
481 decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
482 -- decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM, NULL,
483 -- p_SECURITY_GROUP_ID));
484 End LEAD_OPP_LINES_Insert_Row;
485
486 PROCEDURE LEAD_OPP_LINES_Update_Row(
487 p_LEAD_OPP_LINE_ID NUMBER,
488 p_SALES_LEAD_LINE_ID NUMBER,
489 p_OPP_LINE_ID NUMBER,
490 p_LAST_UPDATE_DATE DATE,
491 p_LAST_UPDATED_BY NUMBER,
492 p_CREATION_DATE DATE,
493 p_CREATED_BY NUMBER,
494 p_LAST_UPDATE_LOGIN NUMBER,
495 p_REQUEST_ID NUMBER,
496 p_PROGRAM_APPLICATION_ID NUMBER,
497 p_PROGRAM_ID NUMBER,
498 p_PROGRAM_UPDATE_DATE DATE,
499 p_ATTRIBUTE_CATEGORY VARCHAR2,
500 p_ATTRIBUTE1 VARCHAR2,
501 p_ATTRIBUTE2 VARCHAR2,
502 p_ATTRIBUTE3 VARCHAR2,
503 p_ATTRIBUTE4 VARCHAR2,
504 p_ATTRIBUTE5 VARCHAR2,
505 p_ATTRIBUTE6 VARCHAR2,
506 p_ATTRIBUTE7 VARCHAR2,
507 p_ATTRIBUTE8 VARCHAR2,
508 p_ATTRIBUTE9 VARCHAR2,
509 p_ATTRIBUTE10 VARCHAR2,
510 p_ATTRIBUTE11 VARCHAR2,
511 p_ATTRIBUTE12 VARCHAR2,
512 p_ATTRIBUTE13 VARCHAR2,
513 p_ATTRIBUTE14 VARCHAR2,
514 p_ATTRIBUTE15 VARCHAR2)
515 -- p_SECURITY_GROUP_ID NUMBER)
516
517 IS
518 BEGIN
519 Update AS_SALES_LEAD_OPP_LINES
520 SET
521 SALES_LEAD_LINE_ID = decode( p_SALES_LEAD_LINE_ID, FND_API.G_MISS_NUM,
522 SALES_LEAD_LINE_ID, p_SALES_LEAD_LINE_ID),
523 OPP_LINE_ID = decode( p_OPP_LINE_ID, FND_API.G_MISS_NUM, OPP_LINE_ID,
524 p_OPP_LINE_ID),
525 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE,
526 LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
527 LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM,
528 LAST_UPDATED_BY, p_LAST_UPDATED_BY),
529 CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE,
530 CREATION_DATE, p_CREATION_DATE),
531 CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY,
532 p_CREATED_BY),
533 LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM,
534 LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
535 REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID,
536 p_REQUEST_ID),
537 PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID,
538 FND_API.G_MISS_NUM,
539 PROGRAM_APPLICATION_ID,
540 p_PROGRAM_APPLICATION_ID),
541 PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID,
542 p_PROGRAM_ID),
543 PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,
544 PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
545 ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,
546 ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
547 ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1,
548 p_ATTRIBUTE1),
549 ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2,
550 p_ATTRIBUTE2),
551 ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3,
552 p_ATTRIBUTE3),
553 ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4,
554 p_ATTRIBUTE4),
555 ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5,
556 p_ATTRIBUTE5),
557 ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6,
558 p_ATTRIBUTE6),
559 ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7,
560 p_ATTRIBUTE7),
561 ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8,
562 p_ATTRIBUTE8),
563 ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9,
564 p_ATTRIBUTE9),
565 ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10,
566 p_ATTRIBUTE10),
570 p_ATTRIBUTE12),
567 ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11,
568 p_ATTRIBUTE11),
569 ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12,
571 ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13,
572 p_ATTRIBUTE13),
573 ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14,
574 p_ATTRIBUTE14),
575 ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15,
576 p_ATTRIBUTE15)
577 -- SECURITY_GROUP_ID = decode( p_SECURITY_GROUP_ID, FND_API.G_MISS_NUM,
578 -- SECURITY_GROUP_ID, p_SECURITY_GROUP_ID)
579 where LEAD_OPP_LINE_ID = p_LEAD_OPP_LINE_ID;
580
581 If (SQL%NOTFOUND) then
582 RAISE NO_DATA_FOUND;
583 End If;
584 END LEAD_OPP_LINES_Update_Row;
585
586 PROCEDURE LEAD_OPP_LINES_Delete_Row(
587 p_LEAD_OPP_LINE_ID NUMBER)
588 IS
589 BEGIN
590 DELETE FROM AS_SALES_LEAD_OPP_LINES
591 WHERE LEAD_OPP_LINE_ID = p_LEAD_OPP_LINE_ID;
592 If (SQL%NOTFOUND) then
593 RAISE NO_DATA_FOUND;
594 End If;
595 END LEAD_OPP_LINES_Delete_Row;
596
597 PROCEDURE LEAD_OPP_LINES_Lock_Row(
598 p_LEAD_OPP_LINE_ID NUMBER,
599 p_SALES_LEAD_LINE_ID NUMBER,
600 p_OPP_LINE_ID NUMBER,
601 p_LAST_UPDATE_DATE DATE,
602 p_LAST_UPDATED_BY NUMBER,
603 p_CREATION_DATE DATE,
604 p_CREATED_BY NUMBER,
605 p_LAST_UPDATE_LOGIN NUMBER,
606 p_REQUEST_ID NUMBER,
607 p_PROGRAM_APPLICATION_ID NUMBER,
608 p_PROGRAM_ID NUMBER,
609 p_PROGRAM_UPDATE_DATE DATE,
610 p_ATTRIBUTE_CATEGORY VARCHAR2,
611 p_ATTRIBUTE1 VARCHAR2,
612 p_ATTRIBUTE2 VARCHAR2,
613 p_ATTRIBUTE3 VARCHAR2,
614 p_ATTRIBUTE4 VARCHAR2,
615 p_ATTRIBUTE5 VARCHAR2,
616 p_ATTRIBUTE6 VARCHAR2,
617 p_ATTRIBUTE7 VARCHAR2,
618 p_ATTRIBUTE8 VARCHAR2,
619 p_ATTRIBUTE9 VARCHAR2,
620 p_ATTRIBUTE10 VARCHAR2,
621 p_ATTRIBUTE11 VARCHAR2,
622 p_ATTRIBUTE12 VARCHAR2,
623 p_ATTRIBUTE13 VARCHAR2,
624 p_ATTRIBUTE14 VARCHAR2,
625 p_ATTRIBUTE15 VARCHAR2)
626 -- p_SECURITY_GROUP_ID NUMBER)
627
628 IS
629 CURSOR C IS
630 SELECT *
631 FROM AS_SALES_LEAD_OPP_LINES
632 WHERE LEAD_OPP_LINE_ID = p_LEAD_OPP_LINE_ID
633 FOR UPDATE of LEAD_OPP_LINE_ID NOWAIT;
634 Recinfo C%ROWTYPE;
635 BEGIN
636 OPEN C;
637 FETCH C INTO Recinfo;
638 If (C%NOTFOUND) then
639 CLOSE C;
640 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
641 APP_EXCEPTION.RAISE_EXCEPTION;
642 End If;
643 CLOSE C;
644 if (
645 ( Recinfo.LEAD_OPP_LINE_ID = p_LEAD_OPP_LINE_ID)
646 AND ( ( Recinfo.SALES_LEAD_LINE_ID = p_SALES_LEAD_LINE_ID)
647 OR ( ( Recinfo.SALES_LEAD_LINE_ID IS NULL )
648 AND ( p_SALES_LEAD_LINE_ID IS NULL )))
649 AND ( ( Recinfo.OPP_LINE_ID = p_OPP_LINE_ID)
650 OR ( ( Recinfo.OPP_LINE_ID IS NULL )
651 AND ( p_OPP_LINE_ID IS NULL )))
652 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
653 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
654 AND ( p_LAST_UPDATE_DATE IS NULL )))
655 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
656 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
657 AND ( p_LAST_UPDATED_BY IS NULL )))
658 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
659 OR ( ( Recinfo.CREATION_DATE IS NULL )
660 AND ( p_CREATION_DATE IS NULL )))
661 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
662 OR ( ( Recinfo.CREATED_BY IS NULL )
663 AND ( p_CREATED_BY IS NULL )))
664 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
665 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
666 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
667 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
668 OR ( ( Recinfo.REQUEST_ID IS NULL )
669 AND ( p_REQUEST_ID IS NULL )))
670 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
671 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
672 AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
673 AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
674 OR ( ( Recinfo.PROGRAM_ID IS NULL )
675 AND ( p_PROGRAM_ID IS NULL )))
676 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
677 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
678 AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
679 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
680 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
681 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
682 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
683 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
684 AND ( p_ATTRIBUTE1 IS NULL )))
685 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
686 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
690 AND ( p_ATTRIBUTE3 IS NULL )))
687 AND ( p_ATTRIBUTE2 IS NULL )))
688 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
689 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
691 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
692 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
693 AND ( p_ATTRIBUTE4 IS NULL )))
694 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
695 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
696 AND ( p_ATTRIBUTE5 IS NULL )))
697 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
698 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
699 AND ( p_ATTRIBUTE6 IS NULL )))
700 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
701 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
702 AND ( p_ATTRIBUTE7 IS NULL )))
703 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
704 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
705 AND ( p_ATTRIBUTE8 IS NULL )))
706 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
707 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
708 AND ( p_ATTRIBUTE9 IS NULL )))
709 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
710 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
711 AND ( p_ATTRIBUTE10 IS NULL )))
712 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
713 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
714 AND ( p_ATTRIBUTE11 IS NULL )))
715 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
716 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
717 AND ( p_ATTRIBUTE12 IS NULL )))
718 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
719 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
720 AND ( p_ATTRIBUTE13 IS NULL )))
721 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
722 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
723 AND ( p_ATTRIBUTE14 IS NULL )))
724 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
725 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
726 AND ( p_ATTRIBUTE15 IS NULL )))
727 -- AND ( ( Recinfo.SECURITY_GROUP_ID = p_SECURITY_GROUP_ID)
728 -- OR ( ( Recinfo.SECURITY_GROUP_ID IS NULL )
729 -- AND ( p_SECURITY_GROUP_ID IS NULL )))
730 ) then
731 return;
732 else
733 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
734 APP_EXCEPTION.RAISE_EXCEPTION;
735 End If;
736 END LEAD_OPP_LINES_Lock_Row;
737
738
739 End AS_SALES_LEAD_OPP_PKG;