1 PACKAGE Okl_Seeded_Functions_Pvt AS
2 /* $Header: OKLRSFFS.pls 120.28.12010000.4 2008/11/24 21:23:05 djanaswa ship $ */
3
4 ---------------------------------------------------------------------------
5 -- GLOBAL MESSAGE CONSTANTS
6 ---------------------------------------------------------------------------
7 G_FND_APP CONSTANT VARCHAR2(200) := Okl_Api.G_FND_APP;
8 G_FORM_UNABLE_TO_RESERVE_REC CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_UNABLE_TO_RESERVE_REC;
9 G_FORM_RECORD_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_DELETED;
10 G_FORM_RECORD_CHANGED CONSTANT VARCHAR2(200) := Okl_Api.G_FORM_RECORD_CHANGED;
11 G_RECORD_LOGICALLY_DELETED CONSTANT VARCHAR2(200) := Okl_Api.G_RECORD_LOGICALLY_DELETED;
12 G_REQUIRED_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_REQUIRED_VALUE;
13 G_INVALID_VALUE CONSTANT VARCHAR2(200) := Okl_Api.G_INVALID_VALUE;
14 G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_COL_NAME_TOKEN;
15 G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_PARENT_TABLE_TOKEN;
16 G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := Okl_Api.G_CHILD_TABLE_TOKEN;
17 G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXPECTED_ERROR';
18 G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLerrm';
19 G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'OKL_SQLcode';
20 G_UPPERCASE_REQUIRED CONSTANT VARCHAR2(200) := 'OKL_UPPER_CASE_REQUIRED';
21 G_ONE_DOI CONSTANT VARCHAR2(200) := 'OKL_ONE_DOI';
22 G_INVALID_CONTRACT_LINE CONSTANT VARCHAR2(200) := 'OKL_INVALID_CONTRACT_LINE';
23 G_PURPOSE_TOKEN CONSTANT VARCHAR2(200) := 'PURPOSE'; --bug 4024785
24
25 ---------------------------------------------------------------------------
26 -- GLOBAL VARIABLES
27 ---------------------------------------------------------------------------
28 G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_FORMULAFUNCTION_PVT';
29 G_APP_NAME CONSTANT VARCHAR2(3) := Okl_Api.G_APP_NAME;
30
31
32 ---------------------------------------------------------------------------
33 -- GLOBAL EXCEPTION
34 ---------------------------------------------------------------------------
35 G_EXCEPTION_HALT_VALIDATION EXCEPTION;
36
37 ---------------------------------------------------------------------------
38 -- Procedures and Functions
39 ---------------------------------------------------------------------------
40 FUNCTION contract_sum_of_rents(
41
42 p_chr_id IN NUMBER,
43 p_line_id IN NUMBER) RETURN NUMBER;
44
45 FUNCTION contract_income(
46 p_chr_id IN NUMBER,
47 p_line_id IN NUMBER) RETURN NUMBER;
48
49
50
51 FUNCTION line_residual_value(
52 p_chr_id IN NUMBER,
53 p_line_id IN NUMBER) RETURN NUMBER;
54
55 FUNCTION contract_residual_value(
56 p_chr_id IN NUMBER,
57 p_line_id IN NUMBER) RETURN NUMBER;
58
59 FUNCTION contract_oec(
60 p_chr_id IN NUMBER,
61 p_line_id IN NUMBER) RETURN NUMBER;
62
63 FUNCTION line_oec(
64 p_dnz_chr_id IN OKC_K_LINES_V.DNZ_CHR_ID%TYPE,
65 p_cle_id IN OKC_K_LINES_V.CLE_ID%TYPE DEFAULT Okl_Api.G_MISS_NUM) RETURN NUMBER;
66
67 FUNCTION contract_tradein(
68 p_chr_id IN NUMBER,
69 p_line_id IN NUMBER) RETURN NUMBER;
70
71 FUNCTION line_tradein(
72 p_chr_id IN NUMBER,
73 p_line_id IN NUMBER) RETURN NUMBER;
74
75 FUNCTION contract_capital_reduction(
76 p_chr_id IN NUMBER,
77 p_line_id IN NUMBER) RETURN NUMBER;
78
79 FUNCTION line_capital_reduction(
80 p_chr_id IN NUMBER,
81 p_line_id IN NUMBER) RETURN NUMBER;
82
83 FUNCTION line_fees_capitalized(
84 p_chr_id IN NUMBER,
85 p_line_id IN NUMBER) RETURN NUMBER;
86
87 FUNCTION contract_fees_capitalized(
88 p_chr_id IN NUMBER,
89 p_line_id IN NUMBER) RETURN NUMBER;
90
91 FUNCTION line_service_capitalized(
92 p_chr_id IN NUMBER,
93 p_line_id IN NUMBER) RETURN NUMBER;
94
95
96 FUNCTION investor_account_amount(
97 p_chr_id IN NUMBER,
98 p_line_id IN NUMBER) RETURN NUMBER;
99
100 FUNCTION contract_capitalized_interest(
101 p_chr_id IN NUMBER,
102 p_line_id IN NUMBER) RETURN NUMBER;
103
104 FUNCTION line_capitalized_interest(
105 p_chr_id IN NUMBER,
106 p_line_id IN NUMBER) RETURN NUMBER;
107 ---------------------------------------------------------
108 --Bug# 3143522 avsingh: 11.5.10 Subsidies
109 --------------------------------------------------------
110 --1.function to return line discount (asset level subsidies with accounting method 'NET')
111 FUNCTION line_discount(
112 p_chr_id IN NUMBER,
113 p_line_id IN NUMBER) RETURN NUMBER;
114
115 --2.function to return contract discount (sum of all contract subsidies with method = 'NET')
116 FUNCTION contract_discount(
117 p_chr_id IN NUMBER,
118 p_line_id IN NUMBER) RETURN NUMBER;
119
120 ---------------------------------------------------------
121 --End Bug# 3143522 avsingh: 11.5.10 Subsidies
122 ---------------------------------------------------------
123 -----------------------------------------------------------------------
124 --Start Bug# 3036581 : avsingh new formula CONTRACT_AMORTIZED_EXPENSES
125 -----------------------------------------------------------------------
126 ----------------------------------------------------------------------------------------------------
127
128 -- Start of Comments
129 -- Created By: avsingh
130 -- Function Name contract_amortized_expenses
131 -- Description: returns the sum of amount on stream type - Amortized Expense.
132 -- Dependencies:
133 -- Parameters: contract id.
134 -- Version: 1.0
135 -- End of Commnets
136
137 ----------------------------------------------------------------------------------------------------
138 FUNCTION contract_amortized_expenses(
139 p_chr_id IN NUMBER,
140 p_line_id IN NUMBER) RETURN NUMBER;
141 ------------------------------------------------------------------
142 -----------------------------------------------------------------------
143 --End Bug# 3036581 : avsingh new formula CONTRACT_AMORTIZED_EXPENSES
144 -----------------------------------------------------------------------
145 FUNCTION contract_amount_prefunded(
146 p_contract_id IN NUMBER
147 ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
148 ) RETURN NUMBER;
149 PRAGMA RESTRICT_REFERENCES (contract_amount_prefunded, TRUST);
150
151 FUNCTION contract_total_funded(
152 p_contract_id IN NUMBER
153 ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
154 ) RETURN NUMBER;
155 PRAGMA RESTRICT_REFERENCES (contract_total_funded, TRUST);
156
157 FUNCTION contract_total_debits(
158 p_contract_id IN NUMBER
159 ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
160 ) RETURN NUMBER;
161 PRAGMA RESTRICT_REFERENCES (contract_total_debits, TRUST);
162
163 FUNCTION contract_total_adjustments(
164 p_contract_id IN NUMBER
165 ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
166 ) RETURN NUMBER;
167 PRAGMA RESTRICT_REFERENCES (contract_total_adjustments, TRUST);
168
169 ------------------------------------------------------------------
170 FUNCTION creditline_total_limit(
171 p_contract_id IN NUMBER
172 ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
173 ) RETURN NUMBER;
174 PRAGMA RESTRICT_REFERENCES (creditline_total_limit, TRUST);
175
176 FUNCTION creditline_total_remaining(
177 p_contract_id IN NUMBER
178 ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
179 ) RETURN NUMBER;
180 PRAGMA RESTRICT_REFERENCES (creditline_total_remaining, TRUST);
181
182 FUNCTION creditline_total_new_limit(
183 p_contract_id IN NUMBER
184 ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
185 ) RETURN NUMBER;
186 PRAGMA RESTRICT_REFERENCES (creditline_total_new_limit, TRUST);
187
188 FUNCTION creditline_total_addition(
189 p_contract_id IN NUMBER
190 ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
191 ) RETURN NUMBER;
192 PRAGMA RESTRICT_REFERENCES (creditline_total_addition, TRUST);
193
194 FUNCTION creditline_total_reduction(
195 p_contract_id IN NUMBER
196 ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
197 ) RETURN NUMBER;
198 PRAGMA RESTRICT_REFERENCES (creditline_total_reduction, TRUST);
199
200 -- Commented out - no owner identified.
201
202 /* FUNCTION line_capitalcost(
203 p_chr_id IN NUMBER,
204 p_line_id IN NUMBER,
205 p_capred IN NUMBER,
206 p_capred_per IN NUMBER,
207 p_trd_amnt IN NUMBER) RETURN NUMBER; */
208
209 -------------------------------------------------------------------------
210
211 ---------------------------------------------
212 -- Accrual and LP Functions
213 ---------------------------------------------
214
215
216 FUNCTION CONTRACT_DAYS_TO_ACCRUE(p_khr_id IN NUMBER
217 ,p_kle_id IN NUMBER) RETURN NUMBER ;
218
219 FUNCTION CONTRACT_DAYS_IN_YEAR(p_khr_id IN NUMBER
220 ,p_kle_id IN NUMBER) RETURN NUMBER;
221
222 FUNCTION CONTRACT_INTEREST_RATE(p_khr_id IN NUMBER
223 ,p_kle_id IN NUMBER) RETURN NUMBER;
224
225 FUNCTION CONTRACT_PRINCIPAL_BALANCE(p_khr_id IN NUMBER
226 ,p_kle_id IN NUMBER) RETURN NUMBER;
227
228 FUNCTION CONTRACT_UNBILLED_RECEIVABLES(p_khr_id IN NUMBER
229 ,p_kle_id IN NUMBER) RETURN NUMBER;
230
231 FUNCTION CONTRACT_UNEARNED_REVENUE(p_khr_id IN NUMBER
232 ,p_kle_id IN NUMBER) RETURN NUMBER;
233
234 FUNCTION CONTRACT_UNGUARANTEED_RESIDUAL(p_khr_id IN NUMBER
235 ,p_kle_id IN NUMBER) RETURN NUMBER;
236
237 FUNCTION CONTRACT_UNACCRUED_SUBSIDY(p_khr_id IN NUMBER
238 ,p_kle_id IN NUMBER) RETURN NUMBER;
239
240 FUNCTION CONTRACT_TOTAL_ACTUAL_INT(p_khr_id IN NUMBER
241 ,p_kle_id IN NUMBER) RETURN NUMBER;
242
243 FUNCTION CONTRACT_TOTAL_ACCRUED_INT(p_khr_id IN NUMBER
244 ,p_kle_id IN NUMBER) RETURN NUMBER;
245
246 ---------------------------------------------
247 -- AM Functions
248 ---------------------------------------------
249
250 -- MDOKAL 22-Oct-03 Financed Fee's Functions (Bug 3061765)
251 FUNCTION contract_fee_amount (
252 p_contract_id IN NUMBER,
253 p_contract_line_id IN NUMBER)
254 RETURN NUMBER;
255
256 -- MDOKAL 28-SEP-03 Securitization Functions (Bug 302639)
257 FUNCTION investor_rv_factor (
258 p_contract_id IN NUMBER,
259 p_contract_line_id IN NUMBER)
260 RETURN NUMBER;
261
262 -- MDOKAL 28-SEP-03 Securitization Functions (Bug 302639)
263 FUNCTION investor_rent_factor (
264 p_contract_id IN NUMBER,
265 p_contract_line_id IN NUMBER)
266 RETURN NUMBER;
267
268
269 FUNCTION line_estimated_property_tax (
270 p_contract_id IN NUMBER,
271 p_contract_line_id IN NUMBER)
272 RETURN NUMBER;
273
274 FUNCTION contract_remaining_sec_dep (
275 p_contract_id IN NUMBER,
276 p_contract_line_id IN NUMBER)
277 RETURN NUMBER;
278
279 FUNCTION contract_estimate_tax (
280 p_contract_id IN NUMBER,
281 p_contract_line_id IN NUMBER)
282 RETURN NUMBER;
283
284 FUNCTION line_estimate_tax (
285 p_contract_id IN NUMBER,
286 p_contract_line_id IN NUMBER)
287 RETURN NUMBER;
288
289 FUNCTION line_unbilled_streams (
290 p_contract_id IN NUMBER,
291 p_contract_line_id IN NUMBER)
292 RETURN NUMBER;
293
294 -- Just a shell for now
295 FUNCTION line_unbilled_rent (
296 p_contract_id IN NUMBER,
297 p_contract_line_id IN NUMBER)
298 RETURN NUMBER;
299
300 -- Just a shell for now
301 FUNCTION line_unearned_income (
302 p_contract_id IN NUMBER,
303 p_contract_line_id IN NUMBER)
304 RETURN NUMBER;
305
306 -- Just a shell for now
307 FUNCTION line_calculate_fmv (
308 p_contract_id IN NUMBER,
309 p_contract_line_id IN NUMBER)
310 RETURN NUMBER;
311
312 -- Just a shell for now
313 FUNCTION line_calculate_residual_value (
314 p_contract_id IN NUMBER,
315 p_contract_line_id IN NUMBER)
316 RETURN NUMBER;
317
318 -- Added for bug 6326479
319 FUNCTION asset_accu_deprn_reserve (
320 p_contract_id IN NUMBER,
321 p_contract_line_id IN NUMBER)
322 RETURN NUMBER;
323 ---------------------------------------------
324 -- END of AM Functions
325 ---------------------------------------------
326
327 ---------------------------------------------
328 -- CS Functions
329 ---------------------------------------------
330
331 FUNCTION contract_security_deposit(
332 p_contract_id IN NUMBER
333 ,p_contract_line_id IN NUMBER) RETURN NUMBER;
334
335 FUNCTION contract_residual_amount(
336 p_contract_id IN NUMBER
337 ,p_contract_line_id IN NUMBER) RETURN NUMBER;
338
339 FUNCTION contract_rent_amount(
340 p_contract_id IN NUMBER
341 ,p_contract_line_id IN NUMBER) RETURN NUMBER;
342
343 FUNCTION contract_unearned_income(
344 p_contract_id IN NUMBER
345 ,p_contract_line_id IN NUMBER) RETURN NUMBER;
346 FUNCTION contract_depriciation_amount(
347 p_contract_id IN NUMBER
348 ,p_contract_line_id IN NUMBER) RETURN NUMBER;
349 FUNCTION contract_principal_amount( p_contract_id IN NUMBER
350 ,p_contract_line_id IN NUMBER) RETURN NUMBER;
351 --rkraya added
352 FUNCTION unpaid_invoices(
353 p_contract_id IN NUMBER
354 ,p_contract_line_id IN NUMBER) RETURN NUMBER;
355 FUNCTION unapplied_credit_memos(
356 p_contract_id IN NUMBER
357 ,p_contract_line_id IN NUMBER) RETURN NUMBER;
358
359 FUNCTION contract_prin_balance(
360 p_contract_id IN NUMBER
361 ,p_contract_line_id IN NUMBER) RETURN NUMBER;
362
363 --
364 FUNCTION get_asset_subsidy_amount(
365 p_contract_id IN NUMBER,
366 p_accounting_method IN VARCHAR2 DEFAULT NULL) RETURN NUMBER;
367
368
369 FUNCTION contract_acc_depreciation(
370 p_contract_id IN NUMBER
371 ,p_contract_line_id IN NUMBER) RETURN NUMBER;
372
373 FUNCTION pv_of_unbilled_rents(
374 p_contract_id IN NUMBER
375 ,p_contract_line_id IN NUMBER) RETURN NUMBER;
376
377
378 ---------------------------------------------
379 --End of CS Functions
380 ---------------------------------------------
381
382 -----------------------------------------------------------------------
383 FUNCTION INS_MONTHLY_PREMIUM(
384 p_contract_id IN NUMBER
385 ,p_contract_line_id IN NUMBER
386 ) RETURN NUMBER;
387 PRAGMA RESTRICT_REFERENCES (INS_MONTHLY_PREMIUM, TRUST);
388
389
390 FUNCTION INS_REFUNDABLE_MONTHS(
391 p_contract_id IN NUMBER
392 ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
393 ) RETURN NUMBER;
394 PRAGMA RESTRICT_REFERENCES (INS_REFUNDABLE_MONTHS, TRUST);
395
396 -----------------------------------------------------------------------
397
398 -----------------------------------------------------------------------
399 -- Functions By pdevaraj -start
400 -----------------------------------------------------------------------
401 FUNCTION contract_net_investment
402 (
403 p_chr_id IN NUMBER
404 ,p_line_id IN NUMBER
405 )
406 RETURN NUMBER;
407
408 FUNCTION contract_cures_in_possession
409 (
410 p_chr_id IN NUMBER
411 )
412 RETURN NUMBER;
413
414 FUNCTION contract_outstanding_amount
415 (
416 p_chr_id IN NUMBER,
417 p_line_id IN NUMBER
418 )
419 RETURN NUMBER;
420
421 FUNCTION contract_full_cure
422 (
423 p_chr_id IN NUMBER
424 )
425 RETURN NUMBER;
426
427 FUNCTION contract_interest_cure
428 (
429 p_chr_id IN NUMBER
430 )
431 RETURN NUMBER;
432
433 FUNCTION get_unrefunded_cures(
434 p_contract_id IN NUMBER,
435 x_unrefunded_cures OUT NOCOPY NUMBER)
436 RETURN VARCHAR2;
437
438 FUNCTION get_cured_status (p_contract_number IN NUMBER)
439 RETURN VARCHAR2;
440
441 PRAGMA RESTRICT_REFERENCES(get_cured_status, WNDS,WNPS,RNPS);
442
443 -----------------------------------------------------------------------
444 -- Functions By pdevaraj -end
445 -----------------------------------------------------------------------
446
447 ---------------------------------------------
448 -- Functions for Securitization
449 -- mvasudev, 04/02/2003
450 ---------------------------------------------
451 FUNCTION ASSET_UNDISBURSED_STREAMS(p_dnz_chr_id IN NUMBER -- Lease Contract ID
452 ,p_kle_id IN NUMBER -- Lease Contract-Asset ID
453 )
454 RETURN NUMBER;
455 ---------------------------------------------
456 -- END,Functions for Securitization
457 -- mvasudev, 04/02/2003
458 ---------------------------------------------
459
460 -- 06/04/03 cklee start
461
462 FUNCTION investor_rent_accural_amout(
463 p_contract_id IN okc_k_headers_b.id%TYPE
464 ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
465 ) RETURN NUMBER;
466 PRAGMA RESTRICT_REFERENCES (investor_rent_accural_amout, TRUST);
467
468 FUNCTION investor_user_amount_stake(
469 p_contract_id IN okc_k_headers_b.id%TYPE
470 ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
471 ) RETURN NUMBER;
472 PRAGMA RESTRICT_REFERENCES (investor_user_amount_stake, TRUST);
473
474 FUNCTION investor_stream_amount(
475 p_contract_id IN okc_k_headers_b.id%TYPE
476 ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
477 ) RETURN NUMBER;
478 PRAGMA RESTRICT_REFERENCES (investor_stream_amount, TRUST);
479
480 FUNCTION INVESTORS_PV_AMOUNT(p_chr_id IN NUMBER -- Investor Agreement ID
481 ,p_line_id IN NUMBER)
482 RETURN NUMBER;
483 PRAGMA RESTRICT_REFERENCES (INVESTORS_PV_AMOUNT, TRUST);
484
485 -- 06/04/03 cklee end
486
487 -- Fixed bug 3120450
488
489 FUNCTION fee_idc_amount(
490 p_dnz_chr_id IN NUMBER
491 ,p_kle_id IN NUMBER
492 ) RETURN NUMBER;
493
494 -- 09/05/03 jsanju start
495 --for cure calculation
496
497 FUNCTION contract_delinquent_amt (
498 p_contract_id IN okc_k_headers_b.id%TYPE
499 ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
500 ) RETURN NUMBER;
501
502
503 FUNCTION cumulative_vendor_invoice_amt (
504 p_contract_id IN okc_k_headers_b.id%TYPE
505 ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
506 ) RETURN NUMBER;
507
508
509 FUNCTION contract_short_fund_amt (
510 p_contract_id IN okc_k_headers_b.id%TYPE
511 ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
512 ) RETURN NUMBER;
513
514
515 -- 09/05/03 jsanju end
516
517 --rkuttiya 15-SEP-2003 -net_gain_loss_Quote
518 FUNCTION NET_GAIN_LOSS_QUOTE
519 (p_khr_id IN NUMBER,
520 p_kle_id IN NUMBER)
521 RETURN NUMBER;
522 --end rkuttiya
523
524 -- Bug# 3316994 :12-Jan-2004 cklee
525 FUNCTION SUBSIDY_AMOUNT(
526 p_contract_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
527 ,p_contract_line_id IN NUMBER
528 ) RETURN NUMBER;
529
530 FUNCTION REFUND_SUBSIDY(
531 p_contract_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
532 ,p_contract_line_id IN NUMBER
533 ) RETURN NUMBER;
534 -- Bug# 3316994 :12-Jan-2004 cklee
535
536 -- Bug# 3417313
537
538 FUNCTION contract_pretaxinc_book(
539 p_chr_id IN NUMBER
540 ,p_kle_id IN NUMBER
541 )
542 RETURN NUMBER;
543
544 -- fixed bug 3625609
545 FUNCTION CONTRACT_FINANCED_FEE(
546 p_dnz_chr_id IN NUMBER
547 ,p_kle_id IN NUMBER
548 ) RETURN NUMBER;
549
550 -- fixed bug 3673439
551 FUNCTION CONTRACT_ABSORBED_FEE(
552 p_dnz_chr_id IN NUMBER
553 ,p_kle_id IN NUMBER
554 ) RETURN NUMBER;
555
556 -- for bug#3819937 cklee
557 FUNCTION credit_check(
558 p_contract_id IN NUMBER -- credit line contract id
559 ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
560 ) RETURN NUMBER;
561 -- for bug#3819937 cklee
562
563 --Bug# 3872534: start
564 FUNCTION line_asset_cost (
565 p_contract_id IN NUMBER,
566 p_contract_line_id IN NUMBER)
567 RETURN NUMBER;
568
569 FUNCTION line_accumulated_deprn (
570 p_contract_id IN NUMBER,
571 p_contract_line_id IN NUMBER)
572 RETURN NUMBER;
573
574 FUNCTION contract_asset_cost (
575 p_contract_id IN NUMBER,
576 p_contract_line_id IN NUMBER)
577 RETURN NUMBER;
578
579 FUNCTION contract_accumulated_deprn (
580 p_contract_id IN NUMBER,
581 p_contract_line_id IN NUMBER)
582 RETURN NUMBER;
583 --Bug# 3872534: end
584
585 --Bug# 3877032
586 FUNCTION contract_financed_amount
587 (p_contract_id IN NUMBER,
588 p_contract_line_id IN NUMBER)
589 RETURN NUMBER;
590 --Bug# 3877032 End
591
592 --cklee
593 FUNCTION rollover_fee
594 (p_contract_id IN NUMBER,
595 p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
596 RETURN NUMBER;
597 FUNCTION tot_net_transfers
598 (p_contract_id IN NUMBER,
599 p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
600 RETURN NUMBER;
601 --cklee
602
603 -- rmunjulu 3816891
604 FUNCTION line_future_rent (
605 p_contract_id IN NUMBER,
606 p_contract_line_id IN NUMBER)
607 RETURN NUMBER;
608
609 -- rmunjulu 3816891
610 FUNCTION line_future_income (
611 p_contract_id IN NUMBER,
612 p_contract_line_id IN NUMBER)
613 RETURN NUMBER;
614
615 -- rmunjulu 3816891
616 FUNCTION asset_residual(
617 p_khr_id IN NUMBER,
618 p_kle_id IN NUMBER)
619 RETURN NUMBER;
620
621 -- rfedane 4058562
622 FUNCTION principal_balance_financed (p_contract_id IN NUMBER,
623 p_contract_line_id IN NUMBER) RETURN NUMBER;
624
625 -- rfedane 4058562
626 FUNCTION principal_balance_rollover (p_contract_id IN NUMBER,
627 p_contract_line_id IN NUMBER) RETURN NUMBER;
628
629 -- rfedane 4058562
630 FUNCTION principal_balance_fee_line (p_contract_id IN NUMBER,
631 p_contract_line_id IN NUMBER) RETURN NUMBER;
632
633 -- rmunjulu 4299668
634 FUNCTION asset_net_book_value(
635 p_khr_id IN NUMBER,
636 p_kle_id IN NUMBER)
637 RETURN NUMBER;
638
639 -- rmunjulu VENDOR_RESIDUAL_SHARE PROJECT
640 FUNCTION vendor_residual_share_amount(
641 p_khr_id IN NUMBER,
642 p_kle_id IN NUMBER)
643 RETURN NUMBER;
644
645 -- rmunjulu LOANS_ENHANCEMENTS
646 FUNCTION loan_asset_prin_bal(
647 p_khr_id IN NUMBER,
648 p_kle_id IN NUMBER)
649 RETURN NUMBER;
650
651 -- rmunjulu LOANS_ENHANCEMENTS
652 FUNCTION quote_perdiem_amount(
653 p_khr_id IN NUMBER,
654 p_kle_id IN NUMBER)
655 RETURN NUMBER;
656
657 -- STRAT: cklee - bug#4655437 10/06/2005
658 FUNCTION tot_credit_funding_pmt(
659 p_contract_id IN NUMBER -- credit line contract id
660 ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
661 ) RETURN NUMBER;
662
663 FUNCTION tot_credit_principal_pmt(
664 p_contract_id IN NUMBER -- credit line contract id
665 ,p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM
666 ) RETURN NUMBER;
667 -- END: cklee - bug#4655437 10/06/2005
668
669 -- sjalasut, Rebook Change Control Enhancement START
670
671 -- function that returns the sum of unbilled RENT for all active assets on the rebook copy of the contract
672 FUNCTION cont_rbk_unbilled_receivables(p_contract_id okc_k_headers_b.id%TYPE
673 ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER;
674
675 -- function that returns the sum of pre-tax income that was not accrued for all active assets on the rebook copy of the contract
676 FUNCTION cont_rbk_unearned_income(p_contract_id okc_k_headers_b.id%TYPE
677 ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER;
678
679 -- returns sum of rent not billed for all terminated assets
680 FUNCTION cont_tmt_unbilled_receivables(p_contract_id okc_k_headers_b.id%TYPE
681 ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER;
682
683 -- returns sum of pre tax income not accrued for all terminated assets
684 FUNCTION cont_tmt_unearned_income(p_contract_id okc_k_headers_b.id%TYPE
685 ,p_contract_line_id okc_k_lines_b.id%TYPE DEFAULT OKL_API.G_MISS_NUM) RETURN NUMBER;
686
687 -- sjalasut, Rebook Change Control Enhancement END
688 --varangan bug #5036582 start
689 FUNCTION contract_unpaid_invoices(
690 p_contract_id IN NUMBER,
691 p_contract_line_id IN NUMBER)
692 RETURN NUMBER;
693
694 FUNCTION contract_unbilled_streams(
695 p_contract_id IN NUMBER,
696 p_contract_line_id IN NUMBER)
697 RETURN NUMBER;
698 --varangan bug #5036582 end
699
700 --Begin - varangan- bug#5009351
701 FUNCTION contract_next_payment_amount(
702 p_contract_id IN NUMBER,
703 p_contract_line_id IN NUMBER)
704 RETURN NUMBER;
705 --End - varangan- bug#5009351
706
707 -- Added by rravikir -- Bug 5055835
708 FUNCTION check_contract_fin_amount(p_contract_id IN NUMBER,
709 p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
710 RETURN VARCHAR2;
711
712 FUNCTION check_fund_amount(p_contract_id IN NUMBER,
713 p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
714 RETURN VARCHAR2;
715
716 FUNCTION check_party_custacct_match(p_contract_id IN NUMBER,
717 p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
718 RETURN VARCHAR2;
719
720 FUNCTION check_vendor_prog_match(p_contract_id IN NUMBER,
721 p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
722 RETURN VARCHAR2;
723
724 FUNCTION check_booking_date(p_contract_id IN NUMBER,
725 p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
726 RETURN VARCHAR2;
727
728 FUNCTION check_funding_date(p_contract_id IN NUMBER,
729 p_contract_line_id IN NUMBER DEFAULT OKL_API.G_MISS_NUM)
730 RETURN VARCHAR2;
731 -- End
732
733 --03-Jan-07 sechawla 6651621
734 FUNCTION line_taxable_basis (
735 p_khr_id IN NUMBER,
736 p_kle_id IN NUMBER)
737 RETURN NUMBER;
738 --Bug # 6740000 ssdeshpa added Function for calculating the Investor Loan factor Start
739 --For added loan contracts into the Pool
740 FUNCTION investor_loan_factor (
741 p_contract_id IN NUMBER,
742 p_contract_line_id IN NUMBER)
743 RETURN NUMBER;
744 --Bug # 6740000 ssdeshpa End;
745 -- Added by mansrini for ER Bug#6011738
746 FUNCTION front_end_financed_amount(p_contract_id IN NUMBER,
747 p_contract_line_id IN NUMBER DEFAULT
748 OKL_API.G_MISS_NUM)
749 RETURN NUMBER;
750 -- End by mansrini
751
752 -- added Durga Janaswamy for Contract Line Extract
753 FUNCTION total_asset_addon_cost (
754 p_contract_id IN NUMBER,
755 p_contract_line_id IN NUMBER)
756 RETURN NUMBER;
757
758 -- added Durga Janaswamy for Contract Line Extract
759 FUNCTION get_line_subsidy_amount(
760 p_contract_id IN NUMBER,
761 p_fin_asset_line_id IN NUMBER,
762 p_accounting_method IN VARCHAR2 DEFAULT NULL)
763 RETURN NUMBER;
764
765 -- added Durga Janaswamy for Contract Line Extract
766 FUNCTION get_line_subsidy_ovrd_amount(
767 p_contract_id IN NUMBER,
768 p_fin_asset_line_id IN NUMBER,
769 p_accounting_method IN VARCHAR2 DEFAULT NULL)
770 RETURN NUMBER;
771
772 -- added Durga Janaswamy for Contract Line Extract
773 FUNCTION line_financed_amount (
774 p_contract_id IN NUMBER,
775 p_contract_line_id IN NUMBER)
776 RETURN NUMBER;
777
778 -- SECHAWLA 18-Nov-08 : Added for Contract Line Extract
779 FUNCTION Total_Asset_Financed_Fee_Amt(
780 p_chr_id IN NUMBER,
781 p_line_id IN NUMBER) RETURN NUMBER;
782
783 -- SECHAWLA 18-Nov-08 : Added for Contract Line Extract
784 FUNCTION Total_Asset_Rollover_Fee_Amt(
785 p_chr_id IN NUMBER,
786 p_line_id IN NUMBER) RETURN NUMBER;
787 END Okl_Seeded_Functions_Pvt;
[Home] [Help]