[Home] [Help]
9989: l_interest_calculated NUMBER := 0;
9990: r_principal_balance_tbl principal_balance_tbl_typ;
9991: -- l_interest_basis OKL_K_RATE_PARAMS.interest_basis_code%TYPE;
9992: -- l_formula_id OKL_K_RATE_PARAMS.calculation_formula_id%TYPE;
9993: l_formula_name OKL_FORMULAE_V.name%TYPE;
9994: calc_total_int_due_failed EXCEPTION;
9995:
9996: /*
9997: Cursor interest_params_csr (p_contract_id NUMBER, p_effective_date DATE) IS
10003: */
10004:
10005: Cursor formula_csr (p_formula_id NUMBER) IS
10006: SELECT name
10007: FROM okl_formulae_v
10008: WHERE id = p_formula_id;
10009:
10010: /*
10011: Cursor interest_calc_basis_csr (p_contract_id NUMBER) IS
11866: l_api_name CONSTANT VARCHAR2(30) := 'VARIABLE_INTEREST_FLOAT_FACTOR';
11867: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
11868: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
11869: l_invoice_amt NUMBER := 0;
11870: l_formula_id OKL_FORMULAE_V.id%TYPE;
11871: l_formula_name OKL_FORMULAE_V.name%TYPE;
11872: l_line_id OKC_K_LINES_B.id%TYPE;
11873: l_stream_element_date DATE;
11874: l_invoice_id NUMBER;
11867: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
11868: l_stream_type_purpose OKL_STRM_TYPE_V.stream_type_purpose%TYPE;
11869: l_invoice_amt NUMBER := 0;
11870: l_formula_id OKL_FORMULAE_V.id%TYPE;
11871: l_formula_name OKL_FORMULAE_V.name%TYPE;
11872: l_line_id OKC_K_LINES_B.id%TYPE;
11873: l_stream_element_date DATE;
11874: l_invoice_id NUMBER;
11875: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;
11876: var_int_float_factor_failed EXCEPTION;
11877:
11878: Cursor formula_name_csr (p_formula_id NUMBER) IS
11879: SELECT fml.name
11880: FROM okl_formulae_v fml
11881: WHERE fml.id = p_formula_id;
11882:
11883: Cursor asset_billed_streams_csr (p_contract_id NUMBER, p_from_date DATE, p_to_date DATE) IS
11884: SELECT chrb.id contract_id, cleb.id kle_id,