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:
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:
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:
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:
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:
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:
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
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
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
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