[Home] [Help]
PACKAGE BODY: APPS.OZF_CLAIM_LINES_INT_PKG
Source
1 PACKAGE BODY OZF_CLAIM_LINES_INT_PKG as
2 /* $Header: ozftclib.pls 120.1 2005/07/08 07:08:59 appldev ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_CLAIM_LINES_INT_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16
17 G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_CLAIM_LINES_INT_PKG';
18 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftclib.pls';
19
20
21 ----------------------------------------------------------
22 ---- MEDIA ----
23 ----------------------------------------------------------
24
25 -- ========================================================
26 --
27 -- NAME
28 -- createInsertBody
29 --
30 -- PURPOSE
31 --
32 -- NOTES
33 --
34 -- HISTORY
35 --
36 -- ========================================================
37 PROCEDURE Insert_Row(
38 px_interface_claim_line_id IN OUT NOCOPY NUMBER,
39 px_object_version_number IN OUT NOCOPY NUMBER,
40 p_last_update_date DATE,
41 p_last_updated_by NUMBER,
42 p_creation_date DATE,
43 p_created_by NUMBER,
44 p_last_update_login NUMBER,
45 p_request_id NUMBER,
46 p_program_application_id NUMBER,
47 p_program_update_date DATE,
48 p_program_id NUMBER,
49 p_created_from VARCHAR2,
50 p_interface_claim_id NUMBER,
51 p_line_number NUMBER,
52 p_split_from_claim_line_id NUMBER,
53 p_amount NUMBER,
54 p_claim_currency_amount NUMBER,
55 p_acctd_amount NUMBER,
56 p_currency_code VARCHAR2,
57 p_exchange_rate_type VARCHAR2,
58 p_exchange_rate_date DATE,
59 p_exchange_rate NUMBER,
60 p_set_of_books_id NUMBER,
61 p_valid_flag VARCHAR2,
62 p_source_object_id NUMBER,
63 p_source_object_class VARCHAR2,
64 p_source_object_type_id NUMBER,
65 p_source_object_line_id NUMBER,
66 p_plan_id NUMBER,
67 p_offer_id NUMBER,
68 p_utilization_id NUMBER,
69 p_payment_method VARCHAR2,
70 p_payment_reference_id NUMBER,
71 p_payment_reference_number VARCHAR2,
72 p_payment_reference_date DATE,
73 p_voucher_id NUMBER,
74 p_voucher_number VARCHAR2,
75 p_payment_status VARCHAR2,
76 p_approved_flag VARCHAR2,
77 p_approved_date DATE,
78 p_approved_by NUMBER,
79 p_settled_date DATE,
80 p_settled_by NUMBER,
81 p_performance_complete_flag VARCHAR2,
82 p_performance_attached_flag VARCHAR2,
83 p_attribute_category VARCHAR2,
84 p_attribute1 VARCHAR2,
85 p_attribute2 VARCHAR2,
86 p_attribute3 VARCHAR2,
87 p_attribute4 VARCHAR2,
88 p_attribute5 VARCHAR2,
89 p_attribute6 VARCHAR2,
90 p_attribute7 VARCHAR2,
91 p_attribute8 VARCHAR2,
92 p_attribute9 VARCHAR2,
93 p_attribute10 VARCHAR2,
94 p_attribute11 VARCHAR2,
95 p_attribute12 VARCHAR2,
96 p_attribute13 VARCHAR2,
97 p_attribute14 VARCHAR2,
98 p_attribute15 VARCHAR2,
99 px_org_id IN OUT NOCOPY NUMBER)
100
101 IS
102 x_rowid VARCHAR2(30);
103
104
105 BEGIN
106
107 -- R12 Enhancements
108 /* IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
109 SELECT NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
110 INTO px_org_id
111 FROM DUAL;
112 END IF; */
113
114
115 px_object_version_number := 1;
116
117
118 INSERT INTO OZF_CLAIM_LINES_INT_ALL(
119 interface_claim_line_id,
120 object_version_number,
121 last_update_date,
122 last_updated_by,
123 creation_date,
124 created_by,
125 last_update_login,
126 request_id,
127 program_application_id,
128 program_update_date,
129 program_id,
130 created_from,
131 interface_claim_id,
132 line_number,
133 split_from_claim_line_id,
134 amount,
135 claim_currency_amount,
136 acctd_amount,
137 currency_code,
138 exchange_rate_type,
139 exchange_rate_date,
140 exchange_rate,
141 set_of_books_id,
142 valid_flag,
143 source_object_id,
144 source_object_class,
145 source_object_type_id,
146 source_object_line_id,
147 plan_id,
148 offer_id,
149 utilization_id,
150 payment_method,
151 payment_reference_id,
152 payment_reference_number,
153 payment_reference_date,
154 voucher_id,
155 voucher_number,
156 payment_status,
157 approved_flag,
158 approved_date,
159 approved_by,
160 settled_date,
161 settled_by,
162 performance_complete_flag,
163 performance_attached_flag,
164 attribute_category,
165 attribute1,
166 attribute2,
167 attribute3,
168 attribute4,
169 attribute5,
170 attribute6,
171 attribute7,
172 attribute8,
173 attribute9,
174 attribute10,
175 attribute11,
176 attribute12,
177 attribute13,
178 attribute14,
179 attribute15,
180 org_id
181 ) VALUES (
182 px_interface_claim_line_id,
183 px_object_version_number,
184 p_last_update_date,
185 p_last_updated_by,
186 p_creation_date,
187 p_created_by,
188 p_last_update_login,
189 p_request_id,
190 p_program_application_id,
191 p_program_update_date,
192 p_program_id,
193 p_created_from,
194 p_interface_claim_id,
195 p_line_number,
196 p_split_from_claim_line_id,
197 p_amount,
198 p_claim_currency_amount,
199 p_acctd_amount,
200 p_currency_code,
201 p_exchange_rate_type,
202 p_exchange_rate_date,
203 p_exchange_rate,
204 p_set_of_books_id,
205 p_valid_flag,
206 p_source_object_id,
207 p_source_object_class,
208 p_source_object_type_id,
209 p_source_object_line_id,
210 p_plan_id,
211 p_offer_id,
212 p_utilization_id,
213 p_payment_method,
214 p_payment_reference_id,
215 p_payment_reference_number,
216 p_payment_reference_date,
217 p_voucher_id,
218 p_voucher_number,
219 p_payment_status,
220 p_approved_flag,
221 p_approved_date,
222 p_approved_by,
223 p_settled_date,
224 p_settled_by,
225 p_performance_complete_flag,
226 p_performance_attached_flag,
227 p_attribute_category,
228 p_attribute1,
229 p_attribute2,
230 p_attribute3,
231 p_attribute4,
232 p_attribute5,
233 p_attribute6,
234 p_attribute7,
235 p_attribute8,
236 p_attribute9,
237 p_attribute10,
238 p_attribute11,
239 p_attribute12,
240 p_attribute13,
241 p_attribute14,
242 p_attribute15,
243 px_org_id);
244 END Insert_Row;
245
246
247 ----------------------------------------------------------
248 ---- MEDIA ----
249 ----------------------------------------------------------
250
251 -- ========================================================
252 --
253 -- NAME
254 -- createUpdateBody
255 --
256 -- PURPOSE
257 --
258 -- NOTES
259 --
260 -- HISTORY
261 --
262 -- ========================================================
263 PROCEDURE Update_Row(
264 p_interface_claim_line_id NUMBER,
265 p_object_version_number NUMBER,
266 p_last_update_date DATE,
267 p_last_updated_by NUMBER,
268 p_last_update_login NUMBER,
269 p_request_id NUMBER,
270 p_program_application_id NUMBER,
271 p_program_update_date DATE,
272 p_program_id NUMBER,
273 p_created_from VARCHAR2,
274 p_interface_claim_id NUMBER,
275 p_line_number NUMBER,
276 p_split_from_claim_line_id NUMBER,
277 p_amount NUMBER,
278 p_claim_currency_amount NUMBER,
279 p_acctd_amount NUMBER,
280 p_currency_code VARCHAR2,
281 p_exchange_rate_type VARCHAR2,
282 p_exchange_rate_date DATE,
283 p_exchange_rate NUMBER,
284 p_set_of_books_id NUMBER,
285 p_valid_flag VARCHAR2,
286 p_source_object_id NUMBER,
287 p_source_object_class VARCHAR2,
288 p_source_object_type_id NUMBER,
289 p_source_object_line_id NUMBER,
290 p_plan_id NUMBER,
291 p_offer_id NUMBER,
292 p_utilization_id NUMBER,
293 p_payment_method VARCHAR2,
294 p_payment_reference_id NUMBER,
295 p_payment_reference_number VARCHAR2,
296 p_payment_reference_date DATE,
297 p_voucher_id NUMBER,
298 p_voucher_number VARCHAR2,
299 p_payment_status VARCHAR2,
300 p_approved_flag VARCHAR2,
301 p_approved_date DATE,
302 p_approved_by NUMBER,
303 p_settled_date DATE,
304 p_settled_by NUMBER,
305 p_performance_complete_flag VARCHAR2,
306 p_performance_attached_flag VARCHAR2,
307 p_attribute_category VARCHAR2,
308 p_attribute1 VARCHAR2,
309 p_attribute2 VARCHAR2,
310 p_attribute3 VARCHAR2,
311 p_attribute4 VARCHAR2,
312 p_attribute5 VARCHAR2,
313 p_attribute6 VARCHAR2,
314 p_attribute7 VARCHAR2,
315 p_attribute8 VARCHAR2,
316 p_attribute9 VARCHAR2,
317 p_attribute10 VARCHAR2,
318 p_attribute11 VARCHAR2,
319 p_attribute12 VARCHAR2,
320 p_attribute13 VARCHAR2,
321 p_attribute14 VARCHAR2,
322 p_attribute15 VARCHAR2,
323 p_org_id NUMBER)
324
325 IS
326 BEGIN
327 Update OZF_CLAIM_LINES_INT_ALL
328 SET
329 interface_claim_line_id = p_interface_claim_line_id,
330 object_version_number = p_object_version_number,
331 last_update_date = p_last_update_date,
332 last_updated_by = p_last_updated_by,
333 last_update_login = p_last_update_login,
334 request_id = p_request_id,
335 program_application_id = p_program_application_id,
336 program_update_date = p_program_update_date,
337 program_id = p_program_id,
338 created_from = p_created_from,
339 interface_claim_id = p_interface_claim_id,
340 line_number = p_line_number,
341 split_from_claim_line_id = p_split_from_claim_line_id,
342 amount = p_amount,
343 claim_currency_amount = p_claim_currency_amount,
344 acctd_amount = p_acctd_amount,
345 currency_code = p_currency_code,
346 exchange_rate_type = p_exchange_rate_type,
347 exchange_rate_date = p_exchange_rate_date,
348 exchange_rate = p_exchange_rate,
349 set_of_books_id = p_set_of_books_id,
350 valid_flag = p_valid_flag,
351 source_object_id = p_source_object_id,
352 source_object_class = p_source_object_class,
353 source_object_type_id = p_source_object_type_id,
354 source_object_line_id = p_source_object_line_id,
355 plan_id = p_plan_id,
356 offer_id = p_offer_id,
357 utilization_id = p_utilization_id,
358 payment_method = p_payment_method,
359 payment_reference_id = p_payment_reference_id,
360 payment_reference_number = p_payment_reference_number,
361 payment_reference_date = p_payment_reference_date,
362 voucher_id = p_voucher_id,
363 voucher_number = p_voucher_number,
364 payment_status = p_payment_status,
365 approved_flag = p_approved_flag,
366 approved_date = p_approved_date,
367 approved_by = p_approved_by,
368 settled_date = p_settled_date,
369 settled_by = p_settled_by,
370 performance_complete_flag = p_performance_complete_flag,
371 performance_attached_flag = p_performance_attached_flag,
372 attribute_category = p_attribute_category,
373 attribute1 = p_attribute1,
374 attribute2 = p_attribute2,
375 attribute3 = p_attribute3,
376 attribute4 = p_attribute4,
377 attribute5 = p_attribute5,
378 attribute6 = p_attribute6,
379 attribute7 = p_attribute7,
380 attribute8 = p_attribute8,
381 attribute9 = p_attribute9,
382 attribute10 = p_attribute10,
383 attribute11 = p_attribute11,
384 attribute12 = p_attribute12,
385 attribute13 = p_attribute13,
386 attribute14 = p_attribute14,
387 attribute15 = p_attribute15,
388 org_id = p_org_id
389 WHERE INTERFACE_CLAIM_LINE_ID = p_INTERFACE_CLAIM_LINE_ID
390 AND object_version_number = p_object_version_number;
391
392 IF (SQL%NOTFOUND) THEN
393 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
394 END IF;
395 END Update_Row;
396
397
398 ----------------------------------------------------------
399 ---- MEDIA ----
400 ----------------------------------------------------------
401
402 -- ========================================================
403 --
404 -- NAME
405 -- createDeleteBody
406 --
407 -- PURPOSE
408 --
409 -- NOTES
410 --
411 -- HISTORY
412 --
413 -- ========================================================
414 PROCEDURE Delete_Row(
415 p_INTERFACE_CLAIM_LINE_ID NUMBER)
416 IS
417 BEGIN
418 DELETE FROM OZF_CLAIM_LINES_INT_ALL
419 WHERE INTERFACE_CLAIM_LINE_ID = p_INTERFACE_CLAIM_LINE_ID;
420 If (SQL%NOTFOUND) then
421 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
422 End If;
423 END Delete_Row ;
424
425
426
427 ----------------------------------------------------------
428 ---- MEDIA ----
429 ----------------------------------------------------------
430
431 -- ========================================================
432 --
433 -- NAME
434 -- createLockBody
435 --
439 --
436 -- PURPOSE
437 --
438 -- NOTES
440 -- HISTORY
441 --
442 -- ========================================================
443 PROCEDURE Lock_Row(
444 p_interface_claim_line_id NUMBER,
445 p_object_version_number NUMBER,
446 p_last_update_date DATE,
447 p_last_updated_by NUMBER,
448 p_creation_date DATE,
449 p_created_by NUMBER,
450 p_last_update_login NUMBER,
451 p_request_id NUMBER,
452 p_program_application_id NUMBER,
453 p_program_update_date DATE,
454 p_program_id NUMBER,
455 p_created_from VARCHAR2,
456 p_interface_claim_id NUMBER,
457 p_line_number NUMBER,
458 p_split_from_claim_line_id NUMBER,
459 p_amount NUMBER,
460 p_claim_currency_amount NUMBER,
461 p_acctd_amount NUMBER,
462 p_currency_code VARCHAR2,
463 p_exchange_rate_type VARCHAR2,
464 p_exchange_rate_date DATE,
465 p_exchange_rate NUMBER,
466 p_set_of_books_id NUMBER,
467 p_valid_flag VARCHAR2,
468 p_source_object_id NUMBER,
469 p_source_object_class VARCHAR2,
470 p_source_object_type_id NUMBER,
471 p_source_object_line_id NUMBER,
472 p_plan_id NUMBER,
473 p_offer_id NUMBER,
474 p_utilization_id NUMBER,
475 p_payment_method VARCHAR2,
476 p_payment_reference_id NUMBER,
477 p_payment_reference_number VARCHAR2,
478 p_payment_reference_date DATE,
479 p_voucher_id NUMBER,
480 p_voucher_number VARCHAR2,
481 p_payment_status VARCHAR2,
482 p_approved_flag VARCHAR2,
483 p_approved_date DATE,
484 p_approved_by NUMBER,
485 p_settled_date DATE,
486 p_settled_by NUMBER,
487 p_performance_complete_flag VARCHAR2,
488 p_performance_attached_flag VARCHAR2,
489 p_attribute_category VARCHAR2,
490 p_attribute1 VARCHAR2,
491 p_attribute2 VARCHAR2,
492 p_attribute3 VARCHAR2,
493 p_attribute4 VARCHAR2,
494 p_attribute5 VARCHAR2,
495 p_attribute6 VARCHAR2,
496 p_attribute7 VARCHAR2,
497 p_attribute8 VARCHAR2,
498 p_attribute9 VARCHAR2,
499 p_attribute10 VARCHAR2,
500 p_attribute11 VARCHAR2,
501 p_attribute12 VARCHAR2,
502 p_attribute13 VARCHAR2,
503 p_attribute14 VARCHAR2,
504 p_attribute15 VARCHAR2,
505 p_org_id NUMBER)
506
507 IS
508 CURSOR C IS
509 SELECT *
510 FROM OZF_CLAIM_LINES_INT_ALL
511 WHERE INTERFACE_CLAIM_LINE_ID = p_INTERFACE_CLAIM_LINE_ID
512 FOR UPDATE of INTERFACE_CLAIM_LINE_ID NOWAIT;
513 Recinfo C%ROWTYPE;
514 BEGIN
515 OPEN c;
516 FETCH c INTO Recinfo;
517 If (c%NOTFOUND) then
518 CLOSE c;
519 FND_MESSAGE.SET_NAME('OZF', 'OZF_API_RECORD_NOT_FOUND');
520 APP_EXCEPTION.RAISE_EXCEPTION;
521 END IF;
522 CLOSE C;
523 IF (
524 ( Recinfo.interface_claim_line_id = p_interface_claim_line_id)
525 AND ( ( Recinfo.object_version_number = p_object_version_number)
526 OR ( ( Recinfo.object_version_number IS NULL )
527 AND ( p_object_version_number IS NULL )))
528 AND ( ( Recinfo.last_update_date = p_last_update_date)
529 OR ( ( Recinfo.last_update_date IS NULL )
530 AND ( p_last_update_date IS NULL )))
531 AND ( ( Recinfo.last_updated_by = p_last_updated_by)
532 OR ( ( Recinfo.last_updated_by IS NULL )
533 AND ( p_last_updated_by IS NULL )))
534 AND ( ( Recinfo.creation_date = p_creation_date)
535 OR ( ( Recinfo.creation_date IS NULL )
536 AND ( p_creation_date IS NULL )))
537 AND ( ( Recinfo.created_by = p_created_by)
538 OR ( ( Recinfo.created_by IS NULL )
539 AND ( p_created_by IS NULL )))
540 AND ( ( Recinfo.last_update_login = p_last_update_login)
541 OR ( ( Recinfo.last_update_login IS NULL )
542 AND ( p_last_update_login IS NULL )))
543 AND ( ( Recinfo.request_id = p_request_id)
544 OR ( ( Recinfo.request_id IS NULL )
545 AND ( p_request_id IS NULL )))
546 AND ( ( Recinfo.program_application_id = p_program_application_id)
547 OR ( ( Recinfo.program_application_id IS NULL )
548 AND ( p_program_application_id IS NULL )))
549 AND ( ( Recinfo.program_update_date = p_program_update_date)
550 OR ( ( Recinfo.program_update_date IS NULL )
551 AND ( p_program_update_date IS NULL )))
552 AND ( ( Recinfo.program_id = p_program_id)
553 OR ( ( Recinfo.program_id IS NULL )
554 AND ( p_program_id IS NULL )))
555 AND ( ( Recinfo.created_from = p_created_from)
559 OR ( ( Recinfo.interface_claim_id IS NULL )
556 OR ( ( Recinfo.created_from IS NULL )
557 AND ( p_created_from IS NULL )))
558 AND ( ( Recinfo.interface_claim_id = p_interface_claim_id)
560 AND ( p_interface_claim_id IS NULL )))
561 AND ( ( Recinfo.line_number = p_line_number)
562 OR ( ( Recinfo.line_number IS NULL )
563 AND ( p_line_number IS NULL )))
564 AND ( ( Recinfo.split_from_claim_line_id = p_split_from_claim_line_id)
565 OR ( ( Recinfo.split_from_claim_line_id IS NULL )
566 AND ( p_split_from_claim_line_id IS NULL )))
567 AND ( ( Recinfo.amount = p_amount)
568 OR ( ( Recinfo.amount IS NULL )
569 AND ( p_amount IS NULL )))
570 AND ( ( Recinfo.claim_currency_amount = p_claim_currency_amount)
571 OR ( ( Recinfo.claim_currency_amount IS NULL )
572 AND ( p_claim_currency_amount IS NULL )))
573 AND ( ( Recinfo.acctd_amount = p_acctd_amount)
574 OR ( ( Recinfo.acctd_amount IS NULL )
575 AND ( p_acctd_amount IS NULL )))
576 AND ( ( Recinfo.currency_code = p_currency_code)
577 OR ( ( Recinfo.currency_code IS NULL )
578 AND ( p_currency_code IS NULL )))
579 AND ( ( Recinfo.exchange_rate_type = p_exchange_rate_type)
580 OR ( ( Recinfo.exchange_rate_type IS NULL )
581 AND ( p_exchange_rate_type IS NULL )))
582 AND ( ( Recinfo.exchange_rate_date = p_exchange_rate_date)
583 OR ( ( Recinfo.exchange_rate_date IS NULL )
584 AND ( p_exchange_rate_date IS NULL )))
585 AND ( ( Recinfo.exchange_rate = p_exchange_rate)
586 OR ( ( Recinfo.exchange_rate IS NULL )
587 AND ( p_exchange_rate IS NULL )))
588 AND ( ( Recinfo.set_of_books_id = p_set_of_books_id)
589 OR ( ( Recinfo.set_of_books_id IS NULL )
590 AND ( p_set_of_books_id IS NULL )))
591 AND ( ( Recinfo.valid_flag = p_valid_flag)
592 OR ( ( Recinfo.valid_flag IS NULL )
593 AND ( p_valid_flag IS NULL )))
594 AND ( ( Recinfo.source_object_id = p_source_object_id)
595 OR ( ( Recinfo.source_object_id IS NULL )
596 AND ( p_source_object_id IS NULL )))
597 AND ( ( Recinfo.source_object_class = p_source_object_class)
598 OR ( ( Recinfo.source_object_class IS NULL )
599 AND ( p_source_object_class IS NULL )))
600 AND ( ( Recinfo.source_object_type_id = p_source_object_type_id)
601 OR ( ( Recinfo.source_object_type_id IS NULL )
602 AND ( p_source_object_type_id IS NULL )))
603 AND ( ( Recinfo.source_object_line_id = p_source_object_line_id)
604 OR ( ( Recinfo.source_object_line_id IS NULL )
605 AND ( p_source_object_line_id IS NULL )))
606 AND ( ( Recinfo.plan_id = p_plan_id)
607 OR ( ( Recinfo.plan_id IS NULL )
608 AND ( p_plan_id IS NULL )))
609 AND ( ( Recinfo.offer_id = p_offer_id)
610 OR ( ( Recinfo.offer_id IS NULL )
611 AND ( p_offer_id IS NULL )))
612 AND ( ( Recinfo.utilization_id = p_utilization_id)
613 OR ( ( Recinfo.utilization_id IS NULL )
614 AND ( p_utilization_id IS NULL )))
615 AND ( ( Recinfo.payment_method = p_payment_method)
616 OR ( ( Recinfo.payment_method IS NULL )
617 AND ( p_payment_method IS NULL )))
618 AND ( ( Recinfo.payment_reference_id = p_payment_reference_id)
619 OR ( ( Recinfo.payment_reference_id IS NULL )
620 AND ( p_payment_reference_id IS NULL )))
621 AND ( ( Recinfo.payment_reference_number = p_payment_reference_number)
622 OR ( ( Recinfo.payment_reference_number IS NULL )
623 AND ( p_payment_reference_number IS NULL )))
624 AND ( ( Recinfo.payment_reference_date = p_payment_reference_date)
625 OR ( ( Recinfo.payment_reference_date IS NULL )
626 AND ( p_payment_reference_date IS NULL )))
627 AND ( ( Recinfo.voucher_id = p_voucher_id)
628 OR ( ( Recinfo.voucher_id IS NULL )
629 AND ( p_voucher_id IS NULL )))
630 AND ( ( Recinfo.voucher_number = p_voucher_number)
631 OR ( ( Recinfo.voucher_number IS NULL )
632 AND ( p_voucher_number IS NULL )))
633 AND ( ( Recinfo.payment_status = p_payment_status)
634 OR ( ( Recinfo.payment_status IS NULL )
635 AND ( p_payment_status IS NULL )))
636 AND ( ( Recinfo.approved_flag = p_approved_flag)
637 OR ( ( Recinfo.approved_flag IS NULL )
638 AND ( p_approved_flag IS NULL )))
639 AND ( ( Recinfo.approved_date = p_approved_date)
640 OR ( ( Recinfo.approved_date IS NULL )
641 AND ( p_approved_date IS NULL )))
642 AND ( ( Recinfo.approved_by = p_approved_by)
643 OR ( ( Recinfo.approved_by IS NULL )
644 AND ( p_approved_by IS NULL )))
645 AND ( ( Recinfo.settled_date = p_settled_date)
646 OR ( ( Recinfo.settled_date IS NULL )
647 AND ( p_settled_date IS NULL )))
648 AND ( ( Recinfo.settled_by = p_settled_by)
649 OR ( ( Recinfo.settled_by IS NULL )
650 AND ( p_settled_by IS NULL )))
651 AND ( ( Recinfo.performance_complete_flag = p_performance_complete_flag)
652 OR ( ( Recinfo.performance_complete_flag IS NULL )
653 AND ( p_performance_complete_flag IS NULL )))
654 AND ( ( Recinfo.performance_attached_flag = p_performance_attached_flag)
655 OR ( ( Recinfo.performance_attached_flag IS NULL )
656 AND ( p_performance_attached_flag IS NULL )))
657 AND ( ( Recinfo.attribute_category = p_attribute_category)
658 OR ( ( Recinfo.attribute_category IS NULL )
659 AND ( p_attribute_category IS NULL )))
660 AND ( ( Recinfo.attribute1 = p_attribute1)
661 OR ( ( Recinfo.attribute1 IS NULL )
662 AND ( p_attribute1 IS NULL )))
663 AND ( ( Recinfo.attribute2 = p_attribute2)
664 OR ( ( Recinfo.attribute2 IS NULL )
665 AND ( p_attribute2 IS NULL )))
666 AND ( ( Recinfo.attribute3 = p_attribute3)
667 OR ( ( Recinfo.attribute3 IS NULL )
668 AND ( p_attribute3 IS NULL )))
669 AND ( ( Recinfo.attribute4 = p_attribute4)
670 OR ( ( Recinfo.attribute4 IS NULL )
671 AND ( p_attribute4 IS NULL )))
672 AND ( ( Recinfo.attribute5 = p_attribute5)
673 OR ( ( Recinfo.attribute5 IS NULL )
674 AND ( p_attribute5 IS NULL )))
675 AND ( ( Recinfo.attribute6 = p_attribute6)
676 OR ( ( Recinfo.attribute6 IS NULL )
677 AND ( p_attribute6 IS NULL )))
678 AND ( ( Recinfo.attribute7 = p_attribute7)
679 OR ( ( Recinfo.attribute7 IS NULL )
680 AND ( p_attribute7 IS NULL )))
681 AND ( ( Recinfo.attribute8 = p_attribute8)
682 OR ( ( Recinfo.attribute8 IS NULL )
683 AND ( p_attribute8 IS NULL )))
684 AND ( ( Recinfo.attribute9 = p_attribute9)
685 OR ( ( Recinfo.attribute9 IS NULL )
686 AND ( p_attribute9 IS NULL )))
687 AND ( ( Recinfo.attribute10 = p_attribute10)
688 OR ( ( Recinfo.attribute10 IS NULL )
689 AND ( p_attribute10 IS NULL )))
690 AND ( ( Recinfo.attribute11 = p_attribute11)
691 OR ( ( Recinfo.attribute11 IS NULL )
692 AND ( p_attribute11 IS NULL )))
693 AND ( ( Recinfo.attribute12 = p_attribute12)
694 OR ( ( Recinfo.attribute12 IS NULL )
695 AND ( p_attribute12 IS NULL )))
696 AND ( ( Recinfo.attribute13 = p_attribute13)
697 OR ( ( Recinfo.attribute13 IS NULL )
698 AND ( p_attribute13 IS NULL )))
699 AND ( ( Recinfo.attribute14 = p_attribute14)
700 OR ( ( Recinfo.attribute14 IS NULL )
701 AND ( p_attribute14 IS NULL )))
702 AND ( ( Recinfo.attribute15 = p_attribute15)
703 OR ( ( Recinfo.attribute15 IS NULL )
704 AND ( p_attribute15 IS NULL )))
705 AND ( ( Recinfo.org_id = p_org_id)
706 OR ( ( Recinfo.org_id IS NULL )
707 AND ( p_org_id IS NULL )))
708 ) THEN
709 RETURN;
710 ELSE
711 FND_MESSAGE.SET_NAME('OZF', 'OZF_API_RECORD_NOT_FOUND');
712 APP_EXCEPTION.RAISE_EXCEPTION;
713 END IF;
714 END Lock_Row;
715
716 END OZF_CLAIM_LINES_INT_PKG;