APPS.OKL_SEEDED_FUNCTIONS_PVT dependencies on OKC_LINE_STYLES_V

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

1067: G_LINE_RECORD CONSTANT VARCHAR2(200) := 'OKL_LLA_LINE_RECORD';
1068: G_INVALID_CRITERIA CONSTANT VARCHAR2(200) := 'OKL_LLA_INVALID_CRITERIA';
1069: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
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';

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

1068: G_INVALID_CRITERIA CONSTANT VARCHAR2(200) := 'OKL_LLA_INVALID_CRITERIA';
1069: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
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;

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

1069: G_EXCEPTION_HALT_VALIDATION EXCEPTION;
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';

Line 1079: lv_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

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;
1080: ln_model_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
1081: ln_addon_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
1082: ln_total_line_oec OKL_K_LINES_V.OEC%TYPE := 0;
1083: l_capred_incl_terminated BOOLEAN := FALSE;

Line 6378: ,okc_line_styles_v lse

6374: CURSOR parent_line_id_csr (p_contract_id NUMBER)
6375: IS
6376: SELECT line.id parent_line_id
6377: FROM okc_k_lines_b line
6378: ,okc_line_styles_v lse
6379: WHERE line.lse_id=lse.id
6380: AND lse.lty_code= 'FREE_FORM1'
6381: AND line.sts_code <> 'ABANDONED'
6382: AND dnz_chr_id = p_contract_id;

Line 7008: ,okc_line_styles_v lse

7004: CURSOR parent_line_id_csr (p_contract_id NUMBER)
7005: IS
7006: SELECT line.id parent_line_id
7007: FROM okc_k_lines_b line
7008: ,okc_line_styles_v lse
7009: WHERE line.lse_id=lse.id
7010: AND lse.lty_code= 'FREE_FORM1'
7011: AND line.sts_code <> 'ABANDONED'
7012: AND dnz_chr_id = p_contract_id;

Line 13926: okc_line_styles_v lse

13922: FROM fa_books fab,
13923: fa_book_controls fbc,
13924: okc_k_items_v itm,
13925: okc_k_lines_b kle,
13926: okc_line_styles_v lse
13927: WHERE fbc.book_class = 'CORPORATE'
13928: AND fab.book_type_code = fbc.book_type_code
13929: AND fab.asset_id = itm.object1_id1
13930: AND itm.cle_id = kle.id

Line 15598: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;

15594: 'OKL_LLA_INVALID_CRITERIA';
15595: l_return_status VARCHAR2(3) :=
15596: OKL_API.G_RET_STS_SUCCESS;
15597:
15598: l_lty_code OKC_LINE_STYLES_V.LTY_CODE%TYPE;
15599: l_financed_amount NUMBER;
15600: l_asset_cost NUMBER;
15601: l_addon NUMBER;
15602: l_cap_fee NUMBER;