eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_LA_STREAM_PVT dependencies on DUAL

Line 1741: -- fetch the residual value insurance amount

1737: l_fee_types_rec.item_id2 := l_fee_dtls_rec.item_object1_id2;
1738: l_fee_types_rec.effective_from := l_fee_dtls_rec.line_start_date;
1739: l_fee_types_rec.effective_to := l_fee_dtls_rec.line_end_date;
1740: END LOOP;
1741: -- fetch the residual value insurance amount
1742: -- get the stream header id
1743: FOR l_strm_rec IN strm_csr(p_chr_id,l_line_id,'CURR',p_purpose,l_fee_types_rec.item_id1)
1744: LOOP
1745: l_stmv_rec.id := l_strm_rec.strm_id;

Line 2053: FROM DUAL

2049: /*
2050: CURSOR get_rep_tax_csr(p_asset_number okl_txd_assets_b.asset_number%TYPE)
2051: IS
2052: SELECT 'Y'
2053: FROM DUAL
2054: WHERE EXISTS (SELECT 'Y'
2055: FROM okl_txd_assets_b txd
2056: WHERE txd.asset_number = p_asset_number
2057: AND txd.tax_book = fnd_profile.value('OKL_REPORTING_PDT_ASSET_BOOK'));

Line 2115: FROM dual

2111: -- To check if the chr_id has TERMINATED Line
2112: CURSOR l_hdr_ter_csr (p_chr_id NUMBER)
2113: IS
2114: SELECT 'Y'
2115: FROM dual
2116: WHERE EXISTS (SELECT 'Y'
2117: FROM okc_k_lines_b cle,
2118: okc_line_styles_b lse
2119: WHERE cle.dnz_chr_id = p_chr_id

Line 2128: FROM dual

2124: CURSOR l_lne_ter_csr (p_chr_id NUMBER,
2125: p_cle_id NUMBER)
2126: IS
2127: SELECT 'Y'
2128: FROM dual
2129: WHERE EXISTS (SELECT 'Y'
2130: FROM okc_k_lines_b cle,
2131: okc_line_styles_b lse
2132: WHERE cle.dnz_chr_id = p_chr_id

Line 3083: kle.residual_value residual_value

3079: DECODE(rul2.rule_information10, 'Y', 'ARREARS', 'ADVANCE') advance_arrears,
3080: FND_NUMBER.canonical_to_number(rul2.rule_information6) amount,
3081: lse.lty_code lty_code,
3082: kle.capital_amount capital_amount,
3083: kle.residual_value residual_value
3084: FROM okc_rule_groups_b rgp,
3085: okc_rules_b rul1,
3086: okc_rules_b rul2,
3087: okc_k_lines_b cle,

Line 3107: FROM dual

3103: --srsreeni bug 5869271 end add
3104: -- To get the streams information
3105: CURSOR l_stmp_yn_csr(khrid NUMBER, p VARCHAR2) IS
3106: SELECT 'Y' What
3107: FROM dual
3108: WHERE EXISTS(SELECT stm.id stmid
3109: FROM okl_streams stm
3110: WHERE stm.khr_id = khrid
3111: --AND stm.say_code = 'CURR'

Line 5004: kle.residual_code,

5000: CURSOR l_line_csr( chrid NUMBER )
5001: IS
5002: SELECT kle.id,
5003: kle.oec,
5004: kle.residual_code,
5005: kle.capital_amount,
5006: kle.delivered_date,
5007: kle.date_funding_required,
5008: kle.residual_grnty_amount,

Line 5008: kle.residual_grnty_amount,

5004: kle.residual_code,
5005: kle.capital_amount,
5006: kle.delivered_date,
5007: kle.date_funding_required,
5008: kle.residual_grnty_amount,
5009: kle.date_funding,
5010: kle.residual_value,
5011: kle.amount,
5012: kle.price_negotiated,

Line 5010: kle.residual_value,

5006: kle.delivered_date,
5007: kle.date_funding_required,
5008: kle.residual_grnty_amount,
5009: kle.date_funding,
5010: kle.residual_value,
5011: kle.amount,
5012: kle.price_negotiated,
5013: kle.start_date,
5014: kle.end_date,

Line 5571: FROM DUAL

5567: -- To check if the contract is MASS REBOOK candidate
5568: CURSOR c_chk_msrbk_csr(p_chr_id NUMBER)
5569: IS
5570: SELECT 'Y'
5571: FROM DUAL
5572: WHERE EXISTS (SELECT 'Y'
5573: FROM okl_rbk_selected_contract
5574: WHERE khr_id = p_chr_id
5575: AND status = 'UNDER REVISION');

Line 5655: FROM dual;

5651: -- WHERE str.khr_id = p_chr_id
5652: -- AND str.say_code = 'CURR'
5653: -- AND nvl(str.purpose_code, 'ORIGIN') = p_purpose;
5654: SELECT OKL_SIF_SEQ.NEXTVAL
5655: FROM dual;
5656:
5657: -- Bucket to store the billed amonts
5658: TYPE bill_rec_type IS RECORD (
5659: kle_id NUMBER := NULL,

Line 6643: FROM dual

6639: -- Validate weather the stream generation is done thru internal/external stream generation
6640: CURSOR validate_esg_isg (p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE)
6641: IS
6642: SELECT 1
6643: FROM dual
6644: WHERE EXISTS (SELECT 1
6645: FROM okl_streams
6646: WHERE khr_id= p_dnz_chr_id
6647: AND say_code = 'WORK'

Line 6653: FROM dual

6649: -- Validate the contract has Subsidy line
6650: CURSOR validate_sub_line (p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE)
6651: IS
6652: SELECT 1
6653: FROM dual
6654: WHERE EXISTS (SELECT '1'
6655: FROM okl_subsidies_b subb,
6656: okc_k_lines_b cle_fin,
6657: okc_line_styles_b lse_fin,

Line 7481: 'INVESTOR_RENT_PAYABLE', 'INVESTOR_RESIDUAL_BUYBACK',

7477: 'INVESTOR_LATE_INTEREST_PAY', 'INVESTOR_PAYABLE',
7478: 'INVESTOR_PRETAX_INCOME', 'INVESTOR_PRINCIPAL_PAYABLE',
7479: 'INVESTOR_RECEIVABLE', 'INVESTOR_RENTAL_ACCRUAL',
7480: 'INVESTOR_RENT_BUYBACK', 'INVESTOR_RENT_DISB_BASIS',
7481: 'INVESTOR_RENT_PAYABLE', 'INVESTOR_RESIDUAL_BUYBACK',
7482: 'INVESTOR_RESIDUAL_DISB_BASIS', 'INVESTOR_RESIDUAL_PAY',
7483: 'INVESTOR_VARIABLE_INTEREST', 'PV_RENT_SECURITIZED',
7484: 'PV_RV_SECURITIZED')
7485: -- INVESTOR_CNTRCT_OBLIGATION_PAY' --'INVESTOR_CONTRACT_OBLIGATION_PAYABLE'

Line 7482: 'INVESTOR_RESIDUAL_DISB_BASIS', 'INVESTOR_RESIDUAL_PAY',

7478: 'INVESTOR_PRETAX_INCOME', 'INVESTOR_PRINCIPAL_PAYABLE',
7479: 'INVESTOR_RECEIVABLE', 'INVESTOR_RENTAL_ACCRUAL',
7480: 'INVESTOR_RENT_BUYBACK', 'INVESTOR_RENT_DISB_BASIS',
7481: 'INVESTOR_RENT_PAYABLE', 'INVESTOR_RESIDUAL_BUYBACK',
7482: 'INVESTOR_RESIDUAL_DISB_BASIS', 'INVESTOR_RESIDUAL_PAY',
7483: 'INVESTOR_VARIABLE_INTEREST', 'PV_RENT_SECURITIZED',
7484: 'PV_RV_SECURITIZED')
7485: -- INVESTOR_CNTRCT_OBLIGATION_PAY' --'INVESTOR_CONTRACT_OBLIGATION_PAYABLE'
7486: -- ,'INVESTOR_RESIDUAL_PAY' ) --'INVESTOR_RESIDUAL_PAYABLE')

Line 7486: -- ,'INVESTOR_RESIDUAL_PAY' ) --'INVESTOR_RESIDUAL_PAYABLE')

7482: 'INVESTOR_RESIDUAL_DISB_BASIS', 'INVESTOR_RESIDUAL_PAY',
7483: 'INVESTOR_VARIABLE_INTEREST', 'PV_RENT_SECURITIZED',
7484: 'PV_RV_SECURITIZED')
7485: -- INVESTOR_CNTRCT_OBLIGATION_PAY' --'INVESTOR_CONTRACT_OBLIGATION_PAYABLE'
7486: -- ,'INVESTOR_RESIDUAL_PAY' ) --'INVESTOR_RESIDUAL_PAYABLE')
7487:
7488: --Condition added by kthiruva for Bug 4737555 .Streams generated by Interest Calc Prog should not be historised
7489: AND (l_strms_rec.SGN_CODE NOT IN ('INTC','LATE_CALC')) -- bug 6472228
7490: AND l_hist_flag = 'Y') THEN

Line 7934: 'INVESTOR_RENT_BUYBACK', 'INVESTOR_RENT_DISB_BASIS', 'INVESTOR_RENT_PAYABLE', 'INVESTOR_RESIDUAL_BUYBACK',

7930: AND STY.stream_type_purpose NOT IN
7931: ('INVESTOR_CNTRCT_OBLIGATION_PAY', 'INVESTOR_DISB_ADJUSTMENT', 'INVESTOR_EVERGREEN_RENT_PAY', 'INVESTOR_INTEREST_INCOME',
7932: 'INVESTOR_INTEREST_PAYABLE', 'INVESTOR_LATE_FEE_PAYABLE', 'INVESTOR_LATE_INTEREST_PAY', 'INVESTOR_PAYABLE',
7933: 'INVESTOR_PRETAX_INCOME', 'INVESTOR_PRINCIPAL_PAYABLE', 'INVESTOR_RECEIVABLE', 'INVESTOR_RENTAL_ACCRUAL',
7934: 'INVESTOR_RENT_BUYBACK', 'INVESTOR_RENT_DISB_BASIS', 'INVESTOR_RENT_PAYABLE', 'INVESTOR_RESIDUAL_BUYBACK',
7935: 'INVESTOR_RESIDUAL_DISB_BASIS', 'INVESTOR_RESIDUAL_PAY', 'INVESTOR_VARIABLE_INTEREST', 'PV_RENT_SECURITIZED',
7936: 'PV_RV_SECURITIZED' --, 'ADVANCE_RENT' -- 7653893: Modified to consider Advance Rental Streams for copy over
7937: , 'PASS_THROUGH_EVERGREEN_FEE', 'PASS_THROUGH_EVERGREEN_RENT', 'PASS_THROUGH_EVERGREEN_SERVICE',
7938: 'PASS_THROUGH_FEE', 'PASS_THROUGH_SERVICE', 'PASS_THRU_EXP_ACCRUAL', 'PASS_THRU_REV_ACCRUAL', 'PASS_THRU_SVC_EXP_ACCRUAL',

Line 7935: 'INVESTOR_RESIDUAL_DISB_BASIS', 'INVESTOR_RESIDUAL_PAY', 'INVESTOR_VARIABLE_INTEREST', 'PV_RENT_SECURITIZED',

7931: ('INVESTOR_CNTRCT_OBLIGATION_PAY', 'INVESTOR_DISB_ADJUSTMENT', 'INVESTOR_EVERGREEN_RENT_PAY', 'INVESTOR_INTEREST_INCOME',
7932: 'INVESTOR_INTEREST_PAYABLE', 'INVESTOR_LATE_FEE_PAYABLE', 'INVESTOR_LATE_INTEREST_PAY', 'INVESTOR_PAYABLE',
7933: 'INVESTOR_PRETAX_INCOME', 'INVESTOR_PRINCIPAL_PAYABLE', 'INVESTOR_RECEIVABLE', 'INVESTOR_RENTAL_ACCRUAL',
7934: 'INVESTOR_RENT_BUYBACK', 'INVESTOR_RENT_DISB_BASIS', 'INVESTOR_RENT_PAYABLE', 'INVESTOR_RESIDUAL_BUYBACK',
7935: 'INVESTOR_RESIDUAL_DISB_BASIS', 'INVESTOR_RESIDUAL_PAY', 'INVESTOR_VARIABLE_INTEREST', 'PV_RENT_SECURITIZED',
7936: 'PV_RV_SECURITIZED' --, 'ADVANCE_RENT' -- 7653893: Modified to consider Advance Rental Streams for copy over
7937: , 'PASS_THROUGH_EVERGREEN_FEE', 'PASS_THROUGH_EVERGREEN_RENT', 'PASS_THROUGH_EVERGREEN_SERVICE',
7938: 'PASS_THROUGH_FEE', 'PASS_THROUGH_SERVICE', 'PASS_THRU_EXP_ACCRUAL', 'PASS_THRU_REV_ACCRUAL', 'PASS_THRU_SVC_EXP_ACCRUAL',
7939: 'PASS_THRU_SVC_REV_ACCRUAL', 'PV_RV', 'PV_RV_GUARANTEED', 'PV_RV_UNGUARANTEED', 'RESIDUAL_GUARANTEED', 'RESIDUAL_VALUE',

Line 7939: 'PASS_THRU_SVC_REV_ACCRUAL', 'PV_RV', 'PV_RV_GUARANTEED', 'PV_RV_UNGUARANTEED', 'RESIDUAL_GUARANTEED', 'RESIDUAL_VALUE',

7935: 'INVESTOR_RESIDUAL_DISB_BASIS', 'INVESTOR_RESIDUAL_PAY', 'INVESTOR_VARIABLE_INTEREST', 'PV_RENT_SECURITIZED',
7936: 'PV_RV_SECURITIZED' --, 'ADVANCE_RENT' -- 7653893: Modified to consider Advance Rental Streams for copy over
7937: , 'PASS_THROUGH_EVERGREEN_FEE', 'PASS_THROUGH_EVERGREEN_RENT', 'PASS_THROUGH_EVERGREEN_SERVICE',
7938: 'PASS_THROUGH_FEE', 'PASS_THROUGH_SERVICE', 'PASS_THRU_EXP_ACCRUAL', 'PASS_THRU_REV_ACCRUAL', 'PASS_THRU_SVC_EXP_ACCRUAL',
7939: 'PASS_THRU_SVC_REV_ACCRUAL', 'PV_RV', 'PV_RV_GUARANTEED', 'PV_RV_UNGUARANTEED', 'RESIDUAL_GUARANTEED', 'RESIDUAL_VALUE',
7940: 'SECURITY_DEPOSIT', 'SERVICE_EXPENSE', 'SERVICE_FEE_AMORT_SCHEDULE', 'SERVICE_FEE_AUDIT_LETTER', 'SERVICE_FEE_DOCUMENT_REQ',
7941: 'SERVICE_FEE_EXCHG_REQUEST', 'SERVICE_FEE_GENERAL', 'SERVICE_FEE_INTEREST_CONV', 'SERVICE_FEE_INVOICE_DEMAND',
7942: 'SERVICE_FEE_INVOICE_REPRINT', 'SERVICE_FEE_PMT_CHANGE', 'SERVICE_FEE_REST_REQUEST', 'SERVICE_FEE_TERM_REQUEST',
7943: 'SERVICE_FEE_TRANS_REQUEST', 'SERVICE_FEE_VAR_RATE_STMNT', 'SERVICE_FEE_VAT_SCHEDULE', 'SERVICE_INCOME', 'SERVICE_PAYMENT',

Line 8032: 'INVESTOR_RENT_BUYBACK', 'INVESTOR_RENT_DISB_BASIS', 'INVESTOR_RENT_PAYABLE', 'INVESTOR_RESIDUAL_BUYBACK',

8028: AND STY.stream_type_purpose NOT IN
8029: ('INVESTOR_CNTRCT_OBLIGATION_PAY', 'INVESTOR_DISB_ADJUSTMENT', 'INVESTOR_EVERGREEN_RENT_PAY', 'INVESTOR_INTEREST_INCOME',
8030: 'INVESTOR_INTEREST_PAYABLE', 'INVESTOR_LATE_FEE_PAYABLE', 'INVESTOR_LATE_INTEREST_PAY', 'INVESTOR_PAYABLE',
8031: 'INVESTOR_PRETAX_INCOME', 'INVESTOR_PRINCIPAL_PAYABLE', 'INVESTOR_RECEIVABLE', 'INVESTOR_RENTAL_ACCRUAL',
8032: 'INVESTOR_RENT_BUYBACK', 'INVESTOR_RENT_DISB_BASIS', 'INVESTOR_RENT_PAYABLE', 'INVESTOR_RESIDUAL_BUYBACK',
8033: 'INVESTOR_RESIDUAL_DISB_BASIS', 'INVESTOR_RESIDUAL_PAY', 'INVESTOR_VARIABLE_INTEREST', 'PV_RENT_SECURITIZED',
8034: 'PV_RV_SECURITIZED', 'ADVANCE_RENT', 'PASS_THROUGH_EVERGREEN_FEE', 'PASS_THROUGH_EVERGREEN_RENT', 'PASS_THROUGH_EVERGREEN_SERVICE',
8035: 'PASS_THROUGH_FEE', 'PASS_THROUGH_SERVICE', 'PASS_THRU_EXP_ACCRUAL', 'PASS_THRU_REV_ACCRUAL', 'PASS_THRU_SVC_EXP_ACCRUAL',
8036: 'PASS_THRU_SVC_REV_ACCRUAL', 'PV_RV', 'PV_RV_GUARANTEED', 'PV_RV_UNGUARANTEED', 'RESIDUAL_GUARANTEED', 'RESIDUAL_VALUE',

Line 8033: 'INVESTOR_RESIDUAL_DISB_BASIS', 'INVESTOR_RESIDUAL_PAY', 'INVESTOR_VARIABLE_INTEREST', 'PV_RENT_SECURITIZED',

8029: ('INVESTOR_CNTRCT_OBLIGATION_PAY', 'INVESTOR_DISB_ADJUSTMENT', 'INVESTOR_EVERGREEN_RENT_PAY', 'INVESTOR_INTEREST_INCOME',
8030: 'INVESTOR_INTEREST_PAYABLE', 'INVESTOR_LATE_FEE_PAYABLE', 'INVESTOR_LATE_INTEREST_PAY', 'INVESTOR_PAYABLE',
8031: 'INVESTOR_PRETAX_INCOME', 'INVESTOR_PRINCIPAL_PAYABLE', 'INVESTOR_RECEIVABLE', 'INVESTOR_RENTAL_ACCRUAL',
8032: 'INVESTOR_RENT_BUYBACK', 'INVESTOR_RENT_DISB_BASIS', 'INVESTOR_RENT_PAYABLE', 'INVESTOR_RESIDUAL_BUYBACK',
8033: 'INVESTOR_RESIDUAL_DISB_BASIS', 'INVESTOR_RESIDUAL_PAY', 'INVESTOR_VARIABLE_INTEREST', 'PV_RENT_SECURITIZED',
8034: 'PV_RV_SECURITIZED', 'ADVANCE_RENT', 'PASS_THROUGH_EVERGREEN_FEE', 'PASS_THROUGH_EVERGREEN_RENT', 'PASS_THROUGH_EVERGREEN_SERVICE',
8035: 'PASS_THROUGH_FEE', 'PASS_THROUGH_SERVICE', 'PASS_THRU_EXP_ACCRUAL', 'PASS_THRU_REV_ACCRUAL', 'PASS_THRU_SVC_EXP_ACCRUAL',
8036: 'PASS_THRU_SVC_REV_ACCRUAL', 'PV_RV', 'PV_RV_GUARANTEED', 'PV_RV_UNGUARANTEED', 'RESIDUAL_GUARANTEED', 'RESIDUAL_VALUE',
8037: 'SECURITY_DEPOSIT', 'SERVICE_EXPENSE', 'SERVICE_FEE_AMORT_SCHEDULE', 'SERVICE_FEE_AUDIT_LETTER', 'SERVICE_FEE_DOCUMENT_REQ',

Line 8036: 'PASS_THRU_SVC_REV_ACCRUAL', 'PV_RV', 'PV_RV_GUARANTEED', 'PV_RV_UNGUARANTEED', 'RESIDUAL_GUARANTEED', 'RESIDUAL_VALUE',

8032: 'INVESTOR_RENT_BUYBACK', 'INVESTOR_RENT_DISB_BASIS', 'INVESTOR_RENT_PAYABLE', 'INVESTOR_RESIDUAL_BUYBACK',
8033: 'INVESTOR_RESIDUAL_DISB_BASIS', 'INVESTOR_RESIDUAL_PAY', 'INVESTOR_VARIABLE_INTEREST', 'PV_RENT_SECURITIZED',
8034: 'PV_RV_SECURITIZED', 'ADVANCE_RENT', 'PASS_THROUGH_EVERGREEN_FEE', 'PASS_THROUGH_EVERGREEN_RENT', 'PASS_THROUGH_EVERGREEN_SERVICE',
8035: 'PASS_THROUGH_FEE', 'PASS_THROUGH_SERVICE', 'PASS_THRU_EXP_ACCRUAL', 'PASS_THRU_REV_ACCRUAL', 'PASS_THRU_SVC_EXP_ACCRUAL',
8036: 'PASS_THRU_SVC_REV_ACCRUAL', 'PV_RV', 'PV_RV_GUARANTEED', 'PV_RV_UNGUARANTEED', 'RESIDUAL_GUARANTEED', 'RESIDUAL_VALUE',
8037: 'SECURITY_DEPOSIT', 'SERVICE_EXPENSE', 'SERVICE_FEE_AMORT_SCHEDULE', 'SERVICE_FEE_AUDIT_LETTER', 'SERVICE_FEE_DOCUMENT_REQ',
8038: 'SERVICE_FEE_EXCHG_REQUEST', 'SERVICE_FEE_GENERAL', 'SERVICE_FEE_INTEREST_CONV', 'SERVICE_FEE_INVOICE_DEMAND',
8039: 'SERVICE_FEE_INVOICE_REPRINT', 'SERVICE_FEE_PMT_CHANGE', 'SERVICE_FEE_REST_REQUEST', 'SERVICE_FEE_TERM_REQUEST',
8040: 'SERVICE_FEE_TRANS_REQUEST', 'SERVICE_FEE_VAR_RATE_STMNT', 'SERVICE_FEE_VAT_SCHEDULE', 'SERVICE_INCOME', 'SERVICE_PAYMENT',

Line 8663: FROM DUAL

8659: -- validate the contract is reporting product or not
8660: CURSOR validate_pdt_csr(p_chr_id NUMBER)
8661: IS
8662: SELECT 'Y'
8663: FROM DUAL
8664: WHERE EXISTS (SELECT 1
8665: FROM okl_k_headers khr,
8666: okl_products_v pdt
8667: WHERE khr.id = p_chr_id

Line 9780: l_streams_tbl(11) := 'RENT';--'PRESENT VALUE RESIDUAL'; --TBC

9776: l_streams_tbl(7) := 'RENTAL ACCRUAL';
9777: l_streams_tbl(8) := 'FINANCED EXTENSION FEE INCOME';
9778: l_streams_tbl(9) := 'RATE SUBSIDY';
9779: l_streams_tbl(10) := 'PRE-TAX INCOME';
9780: l_streams_tbl(11) := 'RENT';--'PRESENT VALUE RESIDUAL'; --TBC
9781: l_streams_tbl(12) := 'RENT';--'PV GUARANTEE';--TBC
9782: l_streams_tbl(13) := 'RESIDUAL VALUE INSURANCE PREMIUM';
9783: l_streams_tbl(14) := 'GUARANTEED RESIDUAL INSURED'; -- RVI takes care of requesting by default.
9784: l_streams_tbl(15) := 'RENT';--'PRESENT VALUE INSURED RESIDUAL';--TBC

Line 9782: l_streams_tbl(13) := 'RESIDUAL VALUE INSURANCE PREMIUM';

9778: l_streams_tbl(9) := 'RATE SUBSIDY';
9779: l_streams_tbl(10) := 'PRE-TAX INCOME';
9780: l_streams_tbl(11) := 'RENT';--'PRESENT VALUE RESIDUAL'; --TBC
9781: l_streams_tbl(12) := 'RENT';--'PV GUARANTEE';--TBC
9782: l_streams_tbl(13) := 'RESIDUAL VALUE INSURANCE PREMIUM';
9783: l_streams_tbl(14) := 'GUARANTEED RESIDUAL INSURED'; -- RVI takes care of requesting by default.
9784: l_streams_tbl(15) := 'RENT';--'PRESENT VALUE INSURED RESIDUAL';--TBC
9785: l_streams_tbl(16) := 'RENT';--'UNEARNED INCOME';
9786: l_streams_tbl(17) := 'RENT'; --'DEFERRED INCOME';

Line 9783: l_streams_tbl(14) := 'GUARANTEED RESIDUAL INSURED'; -- RVI takes care of requesting by default.

9779: l_streams_tbl(10) := 'PRE-TAX INCOME';
9780: l_streams_tbl(11) := 'RENT';--'PRESENT VALUE RESIDUAL'; --TBC
9781: l_streams_tbl(12) := 'RENT';--'PV GUARANTEE';--TBC
9782: l_streams_tbl(13) := 'RESIDUAL VALUE INSURANCE PREMIUM';
9783: l_streams_tbl(14) := 'GUARANTEED RESIDUAL INSURED'; -- RVI takes care of requesting by default.
9784: l_streams_tbl(15) := 'RENT';--'PRESENT VALUE INSURED RESIDUAL';--TBC
9785: l_streams_tbl(16) := 'RENT';--'UNEARNED INCOME';
9786: l_streams_tbl(17) := 'RENT'; --'DEFERRED INCOME';
9787: l_streams_tbl(18) := 'TERMINATION VALUE';

Line 9784: l_streams_tbl(15) := 'RENT';--'PRESENT VALUE INSURED RESIDUAL';--TBC

9780: l_streams_tbl(11) := 'RENT';--'PRESENT VALUE RESIDUAL'; --TBC
9781: l_streams_tbl(12) := 'RENT';--'PV GUARANTEE';--TBC
9782: l_streams_tbl(13) := 'RESIDUAL VALUE INSURANCE PREMIUM';
9783: l_streams_tbl(14) := 'GUARANTEED RESIDUAL INSURED'; -- RVI takes care of requesting by default.
9784: l_streams_tbl(15) := 'RENT';--'PRESENT VALUE INSURED RESIDUAL';--TBC
9785: l_streams_tbl(16) := 'RENT';--'UNEARNED INCOME';
9786: l_streams_tbl(17) := 'RENT'; --'DEFERRED INCOME';
9787: l_streams_tbl(18) := 'TERMINATION VALUE';
9788: l_streams_tbl(19) := 'STIP LOSS VALUE';

Line 9835: -- Then we can include RENT,RENT,RENT,RESIDUAL VALUE INSURANCE PREMIUM

9831: IF ((j > x_stream_types_tbl.COUNT ) AND ( l_strm_name <> l_streams_tbl(i))) THEN
9832: l_blnInclude := OKL_API.G_FALSE;
9833: -- If the Deal type Containing Lease
9834: IF (INSTR( p_deal_type, 'LEASE') > 0) THEN
9835: -- Then we can include RENT,RENT,RENT,RESIDUAL VALUE INSURANCE PREMIUM
9836: -- RENT,RENT
9837: IF l_streams_tbl(i) = 'RENT' OR
9838: l_streams_tbl(i) = 'RESIDUAL VALUE INSURANCE PREMIUM' THEN
9839: l_blnInclude := OKL_API.G_TRUE;

Line 9838: l_streams_tbl(i) = 'RESIDUAL VALUE INSURANCE PREMIUM' THEN

9834: IF (INSTR( p_deal_type, 'LEASE') > 0) THEN
9835: -- Then we can include RENT,RENT,RENT,RESIDUAL VALUE INSURANCE PREMIUM
9836: -- RENT,RENT
9837: IF l_streams_tbl(i) = 'RENT' OR
9838: l_streams_tbl(i) = 'RESIDUAL VALUE INSURANCE PREMIUM' THEN
9839: l_blnInclude := OKL_API.G_TRUE;
9840: -- then we can include PRE-TAX INCOME if Deal type is Lease Direct finance
9841: -- then we can include PRE-TAX INCOME if Deal type is Lease Sale Type
9842: ELSIF l_streams_tbl(i) = 'PRE-TAX INCOME' AND

Line 10168: kle.residual_code,

10164:
10165: cursor l_line_rec_csr1( chrid NUMBER, lnetype VARCHAR2 ) is
10166: select kle.id,
10167: kle.oec,
10168: kle.residual_code,
10169: kle.capital_amount,
10170: kle.delivered_date,
10171: kle.date_funding_required,
10172: kle.residual_grnty_amount,

Line 10172: kle.residual_grnty_amount,

10168: kle.residual_code,
10169: kle.capital_amount,
10170: kle.delivered_date,
10171: kle.date_funding_required,
10172: kle.residual_grnty_amount,
10173: kle.date_funding,
10174: kle.residual_value,
10175: kle.amount,
10176: kle.price_negotiated,

Line 10174: kle.residual_value,

10170: kle.delivered_date,
10171: kle.date_funding_required,
10172: kle.residual_grnty_amount,
10173: kle.date_funding,
10174: kle.residual_value,
10175: kle.amount,
10176: kle.price_negotiated,
10177: kle.start_date,
10178: kle.end_date,

Line 10477: FROM dual

10473: -- Validate the contract has Subsidy line
10474: CURSOR validate_sub_line (p_dnz_chr_id OKC_K_LINES_B.DNZ_CHR_ID%TYPE)
10475: IS
10476: SELECT 1
10477: FROM dual
10478: WHERE EXISTS (SELECT '1'
10479: FROM okl_subsidies_b subb,
10480: okc_k_lines_b cle_fin,
10481: okc_line_styles_b lse_fin,

Line 11019: kle.residual_code,

11015: tl.item_description,
11016: kle.id,
11017: kle.cle_id,
11018: kle.oec,
11019: kle.residual_code,
11020: kle.capital_amount,
11021: kle.initial_direct_cost,
11022: kle.delivered_date,
11023: kle.date_funding_required,

Line 11024: kle.residual_grnty_amount,

11020: kle.capital_amount,
11021: kle.initial_direct_cost,
11022: kle.delivered_date,
11023: kle.date_funding_required,
11024: kle.residual_grnty_amount,
11025: kle.date_funding,
11026: kle.residual_value,
11027: kle.date_delivery_expected,
11028: kle.orig_system_id1 old_line_id,

Line 11026: kle.residual_value,

11022: kle.delivered_date,
11023: kle.date_funding_required,
11024: kle.residual_grnty_amount,
11025: kle.date_funding,
11026: kle.residual_value,
11027: kle.date_delivery_expected,
11028: kle.orig_system_id1 old_line_id,
11029: kle.amount,
11030: kle.price_negotiated,

Line 11239: FROM DUAL;

11235: CURSOR c_num_of_disb(p_contract_end_date DATE, p_payout_date DATE, p_frequency VARCHAR2)
11236: IS
11237: SELECT CEIL(Months_between(p_contract_end_date, p_payout_date)/
11238: DECODE(p_frequency,'A',12,'S',6,'Q',3,1))
11239: FROM DUAL;
11240:
11241:
11242: --sechawla 20-Jul-09 PRB ESG Enhancements : check rebook option
11243: cursor get_rebook_type is

Line 20152: FROM dual

20148: -- To check if the chr_id has Financed fee feetype defined
20149: CURSOR l_financed_type_csr (chrId NUMBER)
20150: IS
20151: SELECT 1
20152: FROM dual
20153: WHERE EXISTS (SELECT 1
20154: FROM okc_k_lines_b cle,
20155: okc_line_styles_b lse,
20156: okl_k_lines kle

Line 20247: kle.residual_code,

20243: CURSOR l_line_rec_csr_lease(chrid NUMBER, lnetype VARCHAR2)
20244: IS
20245: SELECT kle.id,
20246: kle.oec,
20247: kle.residual_code,
20248: kle.capital_amount,
20249: kle.delivered_date,
20250: kle.date_funding_required,
20251: kle.residual_grnty_amount,

Line 20251: kle.residual_grnty_amount,

20247: kle.residual_code,
20248: kle.capital_amount,
20249: kle.delivered_date,
20250: kle.date_funding_required,
20251: kle.residual_grnty_amount,
20252: kle.date_funding,
20253: kle.date_terminated,
20254: kle.residual_value,
20255: kle.date_delivery_expected,

Line 20254: kle.residual_value,

20250: kle.date_funding_required,
20251: kle.residual_grnty_amount,
20252: kle.date_funding,
20253: kle.date_terminated,
20254: kle.residual_value,
20255: kle.date_delivery_expected,
20256: kle.orig_system_id1 old_line_id,
20257: kle.amount,
20258: kle.price_negotiated,

Line 20423: --added by bkatraga for residual streams. Bug 4274539

20419: -- nikshah -- Bug # 5484903 Fixed,
20420: -- Removed CURSOR primary_sty_id_csr definition
20421:
20422:
20423: --added by bkatraga for residual streams. Bug 4274539
20424: l_primary_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE;
20425:
20426: --To get the styid for primary stream purpose Residual Value
20427: CURSOR get_residual_primary_sty_id (l_pdt_id NUMBER, l_contract_start_date DATE)

Line 20426: --To get the styid for primary stream purpose Residual Value

20422:
20423: --added by bkatraga for residual streams. Bug 4274539
20424: l_primary_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE;
20425:
20426: --To get the styid for primary stream purpose Residual Value
20427: CURSOR get_residual_primary_sty_id (l_pdt_id NUMBER, l_contract_start_date DATE)
20428: IS
20429: SELECT PRIMARY_STY_ID
20430: FROM OKL_STRM_TMPT_LINES_UV STL

Line 20427: CURSOR get_residual_primary_sty_id (l_pdt_id NUMBER, l_contract_start_date DATE)

20423: --added by bkatraga for residual streams. Bug 4274539
20424: l_primary_sty_id OKL_ST_GEN_TMPT_LNS.PRIMARY_STY_ID%TYPE;
20425:
20426: --To get the styid for primary stream purpose Residual Value
20427: CURSOR get_residual_primary_sty_id (l_pdt_id NUMBER, l_contract_start_date DATE)
20428: IS
20429: SELECT PRIMARY_STY_ID
20430: FROM OKL_STRM_TMPT_LINES_UV STL
20431: WHERE STL.PRIMARY_YN = 'Y'

Line 20435: AND PRIMARY_STY_PURPOSE = 'RESIDUAL_VALUE';

20431: WHERE STL.PRIMARY_YN = 'Y'
20432: AND STL.PDT_ID = l_pdt_id
20433: AND (STL.START_DATE <= l_contract_start_date)
20434: AND (STL.END_DATE >= l_contract_start_date OR STL.END_DATE IS NULL)
20435: AND PRIMARY_STY_PURPOSE = 'RESIDUAL_VALUE';
20436: -- end bkatraga
20437:
20438:
20439: l_pdt_id_rec l_hdr_pdt_csr%ROWTYPE;

Line 20641: p_primary_sty_purpose =>'RESIDUAL_VALUE_INSURANCE_PREMIUM',

20637: IF(g_rep_req_yn = 'Y') THEN
20638: get_primary_stream_type(
20639: p_khr_id =>p_chr_id,
20640: p_pdt_id =>l_pdt_id_rec.report_pdt_id,
20641: p_primary_sty_purpose =>'RESIDUAL_VALUE_INSURANCE_PREMIUM',
20642: x_return_status => x_return_status,
20643: x_primary_sty_id =>l_sty_id );
20644: IF x_return_status = 'E' THEN
20645: x_return_status := 'S';

Line 20650: p_primary_sty_purpose => 'RESIDUAL_VALUE_INSURANCE_PREMIUM',

20646: END IF;
20647: ELSE
20648: get_primary_stream_type (
20649: p_khr_id => p_chr_id,
20650: p_primary_sty_purpose => 'RESIDUAL_VALUE_INSURANCE_PREMIUM',
20651: x_return_status => x_return_status,
20652: x_primary_sty_id =>l_sty_id
20653: );
20654: IF x_return_status = 'E' THEN

Line 20765: l_csm_line_details_tbl(i).residual_guarantee_method := l_line_rec.residual_code;

20761: --END IF;
20762:
20763: l_csm_line_details_tbl(i).state_depre_dmnshing_value_rt := 0; -- TBD
20764: l_csm_line_details_tbl(i).book_depre_dmnshing_value_rt := 0; -- TBD
20765: l_csm_line_details_tbl(i).residual_guarantee_method := l_line_rec.residual_code;
20766: l_csm_line_details_tbl(i).fed_depre_dmnshing_value_rate := 0; -- TBD
20767: l_csm_line_details_tbl(i).purchase_option := l_purchase_option;
20768: l_csm_line_details_tbl(i).purchase_option_amount := l_purchase_option_amount;
20769: IF l_line_rec.ste_code = 'TERMINATED' THEN

Line 20770: l_csm_line_details_tbl(i).residual_date := l_line_rec.date_terminated;

20766: l_csm_line_details_tbl(i).fed_depre_dmnshing_value_rate := 0; -- TBD
20767: l_csm_line_details_tbl(i).purchase_option := l_purchase_option;
20768: l_csm_line_details_tbl(i).purchase_option_amount := l_purchase_option_amount;
20769: IF l_line_rec.ste_code = 'TERMINATED' THEN
20770: l_csm_line_details_tbl(i).residual_date := l_line_rec.date_terminated;
20771: ELSE
20772: --Added by bkatraga for bug 14822974
20773: l_adv_arrears := 'N';
20774: OPEN l_adv_arrears_csr(p_chr_id, l_line_rec.id);

Line 20779: l_csm_line_details_tbl(i).residual_date := l_hdr_rec.end_date + 1;

20775: FETCH l_adv_arrears_csr INTO l_adv_arrears;
20776: CLOSE l_adv_arrears_csr;
20777:
20778: IF(l_adv_arrears = 'Y' AND l_arrears_pay_dates_option = 'FIRST_DAY_OF_NEXT_PERIOD') THEN
20779: l_csm_line_details_tbl(i).residual_date := l_hdr_rec.end_date + 1;
20780: ELSE
20781: l_csm_line_details_tbl(i).residual_date := l_hdr_rec.end_date;
20782: END IF;
20783: --end bkatraga for bug 14822974

Line 20781: l_csm_line_details_tbl(i).residual_date := l_hdr_rec.end_date;

20777:
20778: IF(l_adv_arrears = 'Y' AND l_arrears_pay_dates_option = 'FIRST_DAY_OF_NEXT_PERIOD') THEN
20779: l_csm_line_details_tbl(i).residual_date := l_hdr_rec.end_date + 1;
20780: ELSE
20781: l_csm_line_details_tbl(i).residual_date := l_hdr_rec.end_date;
20782: END IF;
20783: --end bkatraga for bug 14822974
20784: END IF;
20785: IF l_line_rec.residual_value IS NULL THEN

Line 20785: IF l_line_rec.residual_value IS NULL THEN

20781: l_csm_line_details_tbl(i).residual_date := l_hdr_rec.end_date;
20782: END IF;
20783: --end bkatraga for bug 14822974
20784: END IF;
20785: IF l_line_rec.residual_value IS NULL THEN
20786: l_csm_line_details_tbl(i).residual_amount := 0;
20787: END IF; -- Added by gboomina for BUG 4384784
20788: -- calling the asset mangement API
20789: -- to get the residual value of Terminated line

Line 20786: l_csm_line_details_tbl(i).residual_amount := 0;

20782: END IF;
20783: --end bkatraga for bug 14822974
20784: END IF;
20785: IF l_line_rec.residual_value IS NULL THEN
20786: l_csm_line_details_tbl(i).residual_amount := 0;
20787: END IF; -- Added by gboomina for BUG 4384784
20788: -- calling the asset mangement API
20789: -- to get the residual value of Terminated line
20790: -- Changed the ELSIF to IF by gboomina for BUG 4384784

Line 20789: -- to get the residual value of Terminated line

20785: IF l_line_rec.residual_value IS NULL THEN
20786: l_csm_line_details_tbl(i).residual_amount := 0;
20787: END IF; -- Added by gboomina for BUG 4384784
20788: -- calling the asset mangement API
20789: -- to get the residual value of Terminated line
20790: -- Changed the ELSIF to IF by gboomina for BUG 4384784
20791: IF l_line_rec.ste_code = 'TERMINATED' THEN
20792: -- Start fix for bug 6858487
20793: retrive_orig_hdr_id(p_chr_id, l_orig_chr_id);

Line 20802: l_csm_line_details_tbl(i).residual_amount := okl_am_util_pvt.get_actual_asset_residual(p_khr_id => l_orig_chr_id,

20798: CLOSE c_get_orig_line_id;
20799: ELSE
20800: l_orig_cle_id := l_line_rec.id;
20801: END IF;
20802: l_csm_line_details_tbl(i).residual_amount := okl_am_util_pvt.get_actual_asset_residual(p_khr_id => l_orig_chr_id,
20803: p_kle_id => l_orig_cle_id);
20804:
20805: -- End fix for bug 6858487
20806: -- Changed the ELSE to ELSIF condition by gboomina for BUG 4384784

Line 20807: ELSIF l_line_rec.residual_value IS NOT NULL THEN

20803: p_kle_id => l_orig_cle_id);
20804:
20805: -- End fix for bug 6858487
20806: -- Changed the ELSE to ELSIF condition by gboomina for BUG 4384784
20807: ELSIF l_line_rec.residual_value IS NOT NULL THEN
20808: l_csm_line_details_tbl(i).residual_amount := l_line_rec.residual_value;
20809: END IF;
20810: IF l_line_rec.delivered_date IS NULL THEN
20811: l_csm_line_details_tbl(i).date_delivery := l_line_rec.start_date;

Line 20808: l_csm_line_details_tbl(i).residual_amount := l_line_rec.residual_value;

20804:
20805: -- End fix for bug 6858487
20806: -- Changed the ELSE to ELSIF condition by gboomina for BUG 4384784
20807: ELSIF l_line_rec.residual_value IS NOT NULL THEN
20808: l_csm_line_details_tbl(i).residual_amount := l_line_rec.residual_value;
20809: END IF;
20810: IF l_line_rec.delivered_date IS NULL THEN
20811: l_csm_line_details_tbl(i).date_delivery := l_line_rec.start_date;
20812: ELSE

Line 20815: l_csm_line_details_tbl(i).residual_guarantee_amount := l_line_rec.residual_grnty_amount;

20811: l_csm_line_details_tbl(i).date_delivery := l_line_rec.start_date;
20812: ELSE
20813: l_csm_line_details_tbl(i).date_delivery := l_line_rec.delivered_date;
20814: END IF;
20815: l_csm_line_details_tbl(i).residual_guarantee_amount := l_line_rec.residual_grnty_amount;
20816: --Modified by kthiruva for Pricing Enhancements
20817: --Currently the funding date defaults to the start date for all asset lines
20818: --The funding date is now a user enterable value and hence date_funding should
20819: --obtain its value from the date_funding_expected column.

Line 21299: -- added by bkatraga for residual streams. Bug 4274539

21295: EXIT WHEN(x_return_status = OKL_API.G_RET_STS_ERROR);
21296: END IF;
21297:
21298:
21299: -- added by bkatraga for residual streams. Bug 4274539
21300: IF(l_line_rec.residual_value IS NOT NULL) THEN
21301: -- To get the primary stream purpose Residual Value id into l_primary_sty_id
21302: OPEN get_residual_primary_sty_id(l_hdr_rec.pid, l_hdr_rec.start_date);
21303: FETCH get_residual_primary_sty_id INTO l_primary_sty_id;

Line 21300: IF(l_line_rec.residual_value IS NOT NULL) THEN

21296: END IF;
21297:
21298:
21299: -- added by bkatraga for residual streams. Bug 4274539
21300: IF(l_line_rec.residual_value IS NOT NULL) THEN
21301: -- To get the primary stream purpose Residual Value id into l_primary_sty_id
21302: OPEN get_residual_primary_sty_id(l_hdr_rec.pid, l_hdr_rec.start_date);
21303: FETCH get_residual_primary_sty_id INTO l_primary_sty_id;
21304: CLOSE get_residual_primary_sty_id;

Line 21301: -- To get the primary stream purpose Residual Value id into l_primary_sty_id

21297:
21298:
21299: -- added by bkatraga for residual streams. Bug 4274539
21300: IF(l_line_rec.residual_value IS NOT NULL) THEN
21301: -- To get the primary stream purpose Residual Value id into l_primary_sty_id
21302: OPEN get_residual_primary_sty_id(l_hdr_rec.pid, l_hdr_rec.start_date);
21303: FETCH get_residual_primary_sty_id INTO l_primary_sty_id;
21304: CLOSE get_residual_primary_sty_id;
21305: -- To check if the product is reporting one or not

Line 21302: OPEN get_residual_primary_sty_id(l_hdr_rec.pid, l_hdr_rec.start_date);

21298:
21299: -- added by bkatraga for residual streams. Bug 4274539
21300: IF(l_line_rec.residual_value IS NOT NULL) THEN
21301: -- To get the primary stream purpose Residual Value id into l_primary_sty_id
21302: OPEN get_residual_primary_sty_id(l_hdr_rec.pid, l_hdr_rec.start_date);
21303: FETCH get_residual_primary_sty_id INTO l_primary_sty_id;
21304: CLOSE get_residual_primary_sty_id;
21305: -- To check if the product is reporting one or not
21306: --vdamerla Bug61130937 starts

Line 21303: FETCH get_residual_primary_sty_id INTO l_primary_sty_id;

21299: -- added by bkatraga for residual streams. Bug 4274539
21300: IF(l_line_rec.residual_value IS NOT NULL) THEN
21301: -- To get the primary stream purpose Residual Value id into l_primary_sty_id
21302: OPEN get_residual_primary_sty_id(l_hdr_rec.pid, l_hdr_rec.start_date);
21303: FETCH get_residual_primary_sty_id INTO l_primary_sty_id;
21304: CLOSE get_residual_primary_sty_id;
21305: -- To check if the product is reporting one or not
21306: --vdamerla Bug61130937 starts
21307: IF l_line_rec.ste_code <> 'TERMINATED' THEN

Line 21304: CLOSE get_residual_primary_sty_id;

21300: IF(l_line_rec.residual_value IS NOT NULL) THEN
21301: -- To get the primary stream purpose Residual Value id into l_primary_sty_id
21302: OPEN get_residual_primary_sty_id(l_hdr_rec.pid, l_hdr_rec.start_date);
21303: FETCH get_residual_primary_sty_id INTO l_primary_sty_id;
21304: CLOSE get_residual_primary_sty_id;
21305: -- To check if the product is reporting one or not
21306: --vdamerla Bug61130937 starts
21307: IF l_line_rec.ste_code <> 'TERMINATED' THEN
21308:

Line 21310: -- To get the dependant stream types of purpose Residual Value which have pricing name defined

21306: --vdamerla Bug61130937 starts
21307: IF l_line_rec.ste_code <> 'TERMINATED' THEN
21308:
21309: IF(g_rep_req_yn = 'Y') THEN
21310: -- To get the dependant stream types of purpose Residual Value which have pricing name defined
21311: get_dependent_stream_types
21312: (
21313: p_khr_id =>p_chr_id,
21314: p_pdt_id =>l_pdt_id_rec.report_pdt_id,

Line 23736: FROM DUAL

23732:
23733: CURSOR c_valid_khr_csr(p_khr_id OKC_K_HEADERS_B.ID%TYPE)
23734: IS
23735: SELECT 1
23736: FROM DUAL
23737: WHERE EXISTS (SELECT 1
23738: FROM okc_k_headers_b
23739: WHERE id = p_khr_id);
23740: TYPE sll_date_rec_type IS RECORD (

Line 24338: -- Procedure Name : get_so_residual_value1

24334: END get_so_asset_oec1;
24335: -------------------------------------------------------------------------------------------------
24336: -- Start of Commnets
24337: -- Badrinath Kuchibholta
24338: -- Procedure Name : get_so_residual_value1
24339: -- Description : get_so_residual_value1
24340: -- Business Rules :
24341: -- Parameters : Standard Parameters with p_khr_id, p_kle_id and p_subside_yn
24342: -- Version :

Line 24339: -- Description : get_so_residual_value1

24335: -------------------------------------------------------------------------------------------------
24336: -- Start of Commnets
24337: -- Badrinath Kuchibholta
24338: -- Procedure Name : get_so_residual_value1
24339: -- Description : get_so_residual_value1
24340: -- Business Rules :
24341: -- Parameters : Standard Parameters with p_khr_id, p_kle_id and p_subside_yn
24342: -- Version :
24343: -- End of Commnets

Line 24345: PROCEDURE get_so_residual_value1(p_khr_id IN NUMBER,

24341: -- Parameters : Standard Parameters with p_khr_id, p_kle_id and p_subside_yn
24342: -- Version :
24343: -- End of Commnets
24344: -------------------------------------------------------------------------------------------------
24345: PROCEDURE get_so_residual_value1(p_khr_id IN NUMBER,
24346: p_kle_id IN NUMBER,
24347: p_subside_yn IN VARCHAR2,
24348: x_return_status OUT NOCOPY VARCHAR2,
24349: x_residual_value OUT NOCOPY NUMBER,

Line 24349: x_residual_value OUT NOCOPY NUMBER,

24345: PROCEDURE get_so_residual_value1(p_khr_id IN NUMBER,
24346: p_kle_id IN NUMBER,
24347: p_subside_yn IN VARCHAR2,
24348: x_return_status OUT NOCOPY VARCHAR2,
24349: x_residual_value OUT NOCOPY NUMBER,
24350: x_start_date OUT NOCOPY DATE)
24351: IS
24352: l_return_status VARCHAR2(3):= OKL_API.G_RET_STS_SUCCESS;
24353: l_msg_count NUMBER;

Line 24368: kle_rv.residual_percentage residual_percent,

24364: p_kle_id NUMBER)
24365: IS
24366: SELECT kle_rv.id asset_line_id,
24367: kle_rv.oec oec,
24368: kle_rv.residual_percentage residual_percent,
24369: cle_so.start_date
24370: FROM okc_k_headers_b chr_rv,
24371: okc_line_styles_b lse_rv,
24372: okl_k_lines kle_rv,

Line 24432: IF get_rvs_rec.residual_percent IS NOT NULL THEN

24428: OKL_API.set_message(p_app_name => G_APP_NAME,
24429: p_msg_name => G_CALC_AMOUNT);
24430: EXIT WHEN(l_return_status = OKL_API.G_RET_STS_ERROR);
24431: END IF;
24432: IF get_rvs_rec.residual_percent IS NOT NULL THEN
24433: l_res_val := get_rvs_rec.residual_percent * (get_rvs_rec.oec - nvl(l_dis_amt,0)) /100;
24434: l_tot_res_val := l_tot_res_val + l_res_val;
24435: ELSE
24436: l_tot_res_val := 0;

Line 24433: l_res_val := get_rvs_rec.residual_percent * (get_rvs_rec.oec - nvl(l_dis_amt,0)) /100;

24429: p_msg_name => G_CALC_AMOUNT);
24430: EXIT WHEN(l_return_status = OKL_API.G_RET_STS_ERROR);
24431: END IF;
24432: IF get_rvs_rec.residual_percent IS NOT NULL THEN
24433: l_res_val := get_rvs_rec.residual_percent * (get_rvs_rec.oec - nvl(l_dis_amt,0)) /100;
24434: l_tot_res_val := l_tot_res_val + l_res_val;
24435: ELSE
24436: l_tot_res_val := 0;
24437: EXIT;

Line 24440: IF get_rvs_rec.residual_percent IS NOT NULL THEN

24436: l_tot_res_val := 0;
24437: EXIT;
24438: END IF;
24439: ELSE
24440: IF get_rvs_rec.residual_percent IS NOT NULL THEN
24441: l_res_val := get_rvs_rec.residual_percent * get_rvs_rec.oec /100;
24442: l_tot_res_val := l_tot_res_val + l_res_val;
24443: ELSE
24444: l_tot_res_val := 0;

Line 24441: l_res_val := get_rvs_rec.residual_percent * get_rvs_rec.oec /100;

24437: EXIT;
24438: END IF;
24439: ELSE
24440: IF get_rvs_rec.residual_percent IS NOT NULL THEN
24441: l_res_val := get_rvs_rec.residual_percent * get_rvs_rec.oec /100;
24442: l_tot_res_val := l_tot_res_val + l_res_val;
24443: ELSE
24444: l_tot_res_val := 0;
24445: EXIT;

Line 24453: x_residual_value := l_tot_res_val;

24449: END LOOP;
24450: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
24451: RAISE OKL_API.G_EXCEPTION_ERROR;
24452: END IF;
24453: x_residual_value := l_tot_res_val;
24454: IF (x_residual_value IS NULL) THEN -- bug# 3381546.
24455: OKL_API.set_message(p_app_name => G_APP_NAME,
24456: p_msg_name => G_INVALID_VALUE,
24457: p_token1 => G_COL_NAME_TOKEN,

Line 24454: IF (x_residual_value IS NULL) THEN -- bug# 3381546.

24450: IF l_return_status <> OKL_API.G_RET_STS_SUCCESS THEN
24451: RAISE OKL_API.G_EXCEPTION_ERROR;
24452: END IF;
24453: x_residual_value := l_tot_res_val;
24454: IF (x_residual_value IS NULL) THEN -- bug# 3381546.
24455: OKL_API.set_message(p_app_name => G_APP_NAME,
24456: p_msg_name => G_INVALID_VALUE,
24457: p_token1 => G_COL_NAME_TOKEN,
24458: p_token1_value => 'Residual Value');

Line 24458: p_token1_value => 'Residual Value');

24454: IF (x_residual_value IS NULL) THEN -- bug# 3381546.
24455: OKL_API.set_message(p_app_name => G_APP_NAME,
24456: p_msg_name => G_INVALID_VALUE,
24457: p_token1 => G_COL_NAME_TOKEN,
24458: p_token1_value => 'Residual Value');
24459: RAISE OKL_API.G_EXCEPTION_ERROR;
24460: END IF;
24461: x_return_status := l_return_status;
24462: EXCEPTION

Line 24473: END get_so_residual_value1;

24469: IF get_rvs_csr%ISOPEN THEN
24470: CLOSE get_rvs_csr;
24471: END IF;
24472: x_return_status := OKL_API.G_RET_STS_ERROR;
24473: END get_so_residual_value1;
24474:
24475: -------------------------------------------------------------------------------------------------
24476: -- Start of Commnets
24477: -- Santhosh Siruvole

Line 24485: PROCEDURE get_so_residual_value(p_khr_id IN NUMBER,

24481: -- Parameters : Standard Parameters with p_khr_id, p_kle_id and p_subside_yn
24482: -- Version :
24483: -- End of Commnets
24484: -------------------------------------------------------------------------------------------------
24485: PROCEDURE get_so_residual_value(p_khr_id IN NUMBER,
24486: p_kle_id IN NUMBER,
24487: p_subside_yn IN VARCHAR2,
24488: x_return_status OUT NOCOPY VARCHAR2,
24489: x_residual_value OUT NOCOPY NUMBER,

Line 24489: x_residual_value OUT NOCOPY NUMBER,

24485: PROCEDURE get_so_residual_value(p_khr_id IN NUMBER,
24486: p_kle_id IN NUMBER,
24487: p_subside_yn IN VARCHAR2,
24488: x_return_status OUT NOCOPY VARCHAR2,
24489: x_residual_value OUT NOCOPY NUMBER,
24490: x_start_date OUT NOCOPY DATE)
24491: IS
24492: l_return_status VARCHAR2(3):= OKL_API.G_RET_STS_SUCCESS;
24493: l_msg_count NUMBER;

Line 24520: p_formula_name => 'LINE_RESIDUAL_VALUE',

24516: p_init_msg_list => OKL_API.G_TRUE,
24517: x_return_status => l_return_status,
24518: x_msg_count => l_msg_count,
24519: x_msg_data => l_msg_data,
24520: p_formula_name => 'LINE_RESIDUAL_VALUE',
24521: p_contract_id => p_khr_id,
24522: p_line_id => p_kle_id,
24523: x_value => x_residual_value);
24524: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

Line 24523: x_value => x_residual_value);

24519: x_msg_data => l_msg_data,
24520: p_formula_name => 'LINE_RESIDUAL_VALUE',
24521: p_contract_id => p_khr_id,
24522: p_line_id => p_kle_id,
24523: x_value => x_residual_value);
24524: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
24525: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
24526: ELSIF l_return_status = OKL_API.G_RET_STS_ERROR THEN
24527: RAISE OKL_API.G_EXCEPTION_ERROR;

Line 24534: get_so_residual_value1(p_khr_id => p_khr_id,

24530: x_start_date := khr_type_rec.start_date;
24531:
24532: Else
24533:
24534: get_so_residual_value1(p_khr_id => p_khr_id,
24535: p_kle_id => p_kle_id,
24536: p_subside_yn => p_subside_yn,
24537: x_return_status => x_return_status,
24538: x_residual_value => x_residual_value,

Line 24538: x_residual_value => x_residual_value,

24534: get_so_residual_value1(p_khr_id => p_khr_id,
24535: p_kle_id => p_kle_id,
24536: p_subside_yn => p_subside_yn,
24537: x_return_status => x_return_status,
24538: x_residual_value => x_residual_value,
24539: x_start_date => x_start_date);
24540:
24541: End If;
24542:

Line 24555: End get_so_residual_value;

24551: CLOSE khr_type_csr;
24552: END IF;
24553: x_return_status := OKL_API.G_RET_STS_ERROR;
24554:
24555: End get_so_residual_value;
24556:
24557: -------------------------------------------------------------------------------------------------
24558: -- Start of Commnets
24559: -- Santhosh Siruvole

Line 24778: kle.residual_code,

24774: CURSOR l_line_rec_csr(chrid NUMBER, lnetype VARCHAR2)
24775: IS
24776: SELECT kle.id,
24777: kle.oec,
24778: kle.residual_code,
24779: kle.capital_amount,
24780: kle.delivered_date,
24781: kle.date_funding_required,
24782: kle.residual_grnty_amount,

Line 24782: kle.residual_grnty_amount,

24778: kle.residual_code,
24779: kle.capital_amount,
24780: kle.delivered_date,
24781: kle.date_funding_required,
24782: kle.residual_grnty_amount,
24783: kle.residual_code guarantee_type,
24784: kle.date_funding,
24785: kle.residual_value,
24786: kle.amount,

Line 24783: kle.residual_code guarantee_type,

24779: kle.capital_amount,
24780: kle.delivered_date,
24781: kle.date_funding_required,
24782: kle.residual_grnty_amount,
24783: kle.residual_code guarantee_type,
24784: kle.date_funding,
24785: kle.residual_value,
24786: kle.amount,
24787: kle.price_negotiated,

Line 24785: kle.residual_value,

24781: kle.date_funding_required,
24782: kle.residual_grnty_amount,
24783: kle.residual_code guarantee_type,
24784: kle.date_funding,
24785: kle.residual_value,
24786: kle.amount,
24787: kle.price_negotiated,
24788: kle.start_date,
24789: kle.end_date,

Line 24814: kle.residual_code,

24810: CURSOR l_so_line_rec_csr(p_chr_id NUMBER, p_cle_id NUMBER)
24811: IS
24812: SELECT kle.id,
24813: kle.oec,
24814: kle.residual_code,
24815: kle.capital_amount,
24816: kle.delivered_date,
24817: kle.date_funding_required,
24818: kle.residual_grnty_amount,

Line 24818: kle.residual_grnty_amount,

24814: kle.residual_code,
24815: kle.capital_amount,
24816: kle.delivered_date,
24817: kle.date_funding_required,
24818: kle.residual_grnty_amount,
24819: kle.date_funding,
24820: kle.residual_value,
24821: kle.amount,
24822: kle.price_negotiated,

Line 24820: kle.residual_value,

24816: kle.delivered_date,
24817: kle.date_funding_required,
24818: kle.residual_grnty_amount,
24819: kle.date_funding,
24820: kle.residual_value,
24821: kle.amount,
24822: kle.price_negotiated,
24823: kle.start_date,
24824: kle.end_date,

Line 24979: FROM dual

24975: -- To check if the chr_id has Financed fee feetype defined
24976: CURSOR l_financed_type_csr (chrId NUMBER)
24977: IS
24978: SELECT 1
24979: FROM dual
24980: WHERE EXISTS (SELECT 1
24981: FROM okc_k_lines_b cle,
24982: okc_line_styles_b lse,
24983: okl_k_lines kle

Line 25211: -- Fetching the Header rule for Residual value insurance premium

25207: CLOSE ib_csr;
25208: l_csm_lease_header.country := l_ib_rec.country;
25209: l_csm_lease_header.orp_code := OKL_CREATE_STREAMS_PUB.G_ORP_CODE_BOOKING;
25210: l_csm_lease_header.rvi_yn := OKL_CREATE_STREAMS_PUB.G_FND_NO;
25211: -- Fetching the Header rule for Residual value insurance premium
25212: OPEN l_hdrrl_csr('LARVIN', 'LARVAU', TO_NUMBER(p_chr_id));
25213: FETCH l_hdrrl_csr INTO l_hdrrl_rec;
25214: CLOSE l_hdrrl_csr;
25215: IF l_hdrrl_rec.rule_information1 = 'Y' THEN

Line 25223: p_primary_sty_purpose =>'RESIDUAL_VALUE_INSURANCE_PREMIUM',

25219: get_primary_stream_type
25220: (
25221: p_khr_id =>p_chr_id,
25222: p_pdt_id =>l_pdt_id_rec.report_pdt_id,
25223: p_primary_sty_purpose =>'RESIDUAL_VALUE_INSURANCE_PREMIUM',
25224: x_return_status => x_return_status,
25225: x_primary_sty_id =>l_sty_id
25226: );
25227:

Line 25233: p_primary_sty_purpose => 'RESIDUAL_VALUE_INSURANCE_PREMIUM',

25229:
25230: get_primary_stream_type
25231: (
25232: p_khr_id => p_chr_id,
25233: p_primary_sty_purpose => 'RESIDUAL_VALUE_INSURANCE_PREMIUM',
25234: x_return_status => x_return_status,
25235: x_primary_sty_id =>l_sty_id
25236: );
25237:

Line 25244: AND name = 'RESIDUAL VALUE INSURANCE PREMIUM';

25240: SELECT nvl(id,-1)
25241: INTO styid
25242: FROM okl_strm_type_tl
25243: WHERE LANGUAGE = 'US'
25244: AND name = 'RESIDUAL VALUE INSURANCE PREMIUM';
25245: IF styid = -1 THEN
25246: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
25247: END IF;
25248: */

Line 25292: l_csm_line_details_tbl(i).residual_guarantee_method := l_line_rec.residual_code;

25288: i := i + 1;
25289: l_csm_line_details_tbl(i).kle_asset_id := l_line_rec.id;
25290: l_csm_line_details_tbl(i).state_depre_dmnshing_value_rt := 0;
25291: l_csm_line_details_tbl(i).book_depre_dmnshing_value_rt := 0;
25292: l_csm_line_details_tbl(i).residual_guarantee_method := l_line_rec.residual_code;
25293: l_csm_line_details_tbl(i).fed_depre_dmnshing_value_rate := 0;
25294: l_csm_line_details_tbl(i).purchase_option := l_purchase_option;
25295: l_csm_line_details_tbl(i).purchase_option_amount := l_purchase_option_amount;
25296:

Line 25386: IF l_line_rec.residual_value IS NULL THEN

25382: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR);
25383: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
25384: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
25385: END IF;
25386: IF l_line_rec.residual_value IS NULL THEN
25387: l_csm_line_details_tbl(i).residual_amount := 0;
25388: ELSE
25389: l_csm_line_details_tbl(i).residual_amount := l_line_rec.residual_value;
25390: END IF;

Line 25387: l_csm_line_details_tbl(i).residual_amount := 0;

25383: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
25384: EXIT WHEN (x_return_status = OKL_API.G_RET_STS_ERROR);
25385: END IF;
25386: IF l_line_rec.residual_value IS NULL THEN
25387: l_csm_line_details_tbl(i).residual_amount := 0;
25388: ELSE
25389: l_csm_line_details_tbl(i).residual_amount := l_line_rec.residual_value;
25390: END IF;
25391: IF l_line_rec.delivered_date IS NULL THEN

Line 25389: l_csm_line_details_tbl(i).residual_amount := l_line_rec.residual_value;

25385: END IF;
25386: IF l_line_rec.residual_value IS NULL THEN
25387: l_csm_line_details_tbl(i).residual_amount := 0;
25388: ELSE
25389: l_csm_line_details_tbl(i).residual_amount := l_line_rec.residual_value;
25390: END IF;
25391: IF l_line_rec.delivered_date IS NULL THEN
25392: l_csm_line_details_tbl(i).date_delivery := l_line_rec.start_date;
25393: ELSE

Line 25396: l_csm_line_details_tbl(i).residual_guarantee_amount := l_line_rec.residual_grnty_amount;

25392: l_csm_line_details_tbl(i).date_delivery := l_line_rec.start_date;
25393: ELSE
25394: l_csm_line_details_tbl(i).date_delivery := l_line_rec.delivered_date;
25395: END IF;
25396: l_csm_line_details_tbl(i).residual_guarantee_amount := l_line_rec.residual_grnty_amount;
25397: IF l_line_rec.residual_grnty_amount IS NOT NULL OR
25398: l_line_rec.residual_grnty_amount <> OKL_API.G_MISS_NUM THEN
25399: l_csm_line_details_tbl(i).guarantee_type := l_line_rec.guarantee_type;
25400: END IF;

Line 25397: IF l_line_rec.residual_grnty_amount IS NOT NULL OR

25393: ELSE
25394: l_csm_line_details_tbl(i).date_delivery := l_line_rec.delivered_date;
25395: END IF;
25396: l_csm_line_details_tbl(i).residual_guarantee_amount := l_line_rec.residual_grnty_amount;
25397: IF l_line_rec.residual_grnty_amount IS NOT NULL OR
25398: l_line_rec.residual_grnty_amount <> OKL_API.G_MISS_NUM THEN
25399: l_csm_line_details_tbl(i).guarantee_type := l_line_rec.guarantee_type;
25400: END IF;
25401: --smahapat changed 03/13/04

Line 25398: l_line_rec.residual_grnty_amount <> OKL_API.G_MISS_NUM THEN

25394: l_csm_line_details_tbl(i).date_delivery := l_line_rec.delivered_date;
25395: END IF;
25396: l_csm_line_details_tbl(i).residual_guarantee_amount := l_line_rec.residual_grnty_amount;
25397: IF l_line_rec.residual_grnty_amount IS NOT NULL OR
25398: l_line_rec.residual_grnty_amount <> OKL_API.G_MISS_NUM THEN
25399: l_csm_line_details_tbl(i).guarantee_type := l_line_rec.guarantee_type;
25400: END IF;
25401: --smahapat changed 03/13/04
25402: --cannot support until field populated by authoring since field mandatory