[Home] [Help]
PACKAGE: APPS.OZF_CLAIM_ACCRUAL_PVT
Source
1 PACKAGE OZF_CLAIM_ACCRUAL_PVT AS
2 /* $Header: ozfvcacs.pls 120.6 2008/01/07 06:54:11 psomyaju ship $ */
3
4 TYPE line_util_rec_type IS RECORD
5 (
6 claim_line_util_id NUMBER,
7 object_version_number NUMBER,
8 last_update_date DATE,
9 last_updated_by NUMBER,
10 creation_date DATE,
11 created_by NUMBER,
12 last_update_login NUMBER,
13 claim_line_id NUMBER,
14 utilization_id NUMBER,
15 amount NUMBER,
16 currency_code VARCHAR2(15),
17 exchange_rate_type VARCHAR2(30),
18 exchange_rate_date DATE,
19 exchange_rate NUMBER,
20 acctd_amount NUMBER,
21 util_curr_amount NUMBER,
22 plan_curr_amount NUMBER,
23 scan_unit NUMBER,
24 activity_product_id NUMBER,
25 uom_code VARCHAR2(3),
26 quantity NUMBER,
27 org_id NUMBER,
28 univ_curr_amount NUMBER,
29 fxgl_acctd_amount NUMBER,
30 utilized_acctd_amount NUMBER,
31 update_from_tbl_flag VARCHAR2(1) := FND_API.g_false
32 );
33
34 TYPE line_util_tbl_type is TABLE OF line_util_rec_type
35 INDEX BY BINARY_INTEGER;
36
37 TYPE funds_util_flt_type IS RECORD
38 (
39 claim_line_id NUMBER,
40 fund_id NUMBER,
41 activity_type VARCHAR2(30),
42 activity_id NUMBER,
43 activity_product_id NUMBER,
44 schedule_id NUMBER,
45 offer_type VARCHAR2(30),
46 document_class VARCHAR2(15),
47 document_id NUMBER,
48 product_level_type VARCHAR2(30),
49 product_id NUMBER,
50 reference_type VARCHAR2(30),
51 reference_id NUMBER,
52 utilization_type VARCHAR2(30),
53 total_amount NUMBER,
54 old_total_amount NUMBER,
55 pay_over_all_flag BOOLEAN, -- Bugfix 5154157
56 total_units NUMBER,
57 old_total_units NUMBER,
58 quantity NUMBER,
59 uom_code VARCHAR2(3),
60 cust_account_id NUMBER,
61 relationship_type VARCHAR2(30),
62 related_cust_account_id NUMBER,
63 buy_group_cust_account_id NUMBER,
64 buy_group_party_id NUMBER,
65 select_cust_children_flag VARCHAR2(1) := 'N',
66 pay_to_customer VARCHAR2(30),
67 prorate_earnings_flag VARCHAR2(1),
68 adjustment_type_id NUMBER := null,
69 end_date DATE,
70 run_mode VARCHAR2(30),
71 check_sales_rep_flag VARCHAR2(1),
72 group_by_offer VARCHAR2(1),
73 offer_payment_method VARCHAR2(30), -- internal use; do not populate
74 utiz_currency_code VARCHAR2(15),
75 bill_to_site_use_id NUMBER
76 );
77
78 TYPE offer_performance_rec_type IS RECORD
79 (
80 offer_id NUMBER,
81 offer_performance_id NUMBER,
82 product_attribute VARCHAR2(30),
83 product_attr_value VARCHAR2(240),
84 start_date DATE,
85 end_date DATE,
86 requirement_type VARCHAR2(30),
87 estimated_value NUMBER,
88 uom_code VARCHAR2(30)
89 );
90
91 TYPE offer_performance_tbl_type is TABLE OF offer_performance_rec_type
92 INDEX BY BINARY_INTEGER;
93
94 TYPE offer_earning_rec_type IS RECORD
95 (
96 offer_id NUMBER,
97 acctd_amount_over NUMBER
98 );
99
100 TYPE offer_earning_tbl_type is TABLE OF offer_earning_rec_type
101 INDEX BY BINARY_INTEGER;
102
103 ---------------------------------------------------------------------
104 -- PROCEDURE
105 -- Get_Utiz_Sql_Stmt
106 --
107 -- PARAMETERS
108 -- p_summary_view : Available values
109 -- 1. OZF_AUTOPAY_PVT -- 'AUTOPAY'
110 -- 2. OZF_CLAIM_LINE_PVT --'ACTIVITY', 'PRODUCT', 'SCHEDULE'
111 -- p_funds_util_flt :
112 -- p_cust_account_id : Only be used for OZF_AUTOPAY_PVT
113 -- x_utiz_sql_stmt : Return datatype is VARCHAR2(500)
114 --
115 -- NOTE
116 -- 1. This statement will be used for both OZF_AUTOPAY_PVT and OZF_CLAIM_LINE_PVT
117 -- to get funds_utilized SQL statement by giving in search criteria.
118 --
119 -- HISTORY
120 -- 25-JUN-2002 mchang Create.
121 ---------------------------------------------------------------------
122 PROCEDURE Get_Utiz_Sql_Stmt(
123 p_api_version IN NUMBER
124 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
125 ,p_commit IN VARCHAR2 := FND_API.g_false
126 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
127
128 ,x_return_status OUT NOCOPY VARCHAR2
129 ,x_msg_count OUT NOCOPY NUMBER
130 ,x_msg_data OUT NOCOPY VARCHAR2
131
132 ,p_summary_view IN VARCHAR2 := NULL
133 ,p_funds_util_flt IN funds_util_flt_type
134 ,p_cust_account_id IN NUMBER := NULL
135
136 ,x_utiz_sql_stmt OUT NOCOPY VARCHAR2
137 );
138
139
140 ---------------------------------------------------------------------
141 -- PROCEDURE
142 -- Create_Line_Util_Tbl
143 --
144 -- PURPOSE
145 -- Create multiple records of claim line utils.
146 --
147 -- PARAMETERS
148 -- p_line_util_tbl: the new records to be inserted
149 -- x_error_index: return the index number in table where error happened.
150 --
151 -- NOTES
152 ---------------------------------------------------------------------
153 PROCEDURE Create_Line_Util_Tbl(
154 p_api_version IN NUMBER
155 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
156 ,p_commit IN VARCHAR2 := FND_API.g_false
157 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
158
159 ,x_return_status OUT NOCOPY VARCHAR2
160 ,x_msg_data OUT NOCOPY VARCHAR2
161 ,x_msg_count OUT NOCOPY NUMBER
162
163 ,p_line_util_tbl IN line_util_tbl_type
164 ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
165
166 ,x_error_index OUT NOCOPY NUMBER
167 );
168
169
170 ---------------------------------------------------------------------
171 -- PROCEDURE
172 -- Create_Line_Util
173 --
174 -- PURPOSE
175 -- Create a new record of claim line util.
176 --
177 -- PARAMETERS
178 -- p_line_util_rec: the new record to be inserted
179 -- x_line_util_id: return the claim_line_util_id of the new record.
180 --
181 -- NOTES
182 -- 1. object_version_number will be set to 1.
183 -- 2. If claim_line_util_id is passed in, the uniqueness will be checked.
184 -- Raise exception in case of duplicates.
185 -- 3. If claim_line_util_id is not passed in, generate a unique one from
186 -- the sequence.
187 -- 4. Please don't pass in any FND_API.g_miss_char/num/date for claim_line_util record.
188 ---------------------------------------------------------------------
189 PROCEDURE Create_Line_Util(
190 p_api_version IN NUMBER
191 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
192 ,p_commit IN VARCHAR2 := FND_API.g_false
193 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
194
195 ,x_return_status OUT NOCOPY VARCHAR2
196 ,x_msg_count OUT NOCOPY NUMBER
197 ,x_msg_data OUT NOCOPY VARCHAR2
198
199 ,p_line_util_rec IN line_util_rec_type
200 ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
201
202 ,x_line_util_id OUT NOCOPY NUMBER
203 );
204
205
206 ---------------------------------------------------------------------
207 -- PROCEDURE
208 -- Update_Line_Util_Tbl
209 --
210 -- PURPOSE
211 -- Update multiple records of claim line utils.
212 --
213 -- PARAMETERS
214 -- p_line_util_tbl: the new records to be updated.
215 -- x_error_index: return the index number in table where error happened.
216 --
217 -- NOTES
218 ---------------------------------------------------------------------
219 PROCEDURE Update_Line_Util_Tbl(
220 p_api_version IN NUMBER
221 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
222 ,p_commit IN VARCHAR2 := FND_API.g_false
223 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
224
225 ,x_return_status OUT NOCOPY VARCHAR2
226 ,x_msg_data OUT NOCOPY VARCHAR2
227 ,x_msg_count OUT NOCOPY NUMBER
228
229 ,p_line_util_tbl IN line_util_tbl_type
230 ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
231
232 ,x_error_index OUT NOCOPY NUMBER
233 );
234
235
236 ---------------------------------------------------------------------
237 -- PROCEDURE
238 -- Update_Line_Util
239 --
240 -- PURPOSE
241 -- Update a claim line util record.
242 --
243 -- PARAMETERS
244 -- p_line_util_rec: the record with new items.
245 --
246 -- NOTES
247 -- 1. Raise exception if the object_version_number doesn't match.
248 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
249 -- that column won't be updated.
250 ----------------------------------------------------------------------
251 PROCEDURE Update_Line_Util(
252 p_api_version IN NUMBER
253 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
254 ,p_commit IN VARCHAR2 := FND_API.g_false
255 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
256
257 ,x_return_status OUT NOCOPY VARCHAR2
258 ,x_msg_count OUT NOCOPY NUMBER
259 ,x_msg_data OUT NOCOPY VARCHAR2
260
261 ,p_line_util_rec IN line_util_rec_type
262 ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
263
264 ,x_object_version OUT NOCOPY NUMBER
265 );
266
267 ---------------------------------------------------------------------
268 -- PROCEDURE
269 -- Delete_Line_Util_Tbl
270 --
271 -- PURPOSE
272 -- Delete multiple records of claim line utils.
273 --
274 -- PARAMETERS
275 -- p_line_util_tbl: the new records to be deleted
276 -- x_error_index: return the index number in table where error happened.
277 --
278 -- NOTES
279 ---------------------------------------------------------------------
280 PROCEDURE Delete_Line_Util_Tbl(
281 p_api_version IN NUMBER
282 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
283 ,p_commit IN VARCHAR2 := FND_API.g_false
284 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
285
286 ,x_return_status OUT NOCOPY VARCHAR2
287 ,x_msg_data OUT NOCOPY VARCHAR2
288 ,x_msg_count OUT NOCOPY NUMBER
289
290 ,p_line_util_tbl IN line_util_tbl_type
291 ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
292
293 ,x_error_index OUT NOCOPY NUMBER
294 );
295
296
297 --------------------------------------------------------------------
298 -- PROCEDURE
299 -- Delete_Line_Util
300 --
301 -- PURPOSE
302 -- Delete a record of claim line util.
303 --
304 -- PARAMETERS
305 -- p_line_util_id: the claim_line_id
306 -- p_object_version: the object_version_number
307 --
308 -- NOTES
309 -- 1. Raise exception if the object_version_number doesn't match.
310 --------------------------------------------------------------------
311 PROCEDURE Delete_Line_Util(
312 p_api_version IN NUMBER
313 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
314 ,p_commit IN VARCHAR2 := FND_API.g_false
315
316 ,x_return_status OUT NOCOPY VARCHAR2
317 ,x_msg_count OUT NOCOPY NUMBER
318 ,x_msg_data OUT NOCOPY VARCHAR2
319
320 ,p_line_util_id IN NUMBER
321 ,p_object_version IN NUMBER
322 ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
323 );
324
325
326 ---------------------------------------------------------------------
327 -- PROCEDURE
328 -- Init_Line_Util_Rec
329 --
330 -- PURPOSE
331 -- Initialize all attributes to be FND_API.g_miss_char/num/date.
332 ---------------------------------------------------------------------
333 PROCEDURE Init_Line_Util_Rec(
334 x_line_util_rec OUT NOCOPY line_util_rec_type
335 );
336
337
338 ---------------------------------------------------------------------
339 -- PROCEDURE
340 -- Complete_Line_Util_Rec
341 --
342 -- PURPOSE
343 -- For update_line_util, some attributes may be passed in as
344 -- FND_API.g_miss_char/num/date if the user doesn't want to
345 -- update those attributes. This procedure will replace the
346 -- "g_miss" attributes with current database values.
347 --
348 -- PARAMETERS
349 -- p_line_util_rec: the record which may contain attributes as
350 -- FND_API.g_miss_char/num/date
351 -- x_complete_rec: the complete record after all "g_miss" items
352 -- have been replaced by current database values
353 ---------------------------------------------------------------------
354 PROCEDURE Complete_Line_Util_Rec(
355 p_line_util_rec IN line_util_rec_type
356 ,x_complete_rec OUT NOCOPY line_util_rec_type
357 );
358
359
360 ---------------------------------------------------------------------
361 -- PROCEDURE
362 -- Create_Group_Line_Util
363 --
364 -- PURPOSE
365 -- Create multiple records of line utils for Automatic Association.
366 --
367 -- PARAMETERS
368 -- p_fund_util_flt: the search criteria to select funds_utilized records.
369 --
370 -- NOTES
371 ---------------------------------------------------------------------
372 PROCEDURE Create_Group_Line_Util(
373 p_api_version IN NUMBER
374 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
375 ,p_commit IN VARCHAR2 := FND_API.g_false
376 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
377
378 ,x_return_status OUT NOCOPY VARCHAR2
379 ,x_msg_count OUT NOCOPY NUMBER
380 ,x_msg_data OUT NOCOPY VARCHAR2
381
382 ,p_fund_util_flt IN funds_util_flt_type
383 ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
384 );
385
386
387 ---------------------------------------------------------------------
388 -- PROCEDURE
389 -- Update_Group_Line_Util
390 --
391 -- PURPOSE
392 -- Create multiple records of line utils for Automatic Association.
393 --
394 -- PARAMETERS
395 --
396 -- NOTES
397 ---------------------------------------------------------------------
398 PROCEDURE Update_Group_Line_Util(
399 p_api_version IN NUMBER
400 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
401 ,p_commit IN VARCHAR2 := FND_API.g_false
402 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
403
404 ,x_return_status OUT NOCOPY VARCHAR2
405 ,x_msg_count OUT NOCOPY NUMBER
406 ,x_msg_data OUT NOCOPY VARCHAR2
407
408 ,p_summary_view IN VARCHAR2 := NULL
409 ,p_funds_util_flt IN funds_util_flt_type
413
410 ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
411 );
412
414 ---------------------------------------------------------------------
415 -- PROCEDURE
416 -- Delete_Group_Line_Util
417 --
418 -- PURPOSE
419 -- Delete multiple records of line utils for Automatic Association.
420 --
421 -- PARAMETERS
422 -- p_claim_line_id:
423 --
424 -- NOTES
425 ---------------------------------------------------------------------
426 PROCEDURE Delete_Group_Line_Util(
427 p_api_version IN NUMBER
428 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
429 ,p_commit IN VARCHAR2 := FND_API.g_false
430 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
431
432 ,x_return_status OUT NOCOPY VARCHAR2
433 ,x_msg_count OUT NOCOPY NUMBER
434 ,x_msg_data OUT NOCOPY VARCHAR2
435
436 ,p_funds_util_flt IN funds_util_flt_type
437 ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
438 );
439
440
441 ---------------------------------------------------------------------
442 -- PROCEDURE
443 -- Asso_Accruals_To_Claim
444 --
445 -- PURPOSE
446 -- Associate earnings to the given claim based on given filters.
447 --
448 -- PARAMETERS
449 -- p_claim_id:
450 -- p_funds_util_flt:
451 --
452 -- NOTES
453 ---------------------------------------------------------------------
454 PROCEDURE Asso_Accruals_To_Claim(
455 p_api_version IN NUMBER
456 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
457 ,p_commit IN VARCHAR2 := FND_API.g_false
458 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
459
460 ,x_return_status OUT NOCOPY VARCHAR2
461 ,x_msg_count OUT NOCOPY NUMBER
462 ,x_msg_data OUT NOCOPY VARCHAR2
463
464 ,p_claim_id IN NUMBER
465 ,p_funds_util_flt IN funds_util_flt_type
466 );
467
468
469 ---------------------------------------------------------------------
470 -- PROCEDURE
471 -- Asso_Accruals_To_Claim_Line
472 --
473 -- PURPOSE
474 -- Associate earnings to the given claim line based on line
475 -- properties
476 --
477 -- PARAMETERS
478 -- p_claim_line_id:
479 --
480 -- NOTES
481 ---------------------------------------------------------------------
482 PROCEDURE Asso_Accruals_To_Claim_Line(
483 p_api_version IN NUMBER
484 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
485 ,p_commit IN VARCHAR2 := FND_API.g_false
486 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
487
488 ,x_return_status OUT NOCOPY VARCHAR2
489 ,x_msg_count OUT NOCOPY NUMBER
490 ,x_msg_data OUT NOCOPY VARCHAR2
491
492 ,p_claim_line_id IN NUMBER
493 );
494
495
496 ---------------------------------------------------------------------
497 -- PROCEDURE
498 -- Create_Claim_For_Accruals
499 --
500 -- PURPOSE
501 -- Create a claim and associate earnings based on search filters.
502 --
503 -- PARAMETERS
504 -- p_claim_rec: claim record
505 -- p_funds_util_flt: search filter for earnings
506 --
507 -- NOTES
508 ---------------------------------------------------------------------
509 PROCEDURE Create_Claim_For_Accruals(
510 p_api_version IN NUMBER
511 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
512 ,p_commit IN VARCHAR2 := FND_API.g_false
513 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
514
515 ,x_return_status OUT NOCOPY VARCHAR2
516 ,x_msg_count OUT NOCOPY NUMBER
517 ,x_msg_data OUT NOCOPY VARCHAR2
518
519 ,p_claim_rec IN ozf_claim_pvt.claim_rec_type
520 ,p_funds_util_flt IN ozf_claim_accrual_pvt.funds_util_flt_type
521
522 ,x_claim_id OUT NOCOPY NUMBER
523 );
524
525
526 ---------------------------------------------------------------------
527 -- PROCEDURE
528 -- Pay_Claim_For_Accruals
529 --
530 -- PURPOSE
531 -- Create a claim, associate earnings based on search filters, and
532 -- close the claim
533 --
534 -- PARAMETERS
535 -- p_claim_rec: claim record
536 -- p_funds_util_flt: search filter for earnings
537 --
538 -- NOTES
539 ---------------------------------------------------------------------
540 PROCEDURE Pay_Claim_For_Accruals(
541 p_api_version IN NUMBER
542 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
543 ,p_commit IN VARCHAR2 := FND_API.g_false
544 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
545
546 ,x_return_status OUT NOCOPY VARCHAR2
547 ,x_msg_count OUT NOCOPY NUMBER
548 ,x_msg_data OUT NOCOPY VARCHAR2
549
550 ,p_claim_rec IN ozf_claim_pvt.claim_rec_type
551 ,p_funds_util_flt IN ozf_claim_accrual_pvt.funds_util_flt_type
552
553 ,x_claim_id OUT NOCOPY NUMBER
554 );
555
556
557 ---------------------------------------------------------------------
561 -- PURPOSE
558 -- PROCEDURE
559 -- Initiate_Batch_Payment
560 --
562 -- Create claims and initiate payments for resale batches
563 --
564 -- PARAMETERS
565 -- p_resale_batch_id: resale batch id
566 --
567 -- NOTES
568 ---------------------------------------------------------------------
569 PROCEDURE Initiate_Batch_Payment(
570 p_api_version IN NUMBER
571 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
572 ,p_commit IN VARCHAR2 := FND_API.g_false
573 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
574
575 ,x_return_status OUT NOCOPY VARCHAR2
576 ,x_msg_count OUT NOCOPY NUMBER
577 ,x_msg_data OUT NOCOPY VARCHAR2
578
579 ,p_resale_batch_id IN NUMBER
580 );
581
582
583 ---------------------------------------------------------------------
584 -- PROCEDURE
585 -- Adjust_Fund_Utilization
586 --
587 -- PURPOSE
588 -- Create adjustment requests for over-utilized earnings and
589 -- update scan_unit_remaining in ozf_funds_utilized. Called
590 -- after claim is approved.
591 --
592 -- PARAMETERS
593 -- p_claim_id
594 --
595 -- NOTES
596 ---------------------------------------------------------------------
597 PROCEDURE Adjust_Fund_Utilization(
598 p_api_version IN NUMBER
599 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
600 ,p_commit IN VARCHAR2 := FND_API.g_false
601 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
602
603 ,x_return_status OUT NOCOPY VARCHAR2
604 ,x_msg_count OUT NOCOPY NUMBER
605 ,x_msg_data OUT NOCOPY VARCHAR2
606
607 ,p_claim_id IN NUMBER
608 ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
609
610 ,x_next_status OUT NOCOPY VARCHAR2
611 );
612
613
614 ---------------------------------------------------------------------
615 -- PROCEDURE
616 -- Check_Offer_Performance
617 --
618 -- PARAMETERS
619 -- p_cust_account_id : customer account id
620 -- p_offer_id : offer id
621 --
622 -- HISTORY
623 ---------------------------------------------------------------------
624 PROCEDURE Check_Offer_Performance(
625 p_cust_account_id IN NUMBER
626 ,p_offer_id IN NUMBER
627 ,p_resale_flag IN VARCHAR2
628 ,p_check_all_flag IN VARCHAR2
629
630 ,x_performance_flag OUT NOCOPY VARCHAR2
631 ,x_offer_perf_tbl OUT NOCOPY offer_performance_tbl_type
632 );
633
634 ---------------------------------------------------------------------
635 -- PROCEDURE
636 -- Check_Offer_Performance_Tbl
637 --
638 -- PURPOSE
639 -- For the associated earnings in the given claim, find the offer
640 -- performance requirements that the customer has not met.
641 --
642 -- PARAMETERS
643 -- p_claim_id : customer account id
644 --
645 -- HISTORY
646 ---------------------------------------------------------------------
647 PROCEDURE Check_Offer_Performance_Tbl(
648 p_claim_id IN NUMBER
649
650 ,x_offer_perf_tbl OUT NOCOPY offer_performance_tbl_type
651 );
652
653 ---------------------------------------------------------------------
654 -- PROCEDURE
655 -- Check_Offer_Earning_Tbl
656 --
657 -- PURPOSE
658 -- For the associated earnings in the given claim, find the offers
659 -- whose paid amount is greater than the available amount
660 --
661 -- PARAMETERS
662 -- p_claim_id : customer account id
663 --
664 -- HISTORY
665 ---------------------------------------------------------------------
666 PROCEDURE Check_Offer_Earning_Tbl(
667 p_claim_id IN NUMBER
668
669 ,x_offer_earn_tbl OUT NOCOPY offer_earning_tbl_type
670 );
671
672 ---------------------------------------------------------------------
673 -- FUNCTION
674 -- Perform_Approval_Required
675 --
676 -- PURPOSE
677 -- Returns TRUE if the claim requires performance approval.
678 --
679 -- PARAMETERS
680 -- p_claim_id
681 --
682 -- NOTES
683 ---------------------------------------------------------------------
684 FUNCTION Perform_Approval_Required(
685 p_claim_id IN NUMBER
686 ) RETURN VARCHAR2;
687
688
692 --
689 ---------------------------------------------------------------------
690 -- FUNCTION
691 -- Earnings_Approval_Required
693 -- PURPOSE
694 -- Returns TRUE if the claim requires earnings approval.
695 --
696 -- PARAMETERS
697 -- p_claim_id
698 --
699 -- NOTES
700 ---------------------------------------------------------------------
701 FUNCTION Earnings_Approval_Required(
702 p_claim_id IN NUMBER
703 ) RETURN VARCHAR2;
704
705 ---------------------------------------------------------------------
706 -- FUNCTION
707 -- Calculate_FXGL_Amount
708 --
709 -- PURPOSE
710 -- Returns FXGL amount of the claim line util
711 --
712 -- PARAMETERS
713 --
714 --
715 -- NOTES
716 ---------------------------------------------------------------------
717 FUNCTION Calculate_FXGL_Amount(
718 p_line_util_rec IN line_util_rec_type
719 ) RETURN NUMBER;
720
721 ---------------------------------------------------------------------
722 -- PROCEDURE
723 -- Initiate_SD_Payment
724 -- R12.1 Enhancements
725 --
726 -- PURPOSE
727 -- R12.1 Enhancements
728 -- Ship & Debit Claim Creation
729 --
730 -- PARAMETERS
731 -- p_ship_debit_id : Ship & Debit Request/Batch Id
732 -- p_ship_debit_type : Request Type (SUPPLIER/INTERNAL)
733 -- p_claim_number : Only for SUPPLIER request type
734 --
735 -- HISTORY
736 -- 19-OCT-2007 psomyaju Created.
737 ---------------------------------------------------------------------
738
739 PROCEDURE Initiate_SD_Payment(
740 p_api_version IN NUMBER
741 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
742 ,p_commit IN VARCHAR2 := FND_API.g_false
743 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
744 ,x_return_status OUT NOCOPY VARCHAR2
745 ,x_msg_count OUT NOCOPY NUMBER
746 ,x_msg_data OUT NOCOPY VARCHAR2
747 ,p_ship_debit_id IN NUMBER
748 ,p_ship_debit_type IN VARCHAR2
749 ,x_claim_id OUT NOCOPY NUMBER
750 );
751
752 END OZF_Claim_Accrual_PVT;