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