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.

[Home] [Help]

APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_CREATE_STREAMS_PUB

Line 1714: PROCEDURE print_lease_tables(p_rents_tbl_in IN Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type,

1710: print_debug('error in procedure print_loan_tables');
1711: print_debug('sqlcode : ' || sqlcode || ' $ sqlerrm : ' || sqlerrm);
1712: END print_loan_tables;
1713:
1714: PROCEDURE print_lease_tables(p_rents_tbl_in IN Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type,
1715: p_csm_line_details_tbl IN okl_create_streams_pvt.csm_line_details_tbl_type) IS
1716: l_api_name CONSTANT VARCHAR2(30) := 'print_lease_tables';
1717: i NUMBER;
1718: l_source Number;

Line 1719: l_rents_tbl_in Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;

1715: p_csm_line_details_tbl IN okl_create_streams_pvt.csm_line_details_tbl_type) IS
1716: l_api_name CONSTANT VARCHAR2(30) := 'print_lease_tables';
1717: i NUMBER;
1718: l_source Number;
1719: l_rents_tbl_in Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
1720: l_csm_line_details_tbl okl_create_streams_pvt.csm_line_details_tbl_type;
1721: BEGIN
1722: l_rents_tbl_in := p_rents_tbl_in;
1723: l_csm_line_details_tbl := p_csm_line_details_tbl;

Line 10178: l_rents_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;

10174: l_vipv_rec vipv_rec;
10175: x_vipv_rec vipv_rec;
10176: l_skip_prc_engine VARCHAR2(1) := OKL_API.G_FALSE;
10177: --l_rents_tbl and l_rents_tbl_in used for lease processing
10178: l_rents_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
10179: l_rents_tbl_in Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
10180: --l_rents_prin_tbl used for loan processing
10181: l_rents_prin_tbl csm_periodic_expenses_tbl_type;
10182: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;

Line 10179: l_rents_tbl_in Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;

10175: x_vipv_rec vipv_rec;
10176: l_skip_prc_engine VARCHAR2(1) := OKL_API.G_FALSE;
10177: --l_rents_tbl and l_rents_tbl_in used for lease processing
10178: l_rents_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
10179: l_rents_tbl_in Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
10180: --l_rents_prin_tbl used for loan processing
10181: l_rents_prin_tbl csm_periodic_expenses_tbl_type;
10182: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
10183: l_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;

Line 10185: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;

10181: l_rents_prin_tbl csm_periodic_expenses_tbl_type;
10182: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
10183: l_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
10184: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
10185: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;
10186: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
10187: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;
10188: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
10189: --p_csm_loan_levels_tbl csm_loan_level_tbl_type;

Line 10186: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;

10182: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
10183: l_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
10184: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
10185: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;
10186: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
10187: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;
10188: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
10189: --p_csm_loan_levels_tbl csm_loan_level_tbl_type;
10190: l_csm_loan_levels_tbl_in csm_loan_level_tbl_type;

Line 10187: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;

10183: l_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
10184: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
10185: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;
10186: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
10187: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;
10188: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
10189: --p_csm_loan_levels_tbl csm_loan_level_tbl_type;
10190: l_csm_loan_levels_tbl_in csm_loan_level_tbl_type;
10191: l_csm_lease_header okl_create_streams_pvt.csm_lease_rec_type;

Line 10188: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;

10184: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
10185: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;
10186: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
10187: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;
10188: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
10189: --p_csm_loan_levels_tbl csm_loan_level_tbl_type;
10190: l_csm_loan_levels_tbl_in csm_loan_level_tbl_type;
10191: l_csm_lease_header okl_create_streams_pvt.csm_lease_rec_type;
10192: l_csm_line_details_tbl okl_create_streams_pvt.csm_line_details_tbl_type;

Line 10193: l_req_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;

10189: --p_csm_loan_levels_tbl csm_loan_level_tbl_type;
10190: l_csm_loan_levels_tbl_in csm_loan_level_tbl_type;
10191: l_csm_lease_header okl_create_streams_pvt.csm_lease_rec_type;
10192: l_csm_line_details_tbl okl_create_streams_pvt.csm_line_details_tbl_type;
10193: l_req_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
10194:
10195: l_index NUMBER := 0;
10196: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
10197: l_api_name CONSTANT VARCHAR2(30) := 'initiate_request';

Line 10469: l_csm_loan_header.orp_code := Okl_Create_Streams_Pub.G_ORP_CODE_VARIABLE_INTEREST;

10465: print_debug('Contents of l_csm_loan_levels_tbl after call to OKL_LA_STREAM_PUB.extract_params_loan.');
10466: print_loan_tables(p_rent_tbl => l_rents_prin_tbl,
10467: p_csm_loan_level_tbl => l_csm_loan_levels_tbl);
10468:
10469: l_csm_loan_header.orp_code := Okl_Create_Streams_Pub.G_ORP_CODE_VARIABLE_INTEREST;
10470: l_csm_stream_types_tbl.DELETE;
10471: l_total_lending := 0;
10472: l_rents_prin_tbl.delete;
10473: l_sequence := 0;

Line 10480: --CHECK FOR level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL

10476: l_loan_levels_cntr := l_csm_loan_levels_tbl.first;
10477: LOOP
10478: EXIT WHEN l_loan_levels_cntr IS NULL;
10479:
10480: --CHECK FOR level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL
10481: --DO NOT MAKE A PRICING CALL IN THIS CASE
10482: --for Principal Payments only
10483: IF(l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL)
10484: AND (l_csm_loan_levels_tbl(l_loan_levels_cntr).lock_level_step = 'false' OR l_csm_loan_levels_tbl(l_loan_levels_cntr).lock_level_step = OKC_API.G_MISS_CHAR) THEN

Line 10483: IF(l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL)

10479:
10480: --CHECK FOR level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL
10481: --DO NOT MAKE A PRICING CALL IN THIS CASE
10482: --for Principal Payments only
10483: IF(l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL)
10484: AND (l_csm_loan_levels_tbl(l_loan_levels_cntr).lock_level_step = 'false' OR l_csm_loan_levels_tbl(l_loan_levels_cntr).lock_level_step = OKC_API.G_MISS_CHAR) THEN
10485: --call var_int_rent_level passing the level payments and interest rate
10486:
10487: IF (l_csm_loan_levels_tbl(l_loan_levels_cntr).period = 'T') THEN

Line 10535: l_rents_prin_tbl(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;

10531: l_rents_prin_tbl(l_loan_levels_cntr).level_type := l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type;
10532: l_rents_prin_tbl(l_loan_levels_cntr).amount := l_csm_loan_levels_tbl(l_loan_levels_cntr).amount;
10533: l_rents_prin_tbl(l_loan_levels_cntr).advance_or_arrears := l_csm_loan_levels_tbl(l_loan_levels_cntr).advance_or_arrears;
10534: l_rents_prin_tbl(l_loan_levels_cntr).period := l_csm_loan_levels_tbl(l_loan_levels_cntr).period;
10535: l_rents_prin_tbl(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;
10536: l_rents_prin_tbl(l_loan_levels_cntr).first_payment_date := l_level_date_start;
10537: l_rents_prin_tbl(l_loan_levels_cntr).rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
10538:
10539: /* l_rents_prin_tbl(l_loan_levels_cntr).kle_asset_id := l_csm_loan_levels_tbl(l_loan_levels_cntr).kle_loan_id;

Line 10541: l_rents_prin_tbl(l_loan_levels_cntr).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;

10537: l_rents_prin_tbl(l_loan_levels_cntr).rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
10538:
10539: /* l_rents_prin_tbl(l_loan_levels_cntr).kle_asset_id := l_csm_loan_levels_tbl(l_loan_levels_cntr).kle_loan_id;
10540: l_rents_prin_tbl(l_loan_levels_cntr).income_or_expense := l_csm_loan_levels_tbl(l_loan_levels_cntr).income_or_expense;
10541: l_rents_prin_tbl(l_loan_levels_cntr).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;
10542: l_rents_prin_tbl(l_loan_levels_cntr).structure := l_csm_loan_levels_tbl(l_loan_levels_cntr).structure;
10543: l_rents_prin_tbl(l_loan_levels_cntr).days_in_month := l_csm_loan_levels_tbl(l_loan_levels_cntr).days_in_month;
10544: l_rents_prin_tbl(l_loan_levels_cntr).days_in_year := l_csm_loan_levels_tbl(l_loan_levels_cntr).days_in_year;
10545: */ END IF;

Line 10548: ELSIF(l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PAYMENT)

10544: l_rents_prin_tbl(l_loan_levels_cntr).days_in_year := l_csm_loan_levels_tbl(l_loan_levels_cntr).days_in_year;
10545: */ END IF;
10546: --CHECK FOR RENT PAYMENT
10547: --for Rent and Unscheduled Principal Paydown
10548: ELSIF(l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PAYMENT)
10549: OR (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL AND
10550: l_csm_loan_levels_tbl(l_loan_levels_cntr).lock_level_step = Okl_Create_Streams_Pub.G_LOCK_AMOUNT) THEN
10551: --if(j = 1) THEN
10552: --l_loan_levels_date_start := l_csm_loan_levels_tbl(l_loan_levels_cntr).date_start;

Line 10549: OR (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL AND

10545: */ END IF;
10546: --CHECK FOR RENT PAYMENT
10547: --for Rent and Unscheduled Principal Paydown
10548: ELSIF(l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PAYMENT)
10549: OR (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL AND
10550: l_csm_loan_levels_tbl(l_loan_levels_cntr).lock_level_step = Okl_Create_Streams_Pub.G_LOCK_AMOUNT) THEN
10551: --if(j = 1) THEN
10552: --l_loan_levels_date_start := l_csm_loan_levels_tbl(l_loan_levels_cntr).date_start;
10553: IF (l_csm_loan_levels_tbl(l_loan_levels_cntr).period = 'T') THEN

Line 10550: l_csm_loan_levels_tbl(l_loan_levels_cntr).lock_level_step = Okl_Create_Streams_Pub.G_LOCK_AMOUNT) THEN

10546: --CHECK FOR RENT PAYMENT
10547: --for Rent and Unscheduled Principal Paydown
10548: ELSIF(l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PAYMENT)
10549: OR (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL AND
10550: l_csm_loan_levels_tbl(l_loan_levels_cntr).lock_level_step = Okl_Create_Streams_Pub.G_LOCK_AMOUNT) THEN
10551: --if(j = 1) THEN
10552: --l_loan_levels_date_start := l_csm_loan_levels_tbl(l_loan_levels_cntr).date_start;
10553: IF (l_csm_loan_levels_tbl(l_loan_levels_cntr).period = 'T') THEN
10554: l_loan_levels_date_start := get_pay_level_start_date(l_csm_loan_levels_tbl(l_loan_levels_cntr).kle_loan_id,

Line 10590: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;

10586: END IF;
10587:
10588: l_csm_loan_levels_tbl_in(l_loan_levels_cntr) := l_csm_loan_levels_tbl(l_loan_levels_cntr);
10589: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).level_index_number := l_sequence;
10590: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;
10591: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
10592: IF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PAYMENT) THEN
10593: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;
10594: ELSIF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL) THEN

Line 10592: IF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PAYMENT) THEN

10588: l_csm_loan_levels_tbl_in(l_loan_levels_cntr) := l_csm_loan_levels_tbl(l_loan_levels_cntr);
10589: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).level_index_number := l_sequence;
10590: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;
10591: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
10592: IF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PAYMENT) THEN
10593: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;
10594: ELSIF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL) THEN
10595: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_BOTH;
10596: END IF;

Line 10593: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;

10589: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).level_index_number := l_sequence;
10590: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;
10591: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
10592: IF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PAYMENT) THEN
10593: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;
10594: ELSIF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL) THEN
10595: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_BOTH;
10596: END IF;
10597: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).date_start := l_level_date_start;

Line 10594: ELSIF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL) THEN

10590: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;
10591: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
10592: IF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PAYMENT) THEN
10593: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;
10594: ELSIF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL) THEN
10595: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_BOTH;
10596: END IF;
10597: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).date_start := l_level_date_start;
10598: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).number_of_periods := l_number_of_periods;

Line 10595: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_BOTH;

10591: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
10592: IF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PAYMENT) THEN
10593: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;
10594: ELSIF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL) THEN
10595: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_BOTH;
10596: END IF;
10597: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).date_start := l_level_date_start;
10598: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).number_of_periods := l_number_of_periods;
10599: END IF;

Line 10600: ELSIF(l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_FUNDING) THEN

10596: END IF;
10597: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).date_start := l_level_date_start;
10598: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).number_of_periods := l_number_of_periods;
10599: END IF;
10600: ELSIF(l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_FUNDING) THEN
10601: --is the below code OK
10602: --will this table, l_csm_loan_levels_tbl, have more than 1 row
10603: --looks like each row is being populated with the principal at the contract level and
10604: --not at the asset level

Line 10619: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;

10615: END IF;
10616:
10617: l_csm_loan_levels_tbl_in(l_loan_levels_cntr) := l_csm_loan_levels_tbl(l_loan_levels_cntr);
10618: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).level_index_number := l_sequence;
10619: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;
10620:
10621: --if the level type is not Principal Paydown then
10622: --get the principal balance
10623: IF (NVL(l_csm_loan_levels_tbl_in(l_loan_levels_cntr).period, 'DMF') <> 'T') THEN

Line 10705: Okl_Create_Streams_Pub.Create_Streams_Loan_Restr(p_api_version => p_api_version,

10701: print_debug('Before pricing call.');
10702: print_loan_tables(p_rent_tbl => l_rents_prin_tbl,
10703: p_csm_loan_level_tbl => l_csm_loan_levels_tbl_in);
10704:
10705: Okl_Create_Streams_Pub.Create_Streams_Loan_Restr(p_api_version => p_api_version,
10706: p_init_msg_list => p_init_msg_list,
10707: p_skip_prc_engine => l_skip_prc_engine,
10708: p_csm_loan_header => l_csm_loan_header,
10709: p_csm_loan_lines_tbl => l_csm_loan_lines_tbl,

Line 10818: l_csm_lease_header.orp_code := OKL_CREATE_STREAMS_PUB.G_ORP_CODE_VARIABLE_INTEREST;

10814: print_debug('Contents of l_rents_tbl and l_csm_line_details_tbl after call to Extract params.');
10815: print_lease_tables(p_rents_tbl_in => l_rents_tbl,
10816: p_csm_line_details_tbl => l_csm_line_details_tbl);
10817:
10818: l_csm_lease_header.orp_code := OKL_CREATE_STREAMS_PUB.G_ORP_CODE_VARIABLE_INTEREST;
10819: l_csm_lease_header.implicit_interest_rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
10820: l_csm_lease_header.date_payments_commencement := l_start_date;
10821: l_csm_lease_header.date_delivery := l_start_date;
10822: l_csm_lease_header.term := l_remaining_term_in_months;

Line 10889: --REPLACE THE BELOW VALUE OF NULL WITH Okl_Create_Streams_Pub.G_LOCK_RATE

10885: IF (l_number_of_periods > 0) THEN
10886: l_rents_tbl_in(l_rent_cntr) := l_rents_tbl(l_rent_cntr);
10887: l_rents_tbl_in(l_rent_cntr).number_of_periods := l_number_of_periods;
10888: --l_rents_tbl_in(l_rent_cntr).amount := 0;
10889: --REPLACE THE BELOW VALUE OF NULL WITH Okl_Create_Streams_Pub.G_LOCK_RATE
10890: l_rents_tbl_in(l_rent_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;
10891: --Check the following with Susan
10892: --IN THE TABLE l_rents_tbl, OVERWRITE ONLY number_of_periods
10893: --AND DATE_START FOR THE FIRST PERIOD FROM WHICH REAMORT WILL

Line 10890: l_rents_tbl_in(l_rent_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;

10886: l_rents_tbl_in(l_rent_cntr) := l_rents_tbl(l_rent_cntr);
10887: l_rents_tbl_in(l_rent_cntr).number_of_periods := l_number_of_periods;
10888: --l_rents_tbl_in(l_rent_cntr).amount := 0;
10889: --REPLACE THE BELOW VALUE OF NULL WITH Okl_Create_Streams_Pub.G_LOCK_RATE
10890: l_rents_tbl_in(l_rent_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;
10891: --Check the following with Susan
10892: --IN THE TABLE l_rents_tbl, OVERWRITE ONLY number_of_periods
10893: --AND DATE_START FOR THE FIRST PERIOD FROM WHICH REAMORT WILL
10894: --BE EFFECTIVE

Line 10898: --l_rents_tbl(1).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;

10894: --BE EFFECTIVE
10895: --l_rents_tbl(1).period := 'M';
10896: l_rents_tbl_in(l_rent_cntr).rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
10897: --l_rents_tbl(1).level_index_number := 1;
10898: --l_rents_tbl(1).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
10899: --l_rents_tbl(1).advance_or_arrears := OKL_CREATE_STREAMS_PUB.G_ARREARS;
10900: --l_rents_tbl(1).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
10901: l_rents_tbl_in(l_rent_cntr).date_start := l_level_date_start;
10902: --BELOW VALUE MUST BE SET TO 'Y'

Line 10899: --l_rents_tbl(1).advance_or_arrears := OKL_CREATE_STREAMS_PUB.G_ARREARS;

10895: --l_rents_tbl(1).period := 'M';
10896: l_rents_tbl_in(l_rent_cntr).rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
10897: --l_rents_tbl(1).level_index_number := 1;
10898: --l_rents_tbl(1).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
10899: --l_rents_tbl(1).advance_or_arrears := OKL_CREATE_STREAMS_PUB.G_ARREARS;
10900: --l_rents_tbl(1).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
10901: l_rents_tbl_in(l_rent_cntr).date_start := l_level_date_start;
10902: --BELOW VALUE MUST BE SET TO 'Y'
10903: l_rents_tbl_in(l_rent_cntr).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;

Line 10900: --l_rents_tbl(1).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;

10896: l_rents_tbl_in(l_rent_cntr).rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
10897: --l_rents_tbl(1).level_index_number := 1;
10898: --l_rents_tbl(1).level_type := OKL_CREATE_STREAMS_PUB.G_SFE_LEVEL_PAYMENT;
10899: --l_rents_tbl(1).advance_or_arrears := OKL_CREATE_STREAMS_PUB.G_ARREARS;
10900: --l_rents_tbl(1).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
10901: l_rents_tbl_in(l_rent_cntr).date_start := l_level_date_start;
10902: --BELOW VALUE MUST BE SET TO 'Y'
10903: l_rents_tbl_in(l_rent_cntr).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;
10904: --l_sequence := l_sequence + 1;

Line 10903: l_rents_tbl_in(l_rent_cntr).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;

10899: --l_rents_tbl(1).advance_or_arrears := OKL_CREATE_STREAMS_PUB.G_ARREARS;
10900: --l_rents_tbl(1).income_or_expense := OKL_CREATE_STREAMS_PUB.G_INCOME;
10901: l_rents_tbl_in(l_rent_cntr).date_start := l_level_date_start;
10902: --BELOW VALUE MUST BE SET TO 'Y'
10903: l_rents_tbl_in(l_rent_cntr).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;
10904: --l_sequence := l_sequence + 1;
10905: IF (NVl(l_prev_kle_id, -99) <> l_rents_tbl(l_rent_cntr).kle_asset_id) THEN
10906: --reset the sequence for the level_index_number for each asset
10907: l_sequence := 1;

Line 10974: Okl_Create_Streams_Pub.CREATE_STREAMS_LEASE_RESTR(

10970: print_lease_tables(p_rents_tbl_in => l_rents_tbl_in,
10971: p_csm_line_details_tbl => l_csm_line_details_tbl);
10972:
10973: --Call Supertrump API to submit request.
10974: Okl_Create_Streams_Pub.CREATE_STREAMS_LEASE_RESTR(
10975: p_api_version => p_api_version,
10976: p_init_msg_list => p_init_msg_list,
10977: x_return_status => x_return_status,
10978: x_msg_count => x_msg_count,