eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE BODY: APPS.AS_LEAD_COMPETITORS_PKG

Source


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