APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKC_LINE_STYLES_V

Line 926: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';

922: G_LINE_RECORD CONSTANT VARCHAR2(200) := 'OKL_LLA_LINE_RECORD';
923: G_INVALID_CRITERIA CONSTANT VARCHAR2(200) := 'OKL_LLA_INVALID_CRITERIA';
924: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
925: G_EXCEPTION_STOP_VALIDATION EXCEPTION;
926: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
927: G_MODEL_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ITEM';
928: G_ADDON_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ADD_ITEM';
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';

Line 927: G_MODEL_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ITEM';

923: G_INVALID_CRITERIA CONSTANT VARCHAR2(200) := 'OKL_LLA_INVALID_CRITERIA';
924: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
925: G_EXCEPTION_STOP_VALIDATION EXCEPTION;
926: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
927: G_MODEL_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ITEM';
928: G_ADDON_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ADD_ITEM';
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;

Line 928: G_ADDON_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ADD_ITEM';

924: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
925: G_EXCEPTION_STOP_VALIDATION EXCEPTION;
926: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
927: G_MODEL_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ITEM';
928: G_ADDON_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'ADD_ITEM';
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';

Line 934: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

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;
938: l_capred_incl_terminated BOOLEAN := FALSE;

Line 5780: ,okc_line_styles_v lse

5776: CURSOR parent_line_id_csr (p_contract_id NUMBER)
5777: IS
5778: SELECT line.id parent_line_id
5779: FROM okc_k_lines_b line
5780: ,okc_line_styles_v lse
5781: WHERE line.lse_id=lse.id
5782: AND lse.lty_code= 'FREE_FORM1'
5783: AND line.sts_code <> 'ABANDONED'
5784: AND dnz_chr_id = p_contract_id;

Line 6410: ,okc_line_styles_v lse

6406: CURSOR parent_line_id_csr (p_contract_id NUMBER)
6407: IS
6408: SELECT line.id parent_line_id
6409: FROM okc_k_lines_b line
6410: ,okc_line_styles_v lse
6411: WHERE line.lse_id=lse.id
6412: AND lse.lty_code= 'FREE_FORM1'
6413: AND line.sts_code <> 'ABANDONED'
6414: AND dnz_chr_id = p_contract_id;

Line 12694: okc_line_styles_v lse

12690: FROM fa_books fab,
12691: fa_book_controls fbc,
12692: okc_k_items_v itm,
12693: okc_k_lines_b kle,
12694: okc_line_styles_v lse
12695: WHERE fbc.book_class = 'CORPORATE'
12696: AND fab.book_type_code = fbc.book_type_code
12697: AND fab.asset_id = itm.object1_id1
12698: AND itm.cle_id = kle.id

Line 14366: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

14362: 'OKL_LLA_INVALID_CRITERIA';
14363: l_return_status VARCHAR2(3) :=
14364: OKL_API.G_RET_STS_SUCCESS;
14365:
14366: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
14367: l_financed_amount NUMBER;
14368: l_asset_cost NUMBER;
14369: l_addon NUMBER;
14370: l_cap_fee NUMBER;