[Home] [Help]
PACKAGE BODY: APPS.AML_MONITOR_CONDITIONS_PKG
Source
1 PACKAGE BODY aml_MONITOR_CONDITIONS_PKG as
2 /* $Header: amltlmcb.pls 115.2 2002/12/13 22:44:06 swkhanna noship $ */
3 -- Start of Comments
4 -- Package name : aml_MONITOR_CONDITIONS_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):= 'aml_MONITOR_CONDITIONS_PKG';
12 G_FILE_NAME CONSTANT VARCHAR2(12) := 'amltlmcb.pls';
13
14 PROCEDURE Insert_Row(
15 px_MONITOR_CONDITION_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_PROCESS_RULE_ID NUMBER
27 ,p_MONITOR_TYPE_CODE VARCHAR2
28 ,p_TIME_LAG_NUM NUMBER
29 ,p_TIME_LAG_UOM_CODE VARCHAR2
30 ,p_TIME_LAG_FROM_STAGE VARCHAR2
31 ,p_TIME_LAG_TO_STAGE VARCHAR2
32 ,p_Expiration_Relative varchar2
33 ,p_Reminder_Defined varchar2
34 ,p_Total_Reminders number
35 ,p_Reminder_Frequency number
36 ,p_Reminder_Freq_uom_code varchar2
37 ,p_Timeout_Defined varchar2
38 ,p_Timeout_Duration number
39 ,p_Timeout_uom_code varchar2
40 ,p_notify_owner varchar2
41 ,p_notify_owner_manager varchar2
42 ,p_ATTRIBUTE_CATEGORY VARCHAR2
43 ,p_ATTRIBUTE1 VARCHAR2
44 ,p_ATTRIBUTE2 VARCHAR2
45 ,p_ATTRIBUTE3 VARCHAR2
46 ,p_ATTRIBUTE4 VARCHAR2
47 ,p_ATTRIBUTE5 VARCHAR2
48 ,p_ATTRIBUTE6 VARCHAR2
49 ,p_ATTRIBUTE7 VARCHAR2
50 ,p_ATTRIBUTE8 VARCHAR2
51 ,p_ATTRIBUTE9 VARCHAR2
52 ,p_ATTRIBUTE10 VARCHAR2
53 ,p_ATTRIBUTE11 VARCHAR2
54 ,p_ATTRIBUTE12 VARCHAR2
55 ,p_ATTRIBUTE13 VARCHAR2
56 ,p_ATTRIBUTE14 VARCHAR2
57 ,p_ATTRIBUTE15 VARCHAR2
58 )
59 IS
60 CURSOR C2 IS SELECT aml_MONITOR_CONDITIONS_S.nextval FROM sys.dual;
61 BEGIN
62 If (px_MONITOR_CONDITION_ID IS NULL) OR (px_MONITOR_CONDITION_ID = FND_API.G_MISS_NUM) then
63 OPEN C2;
64 FETCH C2 INTO px_MONITOR_CONDITION_ID;
65 CLOSE C2;
66 End If;
67 INSERT INTO aml_MONITOR_CONDITIONS(
68 MONITOR_CONDITION_ID
69 ,LAST_UPDATE_DATE
70 ,LAST_UPDATED_BY
71 ,CREATION_DATE
72 ,CREATED_BY
73 ,LAST_UPDATE_LOGIN
74 ,OBJECT_VERSION_NUMBER
75 ,REQUEST_ID
76 ,PROGRAM_APPLICATION_ID
77 ,PROGRAM_ID
78 ,PROGRAM_UPDATE_DATE
79 ,PROCESS_RULE_ID
80 ,MONITOR_TYPE_CODE
81 ,TIME_LAG_NUM
82 ,TIME_LAG_UOM_CODE
83 ,TIME_LAG_FROM_STAGE
84 ,TIME_LAG_TO_STAGE
85 ,Expiration_Relative
86 ,Reminder_Defined
87 ,Total_Reminders
88 ,Reminder_Frequency
89 ,Reminder_Freq_uom_code
90 ,Timeout_Defined
91 ,Timeout_Duration
92 ,Timeout_uom_code
93 ,notify_owner
94 ,notify_owner_manager
95 ,ATTRIBUTE_CATEGORY
96 ,ATTRIBUTE1
97 ,ATTRIBUTE2
98 ,ATTRIBUTE3
99 ,ATTRIBUTE4
100 ,ATTRIBUTE5
101 ,ATTRIBUTE6
102 ,ATTRIBUTE7
103 ,ATTRIBUTE8
104 ,ATTRIBUTE9
105 ,ATTRIBUTE10
106 ,ATTRIBUTE11
107 ,ATTRIBUTE12
108 ,ATTRIBUTE13
109 ,ATTRIBUTE14
110 ,ATTRIBUTE15
111 ) VALUES (
112 px_MONITOR_CONDITION_ID
113 ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
114 ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
115 ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
116 ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
117 ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
118 ,1 --decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, p_OBJECT_VERSION_NUMBER)
119 ,decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID)
120 ,decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID)
121 ,decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID)
122 ,decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE)
123 ,decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_PROCESS_RULE_ID)
124 ,decode( p_MONITOR_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, p_MONITOR_TYPE_CODE)
125 ,decode( p_TIME_LAG_NUM, FND_API.G_MISS_NUM, NULL, p_TIME_LAG_NUM)
126 ,decode( p_TIME_LAG_UOM_CODE, FND_API.G_MISS_CHAR, NULL, p_TIME_LAG_UOM_CODE)
127 ,decode( p_TIME_LAG_FROM_STAGE, FND_API.G_MISS_CHAR, NULL, p_TIME_LAG_FROM_STAGE)
128 ,decode( p_TIME_LAG_TO_STAGE, FND_API.G_MISS_CHAR, NULL, p_TIME_LAG_TO_STAGE)
129 ,decode(p_Expiration_Relative, FND_API.G_MISS_CHAR, NULL, p_Expiration_Relative)
130 ,decode(p_Reminder_Defined , FND_API.G_MISS_CHAR, NULL, p_Reminder_Defined)
134 ,decode(p_Timeout_Defined , FND_API.G_MISS_CHAR, NULL, p_Timeout_Defined)
131 ,decode(p_Total_Reminders , FND_API.G_MISS_NUM, NULL, p_Total_Reminders)
132 ,decode(p_Reminder_Frequency , FND_API.G_MISS_NUM, NULL, p_Reminder_Frequency)
133 ,decode(p_Reminder_Freq_uom_code, FND_API.G_MISS_CHAR, NULL, p_Reminder_Freq_uom_code)
135 ,decode(p_Timeout_Duration , FND_API.G_MISS_NUM, NULL, p_Timeout_Duration)
136 ,decode(p_Timeout_uom_code, FND_API.G_MISS_CHAR, NULL, p_Timeout_uom_code)
137 ,decode(p_notify_owner , FND_API.G_MISS_CHAR, NULL, p_notify_owner)
138 ,decode(p_notify_owner_manager , FND_API.G_MISS_CHAR, NULL, p_notify_owner_manager)
139 ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
140 ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
141 ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
142 ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
143 ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
144 ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
145 ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
146 ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
147 ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
148 ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
149 ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
150 ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
151 ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
152 ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
153 ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
154 ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
155 );
156 End Insert_Row;
157
158 PROCEDURE Update_Row(
159 p_MONITOR_CONDITION_ID NUMBER
160 ,p_LAST_UPDATE_DATE DATE
161 ,p_LAST_UPDATED_BY NUMBER
162 ,p_CREATION_DATE DATE
163 ,p_CREATED_BY NUMBER
164 ,p_LAST_UPDATE_LOGIN NUMBER
165 ,p_OBJECT_VERSION_NUMBER NUMBER
166 ,p_REQUEST_ID NUMBER
167 ,p_PROGRAM_APPLICATION_ID NUMBER
168 ,p_PROGRAM_ID NUMBER
169 ,p_PROGRAM_UPDATE_DATE DATE
170 ,p_PROCESS_RULE_ID NUMBER
171 ,p_MONITOR_TYPE_CODE VARCHAR2
172 ,p_TIME_LAG_NUM NUMBER
173 ,p_TIME_LAG_UOM_CODE VARCHAR2
174 ,p_TIME_LAG_FROM_STAGE VARCHAR2
175 ,p_TIME_LAG_TO_STAGE VARCHAR2
176 ,p_Expiration_Relative varchar2
177 ,p_Reminder_Defined varchar2
178 ,p_Total_Reminders number
179 ,p_Reminder_Frequency number
180 ,p_Reminder_Freq_uom_code varchar2
181 ,p_Timeout_Defined varchar2
182 ,p_Timeout_Duration number
183 ,p_Timeout_uom_code varchar2
184 ,p_notify_owner varchar2
185 ,p_notify_owner_manager varchar2
186 ,p_ATTRIBUTE_CATEGORY VARCHAR2
187 ,p_ATTRIBUTE1 VARCHAR2
188 ,p_ATTRIBUTE2 VARCHAR2
189 ,p_ATTRIBUTE3 VARCHAR2
190 ,p_ATTRIBUTE4 VARCHAR2
191 ,p_ATTRIBUTE5 VARCHAR2
192 ,p_ATTRIBUTE6 VARCHAR2
193 ,p_ATTRIBUTE7 VARCHAR2
194 ,p_ATTRIBUTE8 VARCHAR2
195 ,p_ATTRIBUTE9 VARCHAR2
196 ,p_ATTRIBUTE10 VARCHAR2
197 ,p_ATTRIBUTE11 VARCHAR2
198 ,p_ATTRIBUTE12 VARCHAR2
199 ,p_ATTRIBUTE13 VARCHAR2
200 ,p_ATTRIBUTE14 VARCHAR2
201 ,p_ATTRIBUTE15 VARCHAR2
202 )
203 IS
204 BEGIN
205 Update aml_MONITOR_CONDITIONS
206 SET
207 LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
208 ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
209 ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
210 ,CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
211 ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
212 ,OBJECT_VERSION_NUMBER = decode( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, OBJECT_VERSION_NUMBER, p_OBJECT_VERSION_NUMBER)
213 ,REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID)
214 ,PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID)
215 ,PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID)
216 ,PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE)
217 ,PROCESS_RULE_ID = decode( p_PROCESS_RULE_ID, FND_API.G_MISS_NUM, PROCESS_RULE_ID, p_PROCESS_RULE_ID)
218 ,MONITOR_TYPE_CODE = decode( p_MONITOR_TYPE_CODE, FND_API.G_MISS_CHAR, MONITOR_TYPE_CODE, p_MONITOR_TYPE_CODE)
219 ,TIME_LAG_NUM = decode( p_TIME_LAG_NUM, FND_API.G_MISS_NUM, TIME_LAG_NUM, p_TIME_LAG_NUM)
220 ,TIME_LAG_UOM_CODE = decode( p_TIME_LAG_UOM_CODE, FND_API.G_MISS_CHAR, TIME_LAG_UOM_CODE, p_TIME_LAG_UOM_CODE)
221 ,TIME_LAG_FROM_STAGE = decode( p_TIME_LAG_FROM_STAGE, FND_API.G_MISS_CHAR, TIME_LAG_FROM_STAGE, p_TIME_LAG_FROM_STAGE)
222 ,TIME_LAG_TO_STAGE = decode( p_TIME_LAG_TO_STAGE, FND_API.G_MISS_CHAR, TIME_LAG_TO_STAGE, p_TIME_LAG_TO_STAGE)
223 , Expiration_Relative = decode(p_Expiration_Relative, FND_API.G_MISS_CHAR, NULL, p_Expiration_Relative)
224 ,Reminder_Defined = decode(p_Reminder_Defined , FND_API.G_MISS_CHAR, NULL, p_Reminder_Defined)
225 ,Total_Reminders = decode(p_Total_Reminders , FND_API.G_MISS_NUM, NULL, p_Total_Reminders)
229 ,Timeout_Duration = decode(p_Timeout_Duration , FND_API.G_MISS_NUM, NULL, p_Timeout_Duration)
226 ,Reminder_Frequency = decode(p_Reminder_Frequency , FND_API.G_MISS_NUM, NULL, p_Reminder_Frequency)
227 ,Reminder_Freq_uom_code = decode(p_Reminder_Freq_uom_code, FND_API.G_MISS_CHAR, NULL, p_Reminder_Freq_uom_code)
228 ,Timeout_Defined = decode(p_Timeout_Defined , FND_API.G_MISS_CHAR, NULL, p_Timeout_Defined)
230 ,Timeout_uom_code = decode(p_Timeout_uom_code, FND_API.G_MISS_CHAR, NULL, p_Timeout_uom_code)
231 ,notify_owner = decode(p_notify_owner, FND_API.G_MISS_CHAR, NULL, p_notify_owner)
232 ,notify_owner_manager = decode(p_notify_owner_manager, FND_API.G_MISS_CHAR, NULL, p_notify_owner_manager)
233 ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
234 ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
235 ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
236 ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
237 ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
238 ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
239 ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
240 ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
241 ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
242 ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
243 ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
244 ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
245 ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
246 ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
247 ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
248 ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
249 where MONITOR_CONDITION_ID = p_MONITOR_CONDITION_ID;
250
251 If (SQL%NOTFOUND) then
252 RAISE NO_DATA_FOUND;
253 End If;
254 END Update_Row;
255
256 PROCEDURE Delete_Row(
257 p_process_rule_id NUMBER)
258 IS
259 BEGIN
260 DELETE FROM amL_MONITOR_CONDITIONS
261 WHERE PROCESS_RULE_ID = p_process_rule_id;
262 If (SQL%NOTFOUND) then
263 RAISE NO_DATA_FOUND;
264 End If;
265 END Delete_Row;
266
267 PROCEDURE Lock_Row(
268 p_MONITOR_CONDITION_ID NUMBER
269 ,p_LAST_UPDATE_DATE DATE
270 ,p_LAST_UPDATED_BY NUMBER
271 ,p_CREATION_DATE DATE
272 ,p_CREATED_BY NUMBER
273 ,p_LAST_UPDATE_LOGIN NUMBER
274 ,p_OBJECT_VERSION_NUMBER NUMBER
275 ,p_REQUEST_ID NUMBER
276 ,p_PROGRAM_APPLICATION_ID NUMBER
277 ,p_PROGRAM_ID NUMBER
278 ,p_PROGRAM_UPDATE_DATE DATE
279 ,p_PROCESS_RULE_ID NUMBER
280 ,p_MONITOR_TYPE_CODE VARCHAR2
281 ,p_TIME_LAG_NUM NUMBER
282 ,p_TIME_LAG_UOM_CODE VARCHAR2
283 ,p_TIME_LAG_FROM_STAGE VARCHAR2
284 ,p_TIME_LAG_TO_STAGE VARCHAR2
285 ,p_Expiration_Relative varchar2
286 ,p_Reminder_Defined varchar2
287 ,p_Total_Reminders number
288 ,p_Reminder_Frequency number
289 ,p_Reminder_Freq_uom_code varchar2
290 ,p_Timeout_Defined varchar2
291 ,p_Timeout_Duration number
292 ,p_Timeout_uom_code varchar2
293 ,p_notify_owner varchar2
294 ,p_notify_owner_manager varchar2
295 ,p_ATTRIBUTE_CATEGORY VARCHAR2
296 ,p_ATTRIBUTE1 VARCHAR2
297 ,p_ATTRIBUTE2 VARCHAR2
298 ,p_ATTRIBUTE3 VARCHAR2
299 ,p_ATTRIBUTE4 VARCHAR2
300 ,p_ATTRIBUTE5 VARCHAR2
301 ,p_ATTRIBUTE6 VARCHAR2
302 ,p_ATTRIBUTE7 VARCHAR2
303 ,p_ATTRIBUTE8 VARCHAR2
304 ,p_ATTRIBUTE9 VARCHAR2
305 ,p_ATTRIBUTE10 VARCHAR2
306 ,p_ATTRIBUTE11 VARCHAR2
307 ,p_ATTRIBUTE12 VARCHAR2
308 ,p_ATTRIBUTE13 VARCHAR2
309 ,p_ATTRIBUTE14 VARCHAR2
310 ,p_ATTRIBUTE15 VARCHAR2
311 )
312 IS
313 CURSOR C IS
314 SELECT *
315 FROM amL_MONITOR_CONDITIONS
316 WHERE MONITOR_CONDITION_ID = p_MONITOR_CONDITION_ID
317 FOR UPDATE of MONITOR_CONDITION_ID NOWAIT;
318 Recinfo C%ROWTYPE;
319 BEGIN
320 OPEN C;
321 FETCH C INTO Recinfo;
322 If (C%NOTFOUND) then
323 CLOSE C;
324 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
325 APP_EXCEPTION.RAISE_EXCEPTION;
326 End If;
338 AND ( p_CREATION_DATE IS NULL )))
327 CLOSE C;
328 if (
329 ( Recinfo.MONITOR_CONDITION_ID = p_MONITOR_CONDITION_ID)
330 AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
331 OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
332 AND ( p_LAST_UPDATE_DATE IS NULL )))
333 AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
334 OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
335 AND ( p_LAST_UPDATED_BY IS NULL )))
336 AND ( ( Recinfo.CREATION_DATE = p_CREATION_DATE)
337 OR ( ( Recinfo.CREATION_DATE IS NULL )
339 AND ( ( Recinfo.CREATED_BY = p_CREATED_BY)
340 OR ( ( Recinfo.CREATED_BY IS NULL )
341 AND ( p_CREATED_BY IS NULL )))
342 AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
343 OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
344 AND ( p_LAST_UPDATE_LOGIN IS NULL )))
345 AND ( ( Recinfo.OBJECT_VERSION_NUMBER = p_OBJECT_VERSION_NUMBER)
346 OR ( ( Recinfo.OBJECT_VERSION_NUMBER IS NULL )
347 AND ( p_OBJECT_VERSION_NUMBER IS NULL )))
348 AND ( ( Recinfo.REQUEST_ID = p_REQUEST_ID)
349 OR ( ( Recinfo.REQUEST_ID IS NULL )
350 AND ( p_REQUEST_ID IS NULL )))
351 AND ( ( Recinfo.PROGRAM_APPLICATION_ID = p_PROGRAM_APPLICATION_ID)
352 OR ( ( Recinfo.PROGRAM_APPLICATION_ID IS NULL )
353 AND ( p_PROGRAM_APPLICATION_ID IS NULL )))
354 AND ( ( Recinfo.PROGRAM_ID = p_PROGRAM_ID)
355 OR ( ( Recinfo.PROGRAM_ID IS NULL )
356 AND ( p_PROGRAM_ID IS NULL )))
357 AND ( ( Recinfo.PROGRAM_UPDATE_DATE = p_PROGRAM_UPDATE_DATE)
358 OR ( ( Recinfo.PROGRAM_UPDATE_DATE IS NULL )
359 AND ( p_PROGRAM_UPDATE_DATE IS NULL )))
360 AND ( ( Recinfo.PROCESS_RULE_ID = p_PROCESS_RULE_ID)
361 OR ( ( Recinfo.PROCESS_RULE_ID IS NULL )
362 AND ( p_PROCESS_RULE_ID IS NULL )))
363 AND ( ( Recinfo.MONITOR_TYPE_CODE = p_MONITOR_TYPE_CODE)
364 OR ( ( Recinfo.MONITOR_TYPE_CODE IS NULL )
365 AND ( p_MONITOR_TYPE_CODE IS NULL )))
366 AND ( ( Recinfo.TIME_LAG_NUM = p_TIME_LAG_NUM)
367 OR ( ( Recinfo.TIME_LAG_NUM IS NULL )
368 AND ( p_TIME_LAG_NUM IS NULL )))
369 AND ( ( Recinfo.TIME_LAG_UOM_CODE = p_TIME_LAG_UOM_CODE)
373 OR ( ( Recinfo.TIME_LAG_FROM_STAGE IS NULL )
370 OR ( ( Recinfo.TIME_LAG_UOM_CODE IS NULL )
371 AND ( p_TIME_LAG_UOM_CODE IS NULL )))
372 AND ( ( Recinfo.TIME_LAG_FROM_STAGE = p_TIME_LAG_FROM_STAGE)
374 AND ( p_TIME_LAG_FROM_STAGE IS NULL )))
375 AND ( ( Recinfo.TIME_LAG_TO_STAGE = p_TIME_LAG_TO_STAGE)
376 OR ( ( Recinfo.TIME_LAG_TO_STAGE IS NULL )
377 AND ( p_TIME_LAG_TO_STAGE IS NULL )))
378 AND ( ( Recinfo.Expiration_Relative = p_Expiration_Relative)
379 OR ( ( Recinfo.Expiration_Relative IS NULL )
380 AND ( p_Expiration_Relative IS NULL )))
381 AND ( ( Recinfo.Reminder_Defined = p_Reminder_Defined)
382 OR ( ( Recinfo.Reminder_Defined IS NULL )
383 AND ( p_Reminder_Defined IS NULL )))
384 AND ( ( Recinfo.Total_Reminders = p_Total_Reminders)
385 OR ( ( Recinfo.Total_Reminders IS NULL )
386 AND ( p_Total_Reminders IS NULL )))
387 AND ( ( Recinfo.Reminder_Frequency = p_Reminder_Frequency)
388 OR ( ( Recinfo.Reminder_Frequency IS NULL )
389 AND ( p_Reminder_Frequency IS NULL )))
390 AND ( ( Recinfo.Reminder_Freq_uom_code = p_Reminder_Freq_uom_code)
391 OR ( ( Recinfo.Reminder_Freq_uom_code IS NULL )
392 AND ( p_Reminder_Freq_uom_code IS NULL )))
393 AND ( ( Recinfo.Timeout_Defined = p_Timeout_Defined)
394 OR ( ( Recinfo.Timeout_Defined IS NULL )
395 AND ( p_Timeout_Defined IS NULL )))
396 AND ( ( Recinfo.Timeout_Duration = p_Timeout_Duration)
397 OR ( ( Recinfo.Timeout_Duration IS NULL )
398 AND ( p_Timeout_Duration IS NULL )))
399 AND ( ( Recinfo.Timeout_uom_code = p_Timeout_uom_code)
400 OR ( ( Recinfo.Timeout_uom_code IS NULL )
401 AND ( p_Timeout_uom_code IS NULL )))
402 AND ( ( Recinfo.notify_owner = p_notify_owner)
403 OR ( ( Recinfo.notify_owner IS NULL )
404 AND ( p_notify_owner IS NULL )))
405 AND ( ( Recinfo.notify_owner_manager = p_notify_owner_manager)
406 OR ( ( Recinfo.notify_owner_manager IS NULL )
407 AND ( p_notify_owner_manager IS NULL )))
408 AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
409 OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
410 AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
411 AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
412 OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
413 AND ( p_ATTRIBUTE1 IS NULL )))
414 AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
415 OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
416 AND ( p_ATTRIBUTE2 IS NULL )))
417 AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
418 OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
419 AND ( p_ATTRIBUTE3 IS NULL )))
420 AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
421 OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
422 AND ( p_ATTRIBUTE4 IS NULL )))
423 AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
424 OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
425 AND ( p_ATTRIBUTE5 IS NULL )))
426 AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
427 OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
428 AND ( p_ATTRIBUTE6 IS NULL )))
429 AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
430 OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
434 AND ( p_ATTRIBUTE8 IS NULL )))
431 AND ( p_ATTRIBUTE7 IS NULL )))
432 AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
433 OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
435 AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
436 OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
437 AND ( p_ATTRIBUTE9 IS NULL )))
438 AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
439 OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
440 AND ( p_ATTRIBUTE10 IS NULL )))
441 AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
442 OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
443 AND ( p_ATTRIBUTE11 IS NULL )))
444 AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
445 OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
446 AND ( p_ATTRIBUTE12 IS NULL )))
447 AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
448 OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
449 AND ( p_ATTRIBUTE13 IS NULL )))
450 AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
451 OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
452 AND ( p_ATTRIBUTE14 IS NULL )))
453 AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
454 OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
455 AND ( p_ATTRIBUTE15 IS NULL )))
456 ) then
457 return;
458 else
459 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
460 APP_EXCEPTION.RAISE_EXCEPTION;
461 End If;
462 END Lock_Row;
463
464 End aml_MONITOR_CONDITIONS_PKG;