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_VAR_INT_REAMORT_PVT dependencies on OKL_CREATE_STREAMS_PUB

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

157: END print_loan_tables;
158:
159:
160:
161: PROCEDURE print_lease_tables(p_rents_tbl_in IN Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type,
162: p_csm_line_details_tbl IN okl_create_streams_pvt.csm_line_details_tbl_type) IS
163: l_api_name CONSTANT VARCHAR2(30) := 'print_lease_tables';
164: i NUMBER;
165: l_source Number;

Line 166: l_rents_tbl_in Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;

162: p_csm_line_details_tbl IN okl_create_streams_pvt.csm_line_details_tbl_type) IS
163: l_api_name CONSTANT VARCHAR2(30) := 'print_lease_tables';
164: i NUMBER;
165: l_source Number;
166: l_rents_tbl_in Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
167: l_csm_line_details_tbl okl_create_streams_pvt.csm_line_details_tbl_type;
168: BEGIN
169: l_rents_tbl_in := p_rents_tbl_in;
170: l_csm_line_details_tbl := p_csm_line_details_tbl;

Line 1469: l_rents_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;

1465: l_vipv_rec OKL_VARIABLE_INTEREST_PVT.vipv_rec;
1466: x_vipv_rec OKL_VARIABLE_INTEREST_PVT.vipv_rec;
1467: l_skip_prc_engine VARCHAR2(1) := OKL_API.G_FALSE;
1468: --l_rents_tbl and l_rents_tbl_in used for lease processing
1469: l_rents_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
1470: l_rents_tbl_in Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
1471: --l_rents_prin_tbl used for loan processing
1472: l_rents_prin_tbl OKL_VARIABLE_INTEREST_PVT.csm_periodic_expenses_tbl_type;
1473: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;

Line 1470: l_rents_tbl_in Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;

1466: x_vipv_rec OKL_VARIABLE_INTEREST_PVT.vipv_rec;
1467: l_skip_prc_engine VARCHAR2(1) := OKL_API.G_FALSE;
1468: --l_rents_tbl and l_rents_tbl_in used for lease processing
1469: l_rents_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
1470: l_rents_tbl_in Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
1471: --l_rents_prin_tbl used for loan processing
1472: l_rents_prin_tbl OKL_VARIABLE_INTEREST_PVT.csm_periodic_expenses_tbl_type;
1473: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
1474: l_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;

Line 1476: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;

1472: l_rents_prin_tbl OKL_VARIABLE_INTEREST_PVT.csm_periodic_expenses_tbl_type;
1473: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
1474: l_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
1475: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
1476: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;
1477: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
1478: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;
1479: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
1480: l_csm_loan_levels_tbl_in OKL_VARIABLE_INTEREST_PVT.csm_loan_level_tbl_type;

Line 1477: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;

1473: l_csm_loan_header okl_create_streams_pvt.csm_loan_rec_type;
1474: l_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
1475: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
1476: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;
1477: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
1478: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;
1479: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
1480: l_csm_loan_levels_tbl_in OKL_VARIABLE_INTEREST_PVT.csm_loan_level_tbl_type;
1481: l_csm_lease_header okl_create_streams_pvt.csm_lease_rec_type;

Line 1478: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;

1474: l_csm_loan_lines_tbl okl_create_streams_pvt.csm_loan_line_tbl_type;
1475: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
1476: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;
1477: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
1478: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;
1479: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
1480: l_csm_loan_levels_tbl_in OKL_VARIABLE_INTEREST_PVT.csm_loan_level_tbl_type;
1481: l_csm_lease_header okl_create_streams_pvt.csm_lease_rec_type;
1482: l_csm_line_details_tbl okl_create_streams_pvt.csm_line_details_tbl_type;

Line 1479: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;

1475: l_csm_loan_levels_tbl okl_create_streams_pvt.csm_loan_level_tbl_type;
1476: l_csm_one_off_fee_tbl Okl_Create_Streams_Pub.csm_one_off_fee_tbl_type;
1477: l_csm_periodic_expenses_tbl Okl_Create_Streams_Pub.csm_periodic_expenses_tbl_type;
1478: l_csm_yields_tbl Okl_Create_Streams_Pub.csm_yields_tbl_type;
1479: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
1480: l_csm_loan_levels_tbl_in OKL_VARIABLE_INTEREST_PVT.csm_loan_level_tbl_type;
1481: l_csm_lease_header okl_create_streams_pvt.csm_lease_rec_type;
1482: l_csm_line_details_tbl okl_create_streams_pvt.csm_line_details_tbl_type;
1483: l_req_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;

Line 1483: l_req_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;

1479: l_csm_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
1480: l_csm_loan_levels_tbl_in OKL_VARIABLE_INTEREST_PVT.csm_loan_level_tbl_type;
1481: l_csm_lease_header okl_create_streams_pvt.csm_lease_rec_type;
1482: l_csm_line_details_tbl okl_create_streams_pvt.csm_line_details_tbl_type;
1483: l_req_stream_types_tbl Okl_Create_Streams_Pub.csm_stream_types_tbl_type;
1484:
1485: l_index NUMBER := 0;
1486: l_return_status VARCHAR2(1) := Okc_Api.G_RET_STS_SUCCESS;
1487: l_api_name CONSTANT VARCHAR2(30) := 'initiate_request';

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

1832: OKL_VARIABLE_INTEREST_PVT.print_debug('Contents of l_csm_loan_levels_tbl after call to OKL_LA_STREAM_PUB.extract_params_loan.');
1833: print_loan_tables(p_rent_tbl => l_rents_prin_tbl,
1834: p_csm_loan_level_tbl => l_csm_loan_levels_tbl);
1835:
1836: l_csm_loan_header.orp_code := Okl_Create_Streams_Pub.G_ORP_CODE_VARIABLE_INTEREST;
1837: l_csm_stream_types_tbl.DELETE;
1838: l_total_lending := 0;
1839: l_rents_prin_tbl.delete;
1840: l_sequence := 0;

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

1842: l_loan_levels_cntr := l_csm_loan_levels_tbl.first;
1843: LOOP
1844: EXIT WHEN l_loan_levels_cntr IS NULL;
1845:
1846: --CHECK FOR level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL
1847: --DO NOT MAKE A PRICING CALL IN THIS CASE
1848: --for Principal Payments only
1849: IF(l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL)
1850: 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 1849: IF(l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL)

1845:
1846: --CHECK FOR level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL
1847: --DO NOT MAKE A PRICING CALL IN THIS CASE
1848: --for Principal Payments only
1849: IF(l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL)
1850: 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
1851: --call var_int_rent_level passing the level payments and interest rate
1852:
1853: IF (l_csm_loan_levels_tbl(l_loan_levels_cntr).period = 'T') THEN

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

1901: l_rents_prin_tbl(l_loan_levels_cntr).level_type := l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type;
1902: l_rents_prin_tbl(l_loan_levels_cntr).amount := l_csm_loan_levels_tbl(l_loan_levels_cntr).amount;
1903: l_rents_prin_tbl(l_loan_levels_cntr).advance_or_arrears := l_csm_loan_levels_tbl(l_loan_levels_cntr).advance_or_arrears;
1904: l_rents_prin_tbl(l_loan_levels_cntr).period := l_csm_loan_levels_tbl(l_loan_levels_cntr).period;
1905: l_rents_prin_tbl(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;
1906: l_rents_prin_tbl(l_loan_levels_cntr).first_payment_date := l_level_date_start;
1907: l_rents_prin_tbl(l_loan_levels_cntr).rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
1908: END IF;
1909: --CHECK FOR RENT PAYMENT

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

1907: l_rents_prin_tbl(l_loan_levels_cntr).rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
1908: END IF;
1909: --CHECK FOR RENT PAYMENT
1910: --for Rent and Unscheduled Principal Paydown
1911: ELSIF(l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PAYMENT)
1912: OR (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL AND
1913: l_csm_loan_levels_tbl(l_loan_levels_cntr).lock_level_step = Okl_Create_Streams_Pub.G_LOCK_AMOUNT) THEN
1914: IF (l_csm_loan_levels_tbl(l_loan_levels_cntr).period = 'T') THEN
1915: l_loan_levels_date_start := get_pay_level_start_date(l_csm_loan_levels_tbl(l_loan_levels_cntr).kle_loan_id,

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

1908: END IF;
1909: --CHECK FOR RENT PAYMENT
1910: --for Rent and Unscheduled Principal Paydown
1911: ELSIF(l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PAYMENT)
1912: OR (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL AND
1913: l_csm_loan_levels_tbl(l_loan_levels_cntr).lock_level_step = Okl_Create_Streams_Pub.G_LOCK_AMOUNT) THEN
1914: IF (l_csm_loan_levels_tbl(l_loan_levels_cntr).period = 'T') THEN
1915: l_loan_levels_date_start := get_pay_level_start_date(l_csm_loan_levels_tbl(l_loan_levels_cntr).kle_loan_id,
1916: l_csm_loan_levels_tbl(l_loan_levels_cntr).level_index_number - 1);

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

1909: --CHECK FOR RENT PAYMENT
1910: --for Rent and Unscheduled Principal Paydown
1911: ELSIF(l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PAYMENT)
1912: OR (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL AND
1913: l_csm_loan_levels_tbl(l_loan_levels_cntr).lock_level_step = Okl_Create_Streams_Pub.G_LOCK_AMOUNT) THEN
1914: IF (l_csm_loan_levels_tbl(l_loan_levels_cntr).period = 'T') THEN
1915: l_loan_levels_date_start := get_pay_level_start_date(l_csm_loan_levels_tbl(l_loan_levels_cntr).kle_loan_id,
1916: l_csm_loan_levels_tbl(l_loan_levels_cntr).level_index_number - 1);
1917: OKL_VARIABLE_INTEREST_PVT.print_debug('Fetched start date from SLL - l_loan_levels_date_start: ' || l_loan_levels_date_start);

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

1953: END IF;
1954:
1955: l_csm_loan_levels_tbl_in(l_loan_levels_cntr) := l_csm_loan_levels_tbl(l_loan_levels_cntr);
1956: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).level_index_number := l_sequence;
1957: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;
1958: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
1959: IF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PAYMENT) THEN
1960: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;
1961: ELSIF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL) THEN

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

1955: l_csm_loan_levels_tbl_in(l_loan_levels_cntr) := l_csm_loan_levels_tbl(l_loan_levels_cntr);
1956: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).level_index_number := l_sequence;
1957: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;
1958: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
1959: IF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PAYMENT) THEN
1960: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;
1961: ELSIF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL) THEN
1962: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_BOTH;
1963: END IF;

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

1956: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).level_index_number := l_sequence;
1957: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;
1958: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
1959: IF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PAYMENT) THEN
1960: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;
1961: ELSIF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL) THEN
1962: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_BOTH;
1963: END IF;
1964: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).date_start := l_level_date_start;

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

1957: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;
1958: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
1959: IF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PAYMENT) THEN
1960: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;
1961: ELSIF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL) THEN
1962: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_BOTH;
1963: END IF;
1964: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).date_start := l_level_date_start;
1965: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).number_of_periods := l_number_of_periods;

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

1958: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
1959: IF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PAYMENT) THEN
1960: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_RATE;
1961: ELSIF (l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_PRINCIPAL) THEN
1962: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).lock_level_step := Okl_Create_Streams_Pub.G_LOCK_BOTH;
1963: END IF;
1964: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).date_start := l_level_date_start;
1965: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).number_of_periods := l_number_of_periods;
1966: END IF;

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

1963: END IF;
1964: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).date_start := l_level_date_start;
1965: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).number_of_periods := l_number_of_periods;
1966: END IF;
1967: ELSIF(l_csm_loan_levels_tbl(l_loan_levels_cntr).level_type = Okl_Create_Streams_Pub.G_SFE_LEVEL_FUNDING) THEN
1968: --is the below code OK
1969: --will this table, l_csm_loan_levels_tbl, have more than 1 row
1970: --looks like each row is being populated with the principal at the contract level and
1971: --not at the asset level

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

1982: END IF;
1983:
1984: l_csm_loan_levels_tbl_in(l_loan_levels_cntr) := l_csm_loan_levels_tbl(l_loan_levels_cntr);
1985: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).level_index_number := l_sequence;
1986: l_csm_loan_levels_tbl_in(l_loan_levels_cntr).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;
1987:
1988: --if the level type is not Principal Paydown then
1989: --get the principal balance
1990: IF (NVL(l_csm_loan_levels_tbl_in(l_loan_levels_cntr).period, 'DMF') <> 'T') THEN

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

2063: OKL_VARIABLE_INTEREST_PVT.print_debug('Before pricing call.');
2064: print_loan_tables(p_rent_tbl => l_rents_prin_tbl,
2065: p_csm_loan_level_tbl => l_csm_loan_levels_tbl_in);
2066:
2067: Okl_Create_Streams_Pub.Create_Streams_Loan_Restr(p_api_version => p_api_version,
2068: p_init_msg_list => p_init_msg_list,
2069: p_skip_prc_engine => l_skip_prc_engine,
2070: p_csm_loan_header => l_csm_loan_header,
2071: p_csm_loan_lines_tbl => l_csm_loan_lines_tbl,

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

2190: OKL_VARIABLE_INTEREST_PVT.print_debug('Contents of l_rents_tbl and l_csm_line_details_tbl after call to Extract params.');
2191: print_lease_tables(p_rents_tbl_in => l_rents_tbl,
2192: p_csm_line_details_tbl => l_csm_line_details_tbl);
2193:
2194: l_csm_lease_header.orp_code := OKL_CREATE_STREAMS_PUB.G_ORP_CODE_VARIABLE_INTEREST;
2195: l_csm_lease_header.implicit_interest_rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
2196: l_csm_lease_header.date_payments_commencement := l_start_date;
2197: l_csm_lease_header.date_delivery := l_start_date;
2198: l_csm_lease_header.term := l_remaining_term_in_months;

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

2271: --BE EFFECTIVE
2272: l_rents_tbl_in(l_rent_cntr).rate := l_interest_rate_tbl(l_interest_rate_tbl_index).rate;
2273: l_rents_tbl_in(l_rent_cntr).date_start := l_level_date_start;
2274: --BELOW VALUE MUST BE SET TO 'Y'
2275: l_rents_tbl_in(l_rent_cntr).query_level_yn := Okl_Create_Streams_Pub.G_FND_YES;
2276: IF (NVl(l_prev_kle_id, -99) <> l_rents_tbl(l_rent_cntr).kle_asset_id) THEN
2277: --reset the sequence for the level_index_number for each asset
2278: l_sequence := 1;
2279: l_prev_kle_id := l_rents_tbl(l_rent_cntr).kle_asset_id;

Line 2328: Okl_Create_Streams_Pub.CREATE_STREAMS_LEASE_RESTR(

2324: print_lease_tables(p_rents_tbl_in => l_rents_tbl_in,
2325: p_csm_line_details_tbl => l_csm_line_details_tbl);
2326:
2327: --Call Supertrump API to submit request.
2328: Okl_Create_Streams_Pub.CREATE_STREAMS_LEASE_RESTR(
2329: p_api_version => p_api_version,
2330: p_init_msg_list => p_init_msg_list,
2331: x_return_status => x_return_status,
2332: x_msg_count => x_msg_count,