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_CATCHUP_PVT dependencies on OKL_STRM_ELEMENTS_V

Line 330: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;

326: l_asset_line_tbl_count NUMBER := 0;
327: l_prorated_invoice_amt NUMBER := 0;
328: i_vir_tbl OKL_VARIABLE_INTEREST_PVT.vir_tbl_type;
329: r_vir_tbl OKL_VARIABLE_INTEREST_PVT.vir_tbl_type;
330: l_stream_element_id OKL_STRM_ELEMENTS_V.id%TYPE;
331: var_int_catchup_failed EXCEPTION;
332:
333: --Bug# 13001695: Added parameter cp_stream_type_purpose
334: -- bug 13877914 - excluding financed fee interest

Line 380: okl_strm_elements_v sel_prin_pmt

376: CURSOR principal_adjustment_csr (cp_khr_id NUMBER, cp_start_date DATE, cp_due_date DATE, cp_kle_id NUMBER) IS
377: SELECT nvl(SUM(nvl(sel_prin_pmt.amount, 0)),0) pmt_amt
378: FROM okl_strm_type_v sty_prin_pmt,
379: okl_streams_v stm_prin_pmt,
380: okl_strm_elements_v sel_prin_pmt
381: WHERE stm_prin_pmt.khr_id = cp_khr_id
382: AND stm_prin_pmt.id = sel_prin_pmt.stm_id
383: AND sel_prin_pmt.stream_element_date BETWEEN cp_start_date AND cp_due_date
384: AND stm_prin_pmt.sty_id = sty_prin_pmt.id

Line 859: p_source_table => 'OKL_STRM_ELEMENTS_V');

855: p_catchup_settlement_code => OKL_VARIABLE_INTEREST_PVT.G_CATCHUP_SETTLEMENT_CODE,
856: p_vir_tbl => i_vir_tbl,
857: x_vir_tbl => r_vir_tbl,
858: --Bug# 12974796
859: p_source_table => 'OKL_STRM_ELEMENTS_V');
860: IF (x_return_status = Okl_Api.G_RET_STS_UNEXP_ERROR) THEN
861: OKL_VARIABLE_INTEREST_PVT.print_error_message('Unexpected error raised in call to UPD_VIR_PARAMS_WITH_INVOICE');
862: RAISE Okl_Api.G_EXCEPTION_UNEXPECTED_ERROR;
863: ELSIF (x_return_status = Okl_Api.G_RET_STS_ERROR) THEN