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 744: lv_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;

740: x_las_tbl OUT NOCOPY las_tbl_type)
741: AS
742: l_api_version CONSTANT NUMBER := 1;
743: l_api_name CONSTANT VARCHAR2(30) := 'VERSION_CONTRACT';
744: lv_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
745: lv_deal_type OKL_K_HEADERS_FULL_V.DEAL_TYPE%TYPE;
746: i NUMBER := 0;
747: l_las_rec las_rec_type := p_las_rec;
748: l_active_contract BOOLEAN := FALSE;

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

1104: ,'TRDT',to_char(date_terminated,'dd-mon-yyyy')
1105: ,'STS',sts_code
1106: ,'LOC',location_id
1107: ,asset_number) asc;
1108: CURSOR c_get_sts_code(p_chr_id OKC_K_HEADERS_V.ID%TYPE)
1109: IS
1110: SELECT st.ste_code,
1111: khr.deal_type
1112: -- FROM OKL_K_HEADERS_FULL_V chr,

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

1961: IF c_get_sts_code%NOTFOUND THEN
1962: OKL_API.set_message(p_app_name => G_APP_NAME,
1963: p_msg_name => G_NO_MATCHING_RECORD,
1964: p_token1 => G_COL_NAME_TOKEN,
1965: p_token1_value => 'OKC_K_HEADERS_V.STS_CODE');
1966: RAISE OKL_API.G_EXCEPTION_ERROR;
1967: END IF;
1968: FETCH c_get_sts_code INTO lv_sts_code, lv_deal_type;
1969: CLOSE c_get_sts_code;