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