APPS.OKL_BILLING_REF_WF dependencies on OKL_TRX_REQUESTS

Line 62: l_request_num OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE;

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

Line 79: CURSOR c_fetch_r_number(p_request_id OKL_TRX_REQUESTS.ID%TYPE)

75: l_req_reason VARCHAR2(30);
76: l_message VARCHAR2(30000);
77: l_reason_desc VARCHAR2(100);
78:
79: CURSOR c_fetch_r_number(p_request_id OKL_TRX_REQUESTS.ID%TYPE)
80: IS
81: SELECT trx.request_number,trx.amount,trx.created_by,request_reason_code -- Bug 3983938
82: FROM okl_trx_requests trx
83: WHERE trx.id = p_request_id;

Line 82: FROM okl_trx_requests trx

78:
79: CURSOR c_fetch_r_number(p_request_id OKL_TRX_REQUESTS.ID%TYPE)
80: IS
81: SELECT trx.request_number,trx.amount,trx.created_by,request_reason_code -- Bug 3983938
82: FROM okl_trx_requests trx
83: WHERE trx.id = p_request_id;
84:
85: --skgautam added for bug Bug 3983938
86: CURSOR c_get_reason(p_reason_code VARCHAR2) IS

Line 258: l_request_num OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE;

254: l_msg_count NUMBER;
255: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
256: l_msg_data VARCHAR2(2000);
257:
258: l_request_num OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE;
259: l_trx_id NUMBER;
260: l_nid NUMBER;
261:
262: --rkuttiya commented for problem identified during bug fix - 2923037