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