[Home] [Help]
PACKAGE BODY: APPS.OZF_CLAIM_LINES_HIST_PKG
Source
1 PACKAGE BODY OZF_CLAIM_LINES_HIST_PKG as
2 /* $Header: ozftclhb.pls 120.2 2005/09/08 05:52:21 appldev ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_CLAIM_LINES_HIST_PKG
7 -- Purpose
8 --
9 -- History
10 --
11 -- MCHANG 23-OCT-2001 Remove security_group_id.
12 --
13 -- NOTE
14 --
15 -- End of Comments
16 -- ===============================================================
17
18
19 G_PKG_NAME CONSTANT VARCHAR2(30) := 'OZF_CLAIM_LINES_HIST_PKG';
20 G_FILE_NAME CONSTANT VARCHAR2(12) := 'ozftclhb.pls';
21
22 -- ========================================================
23 --
24 -- NAME
25 -- Insert_Row
26 --
27 -- PURPOSE
28 --
29 -- NOTES
30 --
31 -- HISTORY
32 --
33 -- ========================================================
34 PROCEDURE Insert_Row(
35 px_claim_line_history_id IN OUT NOCOPY NUMBER,
36 px_object_version_number IN OUT NOCOPY NUMBER,
37 p_last_update_date DATE,
38 p_last_updated_by NUMBER,
39 p_creation_date DATE,
40 p_created_by NUMBER,
41 p_last_update_login NUMBER,
42 p_request_id NUMBER,
43 p_program_application_id NUMBER,
44 p_program_update_date DATE,
45 p_program_id NUMBER,
46 p_created_from VARCHAR2,
47 p_claim_history_id NUMBER,
48 p_claim_id NUMBER,
49 p_claim_line_id NUMBER,
50 p_line_number NUMBER,
51 p_split_from_claim_line_id NUMBER,
52 p_amount NUMBER,
53 p_acctd_amount NUMBER,
54 p_currency_code VARCHAR2,
55 p_exchange_rate_type VARCHAR2,
56 p_exchange_rate_date DATE,
57 p_exchange_rate NUMBER,
58 p_set_of_books_id NUMBER,
59 p_valid_flag VARCHAR2,
60 p_source_object_id NUMBER,
61 p_source_object_class VARCHAR2,
62 p_source_object_type_id NUMBER,
63 p_source_object_line_id NUMBER,
64 p_plan_id NUMBER,
65 p_offer_id NUMBER,
66 p_payment_method VARCHAR2,
67 p_payment_reference_id NUMBER,
68 p_payment_reference_number VARCHAR2,
69 p_payment_reference_date DATE,
70 p_voucher_id NUMBER,
71 p_voucher_number VARCHAR2,
72 p_payment_status VARCHAR2,
73 p_approved_flag VARCHAR2,
74 p_approved_date DATE,
75 p_approved_by NUMBER,
76 p_settled_date DATE,
77 p_settled_by NUMBER,
78 p_performance_complete_flag VARCHAR2,
79 p_performance_attached_flag VARCHAR2,
80 p_attribute_category VARCHAR2,
81 p_attribute1 VARCHAR2,
82 p_attribute2 VARCHAR2,
83 p_attribute3 VARCHAR2,
84 p_attribute4 VARCHAR2,
85 p_attribute5 VARCHAR2,
86 p_attribute6 VARCHAR2,
87 p_attribute7 VARCHAR2,
88 p_attribute8 VARCHAR2,
89 p_attribute9 VARCHAR2,
90 p_attribute10 VARCHAR2,
91 p_attribute11 VARCHAR2,
92 p_attribute12 VARCHAR2,
93 p_attribute13 VARCHAR2,
94 p_attribute14 VARCHAR2,
95 p_attribute15 VARCHAR2,
96 px_org_id IN OUT NOCOPY NUMBER,
97 p_utilization_id NUMBER,
98 p_claim_currency_amount NUMBER,
99 p_item_id NUMBER,
100 p_item_description VARCHAR2,
101 p_quantity NUMBER,
102 p_quantity_uom VARCHAR2,
103 p_rate NUMBER,
104 p_activity_type VARCHAR2,
105 p_activity_id NUMBER,
106 p_earnings_associated_flag VARCHAR2,
107 p_comments VARCHAR2,
108 p_related_cust_account_id NUMBER,
109 p_relationship_type VARCHAR2,
110 p_tax_code VARCHAR2,
111 p_select_cust_children_flag VARCHAR2,
112 p_buy_group_cust_account_id NUMBER,
113 p_credit_to VARCHAR2,
114 p_sale_date DATE,
115 p_item_type VARCHAR2,
116 p_tax_amount NUMBER,
117 p_claim_curr_tax_amount NUMBER,
118 p_activity_line_id NUMBER,
119 p_offer_type VARCHAR2,
120 p_prorate_earnings_flag VARCHAR2,
121 p_earnings_end_date DATE
122 )
123 IS
124 x_rowid VARCHAR2(30);
125
126 BEGIN
127
128 IF (px_org_id IS NULL OR px_org_id = FND_API.G_MISS_NUM) THEN
129 px_org_id := MO_GLOBAL.GET_CURRENT_ORG_ID();
130 END IF;
131
132 px_object_version_number := 1;
133
134 INSERT INTO OZF_CLAIM_LINES_HIST_ALL(
135 claim_line_history_id,
136 object_version_number,
137 last_update_date,
138 last_updated_by,
139 creation_date,
140 created_by,
141 last_update_login,
142 request_id,
143 program_application_id,
144 program_update_date,
145 program_id,
146 created_from,
147 claim_history_id,
148 claim_id,
149 claim_line_id,
150 line_number,
151 split_from_claim_line_id,
152 amount,
153 acctd_amount,
154 currency_code,
155 exchange_rate_type,
156 exchange_rate_date,
157 exchange_rate,
158 set_of_books_id,
159 valid_flag,
160 source_object_id,
161 source_object_class,
162 source_object_type_id,
163 source_object_line_id,
164 plan_id,
165 offer_id,
166 payment_method,
167 payment_reference_id,
168 payment_reference_number,
169 payment_reference_date,
170 voucher_id,
171 voucher_number,
172 payment_status,
173 approved_flag,
174 approved_date,
175 approved_by,
176 settled_date,
177 settled_by,
178 performance_complete_flag,
179 performance_attached_flag,
180 attribute_category,
181 attribute1,
182 attribute2,
183 attribute3,
184 attribute4,
185 attribute5,
186 attribute6,
187 attribute7,
188 attribute8,
189 attribute9,
190 attribute10,
191 attribute11,
192 attribute12,
193 attribute13,
194 attribute14,
195 attribute15,
196 org_id,
197 utilization_id,
198 claim_currency_amount,
199 item_id,
200 item_description,
201 quantity,
202 quantity_uom,
203 rate,
204 activity_type,
205 activity_id,
206 earnings_associated_flag,
207 comments,
208 related_cust_account_id,
209 relationship_type,
210 tax_code,
211 select_cust_children_flag,
212 buy_group_cust_account_id,
213 credit_to,
214 sale_date,
215 item_type,
216 tax_amount,
217 claim_curr_tax_amount,
218 activity_line_id,
219 offer_type,
220 prorate_earnings_flag,
221 earnings_end_date
222
223 ) VALUES (
224 px_claim_line_history_id,
225 px_object_version_number,
226 p_last_update_date,
227 p_last_updated_by,
228 p_creation_date,
229 p_created_by,
230 p_last_update_login,
231 p_request_id,
232 p_program_application_id,
233 p_program_update_date,
234 p_program_id,
235 p_created_from,
236 p_claim_history_id,
237 p_claim_id,
238 p_claim_line_id,
239 p_line_number,
240 p_split_from_claim_line_id,
241 p_amount,
242 p_acctd_amount,
243 p_currency_code,
244 p_exchange_rate_type,
245 p_exchange_rate_date,
246 p_exchange_rate,
247 p_set_of_books_id,
248 p_valid_flag,
249 p_source_object_id,
250 p_source_object_class,
251 p_source_object_type_id,
252 p_source_object_line_id,
253 p_plan_id,
254 p_offer_id,
255 p_payment_method,
256 p_payment_reference_id,
257 p_payment_reference_number,
258 p_payment_reference_date,
259 p_voucher_id,
260 p_voucher_number,
261 p_payment_status,
262 p_approved_flag,
263 p_approved_date,
264 p_approved_by,
265 p_settled_date,
266 p_settled_by,
267 p_performance_complete_flag,
268 p_performance_attached_flag,
269 p_attribute_category,
270 p_attribute1,
271 p_attribute2,
272 p_attribute3,
273 p_attribute4,
274 p_attribute5,
275 p_attribute6,
276 p_attribute7,
277 p_attribute8,
278 p_attribute9,
279 p_attribute10,
280 p_attribute11,
281 p_attribute12,
282 p_attribute13,
283 p_attribute14,
284 p_attribute15,
285 px_org_id,
286 p_utilization_id,
287 p_claim_currency_amount,
288 p_item_id,
289 p_item_description,
290 p_quantity,
291 p_quantity_uom,
292 p_rate,
293 p_activity_type,
294 p_activity_id,
295 p_earnings_associated_flag,
296 p_comments,
297 p_related_cust_account_id,
298 p_relationship_type,
299 p_tax_code,
300 p_select_cust_children_flag,
301 p_buy_group_cust_account_id,
302 p_credit_to,
303 p_sale_date,
304 p_item_type,
305 p_tax_amount,
306 p_claim_curr_tax_amount,
307 p_activity_line_id,
308 p_offer_type,
309 p_prorate_earnings_flag,
310 p_earnings_end_date
311 );
312 END Insert_Row;
313
314
315 -- ========================================================
316 --
317 -- NAME
318 -- Update_Row
319 --
320 -- PURPOSE
321 --
322 -- NOTES
323 --
324 -- HISTORY
325 --
326 -- ========================================================
327 PROCEDURE Update_Row(
328 p_claim_line_history_id NUMBER,
329 p_object_version_number NUMBER,
330 p_last_update_date DATE,
331 p_last_updated_by NUMBER,
332 p_last_update_login NUMBER,
333 p_request_id NUMBER,
334 p_program_application_id NUMBER,
335 p_program_update_date DATE,
336 p_program_id NUMBER,
337 p_created_from VARCHAR2,
338 p_claim_history_id NUMBER,
339 p_claim_id NUMBER,
340 p_claim_line_id NUMBER,
341 p_line_number NUMBER,
342 p_split_from_claim_line_id NUMBER,
343 p_amount NUMBER,
344 p_acctd_amount NUMBER,
345 p_currency_code VARCHAR2,
346 p_exchange_rate_type VARCHAR2,
347 p_exchange_rate_date DATE,
348 p_exchange_rate NUMBER,
349 p_set_of_books_id NUMBER,
350 p_valid_flag VARCHAR2,
351 p_source_object_id NUMBER,
352 p_source_object_class VARCHAR2,
353 p_source_object_type_id NUMBER,
354 p_source_object_line_id NUMBER,
355 p_plan_id NUMBER,
356 p_offer_id NUMBER,
357 p_payment_method VARCHAR2,
358 p_payment_reference_id NUMBER,
359 p_payment_reference_number VARCHAR2,
360 p_payment_reference_date DATE,
361 p_voucher_id NUMBER,
362 p_voucher_number VARCHAR2,
363 p_payment_status VARCHAR2,
364 p_approved_flag VARCHAR2,
365 p_approved_date DATE,
366 p_approved_by NUMBER,
367 p_settled_date DATE,
368 p_settled_by NUMBER,
369 p_performance_complete_flag VARCHAR2,
370 p_performance_attached_flag VARCHAR2,
371 p_attribute_category VARCHAR2,
372 p_attribute1 VARCHAR2,
373 p_attribute2 VARCHAR2,
374 p_attribute3 VARCHAR2,
375 p_attribute4 VARCHAR2,
376 p_attribute5 VARCHAR2,
377 p_attribute6 VARCHAR2,
378 p_attribute7 VARCHAR2,
379 p_attribute8 VARCHAR2,
380 p_attribute9 VARCHAR2,
381 p_attribute10 VARCHAR2,
382 p_attribute11 VARCHAR2,
383 p_attribute12 VARCHAR2,
384 p_attribute13 VARCHAR2,
385 p_attribute14 VARCHAR2,
386 p_attribute15 VARCHAR2,
387 p_org_id NUMBER,
388 p_utilization_id NUMBER,
389 p_claim_currency_amount NUMBER,
390 p_item_id NUMBER,
391 p_item_description VARCHAR2,
392 p_quantity NUMBER,
393 p_quantity_uom VARCHAR2,
394 p_rate NUMBER,
398 p_comments VARCHAR2,
395 p_activity_type VARCHAR2,
396 p_activity_id NUMBER,
397 p_earnings_associated_flag VARCHAR2,
399 p_related_cust_account_id NUMBER,
400 p_relationship_type VARCHAR2,
401 p_tax_code VARCHAR2,
402 p_select_cust_children_flag VARCHAR2,
403 p_buy_group_cust_account_id NUMBER,
404 p_credit_to VARCHAR2,
405 p_sale_date DATE,
406 p_item_type VARCHAR2,
407 p_tax_amount NUMBER,
408 p_claim_curr_tax_amount NUMBER,
409 p_activity_line_id NUMBER,
410 p_offer_type VARCHAR2,
411 p_prorate_earnings_flag VARCHAR2,
412 p_earnings_end_date DATE
413 )
414 IS
415 BEGIN
416 UPDATE OZF_CLAIM_LINES_HIST_ALL
417 SET claim_line_history_id = p_claim_line_history_id,
418 object_version_number = p_object_version_number,
419 last_update_date = p_last_update_date,
420 last_updated_by = p_last_updated_by,
421 last_update_login = p_last_update_login,
422 request_id = p_request_id,
423 program_application_id = p_program_application_id,
424 program_update_date = p_program_update_date,
425 program_id = p_program_id,
426 created_from = p_created_from,
427 claim_history_id = p_claim_history_id,
428 claim_id = p_claim_id,
429 claim_line_id = p_claim_line_id,
430 line_number = p_line_number,
431 split_from_claim_line_id = p_split_from_claim_line_id,
432 amount = p_amount,
433 acctd_amount = p_acctd_amount,
434 currency_code = p_currency_code,
435 exchange_rate_type = p_exchange_rate_type,
436 exchange_rate_date = p_exchange_rate_date,
437 exchange_rate = p_exchange_rate,
438 set_of_books_id = p_set_of_books_id,
439 valid_flag = p_valid_flag,
440 source_object_id = p_source_object_id,
441 source_object_class = p_source_object_class,
442 source_object_type_id = p_source_object_type_id,
443 source_object_line_id = p_source_object_line_id,
444 plan_id = p_plan_id,
445 offer_id = p_offer_id,
446 payment_method = p_payment_method,
447 payment_reference_id = p_payment_reference_id,
448 payment_reference_number = p_payment_reference_number,
449 payment_reference_date = p_payment_reference_date,
450 voucher_id = p_voucher_id,
451 voucher_number = p_voucher_number,
452 payment_status = p_payment_status,
453 approved_flag = p_approved_flag,
454 approved_date = p_approved_date,
455 approved_by = p_approved_by,
456 settled_date = p_settled_date,
457 settled_by = p_settled_by,
458 performance_complete_flag = p_performance_complete_flag,
459 performance_attached_flag = p_performance_attached_flag,
460 attribute_category = p_attribute_category,
461 attribute1 = p_attribute1,
462 attribute2 = p_attribute2,
463 attribute3 = p_attribute3,
464 attribute4 = p_attribute4,
465 attribute5 = p_attribute5,
466 attribute6 = p_attribute6,
467 attribute7 = p_attribute7,
468 attribute8 = p_attribute8,
469 attribute9 = p_attribute9,
470 attribute10 = p_attribute10,
471 attribute11 = p_attribute11,
472 attribute12 = p_attribute12,
473 attribute13 = p_attribute13,
474 attribute14 = p_attribute14,
475 attribute15 = p_attribute15,
476 org_id = p_org_id,
477 utilization_id = p_utilization_id,
478 claim_currency_amount = p_claim_currency_amount,
479 item_id = p_item_id,
480 item_description = p_item_description,
481 quantity = p_quantity,
482 quantity_uom = p_quantity_uom,
483 rate = p_rate,
484 activity_type = p_activity_type,
485 activity_id = p_activity_id,
486 earnings_associated_flag = p_earnings_associated_flag,
487 comments = p_comments,
488 related_cust_account_id = p_related_cust_account_id,
489 relationship_type = p_relationship_type,
490 tax_code = p_tax_code,
491 select_cust_children_flag = p_select_cust_children_flag,
492 buy_group_cust_account_id = p_buy_group_cust_account_id,
493 credit_to = p_credit_to,
494 sale_date = p_sale_date,
495 item_type = p_item_type,
496 tax_amount = p_tax_amount,
497 claim_curr_tax_amount = p_claim_curr_tax_amount,
498 activity_line_id = p_activity_line_id,
499 offer_type = p_offer_type,
500 prorate_earnings_flag = p_prorate_earnings_flag,
501 earnings_end_date = p_earnings_end_date
502
503 WHERE CLAIM_LINE_HISTORY_ID = p_CLAIM_LINE_HISTORY_ID
507 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
504 AND object_version_number = p_object_version_number;
505
506 IF (SQL%NOTFOUND) THEN
508 END IF;
509 END Update_Row;
510
511
512 -- ========================================================
513 --
514 -- NAME
515 -- Delete_Row
516 --
517 -- PURPOSE
518 --
519 -- NOTES
520 --
521 -- HISTORY
522 --
523 -- ========================================================
524 PROCEDURE Delete_Row(
525 p_claim_line_history_id NUMBER
526 )
527 IS
528 BEGIN
529 DELETE FROM OZF_CLAIM_LINES_HIST_ALL
530 WHERE CLAIM_LINE_HISTORY_ID = p_CLAIM_LINE_HISTORY_ID;
531 If (SQL%NOTFOUND) then
532 RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
533 End If;
534 END Delete_Row ;
535
536
537 -- ========================================================
538 --
539 -- NAME
540 -- Lock_Row
541 --
542 -- PURPOSE
543 --
544 -- NOTES
545 --
546 -- HISTORY
547 --
548 -- ========================================================
549 PROCEDURE Lock_Row(
550 p_claim_line_history_id NUMBER,
551 p_object_version_number NUMBER,
552 p_last_update_date DATE,
553 p_last_updated_by NUMBER,
554 p_creation_date DATE,
555 p_created_by NUMBER,
556 p_last_update_login NUMBER,
557 p_request_id NUMBER,
558 p_program_application_id NUMBER,
559 p_program_update_date DATE,
560 p_program_id NUMBER,
561 p_created_from VARCHAR2,
562 p_claim_history_id NUMBER,
563 p_claim_id NUMBER,
564 p_claim_line_id NUMBER,
565 p_line_number NUMBER,
566 p_split_from_claim_line_id NUMBER,
567 p_amount NUMBER,
568 p_acctd_amount NUMBER,
569 p_currency_code VARCHAR2,
570 p_exchange_rate_type VARCHAR2,
571 p_exchange_rate_date DATE,
572 p_exchange_rate NUMBER,
573 p_set_of_books_id NUMBER,
574 p_valid_flag VARCHAR2,
575 p_source_object_id NUMBER,
576 p_source_object_class VARCHAR2,
577 p_source_object_type_id NUMBER,
578 p_source_object_line_id NUMBER,
579 p_plan_id NUMBER,
580 p_offer_id NUMBER,
581 p_payment_method VARCHAR2,
582 p_payment_reference_id NUMBER,
583 p_payment_reference_number VARCHAR2,
584 p_payment_reference_date DATE,
585 p_voucher_id NUMBER,
586 p_voucher_number VARCHAR2,
587 p_payment_status VARCHAR2,
588 p_approved_flag VARCHAR2,
589 p_approved_date DATE,
590 p_approved_by NUMBER,
591 p_settled_date DATE,
592 p_settled_by NUMBER,
593 p_performance_complete_flag VARCHAR2,
594 p_performance_attached_flag VARCHAR2,
595 p_attribute_category VARCHAR2,
596 p_attribute1 VARCHAR2,
597 p_attribute2 VARCHAR2,
598 p_attribute3 VARCHAR2,
599 p_attribute4 VARCHAR2,
600 p_attribute5 VARCHAR2,
601 p_attribute6 VARCHAR2,
602 p_attribute7 VARCHAR2,
603 p_attribute8 VARCHAR2,
604 p_attribute9 VARCHAR2,
605 p_attribute10 VARCHAR2,
606 p_attribute11 VARCHAR2,
607 p_attribute12 VARCHAR2,
608 p_attribute13 VARCHAR2,
609 p_attribute14 VARCHAR2,
610 p_attribute15 VARCHAR2,
611 p_org_id NUMBER,
612 p_utilization_id NUMBER,
613 p_claim_currency_amount NUMBER,
614 p_item_id NUMBER,
615 p_item_description VARCHAR2,
616 p_quantity NUMBER,
617 p_quantity_uom VARCHAR2,
618 p_rate NUMBER,
619 p_activity_type VARCHAR2,
620 p_activity_id NUMBER,
621 p_earnings_associated_flag VARCHAR2,
622 p_comments VARCHAR2,
623 p_related_cust_account_id NUMBER,
624 p_relationship_type VARCHAR2,
625 p_tax_code VARCHAR2,
626 p_select_cust_children_flag VARCHAR2,
627 p_buy_group_cust_account_id NUMBER,
628 p_credit_to VARCHAR2,
629 p_sale_date DATE,
630 p_item_type VARCHAR2,
634 p_offer_type VARCHAR2,
631 p_tax_amount NUMBER,
632 p_claim_curr_tax_amount NUMBER,
633 p_activity_line_id NUMBER,
635 p_prorate_earnings_flag VARCHAR2,
636 p_earnings_end_date DATE
637 )
638 IS
639 CURSOR C IS
640 SELECT *
641 FROM OZF_CLAIM_LINES_HIST_ALL
642 WHERE CLAIM_LINE_HISTORY_ID = p_CLAIM_LINE_HISTORY_ID
643 FOR UPDATE of CLAIM_LINE_HISTORY_ID NOWAIT;
644 Recinfo C%ROWTYPE;
645 BEGIN
646 OPEN c;
647 FETCH c INTO Recinfo;
648 If (c%NOTFOUND) then
649 CLOSE c;
650 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
651 APP_EXCEPTION.RAISE_EXCEPTION;
652 END IF;
653 CLOSE C;
654 IF (
655 ( Recinfo.claim_line_history_id = p_claim_line_history_id)
656 AND ( ( Recinfo.object_version_number = p_object_version_number)
657 OR ( ( Recinfo.object_version_number IS NULL )
658 AND ( p_object_version_number IS NULL )))
659 AND ( ( Recinfo.last_update_date = p_last_update_date)
660 OR ( ( Recinfo.last_update_date IS NULL )
661 AND ( p_last_update_date IS NULL )))
662 AND ( ( Recinfo.last_updated_by = p_last_updated_by)
663 OR ( ( Recinfo.last_updated_by IS NULL )
664 AND ( p_last_updated_by IS NULL )))
665 AND ( ( Recinfo.creation_date = p_creation_date)
666 OR ( ( Recinfo.creation_date IS NULL )
667 AND ( p_creation_date IS NULL )))
668 AND ( ( Recinfo.created_by = p_created_by)
669 OR ( ( Recinfo.created_by IS NULL )
670 AND ( p_created_by IS NULL )))
671 AND ( ( Recinfo.last_update_login = p_last_update_login)
672 OR ( ( Recinfo.last_update_login IS NULL )
673 AND ( p_last_update_login IS NULL )))
674 AND ( ( Recinfo.request_id = p_request_id)
675 OR ( ( Recinfo.request_id IS NULL )
676 AND ( p_request_id IS NULL )))
677 AND ( ( Recinfo.program_application_id = p_program_application_id)
678 OR ( ( Recinfo.program_application_id IS NULL )
679 AND ( p_program_application_id IS NULL )))
680 AND ( ( Recinfo.program_update_date = p_program_update_date)
681 OR ( ( Recinfo.program_update_date IS NULL )
682 AND ( p_program_update_date IS NULL )))
683 AND ( ( Recinfo.program_id = p_program_id)
684 OR ( ( Recinfo.program_id IS NULL )
685 AND ( p_program_id IS NULL )))
686 AND ( ( Recinfo.created_from = p_created_from)
687 OR ( ( Recinfo.created_from IS NULL )
688 AND ( p_created_from IS NULL )))
689 AND ( ( Recinfo.claim_history_id = p_claim_history_id)
690 OR ( ( Recinfo.claim_history_id IS NULL )
691 AND ( p_claim_history_id IS NULL )))
692 AND ( ( Recinfo.claim_id = p_claim_id)
693 OR ( ( Recinfo.claim_id IS NULL )
694 AND ( p_claim_id IS NULL )))
695 AND ( ( Recinfo.claim_line_id = p_claim_line_id)
696 OR ( ( Recinfo.claim_line_id IS NULL )
697 AND ( p_claim_line_id IS NULL )))
698 AND ( ( Recinfo.line_number = p_line_number)
699 OR ( ( Recinfo.line_number IS NULL )
700 AND ( p_line_number IS NULL )))
701 AND ( ( Recinfo.split_from_claim_line_id = p_split_from_claim_line_id)
702 OR ( ( Recinfo.split_from_claim_line_id IS NULL )
703 AND ( p_split_from_claim_line_id IS NULL )))
704 AND ( ( Recinfo.amount = p_amount)
705 OR ( ( Recinfo.amount IS NULL )
706 AND ( p_amount IS NULL )))
707 AND ( ( Recinfo.acctd_amount = p_acctd_amount)
708 OR ( ( Recinfo.acctd_amount IS NULL )
709 AND ( p_acctd_amount IS NULL )))
710 AND ( ( Recinfo.currency_code = p_currency_code)
711 OR ( ( Recinfo.currency_code IS NULL )
712 AND ( p_currency_code IS NULL )))
713 AND ( ( Recinfo.exchange_rate_type = p_exchange_rate_type)
714 OR ( ( Recinfo.exchange_rate_type IS NULL )
715 AND ( p_exchange_rate_type IS NULL )))
716 AND ( ( Recinfo.exchange_rate_date = p_exchange_rate_date)
717 OR ( ( Recinfo.exchange_rate_date IS NULL )
718 AND ( p_exchange_rate_date IS NULL )))
719 AND ( ( Recinfo.exchange_rate = p_exchange_rate)
720 OR ( ( Recinfo.exchange_rate IS NULL )
721 AND ( p_exchange_rate IS NULL )))
722 AND ( ( Recinfo.set_of_books_id = p_set_of_books_id)
723 OR ( ( Recinfo.set_of_books_id IS NULL )
724 AND ( p_set_of_books_id IS NULL )))
725 AND ( ( Recinfo.valid_flag = p_valid_flag)
726 OR ( ( Recinfo.valid_flag IS NULL )
727 AND ( p_valid_flag IS NULL )))
728 AND ( ( Recinfo.source_object_id = p_source_object_id)
729 OR ( ( Recinfo.source_object_id IS NULL )
730 AND ( p_source_object_id IS NULL )))
731 AND ( ( Recinfo.source_object_class = p_source_object_class)
732 OR ( ( Recinfo.source_object_class IS NULL )
736 AND ( p_source_object_type_id IS NULL )))
733 AND ( p_source_object_class IS NULL )))
734 AND ( ( Recinfo.source_object_type_id = p_source_object_type_id)
735 OR ( ( Recinfo.source_object_type_id IS NULL )
737 AND ( ( Recinfo.source_object_line_id = p_source_object_line_id)
738 OR ( ( Recinfo.source_object_line_id IS NULL )
739 AND ( p_source_object_line_id IS NULL )))
740 AND ( ( Recinfo.plan_id = p_plan_id)
741 OR ( ( Recinfo.plan_id IS NULL )
742 AND ( p_plan_id IS NULL )))
743 AND ( ( Recinfo.offer_id = p_offer_id)
744 OR ( ( Recinfo.offer_id IS NULL )
745 AND ( p_offer_id IS NULL )))
746 AND ( ( Recinfo.payment_method = p_payment_method)
747 OR ( ( Recinfo.payment_method IS NULL )
748 AND ( p_payment_method IS NULL )))
749 AND ( ( Recinfo.payment_reference_id = p_payment_reference_id)
750 OR ( ( Recinfo.payment_reference_id IS NULL )
751 AND ( p_payment_reference_id IS NULL )))
752 AND ( ( Recinfo.payment_reference_number = p_payment_reference_number)
753 OR ( ( Recinfo.payment_reference_number IS NULL )
754 AND ( p_payment_reference_number IS NULL )))
755 AND ( ( Recinfo.payment_reference_date = p_payment_reference_date)
756 OR ( ( Recinfo.payment_reference_date IS NULL )
757 AND ( p_payment_reference_date IS NULL )))
758 AND ( ( Recinfo.voucher_id = p_voucher_id)
759 OR ( ( Recinfo.voucher_id IS NULL )
760 AND ( p_voucher_id IS NULL )))
761 AND ( ( Recinfo.voucher_number = p_voucher_number)
762 OR ( ( Recinfo.voucher_number IS NULL )
763 AND ( p_voucher_number IS NULL )))
764 AND ( ( Recinfo.payment_status = p_payment_status)
765 OR ( ( Recinfo.payment_status IS NULL )
766 AND ( p_payment_status IS NULL )))
767 AND ( ( Recinfo.approved_flag = p_approved_flag)
768 OR ( ( Recinfo.approved_flag IS NULL )
769 AND ( p_approved_flag IS NULL )))
770 AND ( ( Recinfo.approved_date = p_approved_date)
771 OR ( ( Recinfo.approved_date IS NULL )
772 AND ( p_approved_date IS NULL )))
773 AND ( ( Recinfo.approved_by = p_approved_by)
774 OR ( ( Recinfo.approved_by IS NULL )
775 AND ( p_approved_by IS NULL )))
776 AND ( ( Recinfo.settled_date = p_settled_date)
777 OR ( ( Recinfo.settled_date IS NULL )
778 AND ( p_settled_date IS NULL )))
779 AND ( ( Recinfo.settled_by = p_settled_by)
780 OR ( ( Recinfo.settled_by IS NULL )
781 AND ( p_settled_by IS NULL )))
782 AND ( ( Recinfo.performance_complete_flag = p_performance_complete_flag)
783 OR ( ( Recinfo.performance_complete_flag IS NULL )
784 AND ( p_performance_complete_flag IS NULL )))
785 AND ( ( Recinfo.performance_attached_flag = p_performance_attached_flag)
786 OR ( ( Recinfo.performance_attached_flag IS NULL )
787 AND ( p_performance_attached_flag IS NULL )))
788 AND ( ( Recinfo.attribute_category = p_attribute_category)
789 OR ( ( Recinfo.attribute_category IS NULL )
790 AND ( p_attribute_category IS NULL )))
791 AND ( ( Recinfo.attribute1 = p_attribute1)
792 OR ( ( Recinfo.attribute1 IS NULL )
793 AND ( p_attribute1 IS NULL )))
794 AND ( ( Recinfo.attribute2 = p_attribute2)
795 OR ( ( Recinfo.attribute2 IS NULL )
796 AND ( p_attribute2 IS NULL )))
797 AND ( ( Recinfo.attribute3 = p_attribute3)
798 OR ( ( Recinfo.attribute3 IS NULL )
799 AND ( p_attribute3 IS NULL )))
800 AND ( ( Recinfo.attribute4 = p_attribute4)
801 OR ( ( Recinfo.attribute4 IS NULL )
802 AND ( p_attribute4 IS NULL )))
803 AND ( ( Recinfo.attribute5 = p_attribute5)
804 OR ( ( Recinfo.attribute5 IS NULL )
805 AND ( p_attribute5 IS NULL )))
806 AND ( ( Recinfo.attribute6 = p_attribute6)
807 OR ( ( Recinfo.attribute6 IS NULL )
808 AND ( p_attribute6 IS NULL )))
809 AND ( ( Recinfo.attribute7 = p_attribute7)
810 OR ( ( Recinfo.attribute7 IS NULL )
811 AND ( p_attribute7 IS NULL )))
812 AND ( ( Recinfo.attribute8 = p_attribute8)
813 OR ( ( Recinfo.attribute8 IS NULL )
814 AND ( p_attribute8 IS NULL )))
815 AND ( ( Recinfo.attribute9 = p_attribute9)
816 OR ( ( Recinfo.attribute9 IS NULL )
817 AND ( p_attribute9 IS NULL )))
818 AND ( ( Recinfo.attribute10 = p_attribute10)
819 OR ( ( Recinfo.attribute10 IS NULL )
820 AND ( p_attribute10 IS NULL )))
821 AND ( ( Recinfo.attribute11 = p_attribute11)
822 OR ( ( Recinfo.attribute11 IS NULL )
823 AND ( p_attribute11 IS NULL )))
824 AND ( ( Recinfo.attribute12 = p_attribute12)
825 OR ( ( Recinfo.attribute12 IS NULL )
826 AND ( p_attribute12 IS NULL )))
827 AND ( ( Recinfo.attribute13 = p_attribute13)
828 OR ( ( Recinfo.attribute13 IS NULL )
829 AND ( p_attribute13 IS NULL )))
830 AND ( ( Recinfo.attribute14 = p_attribute14)
831 OR ( ( Recinfo.attribute14 IS NULL )
832 AND ( p_attribute14 IS NULL )))
833 AND ( ( Recinfo.attribute15 = p_attribute15)
834 OR ( ( Recinfo.attribute15 IS NULL )
835 AND ( p_attribute15 IS NULL )))
836 AND ( ( Recinfo.org_id = p_org_id)
837 OR ( ( Recinfo.org_id IS NULL )
838 AND ( p_org_id IS NULL )))
839 AND ( ( Recinfo.utilization_id = p_utilization_id)
840 OR ( ( Recinfo.utilization_id IS NULL )
841 AND ( p_utilization_id IS NULL )))
842 AND ( ( Recinfo.claim_currency_amount = p_claim_currency_amount)
843 OR ( ( Recinfo.claim_currency_amount IS NULL )
844 AND ( p_claim_currency_amount IS NULL )))
845 AND ( ( Recinfo.item_id = p_item_id)
846 OR ( ( Recinfo.item_id IS NULL )
847 AND ( p_item_id IS NULL )))
848 AND ( ( Recinfo.item_description = p_item_description)
849 OR ( ( Recinfo.item_description IS NULL )
850 AND ( p_item_description IS NULL )))
851 AND ( ( Recinfo.quantity = p_quantity)
852 OR ( ( Recinfo.quantity IS NULL )
853 AND ( p_quantity IS NULL )))
854 AND ( ( Recinfo.quantity_uom = p_quantity_uom)
855 OR ( ( Recinfo.quantity_uom IS NULL )
856 AND ( p_quantity_uom IS NULL )))
857 AND ( ( Recinfo.rate = p_rate)
858 OR ( ( Recinfo.rate IS NULL )
859 AND ( p_rate IS NULL )))
860 AND ( ( Recinfo.activity_type = p_activity_type)
861 OR ( ( Recinfo.activity_type IS NULL )
862 AND ( p_activity_type IS NULL )))
863 AND ( ( Recinfo.activity_id = p_activity_id)
864 OR ( ( Recinfo.activity_id IS NULL )
865 AND ( p_activity_id IS NULL )))
866 AND ( ( Recinfo.earnings_associated_flag = p_earnings_associated_flag)
867 OR ( ( Recinfo.earnings_associated_flag IS NULL )
868 AND ( p_earnings_associated_flag IS NULL )))
869 AND ( ( Recinfo.comments = p_comments)
870 OR ( ( Recinfo.comments IS NULL )
871 AND ( p_comments IS NULL )))
872 AND ( ( Recinfo.related_cust_account_id = p_related_cust_account_id)
873 OR ( ( Recinfo.related_cust_account_id IS NULL )
874 AND ( p_related_cust_account_id IS NULL )))
875 AND ( ( Recinfo.relationship_type = p_relationship_type)
876 OR ( ( Recinfo.relationship_type IS NULL )
877 AND ( p_relationship_type IS NULL )))
878 AND ( ( Recinfo.tax_code = p_tax_code)
879 OR ( ( Recinfo.tax_code IS NULL )
880 AND ( p_tax_code IS NULL )))
881 AND ( ( Recinfo.select_cust_children_flag = p_select_cust_children_flag)
882 OR ( ( Recinfo.select_cust_children_flag IS NULL )
883 AND ( p_select_cust_children_flag IS NULL )))
884 AND ( ( Recinfo.buy_group_cust_account_id = p_buy_group_cust_account_id)
885 OR ( ( Recinfo.buy_group_cust_account_id IS NULL )
886 AND ( p_buy_group_cust_account_id IS NULL )))
887 AND ( ( Recinfo.credit_to = p_credit_to)
888 OR ( ( Recinfo.credit_to IS NULL )
889 AND ( p_credit_to IS NULL )))
890 AND ( ( Recinfo.sale_date = p_sale_date)
891 OR ( ( Recinfo.sale_date IS NULL )
892 AND ( p_sale_date IS NULL )))
893 AND ( ( Recinfo.item_type = p_item_type)
894 OR ( ( Recinfo.item_type IS NULL )
895 AND ( p_item_type IS NULL )))
896 AND ( ( Recinfo.tax_amount = p_tax_amount)
897 OR ( ( Recinfo.tax_amount IS NULL )
898 AND ( p_tax_amount IS NULL )))
899 AND ( ( Recinfo.claim_curr_tax_amount = p_claim_curr_tax_amount)
900 OR ( ( Recinfo.claim_curr_tax_amount IS NULL )
901 AND ( p_claim_curr_tax_amount IS NULL )))
902 AND ( ( Recinfo.activity_line_id = p_activity_line_id)
903 OR ( ( Recinfo.activity_line_id IS NULL )
904 AND ( p_activity_line_id IS NULL )))
905 AND ( ( Recinfo.offer_type = p_offer_type)
906 OR ( ( Recinfo.offer_type IS NULL )
907 AND ( p_offer_type IS NULL )))
908 AND ( ( Recinfo.prorate_earnings_flag = p_prorate_earnings_flag)
909 OR ( ( Recinfo.prorate_earnings_flag IS NULL )
910 AND ( p_prorate_earnings_flag IS NULL )))
911 AND ( ( Recinfo.earnings_end_date = p_earnings_end_date)
912 OR ( ( Recinfo.earnings_end_date IS NULL )
913 AND ( p_earnings_end_date IS NULL )))
914
915 ) THEN
916 RETURN;
917 ELSE
918 FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_CHANGED');
919 APP_EXCEPTION.RAISE_EXCEPTION;
920 END IF;
921 END Lock_Row;
922
923 END OZF_CLAIM_LINES_HIST_PKG;