APPS.OKL_BILLING_CORR_REQ_WF dependencies on OKC_K_HEADERS_V

Line 62: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

58: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
59: l_msg_data VARCHAR2(2000);
60:
61: l_request_num OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE;
62: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
63: l_trx_id NUMBER;
64: l_chrv_id NUMBER;
65: l_approver VARCHAR2(100);
66: CURSOR c_fetch_r_number(p_request_id OKL_TRX_REQUESTS.ID%TYPE)

Line 71: CURSOR c_fetch_k_number(p_contract_id OKC_K_HEADERS_V.ID%TYPE)

67: IS
68: SELECT trx.request_number
69: FROM okl_trx_requests trx
70: WHERE trx.id = p_request_id;
71: CURSOR c_fetch_k_number(p_contract_id OKC_K_HEADERS_V.ID%TYPE)
72: IS
73: SELECT chrv.contract_number
74: FROM okc_k_headers_v chrv
75: WHERE chrv.id = p_contract_id;

Line 74: FROM okc_k_headers_v chrv

70: WHERE trx.id = p_request_id;
71: CURSOR c_fetch_k_number(p_contract_id OKC_K_HEADERS_V.ID%TYPE)
72: IS
73: SELECT chrv.contract_number
74: FROM okc_k_headers_v chrv
75: WHERE chrv.id = p_contract_id;
76: BEGIN
77: IF (funcmode = 'RUN') THEN
78: --rkuttiya added for bug:2923037