[Home] [Help]
PACKAGE BODY: APPS.AML_MONITOR_LOG_PKG
Source
1 PACKAGE BODY aml_MONITOR_LOG_PKG as
2 /* $Header: amltlmlb.pls 115.4 2003/01/20 18:24:42 swkhanna ship $ */
3 -- Start of Comments
4 -- Package name : aml_MONITOR_LOG_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'aml_MONITOR_LOG_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'amltlmlb.pls';
13
14 PROCEDURE Insert_Row(
15 px_MONITOR_LOG_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_OBJECT_VERSION_NUMBER NUMBER
22 ,p_REQUEST_ID NUMBER
23 ,p_PROGRAM_APPLICATION_ID NUMBER
24 ,p_PROGRAM_ID NUMBER
25 ,p_PROGRAM_UPDATE_DATE DATE
26 ,p_MONITOR_CONDITION_ID NUMBER
27 ,p_RECIPIENT_ROLE VARCHAR2
28 ,P_MONITOR_ACTION VARCHAR2
29 ,p_RECIPIENT_RESOURCE_ID NUMBER
30 ,p_SALES_LEAD_ID NUMBER
31 ,p_ATTRIBUTE_CATEGORY VARCHAR2
32 ,p_ATTRIBUTE1 VARCHAR2
33 ,p_ATTRIBUTE2 VARCHAR2
34 ,p_ATTRIBUTE3 VARCHAR2
35 ,p_ATTRIBUTE4 VARCHAR2
36 ,p_ATTRIBUTE5 VARCHAR2
37 ,p_ATTRIBUTE6 VARCHAR2
38 ,p_ATTRIBUTE7 VARCHAR2
39 ,p_ATTRIBUTE8 VARCHAR2
40 ,p_ATTRIBUTE9 VARCHAR2
41 ,p_ATTRIBUTE10 VARCHAR2
42 ,p_ATTRIBUTE11 VARCHAR2
43 ,p_ATTRIBUTE12 VARCHAR2
44 ,p_ATTRIBUTE13 VARCHAR2
45 ,p_ATTRIBUTE14 VARCHAR2
46 ,p_ATTRIBUTE15 VARCHAR2
47 )
48 IS
49 CURSOR C2 IS SELECT aml_MONITOR_LOG_S.nextval FROM sys.dual;
50 BEGIN
51 If (px_MONITOR_LOG_ID IS NULL) OR (px_MONITOR_LOG_ID = FND_API.G_MISS_NUM) then
52 OPEN C2;
53 FETCH C2 INTO px_MONITOR_LOG_ID;
54 CLOSE C2;
55 End If;
56 INSERT INTO aml_MONITOR_LOG(
57 MONITOR_LOG_ID
58 ,LAST_UPDATE_DATE
59 ,LAST_UPDATED_BY
60 ,CREATION_DATE
61 ,CREATED_BY
62 ,LAST_UPDATE_LOGIN
63 ,OBJECT_VERSION_NUMBER
64 ,REQUEST_ID
65 ,PROGRAM_APPLICATION_ID
66 ,PROGRAM_ID
67 ,PROGRAM_UPDATE_DATE
68 ,MONITOR_CONDITION_ID
69 ,RECIPIENT_ROLE
70 ,MONITOR_ACTION
71 ,RECIPIENT_RESOURCE_ID
72 ,SALES_LEAD_ID
73 ,ATTRIBUTE_CATEGORY
74 ,ATTRIBUTE1
75 ,ATTRIBUTE2
76 ,ATTRIBUTE3
77 ,ATTRIBUTE4
78 ,ATTRIBUTE5
79 ,ATTRIBUTE6
80 ,ATTRIBUTE7
81 ,ATTRIBUTE8
82 ,ATTRIBUTE9
83 ,ATTRIBUTE10
84 ,ATTRIBUTE11
85 ,ATTRIBUTE12
86 ,ATTRIBUTE13
87 ,ATTRIBUTE14
88 ,ATTRIBUTE15
89 ) VALUES (
90 px_MONITOR_LOG_ID
91 ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
92 ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
93 ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
94 ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
95 ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
96 ,decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
97 ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
98 ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
99 ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
100 ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
101 ,decode( p_MONITOR_CONDITION_ID, FND_API.G_MISS_NUM, NULL, p_MONITOR_CONDITION_ID)
102 ,decode( p_RECIPIENT_ROLE, FND_API.G_MISS_CHAR, NULL, p_RECIPIENT_ROLE)
103 ,decode( p_MONITOR_ACTION, FND_API.G_MISS_CHAR, NULL, p_MONITOR_ACTION)
104 ,decode( p_RECIPIENT_RESOURCE_ID, FND_API.G_MISS_NUM, NULL, p_RECIPIENT_RESOURCE_ID)
105 ,decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM, NULL, p_SALES_LEAD_ID)
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 );
123 End Insert_Row;
124
125 PROCEDURE Update_Row(
126 p_MONITOR_LOG_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_MONITOR_CONDITION_ID NUMBER
138 ,p_RECIPIENT_ROLE VARCHAR2
139 ,p_MONITOR_ACTION VARCHAR2
140 ,p_RECIPIENT_RESOURCE_ID NUMBER
141 ,p_SALES_LEAD_ID NUMBER
142 ,p_ATTRIBUTE_CATEGORY VARCHAR2
143 ,p_ATTRIBUTE1 VARCHAR2
144 ,p_ATTRIBUTE2 VARCHAR2
145 ,p_ATTRIBUTE3 VARCHAR2
146 ,p_ATTRIBUTE4 VARCHAR2
147 ,p_ATTRIBUTE5 VARCHAR2
148 ,p_ATTRIBUTE6 VARCHAR2
149 ,p_ATTRIBUTE7 VARCHAR2
150 ,p_ATTRIBUTE8 VARCHAR2
151 ,p_ATTRIBUTE9 VARCHAR2
152 ,p_ATTRIBUTE10 VARCHAR2
153 ,p_ATTRIBUTE11 VARCHAR2
154 ,p_ATTRIBUTE12 VARCHAR2
155 ,p_ATTRIBUTE13 VARCHAR2
156 ,p_ATTRIBUTE14 VARCHAR2
157 ,p_ATTRIBUTE15 VARCHAR2
158 )
159 IS
160 BEGIN
161 Update aml_MONITOR_LOG
162 SET
163 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
164 ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
165 ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
166 ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
167 ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
168 ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
169 ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
170 ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
171 ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
172 ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
173 ,MONITOR_CONDITION_ID = decode( p_MONITOR_CONDITION_ID, FND_API.G_MISS_NUM, MONITOR_CONDITION_ID, p_MONITOR_CONDITION_ID)
174 ,RECIPIENT_ROLE = decode( p_RECIPIENT_ROLE, FND_API.G_MISS_CHAR, RECIPIENT_ROLE, p_RECIPIENT_ROLE)
175 ,MONITOR_ACTION = decode( p_MONITOR_ACTION, FND_API.G_MISS_CHAR, MONITOR_ACTION, p_MONITOR_ACTION)
176 ,RECIPIENT_RESOURCE_ID = decode( p_RECIPIENT_RESOURCE_ID, FND_API.G_MISS_NUM, RECIPIENT_RESOURCE_ID, p_RECIPIENT_RESOURCE_ID)
177 ,SALES_LEAD_ID = decode( p_SALES_LEAD_ID, FND_API.G_MISS_NUM, SALES_LEAD_ID, p_SALES_LEAD_ID)
178 ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
179 ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
180 ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
181 ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
182 ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
183 ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
184 ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
185 ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
186 ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
187 ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
188 ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
189 ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
190 ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
191 ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
192 ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
193 ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
194 where MONITOR_LOG_ID = p_MONITOR_LOG_ID;
195
196 If (SQL%NOTFOUND) then
197 RAISE NO_DATA_FOUND;
198 End If;
199 END Update_Row;
200
201 PROCEDURE Delete_Row(
202 p_MONITOR_LOG_ID NUMBER)
203 IS
204 BEGIN
205 DELETE FROM aml_MONITOR_LOG
206 WHERE MONITOR_LOG_ID = p_MONITOR_LOG_ID;
207 If (SQL%NOTFOUND) then
208 RAISE NO_DATA_FOUND;
209 End If;
210 END Delete_Row;
211
212 PROCEDURE Lock_Row(
213 p_MONITOR_LOG_ID NUMBER
214 ,p_LAST_UPDATE_DATE DATE
215 ,p_LAST_UPDATED_BY NUMBER
216 ,p_CREATION_DATE DATE
217 ,p_CREATED_BY NUMBER
218 ,p_LAST_UPDATE_LOGIN NUMBER
219 ,p_OBJECT_VERSION_NUMBER NUMBER
220 ,p_REQUEST_ID NUMBER
221 ,p_PROGRAM_APPLICATION_ID NUMBER
222 ,p_PROGRAM_ID NUMBER
223 ,p_PROGRAM_UPDATE_DATE DATE
224 ,p_MONITOR_CONDITION_ID NUMBER
225 ,p_RECIPIENT_ROLE VARCHAR2
226 ,p_MONITOR_ACTION VARCHAR2
227 ,p_RECIPIENT_RESOURCE_ID NUMBER
228 ,p_SALES_LEAD_ID NUMBER
229 ,p_ATTRIBUTE_CATEGORY VARCHAR2
230 ,p_ATTRIBUTE1 VARCHAR2
231 ,p_ATTRIBUTE2 VARCHAR2
232 ,p_ATTRIBUTE3 VARCHAR2
233 ,p_ATTRIBUTE4 VARCHAR2
234 ,p_ATTRIBUTE5 VARCHAR2
235 ,p_ATTRIBUTE6 VARCHAR2
236 ,p_ATTRIBUTE7 VARCHAR2
237 ,p_ATTRIBUTE8 VARCHAR2
238 ,p_ATTRIBUTE9 VARCHAR2
239 ,p_ATTRIBUTE10 VARCHAR2
240 ,p_ATTRIBUTE11 VARCHAR2
241 ,p_ATTRIBUTE12 VARCHAR2
242 ,p_ATTRIBUTE13 VARCHAR2
243 ,p_ATTRIBUTE14 VARCHAR2
244 ,p_ATTRIBUTE15 VARCHAR2
245 )
246 IS
247 CURSOR C IS
248 SELECT *
249 FROM aml_MONITOR_LOG
250 WHERE MONITOR_LOG_ID = p_MONITOR_LOG_ID
251 FOR UPDATE of MONITOR_LOG_ID NOWAIT;
252 Recinfo C%ROWTYPE;
253 BEGIN
254 OPEN C;
255 FETCH C INTO Recinfo;
256 If (C%NOTFOUND) then
257 CLOSE C;
258 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
259 APP_EXCEPTION.RAISE_EXCEPTION;
260 End If;
261 CLOSE C;
262 if (
263 ( Recinfo.MONITOR_LOG_ID = p_MONITOR_LOG_ID)
264 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
265 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
266 AND ( p_LAST_UPDATE_DATE IS NULL )))
267 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
268 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
269 AND ( p_LAST_UPDATED_BY IS NULL )))
270 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
271 OR ( ( Recinfo.CREATION_DATE IS NULL )
272 AND ( p_CREATION_DATE IS NULL )))
273 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
274 OR ( ( Recinfo.CREATED_BY IS NULL )
275 AND ( p_CREATED_BY IS NULL )))
276 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
277 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
278 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
279 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
280 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
281 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
282 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
283 OR ( ( Recinfo.REQUEST_ID IS NULL )
284 AND ( p_REQUEST_ID IS NULL )))
285 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
286 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
287 AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
288 AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
289 OR ( ( Recinfo.PROGRAM_ID IS NULL )
290 AND ( p_PROGRAM_ID IS NULL )))
291 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
292 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
293 AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
294 AND ( ( Recinfo.MONITOR_CONDITION_ID = p_MONITOR_CONDITION_ID)
295 OR ( ( Recinfo.MONITOR_CONDITION_ID IS NULL )
296 AND ( p_MONITOR_CONDITION_ID IS NULL )))
297 AND ( ( Recinfo.RECIPIENT_ROLE = p_RECIPIENT_ROLE)
298 OR ( ( Recinfo.RECIPIENT_ROLE IS NULL )
299 AND ( p_RECIPIENT_ROLE IS NULL )))
300 AND ( ( Recinfo.MONITOR_ACTION = p_MONITOR_ACTION)
301 OR ( ( Recinfo.MONITOR_ACTION IS NULL )
302 AND ( p_MONITOR_ACTION IS NULL )))
303 AND ( ( Recinfo.RECIPIENT_RESOURCE_ID = p_RECIPIENT_RESOURCE_ID)
304 OR ( ( Recinfo.RECIPIENT_RESOURCE_ID IS NULL )
305 AND ( p_RECIPIENT_RESOURCE_ID IS NULL )))
306 AND ( ( Recinfo.SALES_LEAD_ID = p_SALES_LEAD_ID)
307 OR ( ( Recinfo.SALES_LEAD_ID IS NULL )
308 AND ( p_SALES_LEAD_ID IS NULL )))
309 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
310 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
311 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
312 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
313 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
314 AND ( p_ATTRIBUTE1 IS NULL )))
315 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
316 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
317 AND ( p_ATTRIBUTE2 IS NULL )))
318 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
319 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
320 AND ( p_ATTRIBUTE3 IS NULL )))
321 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
322 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
323 AND ( p_ATTRIBUTE4 IS NULL )))
324 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
325 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
326 AND ( p_ATTRIBUTE5 IS NULL )))
327 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
328 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
329 AND ( p_ATTRIBUTE6 IS NULL )))
330 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
331 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
332 AND ( p_ATTRIBUTE7 IS NULL )))
333 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
334 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
335 AND ( p_ATTRIBUTE8 IS NULL )))
336 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
337 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
338 AND ( p_ATTRIBUTE9 IS NULL )))
339 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
340 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
341 AND ( p_ATTRIBUTE10 IS NULL )))
342 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
343 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
344 AND ( p_ATTRIBUTE11 IS NULL )))
345 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
346 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
347 AND ( p_ATTRIBUTE12 IS NULL )))
348 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
349 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
350 AND ( p_ATTRIBUTE13 IS NULL )))
351 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
352 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
353 AND ( p_ATTRIBUTE14 IS NULL )))
354 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
355 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
356 AND ( p_ATTRIBUTE15 IS NULL )))
357 ) then
358 return;
359 else
360 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
361 APP_EXCEPTION.RAISE_EXCEPTION;
362 End If;
363 END Lock_Row;
364
365 End aml_MONITOR_LOG_PKG;