[Home] [Help]
PACKAGE BODY: APPS.OZF_CLAIMS_PKG
Source
1 PACKAGE BODY OZF_CLAIMS_PKG as
2 /* $Header: ozftclab.pls 120.3.12010000.2 2009/07/23 17:15:37 kpatro ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_CLAIMS_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- 20-May-2009 KPATRO Rule Based Settlement Enhancement
12 -- NOTE
13 --
14 -- End of Comments
15 -- ===============================================================
16
17
18 G_PKG_NAME CONSTANT VARCHAR2(30):= 'OZF_CLAIMS_PKG';
19 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftclab.pls';
20
21
22 ----------------------------------------------------------
23 ---- MEDIA ----
24 ----------------------------------------------------------
25
26 -- ========================================================
27 --
28 -- NAME
29 -- createInsertBody
30 --
31 -- PURPOSE
32 --
33 -- NOTES
34 --
35 -- HISTORY
36 --
37 -- ========================================================
38 PROCEDURE Insert_Row(
39 px_claim_id IN OUT NOCOPY NUMBER,
40 px_object_version_number IN OUT NOCOPY NUMBER,
41 p_last_update_date DATE,
42 p_last_updated_by NUMBER,
43 p_creation_date DATE,
44 p_created_by NUMBER,
45 p_last_update_login NUMBER,
46 p_request_id NUMBER,
47 p_program_application_id NUMBER,
48 p_program_update_date DATE,
49 p_program_id NUMBER,
50 p_created_from VARCHAR2,
51 p_batch_id NUMBER,
52 p_claim_number VARCHAR2,
53 p_claim_type_id NUMBER,
54 p_claim_class VARCHAR2,
55 p_claim_date DATE,
56 p_due_date DATE,
57 p_owner_id NUMBER,
58 p_history_event VARCHAR2,
59 p_history_event_date DATE,
60 p_history_event_description VARCHAR2,
61 p_split_from_claim_id NUMBER,
62 p_duplicate_claim_id NUMBER,
63 p_split_date DATE,
64 p_root_claim_id NUMBER,
65 p_amount NUMBER,
66 p_amount_adjusted NUMBER,
67 p_amount_remaining NUMBER,
68 p_amount_settled NUMBER,
69 p_acctd_amount NUMBER,
70 p_acctd_amount_remaining NUMBER,
71 p_acctd_amount_adjusted NUMBER,
72 p_acctd_amount_settled NUMBER,
73 p_tax_amount NUMBER,
74 p_tax_code VARCHAR2,
75 p_tax_calculation_flag VARCHAR2,
76 p_currency_code VARCHAR2,
77 p_exchange_rate_type VARCHAR2,
78 p_exchange_rate_date DATE,
79 p_exchange_rate NUMBER,
80 p_set_of_books_id NUMBER,
81 p_original_claim_date DATE,
82 p_source_object_id NUMBER,
83 p_source_object_class VARCHAR2,
84 p_source_object_type_id NUMBER,
85 p_source_object_number VARCHAR2,
86 p_cust_account_id NUMBER,
87 p_cust_billto_acct_site_id NUMBER,
88 p_cust_shipto_acct_site_id NUMBER,
89 p_location_id NUMBER,
90 p_pay_related_account_flag VARCHAR2,
91 p_related_cust_account_id NUMBER,
92 p_related_site_use_id NUMBER,
93 p_relationship_type VARCHAR2,
94 p_vendor_id NUMBER,
95 p_vendor_site_id NUMBER,
96 p_reason_type VARCHAR2,
97 p_reason_code_id NUMBER,
98 p_task_template_group_id NUMBER,
99 p_status_code VARCHAR2,
100 p_user_status_id NUMBER,
101 p_sales_rep_id NUMBER,
102 p_collector_id NUMBER,
103 p_contact_id NUMBER,
104 p_broker_id NUMBER,
105 p_territory_id NUMBER,
106 p_customer_ref_date DATE,
107 p_customer_ref_number VARCHAR2,
108 p_customer_ref_normalized VARCHAR2,
109 p_assigned_to NUMBER,
110 p_receipt_id NUMBER,
111 p_receipt_number VARCHAR2,
112 p_doc_sequence_id NUMBER,
113 p_doc_sequence_value NUMBER,
114 p_gl_date DATE,
115 p_payment_method VARCHAR2,
116 p_voucher_id NUMBER,
117 p_voucher_number VARCHAR2,
118 p_payment_reference_id NUMBER,
119 p_payment_reference_number VARCHAR2,
120 p_payment_reference_date DATE,
121 p_payment_status VARCHAR2,
122 p_approved_flag VARCHAR2,
123 p_approved_date DATE,
124 p_approved_by NUMBER,
125 p_settled_date DATE,
126 p_settled_by NUMBER,
127 p_effective_date DATE,
128 p_custom_setup_id NUMBER,
129 p_task_id NUMBER,
130 p_country_id NUMBER,
131 p_order_type_id NUMBER,
132 p_comments VARCHAR2,
133 p_attribute_category VARCHAR2,
134 p_attribute1 VARCHAR2,
135 p_attribute2 VARCHAR2,
136 p_attribute3 VARCHAR2,
137 p_attribute4 VARCHAR2,
138 p_attribute5 VARCHAR2,
139 p_attribute6 VARCHAR2,
140 p_attribute7 VARCHAR2,
141 p_attribute8 VARCHAR2,
142 p_attribute9 VARCHAR2,
143 p_attribute10 VARCHAR2,
144 p_attribute11 VARCHAR2,
145 p_attribute12 VARCHAR2,
146 p_attribute13 VARCHAR2,
147 p_attribute14 VARCHAR2,
148 p_attribute15 VARCHAR2,
149 p_deduction_attribute_category VARCHAR2,
150 p_deduction_attribute1 VARCHAR2,
151 p_deduction_attribute2 VARCHAR2,
152 p_deduction_attribute3 VARCHAR2,
153 p_deduction_attribute4 VARCHAR2,
154 p_deduction_attribute5 VARCHAR2,
155 p_deduction_attribute6 VARCHAR2,
156 p_deduction_attribute7 VARCHAR2,
157 p_deduction_attribute8 VARCHAR2,
158 p_deduction_attribute9 VARCHAR2,
159 p_deduction_attribute10 VARCHAR2,
160 p_deduction_attribute11 VARCHAR2,
161 p_deduction_attribute12 VARCHAR2,
162 p_deduction_attribute13 VARCHAR2,
163 p_deduction_attribute14 VARCHAR2,
164 p_deduction_attribute15 VARCHAR2,
165 px_org_id IN OUT NOCOPY NUMBER,
166 p_legal_entity_id NUMBER, -- Added by kishore
167 p_write_off_flag VARCHAR2, -- Auto Write-off enhancements (uday)
168 p_write_off_threshold_amount NUMBER, -- Auto Write-off enhancements (uday)
169 p_under_write_off_threshold VARCHAR2, -- Auto Write-off enhancements (uday)
170 p_customer_reason VARCHAR2, -- Auto Write-off enhancements (uday)
171 p_ship_to_cust_account_id NUMBER, -- Addded by uday
172 p_amount_applied NUMBER, -- Subsequent Receipt Application changes
173 p_applied_receipt_id NUMBER, -- Subsequent Receipt Application changes
174 p_applied_receipt_number VARCHAR2, -- Subsequent Receipt Application changes
175 p_wo_rec_trx_id NUMBER,
176 p_group_claim_id NUMBER,
177 p_appr_wf_item_key VARCHAR2,
178 p_cstl_wf_item_key VARCHAR2,
179 p_batch_type VARCHAR2,
180 p_close_status_id NUMBER,
181 p_open_status_id NUMBER,
182 p_pre_auth_ded_number VARCHAR2, -- Added for Rule Based Settlement
183 p_pre_auth_ded_normalized VARCHAR2, -- Added for Rule Based Settlement
184 p_offer_id NUMBER, -- Added for Rule Based Settlement
185 p_settled_from VARCHAR2, -- Added for Rule Based Settlement
186 p_approval_in_prog VARCHAR2
187 )
188
189 IS
190 x_rowid VARCHAR2(30);
191
192
193 BEGIN
194
195 -- R12 Enhancements
196
197 /* IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
198 SELECT NVL(SUBSTRB(USERENV('CLIENT_INFO'),1,10),-99)
199 INTO px_org_id
200 FROM DUAL;
201 END IF; */
202
203
204 px_object_version_number := 1;
205
206
207 INSERT INTO OZF_CLAIMS_ALL(
208 claim_id,
209 object_version_number,
210 last_update_date,
211 last_updated_by,
212 creation_date,
213 created_by,
214 last_update_login,
215 request_id,
216 program_application_id,
217 program_update_date,
218 program_id,
219 created_from,
220 batch_id,
221 claim_number,
222 claim_type_id,
223 claim_class,
224 claim_date,
225 due_date,
226 owner_id,
227 history_event,
228 history_event_date,
229 history_event_description,
230 split_from_claim_id,
231 duplicate_claim_id,
232 split_date,
233 root_claim_id,
234 amount,
235 amount_adjusted,
236 amount_remaining,
237 amount_settled,
238 acctd_amount,
239 acctd_amount_remaining,
240 acctd_amount_adjusted,
241 acctd_amount_settled,
242 tax_amount,
243 tax_code,
244 tax_calculation_flag,
245 currency_code,
246 exchange_rate_type,
247 exchange_rate_date,
248 exchange_rate,
249 set_of_books_id,
250 original_claim_date,
251 source_object_id,
252 source_object_class,
253 source_object_type_id,
254 source_object_number,
255 cust_account_id,
256 cust_billto_acct_site_id,
257 cust_shipto_acct_site_id,
258 location_id,
259 pay_related_account_flag,
260 related_cust_account_id,
261 related_site_use_id,
262 relationship_type,
263 vendor_id,
264 vendor_site_id,
265 reason_type,
266 reason_code_id,
267 task_template_group_id,
268 status_code,
269 user_status_id,
270 sales_rep_id,
271 collector_id,
272 contact_id,
273 broker_id,
274 territory_id,
275 customer_ref_date,
276 customer_ref_number,
277 customer_ref_normalized,
278 assigned_to,
279 receipt_id,
280 receipt_number,
281 doc_sequence_id,
282 doc_sequence_value,
283 gl_date,
284 payment_method,
285 voucher_id,
286 voucher_number,
287 payment_reference_id,
288 payment_reference_number,
289 payment_reference_date,
290 payment_status,
291 approved_flag,
292 approved_date,
293 approved_by,
294 settled_date,
295 settled_by,
296 effective_date,
297 custom_setup_id,
298 task_id,
299 country_id,
300 order_type_id,
301 comments,
302 attribute_category,
303 attribute1,
304 attribute2,
305 attribute3,
306 attribute4,
307 attribute5,
308 attribute6,
309 attribute7,
310 attribute8,
311 attribute9,
312 attribute10,
313 attribute11,
314 attribute12,
315 attribute13,
316 attribute14,
320 deduction_attribute2,
317 attribute15,
318 deduction_attribute_category,
319 deduction_attribute1,
321 deduction_attribute3,
322 deduction_attribute4,
323 deduction_attribute5,
324 deduction_attribute6,
325 deduction_attribute7,
326 deduction_attribute8,
327 deduction_attribute9,
328 deduction_attribute10,
329 deduction_attribute11,
330 deduction_attribute12,
331 deduction_attribute13,
332 deduction_attribute14,
333 deduction_attribute15,
334 org_id,
335 legal_entity_id,
336 write_off_flag,
337 write_off_threshold_amount,
338 under_write_off_threshold,
339 customer_reason,
340 ship_to_cust_account_id,
341 amount_applied,
342 applied_receipt_id,
343 applied_receipt_number,
344 wo_rec_trx_id,
345 group_claim_id,
346 appr_wf_item_key,
347 cstl_wf_item_key,
348 batch_type,
349 close_status_id,
350 open_status_id,
351 pre_auth_deduction_number, -- Added for Rule Based Settlement
352 pre_auth_deduction_normalized,
353 offer_id,
354 settled_from,
355 approval_in_prog
356
357 ) VALUES (
358 px_claim_id,
359 px_object_version_number,
360 p_last_update_date,
361 p_last_updated_by,
362 p_creation_date,
363 p_created_by,
364 p_last_update_login,
365 p_request_id,
366 p_program_application_id,
367 p_program_update_date,
368 p_program_id,
369 p_created_from,
370 p_batch_id,
371 p_claim_number,
372 p_claim_type_id,
373 p_claim_class,
374 p_claim_date,
375 p_due_date,
376 p_owner_id,
377 p_history_event,
378 p_history_event_date,
379 p_history_event_description,
380 p_split_from_claim_id,
381 p_duplicate_claim_id,
382 p_split_date,
383 p_root_claim_id,
384 p_amount,
385 p_amount_adjusted,
386 p_amount_remaining,
387 p_amount_settled,
388 p_acctd_amount,
389 p_acctd_amount_remaining,
390 p_acctd_amount_adjusted,
391 p_acctd_amount_settled,
392 p_tax_amount,
393 p_tax_code,
394 p_tax_calculation_flag,
395 p_currency_code,
396 p_exchange_rate_type,
397 p_exchange_rate_date,
398 p_exchange_rate,
399 p_set_of_books_id,
400 p_original_claim_date,
401 p_source_object_id,
402 p_source_object_class,
403 p_source_object_type_id,
404 p_source_object_number,
405 p_cust_account_id,
406 p_cust_billto_acct_site_id,
407 p_cust_shipto_acct_site_id,
408 p_location_id,
409 p_pay_related_account_flag,
410 p_related_cust_account_id,
411 p_related_site_use_id,
412 p_relationship_type,
413 p_vendor_id,
414 p_vendor_site_id,
415 p_reason_type,
416 p_reason_code_id,
417 p_task_template_group_id,
418 p_status_code,
419 p_user_status_id,
420 p_sales_rep_id,
421 p_collector_id,
422 p_contact_id,
423 p_broker_id,
424 p_territory_id,
425 p_customer_ref_date,
426 p_customer_ref_number,
427 p_customer_ref_normalized,
428 p_assigned_to,
429 p_receipt_id,
430 p_receipt_number,
431 p_doc_sequence_id,
432 p_doc_sequence_value,
433 p_gl_date,
434 p_payment_method,
435 p_voucher_id,
436 p_voucher_number,
437 p_payment_reference_id,
438 p_payment_reference_number,
439 p_payment_reference_date,
440 p_payment_status,
441 p_approved_flag,
442 p_approved_date,
443 p_approved_by,
444 p_settled_date,
445 p_settled_by,
446 p_effective_date,
447 p_custom_setup_id,
448 p_task_id,
449 p_country_id,
450 p_order_type_id,
451 p_comments,
452 p_attribute_category,
453 p_attribute1,
454 p_attribute2,
455 p_attribute3,
456 p_attribute4,
457 p_attribute5,
458 p_attribute6,
459 p_attribute7,
460 p_attribute8,
461 p_attribute9,
462 p_attribute10,
463 p_attribute11,
464 p_attribute12,
465 p_attribute13,
466 p_attribute14,
467 p_attribute15,
468 p_deduction_attribute_category,
469 p_deduction_attribute1,
470 p_deduction_attribute2,
471 p_deduction_attribute3,
472 p_deduction_attribute4,
473 p_deduction_attribute5,
474 p_deduction_attribute6,
475 p_deduction_attribute7,
476 p_deduction_attribute8,
477 p_deduction_attribute9,
478 p_deduction_attribute10,
479 p_deduction_attribute11,
483 p_deduction_attribute15,
480 p_deduction_attribute12,
481 p_deduction_attribute13,
482 p_deduction_attribute14,
484 px_org_id,
485 p_legal_entity_id,
486 p_write_off_flag,
487 p_write_off_threshold_amount,
488 p_under_write_off_threshold,
489 p_customer_reason,
490 p_ship_to_cust_account_id,
491 p_amount_applied,
492 p_applied_receipt_id,
493 p_applied_receipt_number,
494 p_wo_rec_trx_id,
495 p_group_claim_id,
496 p_appr_wf_item_key,
497 p_cstl_wf_item_key,
498 p_batch_type,
499 p_close_status_id,
500 p_open_status_id,
501 -- Added For Rule Based Settlement
502 p_pre_auth_ded_number,
503 p_pre_auth_ded_normalized,
504 p_offer_id,
505 p_settled_from,
506 p_approval_in_prog
507 );
508 END Insert_Row;
509
510
511 ----------------------------------------------------------
512 ---- MEDIA ----
513 ----------------------------------------------------------
514
515 -- ========================================================
516 --
517 -- NAME
518 -- createUpdateBody
519 --
520 -- PURPOSE
521 --
522 -- NOTES
523 --
524 -- HISTORY
525 --
526 -- ========================================================
527 PROCEDURE Update_Row(
528 p_claim_id NUMBER,
529 p_object_version_number NUMBER,
530 p_last_update_date DATE,
531 p_last_updated_by NUMBER,
532 p_last_update_login NUMBER,
533 p_request_id NUMBER,
534 p_program_application_id NUMBER,
535 p_program_update_date DATE,
536 p_program_id NUMBER,
537 p_created_from VARCHAR2,
538 p_batch_id NUMBER,
539 p_claim_number VARCHAR2,
540 p_claim_type_id NUMBER,
541 p_claim_class VARCHAR2,
542 p_claim_date DATE,
543 p_due_date DATE,
544 p_owner_id NUMBER,
545 p_history_event VARCHAR2,
546 p_history_event_date DATE,
547 p_history_event_description VARCHAR2,
548 p_split_from_claim_id NUMBER,
549 p_duplicate_claim_id NUMBER,
550 p_split_date DATE,
551 p_root_claim_id NUMBER,
552 p_amount NUMBER,
553 p_amount_adjusted NUMBER,
554 p_amount_remaining NUMBER,
555 p_amount_settled NUMBER,
556 p_acctd_amount NUMBER,
557 p_acctd_amount_remaining NUMBER,
558 p_acctd_amount_adjusted NUMBER,
559 p_acctd_amount_settled NUMBER,
560 p_tax_amount NUMBER,
561 p_tax_code VARCHAR2,
562 p_tax_calculation_flag VARCHAR2,
563 p_currency_code VARCHAR2,
564 p_exchange_rate_type VARCHAR2,
565 p_exchange_rate_date DATE,
566 p_exchange_rate NUMBER,
567 p_set_of_books_id NUMBER,
568 p_original_claim_date DATE,
569 p_source_object_id NUMBER,
570 p_source_object_class VARCHAR2,
571 p_source_object_type_id NUMBER,
572 p_source_object_number VARCHAR2,
573 p_cust_account_id NUMBER,
574 p_cust_billto_acct_site_id NUMBER,
575 p_cust_shipto_acct_site_id NUMBER,
576 p_location_id NUMBER,
577 p_pay_related_account_flag VARCHAR2,
578 p_related_cust_account_id NUMBER,
579 p_related_site_use_id NUMBER,
580 p_relationship_type VARCHAR2,
581 p_vendor_id NUMBER,
582 p_vendor_site_id NUMBER,
583 p_reason_type VARCHAR2,
584 p_reason_code_id NUMBER,
585 p_task_template_group_id NUMBER,
586 p_status_code VARCHAR2,
587 p_user_status_id NUMBER,
588 p_sales_rep_id NUMBER,
589 p_collector_id NUMBER,
590 p_contact_id NUMBER,
591 p_broker_id NUMBER,
592 p_territory_id NUMBER,
593 p_customer_ref_date DATE,
594 p_customer_ref_number VARCHAR2,
595 p_customer_ref_normalized VARCHAR2,
596 p_assigned_to NUMBER,
597 p_receipt_id NUMBER,
598 p_receipt_number VARCHAR2,
599 p_doc_sequence_id NUMBER,
600 p_doc_sequence_value NUMBER,
601 p_gl_date DATE,
602 p_payment_method VARCHAR2,
603 p_voucher_id NUMBER,
604 p_voucher_number VARCHAR2,
605 p_payment_reference_id NUMBER,
606 p_payment_reference_number VARCHAR2,
607 p_payment_reference_date DATE,
608 p_payment_status VARCHAR2,
609 p_approved_flag VARCHAR2,
610 p_approved_date DATE,
611 p_approved_by NUMBER,
612 p_settled_date DATE,
613 p_settled_by NUMBER,
614 p_effective_date DATE,
615 p_custom_setup_id NUMBER,
616 p_task_id NUMBER,
617 p_country_id NUMBER,
618 p_order_type_id NUMBER,
619 p_comments VARCHAR2,
620 p_attribute_category VARCHAR2,
621 p_attribute1 VARCHAR2,
622 p_attribute2 VARCHAR2,
623 p_attribute3 VARCHAR2,
624 p_attribute4 VARCHAR2,
625 p_attribute5 VARCHAR2,
626 p_attribute6 VARCHAR2,
630 p_attribute10 VARCHAR2,
627 p_attribute7 VARCHAR2,
628 p_attribute8 VARCHAR2,
629 p_attribute9 VARCHAR2,
631 p_attribute11 VARCHAR2,
632 p_attribute12 VARCHAR2,
633 p_attribute13 VARCHAR2,
634 p_attribute14 VARCHAR2,
635 p_attribute15 VARCHAR2,
636 p_deduction_attribute_category VARCHAR2,
637 p_deduction_attribute1 VARCHAR2,
638 p_deduction_attribute2 VARCHAR2,
639 p_deduction_attribute3 VARCHAR2,
640 p_deduction_attribute4 VARCHAR2,
641 p_deduction_attribute5 VARCHAR2,
642 p_deduction_attribute6 VARCHAR2,
643 p_deduction_attribute7 VARCHAR2,
644 p_deduction_attribute8 VARCHAR2,
645 p_deduction_attribute9 VARCHAR2,
646 p_deduction_attribute10 VARCHAR2,
647 p_deduction_attribute11 VARCHAR2,
648 p_deduction_attribute12 VARCHAR2,
649 p_deduction_attribute13 VARCHAR2,
650 p_deduction_attribute14 VARCHAR2,
651 p_deduction_attribute15 VARCHAR2,
652 p_org_id NUMBER,
653 p_legal_entity_id NUMBER,
654 p_write_off_flag VARCHAR2,
655 p_write_off_threshold_amount NUMBER,
656 p_under_write_off_threshold VARCHAR2,
657 p_customer_reason VARCHAR2,
658 p_ship_to_cust_account_id NUMBER,
659 p_amount_applied NUMBER,
660 p_applied_receipt_id NUMBER,
661 p_applied_receipt_number VARCHAR2,
662 p_wo_rec_trx_id NUMBER,
663 p_group_claim_id NUMBER,
664 p_appr_wf_item_key VARCHAR2,
665 p_cstl_wf_item_key VARCHAR2,
666 p_batch_type VARCHAR2,
667 p_close_status_id NUMBER,
668 p_open_status_id NUMBER,
669 p_pre_auth_ded_number VARCHAR2, -- Added For Rule Based Settlement
670 p_pre_auth_ded_normalized VARCHAR2,
671 p_offer_id NUMBER,
672 p_settled_from VARCHAR2,
673 p_approval_in_prog VARCHAR2
674 )
675 IS
676 BEGIN
677 Update OZF_CLAIMS_ALL
678 SET
679 claim_id = p_claim_id,
680 object_version_number = p_object_version_number,
681 last_update_date = p_last_update_date,
682 last_updated_by = p_last_updated_by,
683 last_update_login = p_last_update_login,
684 request_id = p_request_id,
685 program_application_id = p_program_application_id,
686 program_update_date = p_program_update_date,
687 program_id = p_program_id,
688 created_from = p_created_from,
689 batch_id = p_batch_id,
690 claim_number = p_claim_number,
691 claim_type_id = p_claim_type_id,
692 claim_class = p_claim_class,
693 claim_date = p_claim_date,
694 due_date = p_due_date,
695 owner_id = p_owner_id,
696 history_event = p_history_event,
697 history_event_date = p_history_event_date,
698 history_event_description = p_history_event_description,
699 split_from_claim_id = p_split_from_claim_id,
700 duplicate_claim_id = p_duplicate_claim_id,
701 split_date = p_split_date,
702 root_claim_id = p_root_claim_id,
703 amount = p_amount,
704 amount_adjusted = p_amount_adjusted,
705 amount_remaining = p_amount_remaining,
706 amount_settled = p_amount_settled,
707 acctd_amount = p_acctd_amount,
708 acctd_amount_remaining = p_acctd_amount_remaining,
709 acctd_amount_adjusted = p_acctd_amount_adjusted,
710 acctd_amount_settled = p_acctd_amount_settled,
711 tax_amount = p_tax_amount,
712 tax_code = p_tax_code,
713 tax_calculation_flag = p_tax_calculation_flag,
714 currency_code = p_currency_code,
715 exchange_rate_type = p_exchange_rate_type,
716 exchange_rate_date = p_exchange_rate_date,
717 exchange_rate = p_exchange_rate,
718 set_of_books_id = p_set_of_books_id,
719 original_claim_date = p_original_claim_date,
720 source_object_id = p_source_object_id,
721 source_object_class = p_source_object_class,
722 source_object_type_id = p_source_object_type_id,
723 source_object_number = p_source_object_number,
724 cust_account_id = p_cust_account_id,
725 cust_billto_acct_site_id = p_cust_billto_acct_site_id,
726 cust_shipto_acct_site_id = p_cust_shipto_acct_site_id,
727 location_id = p_location_id,
728 pay_related_account_flag = p_pay_related_account_flag,
729 related_cust_account_id = p_related_cust_account_id,
730 related_site_use_id = p_related_site_use_id,
731 relationship_type = p_relationship_type,
732 vendor_id = p_vendor_id,
733 vendor_site_id = p_vendor_site_id,
734 reason_type = p_reason_type,
735 reason_code_id = p_reason_code_id,
736 task_template_group_id = p_task_template_group_id,
737 status_code = p_status_code,
738 user_status_id = p_user_status_id,
739 sales_rep_id = p_sales_rep_id,
740 collector_id = p_collector_id,
741 contact_id = p_contact_id,
742 broker_id = p_broker_id,
743 territory_id = p_territory_id,
747 assigned_to = p_assigned_to,
744 customer_ref_date = p_customer_ref_date,
745 customer_ref_number = p_customer_ref_number,
746 customer_ref_normalized = p_customer_ref_normalized,
748 receipt_id = p_receipt_id,
749 receipt_number = p_receipt_number,
750 doc_sequence_id = p_doc_sequence_id,
751 doc_sequence_value = p_doc_sequence_value,
752 gl_date = p_gl_date,
753 payment_method = p_payment_method,
754 voucher_id = p_voucher_id,
755 voucher_number = p_voucher_number,
756 payment_reference_id = p_payment_reference_id,
757 payment_reference_number = p_payment_reference_number,
758 payment_reference_date = p_payment_reference_date,
759 payment_status = p_payment_status,
760 approved_flag = p_approved_flag,
761 approved_date = p_approved_date,
762 approved_by = p_approved_by,
763 settled_date = p_settled_date,
764 settled_by = p_settled_by,
765 effective_date = p_effective_date,
766 custom_setup_id = p_custom_setup_id,
767 task_id = p_task_id,
768 country_id = p_country_id,
769 order_type_id = p_order_type_id,
770 comments = p_comments,
771 attribute_category = p_attribute_category,
772 attribute1 = p_attribute1,
773 attribute2 = p_attribute2,
774 attribute3 = p_attribute3,
775 attribute4 = p_attribute4,
776 attribute5 = p_attribute5,
777 attribute6 = p_attribute6,
778 attribute7 = p_attribute7,
779 attribute8 = p_attribute8,
780 attribute9 = p_attribute9,
781 attribute10 = p_attribute10,
782 attribute11 = p_attribute11,
783 attribute12 = p_attribute12,
784 attribute13 = p_attribute13,
785 attribute14 = p_attribute14,
786 attribute15 = p_attribute15,
787 deduction_attribute_category = p_deduction_attribute_category,
788 deduction_attribute1 = p_deduction_attribute1,
789 deduction_attribute2 = p_deduction_attribute2,
790 deduction_attribute3 = p_deduction_attribute3,
791 deduction_attribute4 = p_deduction_attribute4,
792 deduction_attribute5 = p_deduction_attribute5,
793 deduction_attribute6 = p_deduction_attribute6,
794 deduction_attribute7 = p_deduction_attribute7,
795 deduction_attribute8 = p_deduction_attribute8,
796 deduction_attribute9 = p_deduction_attribute9,
797 deduction_attribute10 = p_deduction_attribute10,
798 deduction_attribute11 = p_deduction_attribute11,
799 deduction_attribute12 = p_deduction_attribute12,
800 deduction_attribute13 = p_deduction_attribute13,
801 deduction_attribute14 = p_deduction_attribute14,
802 deduction_attribute15 = p_deduction_attribute15,
803 org_id = p_org_id,
804 legal_entity_id = p_legal_entity_id,
805 write_off_flag = p_write_off_flag,
806 write_off_threshold_amount = p_write_off_threshold_amount,
807 under_write_off_threshold = p_under_write_off_threshold,
808 customer_reason = p_customer_reason,
809 ship_to_cust_account_id = p_ship_to_cust_account_id,
810 amount_applied = p_amount_applied,
811 applied_receipt_id = p_applied_receipt_id,
812 applied_receipt_number = p_applied_receipt_number,
813 wo_rec_trx_id = p_wo_rec_trx_id,
814 group_claim_id = p_group_claim_id,
815 appr_wf_item_key = p_appr_wf_item_key,
816 cstl_wf_item_key = p_cstl_wf_item_key,
817 batch_type = p_batch_type,
818 close_status_id = p_close_status_id,
819 open_status_id = p_open_status_id,
820 -- Added For Rule Based Settlement
821 pre_auth_deduction_number = p_pre_auth_ded_number,
822 pre_auth_deduction_normalized = p_pre_auth_ded_normalized,
823 offer_id = p_offer_id,
824 settled_from = p_settled_from,
825 approval_in_prog = p_approval_in_prog
826 WHERE CLAIM_ID = p_CLAIM_ID;
827 -- AND object_version_number = p_object_version_number;
828
829 IF (SQL%NOTFOUND) THEN
830 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
831 END IF;
832 END Update_Row;
833
834
835 ----------------------------------------------------------
836 ---- MEDIA ----
837 ----------------------------------------------------------
838
839 -- ========================================================
840 --
841 -- NAME
842 -- createDeleteBody
843 --
844 -- PURPOSE
845 --
846 -- NOTES
847 --
848 -- HISTORY
849 --
850 -- ========================================================
851 PROCEDURE Delete_Row(
852 p_CLAIM_ID NUMBER)
853 IS
854 BEGIN
855 DELETE FROM OZF_CLAIMS_ALL
856 WHERE CLAIM_ID = p_CLAIM_ID;
857 If (SQL%NOTFOUND) then
858 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859 End If;
860 END Delete_Row ;
861
862
863
864 ----------------------------------------------------------
865 ---- MEDIA ----
866 ----------------------------------------------------------
867
868 -- ========================================================
869 --
870 -- NAME
871 -- createLockBody
872 --
873 -- PURPOSE
874 --
875 -- NOTES
876 --
877 -- HISTORY
878 --
882 p_object_version_number NUMBER,
879 -- ========================================================
880 PROCEDURE Lock_Row(
881 p_claim_id NUMBER,
883 p_last_update_date DATE,
884 p_last_updated_by NUMBER,
885 p_creation_date DATE,
886 p_created_by NUMBER,
887 p_last_update_login NUMBER,
888 p_request_id NUMBER,
889 p_program_application_id NUMBER,
890 p_program_update_date DATE,
891 p_program_id NUMBER,
892 p_created_from VARCHAR2,
893 p_batch_id NUMBER,
894 p_claim_number VARCHAR2,
895 p_claim_type_id NUMBER,
896 p_claim_class VARCHAR2,
897 p_claim_date DATE,
898 p_due_date DATE,
899 p_owner_id NUMBER,
900 p_history_event VARCHAR2,
901 p_history_event_date DATE,
902 p_history_event_description VARCHAR2,
903 p_split_from_claim_id NUMBER,
904 p_duplicate_claim_id NUMBER,
905 p_split_date DATE,
906 p_root_claim_id NUMBER,
907 p_amount NUMBER,
908 p_amount_adjusted NUMBER,
909 p_amount_remaining NUMBER,
910 p_amount_settled NUMBER,
911 p_acctd_amount NUMBER,
912 p_acctd_amount_remaining NUMBER,
913 p_acctd_amount_adjusted NUMBER,
914 p_acctd_amount_settled NUMBER,
915 p_tax_amount NUMBER,
916 p_tax_code VARCHAR2,
917 p_tax_calculation_flag VARCHAR2,
918 p_currency_code VARCHAR2,
919 p_exchange_rate_type VARCHAR2,
920 p_exchange_rate_date DATE,
921 p_exchange_rate NUMBER,
922 p_set_of_books_id NUMBER,
923 p_original_claim_date DATE,
924 p_source_object_id NUMBER,
925 p_source_object_class VARCHAR2,
926 p_source_object_type_id NUMBER,
927 p_source_object_number VARCHAR2,
928 p_cust_account_id NUMBER,
929 p_cust_billto_acct_site_id NUMBER,
930 p_cust_shipto_acct_site_id NUMBER,
931 p_location_id NUMBER,
932 p_pay_related_account_flag VARCHAR2,
933 p_related_cust_account_id NUMBER,
934 p_related_site_use_id NUMBER,
935 p_relationship_type VARCHAR2,
936 p_vendor_id NUMBER,
937 p_vendor_site_id NUMBER,
938 p_reason_type VARCHAR2,
939 p_reason_code_id NUMBER,
940 p_task_template_group_id NUMBER,
941 p_status_code VARCHAR2,
942 p_user_status_id NUMBER,
943 p_sales_rep_id NUMBER,
944 p_collector_id NUMBER,
945 p_contact_id NUMBER,
946 p_broker_id NUMBER,
947 p_territory_id NUMBER,
948 p_customer_ref_date DATE,
949 p_customer_ref_number VARCHAR2,
950 p_customer_ref_normalized VARCHAR2,
951 p_assigned_to NUMBER,
952 p_receipt_id NUMBER,
953 p_receipt_number VARCHAR2,
954 p_doc_sequence_id NUMBER,
955 p_doc_sequence_value NUMBER,
956 p_gl_date DATE,
957 p_payment_method VARCHAR2,
958 p_voucher_id NUMBER,
959 p_voucher_number VARCHAR2,
960 p_payment_reference_id NUMBER,
961 p_payment_reference_number VARCHAR2,
962 p_payment_reference_date DATE,
963 p_payment_status VARCHAR2,
964 p_approved_flag VARCHAR2,
965 p_approved_date DATE,
966 p_approved_by NUMBER,
967 p_settled_date DATE,
968 p_settled_by NUMBER,
969 p_effective_date DATE,
970 p_custom_setup_id NUMBER,
971 p_task_id NUMBER,
972 p_country_id NUMBER,
973 p_order_type_id NUMBER,
974 p_comments VARCHAR2,
975 p_attribute_category VARCHAR2,
976 p_attribute1 VARCHAR2,
977 p_attribute2 VARCHAR2,
978 p_attribute3 VARCHAR2,
979 p_attribute4 VARCHAR2,
980 p_attribute5 VARCHAR2,
981 p_attribute6 VARCHAR2,
982 p_attribute7 VARCHAR2,
983 p_attribute8 VARCHAR2,
984 p_attribute9 VARCHAR2,
985 p_attribute10 VARCHAR2,
986 p_attribute11 VARCHAR2,
987 p_attribute12 VARCHAR2,
988 p_attribute13 VARCHAR2,
989 p_attribute14 VARCHAR2,
990 p_attribute15 VARCHAR2,
991 p_deduction_attribute_category VARCHAR2,
992 p_deduction_attribute1 VARCHAR2,
993 p_deduction_attribute2 VARCHAR2,
994 p_deduction_attribute3 VARCHAR2,
995 p_deduction_attribute4 VARCHAR2,
996 p_deduction_attribute5 VARCHAR2,
997 p_deduction_attribute6 VARCHAR2,
998 p_deduction_attribute7 VARCHAR2,
999 p_deduction_attribute8 VARCHAR2,
1000 p_deduction_attribute9 VARCHAR2,
1001 p_deduction_attribute10 VARCHAR2,
1002 p_deduction_attribute11 VARCHAR2,
1003 p_deduction_attribute12 VARCHAR2,
1004 p_deduction_attribute13 VARCHAR2,
1005 p_deduction_attribute14 VARCHAR2,
1006 p_deduction_attribute15 VARCHAR2,
1007 p_org_id NUMBER,
1008 p_legal_entity_id NUMBER,
1009 p_write_off_flag VARCHAR2,
1010 p_write_off_threshold_amount NUMBER,
1011 p_under_write_off_threshold VARCHAR2,
1015 p_applied_receipt_id NUMBER,
1012 p_customer_reason VARCHAR2,
1013 p_ship_to_cust_account_id NUMBER,
1014 p_amount_applied NUMBER,
1016 p_applied_receipt_number VARCHAR2,
1017 p_wo_rec_trx_id NUMBER,
1018 p_group_claim_id NUMBER,
1019 p_appr_wf_item_key VARCHAR2,
1020 p_cstl_wf_item_key VARCHAR2,
1021 p_batch_type VARCHAR2,
1022 p_close_status_id NUMBER,
1023 p_open_status_id NUMBER
1024 )
1025
1026 IS
1027 CURSOR C IS
1028 SELECT *
1029 FROM OZF_CLAIMS_ALL
1030 WHERE CLAIM_ID = p_CLAIM_ID
1031 FOR UPDATE of CLAIM_ID NOWAIT;
1032 Recinfo C%ROWTYPE;
1033 BEGIN
1034 OPEN c;
1035 FETCH c INTO Recinfo;
1036 If (c%NOTFOUND) then
1037 CLOSE c;
1038 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
1039 APP_EXCEPTION.RAISE_EXCEPTION;
1040 END IF;
1041 CLOSE C;
1042 IF (
1043 ( Recinfo.claim_id = p_claim_id)
1044 AND ( ( Recinfo.object_version_number = p_object_version_number)
1045 OR ( ( Recinfo.object_version_number IS NULL )
1046 AND ( p_object_version_number IS NULL )))
1047 AND ( ( Recinfo.last_update_date = p_last_update_date)
1048 OR ( ( Recinfo.last_update_date IS NULL )
1049 AND ( p_last_update_date IS NULL )))
1050 AND ( ( Recinfo.last_updated_by = p_last_updated_by)
1051 OR ( ( Recinfo.last_updated_by IS NULL )
1052 AND ( p_last_updated_by IS NULL )))
1053 AND ( ( Recinfo.creation_date = p_creation_date)
1054 OR ( ( Recinfo.creation_date IS NULL )
1055 AND ( p_creation_date IS NULL )))
1056 AND ( ( Recinfo.created_by = p_created_by)
1057 OR ( ( Recinfo.created_by IS NULL )
1058 AND ( p_created_by IS NULL )))
1059 AND ( ( Recinfo.last_update_login = p_last_update_login)
1060 OR ( ( Recinfo.last_update_login IS NULL )
1061 AND ( p_last_update_login IS NULL )))
1062 AND ( ( Recinfo.request_id = p_request_id)
1063 OR ( ( Recinfo.request_id IS NULL )
1064 AND ( p_request_id IS NULL )))
1065 AND ( ( Recinfo.program_application_id = p_program_application_id)
1066 OR ( ( Recinfo.program_application_id IS NULL )
1067 AND ( p_program_application_id IS NULL )))
1068 AND ( ( Recinfo.program_update_date = p_program_update_date)
1069 OR ( ( Recinfo.program_update_date IS NULL )
1070 AND ( p_program_update_date IS NULL )))
1071 AND ( ( Recinfo.program_id = p_program_id)
1072 OR ( ( Recinfo.program_id IS NULL )
1073 AND ( p_program_id IS NULL )))
1074 AND ( ( Recinfo.created_from = p_created_from)
1075 OR ( ( Recinfo.created_from IS NULL )
1076 AND ( p_created_from IS NULL )))
1077 AND ( ( Recinfo.batch_id = p_batch_id)
1078 OR ( ( Recinfo.batch_id IS NULL )
1079 AND ( p_batch_id IS NULL )))
1080 AND ( ( Recinfo.claim_number = p_claim_number)
1081 OR ( ( Recinfo.claim_number IS NULL )
1082 AND ( p_claim_number IS NULL )))
1083 AND ( ( Recinfo.claim_type_id = p_claim_type_id)
1084 OR ( ( Recinfo.claim_type_id IS NULL )
1085 AND ( p_claim_type_id IS NULL )))
1086 AND ( ( Recinfo.claim_class = p_claim_class)
1087 OR ( ( Recinfo.claim_class IS NULL )
1088 AND ( p_claim_class IS NULL )))
1089 AND ( ( Recinfo.claim_date = p_claim_date)
1090 OR ( ( Recinfo.claim_date IS NULL )
1091 AND ( p_claim_date IS NULL )))
1092 AND ( ( Recinfo.due_date = p_due_date)
1093 OR ( ( Recinfo.due_date IS NULL )
1094 AND ( p_due_date IS NULL )))
1095 AND ( ( Recinfo.owner_id = p_owner_id)
1096 OR ( ( Recinfo.owner_id IS NULL )
1097 AND ( p_owner_id IS NULL )))
1098 AND ( ( Recinfo.history_event = p_history_event)
1099 OR ( ( Recinfo.history_event IS NULL )
1100 AND ( p_history_event IS NULL )))
1101 AND ( ( Recinfo.history_event_date = p_history_event_date)
1102 OR ( ( Recinfo.history_event_date IS NULL )
1103 AND ( p_history_event_date IS NULL )))
1104 AND ( ( Recinfo.history_event_description = p_history_event_description)
1105 OR ( ( Recinfo.history_event_description IS NULL )
1106 AND ( p_history_event_description IS NULL )))
1107 AND ( ( Recinfo.split_from_claim_id = p_split_from_claim_id)
1108 OR ( ( Recinfo.split_from_claim_id IS NULL )
1109 AND ( p_split_from_claim_id IS NULL )))
1110 AND ( ( Recinfo.duplicate_claim_id = p_duplicate_claim_id)
1111 OR ( ( Recinfo.duplicate_claim_id IS NULL )
1112 AND ( p_duplicate_claim_id IS NULL )))
1113 AND ( ( Recinfo.split_date = p_split_date)
1114 OR ( ( Recinfo.split_date IS NULL )
1115 AND ( p_split_date IS NULL )))
1116 AND ( ( Recinfo.root_claim_id = p_root_claim_id)
1117 OR ( ( Recinfo.root_claim_id IS NULL )
1118 AND ( p_root_claim_id IS NULL )))
1119 AND ( ( Recinfo.amount = p_amount)
1120 OR ( ( Recinfo.amount IS NULL )
1121 AND ( p_amount IS NULL )))
1122 AND ( ( Recinfo.amount_adjusted = p_amount_adjusted)
1123 OR ( ( Recinfo.amount_adjusted IS NULL )
1124 AND ( p_amount_adjusted IS NULL )))
1128 AND ( ( Recinfo.amount_settled = p_amount_settled)
1125 AND ( ( Recinfo.amount_remaining = p_amount_remaining)
1126 OR ( ( Recinfo.amount_remaining IS NULL )
1127 AND ( p_amount_remaining IS NULL )))
1129 OR ( ( Recinfo.amount_settled IS NULL )
1130 AND ( p_amount_settled IS NULL )))
1131 AND ( ( Recinfo.acctd_amount = p_acctd_amount)
1132 OR ( ( Recinfo.acctd_amount IS NULL )
1133 AND ( p_acctd_amount IS NULL )))
1134 AND ( ( Recinfo.acctd_amount_remaining = p_acctd_amount_remaining)
1135 OR ( ( Recinfo.acctd_amount_remaining IS NULL )
1136 AND ( p_acctd_amount_remaining IS NULL )))
1137 AND ( ( Recinfo.acctd_amount_adjusted = p_acctd_amount_adjusted)
1138 OR ( ( Recinfo.acctd_amount_adjusted IS NULL )
1139 AND ( p_acctd_amount_adjusted IS NULL )))
1140 AND ( ( Recinfo.acctd_amount_settled = p_acctd_amount_settled)
1141 OR ( ( Recinfo.acctd_amount_settled IS NULL )
1142 AND ( p_acctd_amount_settled IS NULL )))
1143 AND ( ( Recinfo.tax_amount = p_tax_amount)
1144 OR ( ( Recinfo.tax_amount IS NULL )
1145 AND ( p_tax_amount IS NULL )))
1146 AND ( ( Recinfo.tax_code = p_tax_code)
1147 OR ( ( Recinfo.tax_code IS NULL )
1148 AND ( p_tax_code IS NULL )))
1149 AND ( ( Recinfo.tax_calculation_flag = p_tax_calculation_flag)
1150 OR ( ( Recinfo.tax_calculation_flag IS NULL )
1151 AND ( p_tax_calculation_flag IS NULL )))
1152 AND ( ( Recinfo.currency_code = p_currency_code)
1153 OR ( ( Recinfo.currency_code IS NULL )
1154 AND ( p_currency_code IS NULL )))
1155 AND ( ( Recinfo.exchange_rate_type = p_exchange_rate_type)
1156 OR ( ( Recinfo.exchange_rate_type IS NULL )
1157 AND ( p_exchange_rate_type IS NULL )))
1158 AND ( ( Recinfo.exchange_rate_date = p_exchange_rate_date)
1159 OR ( ( Recinfo.exchange_rate_date IS NULL )
1160 AND ( p_exchange_rate_date IS NULL )))
1161 AND ( ( Recinfo.exchange_rate = p_exchange_rate)
1162 OR ( ( Recinfo.exchange_rate IS NULL )
1163 AND ( p_exchange_rate IS NULL )))
1164 AND ( ( Recinfo.set_of_books_id = p_set_of_books_id)
1165 OR ( ( Recinfo.set_of_books_id IS NULL )
1166 AND ( p_set_of_books_id IS NULL )))
1167 AND ( ( Recinfo.original_claim_date = p_original_claim_date)
1168 OR ( ( Recinfo.original_claim_date IS NULL )
1169 AND ( p_original_claim_date IS NULL )))
1170 AND ( ( Recinfo.source_object_id = p_source_object_id)
1171 OR ( ( Recinfo.source_object_id IS NULL )
1172 AND ( p_source_object_id IS NULL )))
1173 AND ( ( Recinfo.source_object_class = p_source_object_class)
1174 OR ( ( Recinfo.source_object_class IS NULL )
1175 AND ( p_source_object_class IS NULL )))
1176 AND ( ( Recinfo.source_object_type_id = p_source_object_type_id)
1177 OR ( ( Recinfo.source_object_type_id IS NULL )
1178 AND ( p_source_object_type_id IS NULL )))
1179 AND ( ( Recinfo.source_object_number = p_source_object_number)
1180 OR ( ( Recinfo.source_object_number IS NULL )
1181 AND ( p_source_object_number IS NULL )))
1182 AND ( ( Recinfo.cust_account_id = p_cust_account_id)
1183 OR ( ( Recinfo.cust_account_id IS NULL )
1184 AND ( p_cust_account_id IS NULL )))
1185 AND ( ( Recinfo.cust_billto_acct_site_id = p_cust_billto_acct_site_id)
1186 OR ( ( Recinfo.cust_billto_acct_site_id IS NULL )
1187 AND ( p_cust_billto_acct_site_id IS NULL )))
1188 AND ( ( Recinfo.cust_shipto_acct_site_id = p_cust_shipto_acct_site_id)
1189 OR ( ( Recinfo.cust_shipto_acct_site_id IS NULL )
1190 AND ( p_cust_shipto_acct_site_id IS NULL )))
1191 AND ( ( Recinfo.location_id = p_location_id)
1192 OR ( ( Recinfo.location_id IS NULL )
1193 AND ( p_location_id IS NULL )))
1194 AND ( ( Recinfo.pay_related_account_flag = p_pay_related_account_flag)
1195 OR ( ( Recinfo.pay_related_account_flag IS NULL )
1196 AND ( p_pay_related_account_flag IS NULL )))
1197 AND ( ( Recinfo.related_cust_account_id = p_related_cust_account_id)
1198 OR ( ( Recinfo.related_cust_account_id IS NULL )
1199 AND ( p_related_cust_account_id IS NULL )))
1200 AND ( ( Recinfo.related_site_use_id = p_related_site_use_id)
1201 OR ( ( Recinfo.related_site_use_id IS NULL )
1202 AND ( p_related_site_use_id IS NULL )))
1203 AND ( ( Recinfo.relationship_type = p_relationship_type)
1204 OR ( ( Recinfo.relationship_type IS NULL )
1205 AND ( p_relationship_type IS NULL )))
1206 AND ( ( Recinfo.vendor_id = p_vendor_id)
1207 OR ( ( Recinfo.vendor_id IS NULL )
1208 AND ( p_vendor_id IS NULL )))
1209 AND ( ( Recinfo.vendor_site_id = p_vendor_site_id)
1210 OR ( ( Recinfo.vendor_site_id IS NULL )
1211 AND ( p_vendor_site_id IS NULL )))
1212 AND ( ( Recinfo.reason_type = p_reason_type)
1213 OR ( ( Recinfo.reason_type IS NULL )
1214 AND ( p_reason_type IS NULL )))
1215 AND ( ( Recinfo.reason_code_id = p_reason_code_id)
1216 OR ( ( Recinfo.reason_code_id IS NULL )
1217 AND ( p_reason_code_id IS NULL )))
1218 AND ( ( Recinfo.task_template_group_id = p_task_template_group_id)
1219 OR ( ( Recinfo.task_template_group_id IS NULL )
1220 AND ( p_task_template_group_id IS NULL )))
1221 AND ( ( Recinfo.status_code = p_status_code)
1225 OR ( ( Recinfo.user_status_id IS NULL )
1222 OR ( ( Recinfo.status_code IS NULL )
1223 AND ( p_status_code IS NULL )))
1224 AND ( ( Recinfo.user_status_id = p_user_status_id)
1226 AND ( p_user_status_id IS NULL )))
1227 AND ( ( Recinfo.sales_rep_id = p_sales_rep_id)
1228 OR ( ( Recinfo.sales_rep_id IS NULL )
1229 AND ( p_sales_rep_id IS NULL )))
1230 AND ( ( Recinfo.collector_id = p_collector_id)
1231 OR ( ( Recinfo.collector_id IS NULL )
1232 AND ( p_collector_id IS NULL )))
1233 AND ( ( Recinfo.contact_id = p_contact_id)
1234 OR ( ( Recinfo.contact_id IS NULL )
1235 AND ( p_contact_id IS NULL )))
1236 AND ( ( Recinfo.broker_id = p_broker_id)
1237 OR ( ( Recinfo.broker_id IS NULL )
1238 AND ( p_broker_id IS NULL )))
1239 AND ( ( Recinfo.territory_id = p_territory_id)
1240 OR ( ( Recinfo.territory_id IS NULL )
1241 AND ( p_territory_id IS NULL )))
1242 AND ( ( Recinfo.customer_ref_date = p_customer_ref_date)
1243 OR ( ( Recinfo.customer_ref_date IS NULL )
1244 AND ( p_customer_ref_date IS NULL )))
1245 AND ( ( Recinfo.customer_ref_number = p_customer_ref_number)
1246 OR ( ( Recinfo.customer_ref_number IS NULL )
1247 AND ( p_customer_ref_number IS NULL )))
1248 AND ( ( Recinfo.customer_ref_normalized = p_customer_ref_normalized)
1249 OR ( ( Recinfo.customer_ref_normalized IS NULL )
1250 AND ( p_customer_ref_normalized IS NULL )))
1251 AND ( ( Recinfo.assigned_to = p_assigned_to)
1252 OR ( ( Recinfo.assigned_to IS NULL )
1253 AND ( p_assigned_to IS NULL )))
1254 AND ( ( Recinfo.receipt_id = p_receipt_id)
1255 OR ( ( Recinfo.receipt_id IS NULL )
1256 AND ( p_receipt_id IS NULL )))
1257 AND ( ( Recinfo.receipt_number = p_receipt_number)
1258 OR ( ( Recinfo.receipt_number IS NULL )
1259 AND ( p_receipt_number IS NULL )))
1260 AND ( ( Recinfo.doc_sequence_id = p_doc_sequence_id)
1261 OR ( ( Recinfo.doc_sequence_id IS NULL )
1262 AND ( p_doc_sequence_id IS NULL )))
1263 AND ( ( Recinfo.doc_sequence_value = p_doc_sequence_value)
1264 OR ( ( Recinfo.doc_sequence_value IS NULL )
1265 AND ( p_doc_sequence_value IS NULL )))
1266 AND ( ( Recinfo.gl_date = p_gl_date)
1267 OR ( ( Recinfo.gl_date IS NULL )
1268 AND ( p_gl_date IS NULL )))
1269 AND ( ( Recinfo.payment_method = p_payment_method)
1270 OR ( ( Recinfo.payment_method IS NULL )
1271 AND ( p_payment_method IS NULL )))
1272 AND ( ( Recinfo.voucher_id = p_voucher_id)
1273 OR ( ( Recinfo.voucher_id IS NULL )
1274 AND ( p_voucher_id IS NULL )))
1275 AND ( ( Recinfo.voucher_number = p_voucher_number)
1276 OR ( ( Recinfo.voucher_number IS NULL )
1277 AND ( p_voucher_number IS NULL )))
1278 AND ( ( Recinfo.payment_reference_id = p_payment_reference_id)
1279 OR ( ( Recinfo.payment_reference_id IS NULL )
1280 AND ( p_payment_reference_id IS NULL )))
1281 AND ( ( Recinfo.payment_reference_number = p_payment_reference_number)
1282 OR ( ( Recinfo.payment_reference_number IS NULL )
1283 AND ( p_payment_reference_number IS NULL )))
1284 AND ( ( Recinfo.payment_reference_date = p_payment_reference_date)
1285 OR ( ( Recinfo.payment_reference_date IS NULL )
1286 AND ( p_payment_reference_date IS NULL )))
1287 AND ( ( Recinfo.payment_status = p_payment_status)
1288 OR ( ( Recinfo.payment_status IS NULL )
1289 AND ( p_payment_status IS NULL )))
1290 AND ( ( Recinfo.approved_flag = p_approved_flag)
1291 OR ( ( Recinfo.approved_flag IS NULL )
1292 AND ( p_approved_flag IS NULL )))
1293 AND ( ( Recinfo.approved_date = p_approved_date)
1294 OR ( ( Recinfo.approved_date IS NULL )
1295 AND ( p_approved_date IS NULL )))
1296 AND ( ( Recinfo.approved_by = p_approved_by)
1297 OR ( ( Recinfo.approved_by IS NULL )
1298 AND ( p_approved_by IS NULL )))
1299 AND ( ( Recinfo.settled_date = p_settled_date)
1300 OR ( ( Recinfo.settled_date IS NULL )
1301 AND ( p_settled_date IS NULL )))
1302 AND ( ( Recinfo.settled_by = p_settled_by)
1303 OR ( ( Recinfo.settled_by IS NULL )
1304 AND ( p_settled_by IS NULL )))
1305 AND ( ( Recinfo.effective_date = p_effective_date)
1306 OR ( ( Recinfo.effective_date IS NULL )
1307 AND ( p_effective_date IS NULL )))
1308 AND ( ( Recinfo.custom_setup_id = p_custom_setup_id)
1309 OR ( ( Recinfo.custom_setup_id IS NULL )
1310 AND ( p_custom_setup_id IS NULL )))
1311 AND ( ( Recinfo.task_id = p_task_id)
1312 OR ( ( Recinfo.task_id IS NULL )
1313 AND ( p_task_id IS NULL )))
1314 AND ( ( Recinfo.country_id = p_country_id)
1315 OR ( ( Recinfo.country_id IS NULL )
1316 AND ( p_country_id IS NULL )))
1317 AND ( ( Recinfo.order_type_id = p_order_type_id)
1318 OR ( ( Recinfo.order_type_id IS NULL )
1319 AND ( p_order_type_id IS NULL )))
1320 AND ( ( Recinfo.comments = p_comments)
1321 OR ( ( Recinfo.comments IS NULL )
1322 AND ( p_comments IS NULL )))
1323 AND ( ( Recinfo.attribute_category = p_attribute_category)
1324 OR ( ( Recinfo.attribute_category IS NULL )
1328 AND ( p_attribute1 IS NULL )))
1325 AND ( p_attribute_category IS NULL )))
1326 AND ( ( Recinfo.attribute1 = p_attribute1)
1327 OR ( ( Recinfo.attribute1 IS NULL )
1329 AND ( ( Recinfo.attribute2 = p_attribute2)
1330 OR ( ( Recinfo.attribute2 IS NULL )
1331 AND ( p_attribute2 IS NULL )))
1332 AND ( ( Recinfo.attribute3 = p_attribute3)
1333 OR ( ( Recinfo.attribute3 IS NULL )
1334 AND ( p_attribute3 IS NULL )))
1335 AND ( ( Recinfo.attribute4 = p_attribute4)
1336 OR ( ( Recinfo.attribute4 IS NULL )
1337 AND ( p_attribute4 IS NULL )))
1338 AND ( ( Recinfo.attribute5 = p_attribute5)
1339 OR ( ( Recinfo.attribute5 IS NULL )
1340 AND ( p_attribute5 IS NULL )))
1341 AND ( ( Recinfo.attribute6 = p_attribute6)
1342 OR ( ( Recinfo.attribute6 IS NULL )
1343 AND ( p_attribute6 IS NULL )))
1344 AND ( ( Recinfo.attribute7 = p_attribute7)
1345 OR ( ( Recinfo.attribute7 IS NULL )
1346 AND ( p_attribute7 IS NULL )))
1347 AND ( ( Recinfo.attribute8 = p_attribute8)
1348 OR ( ( Recinfo.attribute8 IS NULL )
1349 AND ( p_attribute8 IS NULL )))
1350 AND ( ( Recinfo.attribute9 = p_attribute9)
1351 OR ( ( Recinfo.attribute9 IS NULL )
1352 AND ( p_attribute9 IS NULL )))
1353 AND ( ( Recinfo.attribute10 = p_attribute10)
1354 OR ( ( Recinfo.attribute10 IS NULL )
1355 AND ( p_attribute10 IS NULL )))
1356 AND ( ( Recinfo.attribute11 = p_attribute11)
1357 OR ( ( Recinfo.attribute11 IS NULL )
1358 AND ( p_attribute11 IS NULL )))
1359 AND ( ( Recinfo.attribute12 = p_attribute12)
1360 OR ( ( Recinfo.attribute12 IS NULL )
1361 AND ( p_attribute12 IS NULL )))
1362 AND ( ( Recinfo.attribute13 = p_attribute13)
1363 OR ( ( Recinfo.attribute13 IS NULL )
1364 AND ( p_attribute13 IS NULL )))
1365 AND ( ( Recinfo.attribute14 = p_attribute14)
1366 OR ( ( Recinfo.attribute14 IS NULL )
1367 AND ( p_attribute14 IS NULL )))
1368 AND ( ( Recinfo.attribute15 = p_attribute15)
1369 OR ( ( Recinfo.attribute15 IS NULL )
1370 AND ( p_attribute15 IS NULL )))
1371 AND ( ( Recinfo.deduction_attribute_category = p_deduction_attribute_category)
1372 OR ( ( Recinfo.deduction_attribute_category IS NULL )
1373 AND ( p_deduction_attribute_category IS NULL )))
1374 AND ( ( Recinfo.deduction_attribute1 = p_deduction_attribute1)
1375 OR ( ( Recinfo.deduction_attribute1 IS NULL )
1376 AND ( p_deduction_attribute1 IS NULL )))
1377 AND ( ( Recinfo.deduction_attribute2 = p_deduction_attribute2)
1378 OR ( ( Recinfo.deduction_attribute2 IS NULL )
1379 AND ( p_deduction_attribute2 IS NULL )))
1380 AND ( ( Recinfo.deduction_attribute3 = p_deduction_attribute3)
1381 OR ( ( Recinfo.deduction_attribute3 IS NULL )
1382 AND ( p_deduction_attribute3 IS NULL )))
1383 AND ( ( Recinfo.deduction_attribute4 = p_deduction_attribute4)
1384 OR ( ( Recinfo.deduction_attribute4 IS NULL )
1385 AND ( p_deduction_attribute4 IS NULL )))
1386 AND ( ( Recinfo.deduction_attribute5 = p_deduction_attribute5)
1387 OR ( ( Recinfo.deduction_attribute5 IS NULL )
1388 AND ( p_deduction_attribute5 IS NULL )))
1389 AND ( ( Recinfo.deduction_attribute6 = p_deduction_attribute6)
1390 OR ( ( Recinfo.deduction_attribute6 IS NULL )
1391 AND ( p_deduction_attribute6 IS NULL )))
1392 AND ( ( Recinfo.deduction_attribute7 = p_deduction_attribute7)
1393 OR ( ( Recinfo.deduction_attribute7 IS NULL )
1394 AND ( p_deduction_attribute7 IS NULL )))
1395 AND ( ( Recinfo.deduction_attribute8 = p_deduction_attribute8)
1396 OR ( ( Recinfo.deduction_attribute8 IS NULL )
1397 AND ( p_deduction_attribute8 IS NULL )))
1398 AND ( ( Recinfo.deduction_attribute9 = p_deduction_attribute9)
1399 OR ( ( Recinfo.deduction_attribute9 IS NULL )
1400 AND ( p_deduction_attribute9 IS NULL )))
1401 AND ( ( Recinfo.deduction_attribute10 = p_deduction_attribute10)
1402 OR ( ( Recinfo.deduction_attribute10 IS NULL )
1403 AND ( p_deduction_attribute10 IS NULL )))
1404 AND ( ( Recinfo.deduction_attribute11 = p_deduction_attribute11)
1405 OR ( ( Recinfo.deduction_attribute11 IS NULL )
1406 AND ( p_deduction_attribute11 IS NULL )))
1407 AND ( ( Recinfo.deduction_attribute12 = p_deduction_attribute12)
1408 OR ( ( Recinfo.deduction_attribute12 IS NULL )
1409 AND ( p_deduction_attribute12 IS NULL )))
1410 AND ( ( Recinfo.deduction_attribute13 = p_deduction_attribute13)
1411 OR ( ( Recinfo.deduction_attribute13 IS NULL )
1412 AND ( p_deduction_attribute13 IS NULL )))
1413 AND ( ( Recinfo.deduction_attribute14 = p_deduction_attribute14)
1414 OR ( ( Recinfo.deduction_attribute14 IS NULL )
1415 AND ( p_deduction_attribute14 IS NULL )))
1416 AND ( ( Recinfo.deduction_attribute15 = p_deduction_attribute15)
1417 OR ( ( Recinfo.deduction_attribute15 IS NULL )
1418 AND ( p_deduction_attribute15 IS NULL )))
1419 AND ( ( Recinfo.org_id = p_org_id)
1420 OR ( ( Recinfo.org_id IS NULL )
1421 AND ( p_org_id IS NULL )))
1422 AND ( ( Recinfo.legal_entity_id = p_legal_entity_id)
1423 OR ( ( Recinfo.legal_entity_id IS NULL )
1424 AND ( p_legal_entity_id IS NULL )))
1425 AND ( ( Recinfo.write_off_flag = p_write_off_flag)
1426 OR ( ( Recinfo.write_off_flag IS NULL )
1427 AND ( p_write_off_flag IS NULL )))
1428 AND ( ( Recinfo.write_off_threshold_amount = p_write_off_threshold_amount)
1429 OR ( ( Recinfo.write_off_threshold_amount IS NULL )
1430 AND ( p_write_off_threshold_amount IS NULL )))
1431 AND ( ( Recinfo.under_write_off_threshold = p_under_write_off_threshold)
1432 OR ( ( Recinfo.under_write_off_threshold IS NULL )
1433 AND ( p_under_write_off_threshold IS NULL )))
1434 AND ( ( Recinfo.customer_reason = p_customer_reason)
1435 OR ( ( Recinfo.customer_reason IS NULL )
1436 AND ( p_customer_reason IS NULL )))
1437 AND ( ( Recinfo.ship_to_cust_account_id = p_ship_to_cust_account_id)
1438 OR ( ( Recinfo.ship_to_cust_account_id IS NULL )
1439 AND ( p_ship_to_cust_account_id IS NULL )))
1440 AND ( ( Recinfo.amount_applied = p_amount_applied)
1441 OR ( ( Recinfo.amount_applied IS NULL )
1442 AND ( p_amount_applied IS NULL )))
1443 AND ( ( Recinfo.applied_receipt_id = p_applied_receipt_id)
1444 OR ( ( Recinfo.applied_receipt_id IS NULL )
1445 AND ( p_applied_receipt_id IS NULL )))
1446 AND ( ( Recinfo.applied_receipt_number = p_applied_receipt_number)
1447 OR ( ( Recinfo.applied_receipt_number IS NULL )
1448 AND ( p_applied_receipt_number IS NULL )))
1449 AND ( ( Recinfo.wo_rec_trx_id = p_wo_rec_trx_id)
1450 OR ( ( Recinfo.wo_rec_trx_id IS NULL )
1451 AND ( p_wo_rec_trx_id IS NULL )))
1452 AND ( ( Recinfo.group_claim_id = p_group_claim_id)
1453 OR ( ( Recinfo.group_claim_id IS NULL )
1454 AND ( p_group_claim_id IS NULL )))
1455 AND ( ( Recinfo.appr_wf_item_key = p_appr_wf_item_key)
1456 OR ( ( Recinfo.appr_wf_item_key IS NULL )
1457 AND ( p_appr_wf_item_key IS NULL )))
1458 AND ( ( Recinfo.cstl_wf_item_key = p_cstl_wf_item_key)
1459 OR ( ( Recinfo.cstl_wf_item_key IS NULL )
1460 AND ( p_cstl_wf_item_key IS NULL )))
1461 AND ( ( Recinfo.batch_type = p_batch_type)
1462 OR ( ( Recinfo.batch_type IS NULL )
1463 AND ( p_batch_type IS NULL )))
1464 AND ( ( Recinfo.close_status_id = p_close_status_id)
1465 OR ( ( Recinfo.close_status_id IS NULL )
1466 AND ( p_close_status_id IS NULL )))
1467 AND ( ( Recinfo.open_status_id = p_open_status_id)
1468 OR ( ( Recinfo.open_status_id IS NULL )
1469 AND ( p_open_status_id IS NULL )))
1470 ) THEN
1471 RETURN;
1472 ELSE
1473 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
1474 APP_EXCEPTION.RAISE_EXCEPTION;
1475 END IF;
1476 END Lock_Row;
1477
1478 END OZF_CLAIMS_PKG;