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_SEEDED_FUNCTIONS_PVT dependencies on OKL_K_LINES_V

Line 933: ln_contract_oec OKL_K_LINES_V.OEC%TYPE := 0;

929: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
930: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
931: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
932: l_api_name CONSTANT VARCHAR2(30) := 'FUNCTION_OEC_CALC';
933: ln_contract_oec OKL_K_LINES_V.OEC%TYPE := 0;
934: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
935: ln_model_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
936: ln_addon_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
937: ln_total_line_oec OKL_K_LINES_V.OEC%TYPE := 0;

Line 935: ln_model_line_oec OKL_K_LINES_V.OEC%TYPE := 0;

931: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
932: l_api_name CONSTANT VARCHAR2(30) := 'FUNCTION_OEC_CALC';
933: ln_contract_oec OKL_K_LINES_V.OEC%TYPE := 0;
934: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
935: ln_model_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
936: ln_addon_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
937: ln_total_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
938: l_capred_incl_terminated BOOLEAN := FALSE;
939: -- Cursor to get the lty_code

Line 936: ln_addon_line_oec OKL_K_LINES_V.OEC%TYPE := 0;

932: l_api_name CONSTANT VARCHAR2(30) := 'FUNCTION_OEC_CALC';
933: ln_contract_oec OKL_K_LINES_V.OEC%TYPE := 0;
934: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
935: ln_model_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
936: ln_addon_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
937: ln_total_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
938: l_capred_incl_terminated BOOLEAN := FALSE;
939: -- Cursor to get the lty_code
940: CURSOR get_lty_code(p_cle_id IN OKC_K_LINES_V.ID%TYPE) IS

Line 937: ln_total_line_oec OKL_K_LINES_V.OEC%TYPE := 0;

933: ln_contract_oec OKL_K_LINES_V.OEC%TYPE := 0;
934: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
935: ln_model_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
936: ln_addon_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
937: ln_total_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
938: l_capred_incl_terminated BOOLEAN := FALSE;
939: -- Cursor to get the lty_code
940: CURSOR get_lty_code(p_cle_id IN OKC_K_LINES_V.ID%TYPE) IS
941: SELECT lse.lty_code

Line 949: FROM OKL_K_LINES_V kle,

945: AND cle.lse_id = lse.id;
946: -- Cursor to sum up oec for contract
947: CURSOR c_contract_oec_calc(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
948: SELECT SUM(kle.oec) oec
949: FROM OKL_K_LINES_V kle,
950: OKC_K_LINES_V cle,
951: OKC_K_HEADERS_V CHR
952: WHERE CHR.id = p_dnz_chr_id
953: AND CHR.id = cle.dnz_chr_id

Line 959: FROM OKL_K_LINES_V kle,

955: AND cle.id = kle.id;
956:
957: CURSOR c_contract_oec_calc_incl_term(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
958: SELECT SUM(kle.oec) oec
959: FROM OKL_K_LINES_V kle,
960: OKC_K_LINES_V cle,
961: OKC_K_HEADERS_V CHR
962: WHERE CHR.id = p_dnz_chr_id
963: AND CHR.id = cle.dnz_chr_id