[Home] [Help]
PACKAGE: APPS.OZF_CLAIM_ACCRUAL_PVT
Source
1 PACKAGE OZF_CLAIM_ACCRUAL_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvcacs.pls 120.15.12020000.2 2012/07/10 09:07:49 ninarasi 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 utilization_id NUMBER, -- Added For Bug 8402328
77 autopay_check VARCHAR2(15), -- Added for Claims-Mulitcurrency ER
78 period_name VARCHAR2(15), -- Added for Bug 11793070
79 year_name VARCHAR2(15), -- Added for Bug 11793070
80 claim_id NUMBER, -- Specific for Association UI
81 created_from VARCHAR2(15) -- Specific for Association UI
82 );
83
84 --//Added for Claims-Mulitcurrency ER
85 TYPE currency_rec_type IS RECORD
86 (
87 functional_currency_code VARCHAR2(15),
88 offer_currency_code VARCHAR2(15),
89 universal_currency_code VARCHAR2(15),
90 claim_currency_code VARCHAR2(15),
91 transaction_currency_code VARCHAR2(15),
92 association_currency_code VARCHAR2(15)
93 );
94
95 TYPE offer_performance_rec_type IS RECORD
96 (
97 offer_id NUMBER,
98 offer_performance_id NUMBER,
99 product_attribute VARCHAR2(30),
100 product_attr_value VARCHAR2(240),
101 start_date DATE,
102 end_date DATE,
103 requirement_type VARCHAR2(30),
104 estimated_value NUMBER,
105 uom_code VARCHAR2(30)
106 );
107
108 TYPE offer_performance_tbl_type is TABLE OF offer_performance_rec_type
109 INDEX BY BINARY_INTEGER;
110
111 TYPE offer_earning_rec_type IS RECORD
112 (
113 offer_id NUMBER,
114 acctd_amount_over NUMBER
115 );
116
117 TYPE offer_earning_tbl_type is TABLE OF offer_earning_rec_type
118 INDEX BY BINARY_INTEGER;
119
120 ---------------------------------------------------------------------
121 -- PROCEDURE
122 -- Get_Utiz_Sql_Stmt
123 --
124 -- PARAMETERS
125 -- p_summary_view : Available values
126 -- 1. OZF_AUTOPAY_PVT -- 'AUTOPAY'
127 -- 2. OZF_CLAIM_LINE_PVT --'ACTIVITY', 'PRODUCT', 'SCHEDULE'
128 -- p_funds_util_flt :
129 -- p_cust_account_id : Only be used for OZF_AUTOPAY_PVT
130 -- x_utiz_sql_stmt : Return datatype is VARCHAR2(500)
131 --
132 -- NOTE
133 -- 1. This statement will be used for both OZF_AUTOPAY_PVT and OZF_CLAIM_LINE_PVT
134 -- to get funds_utilized SQL statement by giving in search criteria.
135 --
136 -- HISTORY
137 -- 25-JUN-2002 mchang Create.
138 ---------------------------------------------------------------------
139 PROCEDURE Get_Utiz_Sql_Stmt(
140 p_api_version IN NUMBER
141 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
142 ,p_commit IN VARCHAR2 := FND_API.g_false
143 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
144
145 ,x_return_status OUT NOCOPY VARCHAR2
146 ,x_msg_count OUT NOCOPY NUMBER
147 ,x_msg_data OUT NOCOPY VARCHAR2
148
149 ,p_summary_view IN VARCHAR2 := NULL
150 ,p_funds_util_flt IN funds_util_flt_type
151 ,px_currency_rec IN OUT NOCOPY currency_rec_type
152 ,p_cust_account_id IN NUMBER := NULL
153
154 ,x_utiz_sql_stmt OUT NOCOPY VARCHAR2
155 );
156
157
158
159
160
161
162
163
164 ---------------------------------------------------------------------
165 -- PROCEDURE
166 -- Update_Line_Util_Tbl
167 --
168 -- PURPOSE
169 -- Update multiple records of claim line utils.
170 --
171 -- PARAMETERS
172 -- p_line_util_tbl: the new records to be updated.
173 -- x_error_index: return the index number in table where error happened.
174 --
175 -- NOTES
176 ---------------------------------------------------------------------
177 PROCEDURE Update_Line_Util_Tbl(
178 p_api_version IN NUMBER
179 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
180 ,p_commit IN VARCHAR2 := FND_API.g_false
181 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
182
183 ,x_return_status OUT NOCOPY VARCHAR2
184 ,x_msg_data OUT NOCOPY VARCHAR2
185 ,x_msg_count OUT NOCOPY NUMBER
186
187 ,p_line_util_tbl IN line_util_tbl_type
188 ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
189
190 ,x_error_index OUT NOCOPY NUMBER
191 );
192
193
194
195
196 ---------------------------------------------------------------------
197 -- PROCEDURE
198 -- Delete_Line_Util_Tbl
199 --
200 -- PURPOSE
201 -- Delete multiple records of claim line utils.
202 --
203 -- PARAMETERS
204 -- p_line_util_tbl: the new records to be deleted
205 -- x_error_index: return the index number in table where error happened.
206 --
207 -- NOTES
208 ---------------------------------------------------------------------
209 PROCEDURE Delete_Line_Util_Tbl(
210 p_api_version IN NUMBER
211 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
212 ,p_commit IN VARCHAR2 := FND_API.g_false
213 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
214
215 ,x_return_status OUT NOCOPY VARCHAR2
216 ,x_msg_data OUT NOCOPY VARCHAR2
217 ,x_msg_count OUT NOCOPY NUMBER
218
219 ,p_line_util_tbl IN line_util_tbl_type
220 ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
221
222 ,x_error_index OUT NOCOPY NUMBER
223 );
224
225
226
227
228
229 ---------------------------------------------------------------------
230 -- PROCEDURE
231 -- Init_Line_Util_Rec
232 --
233 -- PURPOSE
234 -- Initialize all attributes to be FND_API.g_miss_char/num/date.
235 ---------------------------------------------------------------------
236 PROCEDURE Init_Line_Util_Rec(
237 x_line_util_rec OUT NOCOPY line_util_rec_type
238 );
239
240
241 ---------------------------------------------------------------------
242 -- PROCEDURE
243 -- Complete_Line_Util_Rec
244 --
245 -- PURPOSE
246 -- For update_line_util, some attributes may be passed in as
247 -- FND_API.g_miss_char/num/date if the user doesn't want to
248 -- update those attributes. This procedure will replace the
249 -- "g_miss" attributes with current database values.
250 --
251 -- PARAMETERS
252 -- p_line_util_rec: the record which may contain attributes as
253 -- FND_API.g_miss_char/num/date
254 -- x_complete_rec: the complete record after all "g_miss" items
255 -- have been replaced by current database values
256 ---------------------------------------------------------------------
257 PROCEDURE Complete_Line_Util_Rec(
258 p_line_util_rec IN line_util_rec_type
259 ,x_complete_rec OUT NOCOPY line_util_rec_type
260 );
261
262 ---------------------------------------------------------------------
263 -- PROCEDURE
264 -- Update_Group_Line_Util
265 --
266 -- PURPOSE
267 -- Create multiple records of line utils for Automatic Association.
268 --
269 -- PARAMETERS
270 --
271 -- NOTES
272 ---------------------------------------------------------------------
273 PROCEDURE Update_Group_Line_Util(
274 p_api_version IN NUMBER
275 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
276 ,p_commit IN VARCHAR2 := FND_API.g_false
277 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
278
279 ,x_return_status OUT NOCOPY VARCHAR2
280 ,x_msg_count OUT NOCOPY NUMBER
281 ,x_msg_data OUT NOCOPY VARCHAR2
282
283 ,p_summary_view IN VARCHAR2 := NULL
284 ,p_funds_util_flt IN funds_util_flt_type
285 ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
286 );
287
288
289 ---------------------------------------------------------------------
290 -- PROCEDURE
291 -- Delete_Group_Line_Util
292 --
293 -- PURPOSE
294 -- Delete multiple records of line utils for Automatic Association.
295 --
296 -- PARAMETERS
297 -- p_claim_line_id:
298 --
299 -- NOTES
300 ---------------------------------------------------------------------
301 PROCEDURE Delete_Group_Line_Util(
302 p_api_version IN NUMBER
303 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
304 ,p_commit IN VARCHAR2 := FND_API.g_false
305 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
306
307 ,x_return_status OUT NOCOPY VARCHAR2
308 ,x_msg_count OUT NOCOPY NUMBER
309 ,x_msg_data OUT NOCOPY VARCHAR2
310
311 ,p_funds_util_flt IN funds_util_flt_type
312 ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
313 );
314
315
316 ---------------------------------------------------------------------
317 -- PROCEDURE
318 -- Asso_Accruals_To_Claim
319 --
320 -- PURPOSE
321 -- Associate earnings to the given claim based on given filters.
322 --
323 -- PARAMETERS
324 -- p_claim_id:
325 -- p_funds_util_flt:
326 --
327 -- NOTES
328 ---------------------------------------------------------------------
329 PROCEDURE Asso_Accruals_To_Claim(
330 p_api_version IN NUMBER
331 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
332 ,p_commit IN VARCHAR2 := FND_API.g_false
333 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
334
335 ,x_return_status OUT NOCOPY VARCHAR2
336 ,x_msg_count OUT NOCOPY NUMBER
337 ,x_msg_data OUT NOCOPY VARCHAR2
338
339 ,p_claim_id IN NUMBER
340 ,p_funds_util_flt IN funds_util_flt_type
341 );
342
343
344 ---------------------------------------------------------------------
345 -- PROCEDURE
346 -- Asso_Accruals_To_Claim_Line
347 --
348 -- PURPOSE
349 -- Associate earnings to the given claim line based on line
350 -- properties
351 --
352 -- PARAMETERS
353 -- p_claim_line_id:
354 -- p_run_mode: Default NULL
355 --
356 -- NOTES
357 ---------------------------------------------------------------------
358 PROCEDURE Asso_Accruals_To_Claim_Line(
359 p_api_version IN NUMBER
360 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
361 ,p_commit IN VARCHAR2 := FND_API.g_false
362 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
363
364 ,x_return_status OUT NOCOPY VARCHAR2
365 ,x_msg_count OUT NOCOPY NUMBER
366 ,x_msg_data OUT NOCOPY VARCHAR2
367
368 ,p_claim_line_id IN NUMBER
369 ,p_run_mode IN VARCHAR2 DEFAULT NULL --added parameter run mode, default null Bug 13349711
370 );
371
372
376 --
373 ---------------------------------------------------------------------
374 -- PROCEDURE
375 -- Create_Claim_For_Accruals
377 -- PURPOSE
378 -- Create a claim and associate earnings based on search filters.
379 --
380 -- PARAMETERS
381 -- p_claim_rec: claim record
382 -- p_funds_util_flt: search filter for earnings
383 --
384 -- NOTES
385 ---------------------------------------------------------------------
386 PROCEDURE Create_Claim_For_Accruals(
387 p_api_version IN NUMBER
388 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
389 ,p_commit IN VARCHAR2 := FND_API.g_false
390 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
391
392 ,x_return_status OUT NOCOPY VARCHAR2
393 ,x_msg_count OUT NOCOPY NUMBER
394 ,x_msg_data OUT NOCOPY VARCHAR2
395
396 ,p_claim_rec IN ozf_claim_pvt.claim_rec_type
397 ,p_funds_util_flt IN ozf_claim_accrual_pvt.funds_util_flt_type
398
399 ,x_claim_id OUT NOCOPY NUMBER
400 );
401
402 -------------------------------------------------------------------------------
403 -- PROCEDURE
404 -- Create_Claim_Existing_Accruals
405 --
406 -- PURPOSE
407 -- This procedure creates a claim, associates the existing earnings with
408 -- claim lines.
409 --
410 -- PARAMETERS
411 -- p_claim_rec: Claim Record
412 -- p_funds_util_flt: Search Filter to find existing earnings
413 --
414 -- NOTES
415 --
416 -- HISTORY
417 -- 25-JAN-2010 muthsubr Created.
418 -- Bug# 8632964 fixed.
419 -------------------------------------------------------------------------------
420 PROCEDURE Create_Claim_Existing_Accruals(
421 p_api_version IN NUMBER
422 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
423 ,p_commit IN VARCHAR2 := FND_API.g_false
424 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
425 ,x_return_status OUT NOCOPY VARCHAR2
426 ,x_msg_count OUT NOCOPY NUMBER
427 ,x_msg_data OUT NOCOPY VARCHAR2
428 ,p_claim_rec IN ozf_claim_pvt.claim_rec_type
429 ,p_funds_util_flt IN ozf_claim_accrual_pvt.funds_util_flt_type
430 ,x_claim_id OUT NOCOPY NUMBER
431 );
432 ---------------------------------------------------------------------
433 -- PROCEDURE
434 -- Pay_Claim_For_Accruals
435 --
436 -- PURPOSE
437 -- Create a claim, associate earnings based on search filters, and
438 -- close the claim
439 --
440 -- PARAMETERS
441 -- p_claim_rec: claim record
442 -- p_funds_util_flt: search filter for earnings
443 -- p_accrual_flag: for the bug#8632964
444 -- NOTES
445 ---------------------------------------------------------------------
446 PROCEDURE Pay_Claim_For_Accruals(
447 p_api_version IN NUMBER
448 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
449 ,p_commit IN VARCHAR2 := FND_API.g_false
450 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
451 ,p_accrual_flag IN VARCHAR2 DEFAULT NULL
452
453 ,x_return_status OUT NOCOPY VARCHAR2
454 ,x_msg_count OUT NOCOPY NUMBER
455 ,x_msg_data OUT NOCOPY VARCHAR2
456
457 ,p_claim_rec IN ozf_claim_pvt.claim_rec_type
458 ,p_funds_util_flt IN ozf_claim_accrual_pvt.funds_util_flt_type
459
460 ,x_claim_id OUT NOCOPY NUMBER
461 );
462
463
464 ---------------------------------------------------------------------
465 -- PROCEDURE
466 -- Initiate_Batch_Payment
467 --
468 -- PURPOSE
469 -- Create claims and initiate payments for resale batches
470 --
471 -- PARAMETERS
472 -- p_resale_batch_id: resale batch id
473 --
474 -- NOTES
475 ---------------------------------------------------------------------
476 PROCEDURE Initiate_Batch_Payment(
477 p_api_version IN NUMBER
478 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
479 ,p_commit IN VARCHAR2 := FND_API.g_false
480 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
481
482 ,x_return_status OUT NOCOPY VARCHAR2
483 ,x_msg_count OUT NOCOPY NUMBER
484 ,x_msg_data OUT NOCOPY VARCHAR2
485
486 ,p_resale_batch_id IN NUMBER
487 );
488
489
490 ---------------------------------------------------------------------
491 -- PROCEDURE
492 -- Adjust_Fund_Utilization
493 --
494 -- PURPOSE
495 -- Create adjustment requests for over-utilized earnings and
496 -- update scan_unit_remaining in ozf_funds_utilized. Called
497 -- after claim is approved.
498 --
499 -- PARAMETERS
500 -- p_claim_id
501 --
502 -- NOTES
503 ---------------------------------------------------------------------
504 PROCEDURE Adjust_Fund_Utilization(
505 p_api_version IN NUMBER
506 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
507 ,p_commit IN VARCHAR2 := FND_API.g_false
508 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
509
510 ,x_return_status OUT NOCOPY VARCHAR2
511 ,x_msg_count OUT NOCOPY NUMBER
512 ,x_msg_data OUT NOCOPY VARCHAR2
513
514 ,p_claim_id IN NUMBER
515 ,p_mode IN VARCHAR2 := OZF_CLAIM_UTILITY_PVT.g_auto_mode
516
517 ,x_next_status OUT NOCOPY VARCHAR2
518 );
519
520
521 ---------------------------------------------------------------------
522 -- PROCEDURE
523 -- Check_Offer_Performance
524 --
525 -- PARAMETERS
529 -- HISTORY
526 -- p_cust_account_id : customer account id
527 -- p_offer_id : offer id
528 --
530 ---------------------------------------------------------------------
531 PROCEDURE Check_Offer_Performance(
532 p_cust_account_id IN NUMBER
533 ,p_offer_id IN NUMBER
534 ,p_resale_flag IN VARCHAR2
535 ,p_check_all_flag IN VARCHAR2
536
537 ,x_performance_flag OUT NOCOPY VARCHAR2
538 ,x_offer_perf_tbl OUT NOCOPY offer_performance_tbl_type
539 );
540
541 ---------------------------------------------------------------------
542 -- PROCEDURE
543 -- Check_Offer_Performance_Tbl
544 --
545 -- PURPOSE
546 -- For the associated earnings in the given claim, find the offer
547 -- performance requirements that the customer has not met.
548 --
549 -- PARAMETERS
550 -- p_claim_id : customer account id
551 --
552 -- HISTORY
553 ---------------------------------------------------------------------
554 PROCEDURE Check_Offer_Performance_Tbl(
555 p_claim_id IN NUMBER
556
557 ,x_offer_perf_tbl OUT NOCOPY offer_performance_tbl_type
558 );
559
560 ---------------------------------------------------------------------
561 -- PROCEDURE
562 -- Check_Offer_Earning_Tbl
563 --
564 -- PURPOSE
565 -- For the associated earnings in the given claim, find the offers
566 -- whose paid amount is greater than the available amount
567 --
568 -- PARAMETERS
569 -- p_claim_id : customer account id
570 --
571 -- HISTORY
572 ---------------------------------------------------------------------
573 PROCEDURE Check_Offer_Earning_Tbl(
574 p_claim_id IN NUMBER
575
576 ,x_offer_earn_tbl OUT NOCOPY offer_earning_tbl_type
577 );
578
579 ---------------------------------------------------------------------
580 -- FUNCTION
581 -- Perform_Approval_Required
582 --
583 -- PURPOSE
584 -- Returns TRUE if the claim requires performance approval.
585 --
586 -- PARAMETERS
587 -- p_claim_id
588 --
589 -- NOTES
590 ---------------------------------------------------------------------
591 FUNCTION Perform_Approval_Required(
592 p_claim_id IN NUMBER
593 ) RETURN VARCHAR2;
594
595
596 ---------------------------------------------------------------------
597 -- FUNCTION
598 -- Earnings_Approval_Required
599 --
600 -- PURPOSE
601 -- Returns TRUE if the claim requires earnings approval.
602 --
603 -- PARAMETERS
604 -- p_claim_id
605 --
606 -- NOTES
607 ---------------------------------------------------------------------
608 FUNCTION Earnings_Approval_Required(
609 p_claim_id IN NUMBER
610 ) RETURN VARCHAR2;
611
612 ---------------------------------------------------------------------
613 -- FUNCTION
614 -- Calculate_FXGL_Amount
615 --
616 -- PURPOSE
617 -- Returns FXGL amount of the claim line util
618 --
619 -- PARAMETERS
620 --
621 --
622 -- NOTES
623 ---------------------------------------------------------------------
624 FUNCTION Calculate_FXGL_Amount(
625 p_line_util_rec IN line_util_rec_type
626 ,p_currency_rec IN currency_rec_type
627 ) RETURN NUMBER;
628
629 ---------------------------------------------------------------------
630 -- PROCEDURE
631 -- Initiate_SD_Payment
632 -- R12.1 Enhancements
633 --
634 -- PURPOSE
635 -- R12.1 Enhancements
636 -- Ship & Debit Claim Creation
637 --
638 -- PARAMETERS
639 -- p_ship_debit_id : Ship & Debit Request/Batch Id
640 -- p_ship_debit_type : Request Type (SUPPLIER/INTERNAL)
641 -- p_claim_number : Only for SUPPLIER request type
642 --
643 -- HISTORY
644 -- 19-OCT-2007 psomyaju Created.
645 ---------------------------------------------------------------------
646
647 PROCEDURE Initiate_SD_Payment(
648 p_api_version IN NUMBER
649 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
650 ,p_commit IN VARCHAR2 := FND_API.g_false
651 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
652 ,x_return_status OUT NOCOPY VARCHAR2
653 ,x_msg_count OUT NOCOPY NUMBER
654 ,x_msg_data OUT NOCOPY VARCHAR2
655 ,p_ship_debit_id IN NUMBER
656 ,p_ship_debit_type IN VARCHAR2
657 ,x_claim_id OUT NOCOPY NUMBER
658 );
659
660 ---------------------------------------------------------------------
661 -- PROCEDURE
662 -- Get_Payment_Detail
663 --
664 -- PURPOSE
665 -- This procedure will return the payment method, vendor ID,vendor
666 -- site ID from customer trade profile
667 --
668 -- PARAMETERS
669 -- p_cust_account - Cust Account ID
670 -- x_payment_method - Payment Method
671 -- x_vendor_id - Vendor ID
672 -- x_vendor_site_id - Vendor Site ID
673 --
674 -- NOTES
675 -- HISTORY
676 -- 30-APR-2010 KPATRO Created for ER#9653312.
677 -- 5/05/2010 KPATRO Bug#9679436 : ISSUES FOUND IN RBS UPDATE
678 -- FLOW ER UNIT TESTING
679 ---------------------------------------------------------------------
680
681 PROCEDURE Get_Payment_Detail
682 (p_cust_account IN NUMBER,
683 p_billto_site_use_id IN NUMBER,
684 x_payment_method OUT NOCOPY VARCHAR2,
685 x_vendor_id OUT NOCOPY NUMBER,
686 x_vendor_site_id OUT NOCOPY NUMBER,
687 x_return_status OUT NOCOPY VARCHAR2
688 );
689
690 ---------------------------------------------------------------------
691 -- PROCEDURE
692 -- Accruals_Association
693 --
694 -- PURPOSE
695 -- Earning Association for the claim.
696 --
697 -- PARAMETERS
698 -- p_claim_id:
699 -- p_funds_util_flt:
700 -- p_summary_view:
701 --
702 -- NOTES
703 ---------------------------------------------------------------------
704 PROCEDURE Accruals_Association(
705 p_api_version IN NUMBER
706 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
707 ,p_commit IN VARCHAR2 := FND_API.g_false
708 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
709
710 ,x_return_status OUT NOCOPY VARCHAR2
711 ,x_msg_count OUT NOCOPY NUMBER
712 ,x_msg_data OUT NOCOPY VARCHAR2
713
714 ,p_claim_id IN NUMBER
715 ,p_funds_util_flt IN funds_util_flt_type
716 ,p_summary_view IN VARCHAR2
717 );
718
719
720 END OZF_Claim_Accrual_PVT;