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 OKC_K_HEADERS_V

Line 1074: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';

1070: G_EXCEPTION_STOP_VALIDATION EXCEPTION;
1071: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
1072: G_MODEL_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ITEM';
1073: G_ADDON_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ADD_ITEM';
1074: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
1075: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
1076: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
1077: l_api_name CONSTANT VARCHAR2(30) := 'FUNCTION_OEC_CALC';
1078: ln_contract_oec OKL_K_LINES_V.OEC%TYPE := 0;

Line 1075: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';

1071: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
1072: G_MODEL_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ITEM';
1073: G_ADDON_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ADD_ITEM';
1074: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
1075: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
1076: l_return_status VARCHAR2(3) := Okl_Api.G_RET_STS_SUCCESS;
1077: l_api_name CONSTANT VARCHAR2(30) := 'FUNCTION_OEC_CALC';
1078: ln_contract_oec OKL_K_LINES_V.OEC%TYPE := 0;
1079: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

Line 1092: CURSOR c_contract_oec_calc(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

1088: okc_line_styles_b lse
1089: WHERE cle.id = p_cle_id
1090: AND cle.lse_id = lse.id;
1091: -- Cursor to sum up oec for contract
1092: CURSOR c_contract_oec_calc(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1093: SELECT SUM(kle.oec) oec
1094: FROM OKL_K_LINES_V kle,
1095: OKC_K_LINES_V cle,
1096: OKC_K_HEADERS_V CHR

Line 1096: OKC_K_HEADERS_V CHR

1092: CURSOR c_contract_oec_calc(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1093: SELECT SUM(kle.oec) oec
1094: FROM OKL_K_LINES_V kle,
1095: OKC_K_LINES_V cle,
1096: OKC_K_HEADERS_V CHR
1097: WHERE CHR.id = p_dnz_chr_id
1098: AND CHR.id = cle.dnz_chr_id
1099: AND cle.sts_code NOT IN ( 'ABANDONED', 'TERMINATED', 'EXPIRED', 'CANCELLED', 'HOLD')
1100: AND cle.id = kle.id;

Line 1102: CURSOR c_contract_oec_calc_incl_term(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS

1098: AND CHR.id = cle.dnz_chr_id
1099: AND cle.sts_code NOT IN ( 'ABANDONED', 'TERMINATED', 'EXPIRED', 'CANCELLED', 'HOLD')
1100: AND cle.id = kle.id;
1101:
1102: CURSOR c_contract_oec_calc_incl_term(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1103: SELECT SUM(kle.oec) oec
1104: FROM OKL_K_LINES_V kle,
1105: OKC_K_LINES_V cle,
1106: OKC_K_HEADERS_V CHR

Line 1106: OKC_K_HEADERS_V CHR

1102: CURSOR c_contract_oec_calc_incl_term(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE) IS
1103: SELECT SUM(kle.oec) oec
1104: FROM OKL_K_LINES_V kle,
1105: OKC_K_LINES_V cle,
1106: OKC_K_HEADERS_V CHR
1107: WHERE CHR.id = p_dnz_chr_id
1108: AND CHR.id = cle.dnz_chr_id
1109: AND cle.sts_code NOT IN ( 'ABANDONED', 'EXPIRED', 'CANCELLED', 'HOLD')
1110: AND cle.id = kle.id;

Line 1205: CURSOR c_nr_con_oec_calc_incl_term(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE,

1201: where kle.id = p_cle_id;
1202:
1203: --Bug# 15992711 , Start
1204: -- Considers either new or re-leased assets of a Contract based on p_line_type parameter
1205: CURSOR c_nr_con_oec_calc_incl_term(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE,
1206: p_line_type VARCHAR2) IS
1207: SELECT SUM(kle.oec) oec
1208: FROM OKL_K_LINES_V kle,
1209: OKC_K_LINES_V cle,

Line 1210: OKC_K_HEADERS_V CHR

1206: p_line_type VARCHAR2) IS
1207: SELECT SUM(kle.oec) oec
1208: FROM OKL_K_LINES_V kle,
1209: OKC_K_LINES_V cle,
1210: OKC_K_HEADERS_V CHR
1211: WHERE CHR.id = p_dnz_chr_id
1212: AND CHR.id = cle.dnz_chr_id
1213: AND cle.sts_code NOT IN ( 'ABANDONED', 'EXPIRED', 'CANCELLED', 'HOLD')
1214: AND cle.id = kle.id

Line 1218: CURSOR c_nr_contract_oec_calc(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE,

1214: AND cle.id = kle.id
1215: AND NVL(kle.re_lease_yn,'N') = DECODE(p_line_type,'NEW','N','RELEASE','Y');
1216:
1217:
1218: CURSOR c_nr_contract_oec_calc(p_dnz_chr_id OKC_K_HEADERS_V.ID%TYPE,
1219: p_line_type VARCHAR2) IS
1220: SELECT SUM(kle.oec) oec
1221: FROM OKL_K_LINES_V kle,
1222: OKC_K_LINES_V cle,

Line 1223: OKC_K_HEADERS_V CHR

1219: p_line_type VARCHAR2) IS
1220: SELECT SUM(kle.oec) oec
1221: FROM OKL_K_LINES_V kle,
1222: OKC_K_LINES_V cle,
1223: OKC_K_HEADERS_V CHR
1224: WHERE CHR.id = p_dnz_chr_id
1225: AND CHR.id = cle.dnz_chr_id
1226: AND cle.sts_code NOT IN ( 'ABANDONED', 'TERMINATED', 'EXPIRED', 'CANCELLED', 'HOLD')
1227: AND cle.id = kle.id

Line 4896: FROM okc_k_headers_v h

4892:
4893: -- Get header number to use in error messages
4894: CURSOR l_chr_csr (cp_chr_id NUMBER) IS
4895: SELECT h.contract_number
4896: FROM okc_k_headers_v h
4897: WHERE h.id = cp_chr_id;
4898:
4899: l_result_amount NUMBER := 0;
4900: l_no_taxable_amount EXCEPTION;

Line 6536: okc_k_headers_v okh

6532: FROM okl_streams_v asv,okl_strm_type_v bs,
6533: okl_strm_elements_v cs,
6534: okl_streams str,
6535: okl_strm_type_v sty,
6536: okc_k_headers_v okh
6537: WHERE cs.stm_id = asv.id AND bs.id = asv.sty_id
6538: AND str.sty_id = sty.id
6539: AND UPPER(sty.name) = 'PRINCIPAL BALANCE'
6540: AND str.say_code = 'CURR'