APPS.OKL_BILLING_CORR_REQ_WF dependencies on OKL_TRX_REQUESTS

Line 61: l_request_num OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE;

57: l_msg_count NUMBER;
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);

Line 66: CURSOR c_fetch_r_number(p_request_id OKL_TRX_REQUESTS.ID%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)
67: IS
68: SELECT trx.request_number
69: FROM okl_trx_requests trx
70: WHERE trx.id = p_request_id;

Line 69: FROM okl_trx_requests trx

65: l_approver VARCHAR2(100);
66: CURSOR c_fetch_r_number(p_request_id OKL_TRX_REQUESTS.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

Line 180: l_request_num OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE;

176: l_msg_count NUMBER;
177: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
178: l_msg_data VARCHAR2(2000);
179:
180: l_request_num OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE;
181: l_trx_id NUMBER;
182: l_nid NUMBER;
183: --rkuttiya commented for fixing problem identified during bug:2923037
184: -- l_ntf_result VARCHAR2(30);