DBA Data[Home] [Help]

APPS.OKL_VP_EXTEND_PVT dependencies on OKC_STATUSES_V

Line 38: FROM okc_statuses_v

34: WHERE code = p_sts_code;
35:
36: CURSOR cur_mean(p_sts_code varchar2) is
37: SELECT meaning
38: FROM okc_statuses_v
39: WHERE code = p_sts_code;
40:
41: l_chg_request_in_process VARCHAR2(1);
42: l_status VARCHAR2(30);

Line 43: l_status_meaning okc_statuses_v.meaning%TYPE;

39: WHERE code = p_sts_code;
40:
41: l_chg_request_in_process VARCHAR2(1);
42: l_status VARCHAR2(30);
43: l_status_meaning okc_statuses_v.meaning%TYPE;
44: l_return_status VARCHAR2(1) := OKC_API.g_ret_sts_success;
45: l_chr_rec cur_k_header%rowtype;
46: l_api_name CONSTANT VARCHAR2(30) := 'validate_chr';
47: