APPS.OKL_LA_ASSET_PVT dependencies on OKC_K_HEADERS_V

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

30: G_FIN_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM1';
31: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
32: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
33: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
34: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
35: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
36: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
37: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';
38: -------------------------------------------------------------------------------------------------

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

31: G_FA_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FIXED_ASSET';
32: G_INST_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'FREE_FORM2';
33: G_IB_LINE_LTY_CODE OKC_LINE_STYLES_V.LTY_CODE%TYPE := 'INST_ITEM';
34: G_LEASE_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LEASE';
35: G_LOAN_SCS_CODE OKC_K_HEADERS_V.SCS_CODE%TYPE := 'LOAN';
36: G_TLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'TLS';
37: G_SLS_TYPE OKC_LINE_STYLES_V.LSE_TYPE%TYPE := 'SLS';
38: -------------------------------------------------------------------------------------------------
39: -- cklee

Line 716: lv_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;

712: x_las_tbl OUT NOCOPY las_tbl_type)
713: AS
714: l_api_version CONSTANT NUMBER := 1;
715: l_api_name CONSTANT VARCHAR2(30) := 'VERSION_CONTRACT';
716: lv_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
717: lv_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
718: i NUMBER := 0;
719: l_las_rec las_rec_type := p_las_rec;
720: l_active_contract BOOLEAN := FALSE;

Line 1080: CURSOR c_get_sts_code(p_chr_id OKC_K_HEADERS_V.ID%TYPE)

1076: ,'TRDT',to_char(date_terminated,'dd-mon-yyyy')
1077: ,'STS',sts_code
1078: ,'LOC',location_id
1079: ,asset_number) asc;
1080: CURSOR c_get_sts_code(p_chr_id OKC_K_HEADERS_V.ID%TYPE)
1081: IS
1082: SELECT st.ste_code,
1083: khr.deal_type
1084: -- FROM OKL_K_HEADERS_FULL_V chr,

Line 1937: p_token1_value => 'OKC_K_HEADERS_V.STS_CODE');

1933: IF c_get_sts_code%NOTFOUND THEN
1934: OKL_API.set_message(p_app_name => G_APP_NAME,
1935: p_msg_name => G_NO_MATCHING_RECORD,
1936: p_token1 => G_COL_NAME_TOKEN,
1937: p_token1_value => 'OKC_K_HEADERS_V.STS_CODE');
1938: RAISE OKL_API.G_EXCEPTION_ERROR;
1939: END IF;
1940: FETCH c_get_sts_code INTO lv_sts_code, lv_deal_type;
1941: CLOSE c_get_sts_code;