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