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