APPS.OKL_CONVERT_INT_TYPE_WF dependencies on OKL_TRX_REQUESTS

Line 132: l_request_num OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE;

128: l_msg_count NUMBER;
129: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
130: l_msg_data VARCHAR2(2000);
131:
132: l_request_num OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE;
133: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
134: l_trx_id NUMBER;
135: l_chrv_id NUMBER;
136: l_request_details OKL_TRX_REQUESTS%ROWTYPE;

Line 136: l_request_details OKL_TRX_REQUESTS%ROWTYPE;

132: l_request_num OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE;
133: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
134: l_trx_id NUMBER;
135: l_chrv_id NUMBER;
136: l_request_details OKL_TRX_REQUESTS%ROWTYPE;
137: l_cit_details OKL_CONVERT_INT_RATE_REQUEST_V%ROWTYPE;
138: l_int_details OKL_K_RATE_PARAMS_V%ROWTYPE;
139: l_var_method VARCHAR2(30);
140: l_int_method VARCHAR2(30);

Line 164: CURSOR c_fetch_req_details(p_request_id OKL_TRX_REQUESTS.ID%TYPE)

160: SELECT chrv.contract_number
161: FROM okc_k_headers_v chrv
162: WHERE chrv.id = p_contract_id;
163:
164: CURSOR c_fetch_req_details(p_request_id OKL_TRX_REQUESTS.ID%TYPE)
165: IS
166: SELECT *
167: FROM okl_trx_requests trx
168: WHERE trx.id = p_request_id;

Line 167: FROM okl_trx_requests trx

163:
164: CURSOR c_fetch_req_details(p_request_id OKL_TRX_REQUESTS.ID%TYPE)
165: IS
166: SELECT *
167: FROM okl_trx_requests trx
168: WHERE trx.id = p_request_id;
169:
170: CURSOR c_cit_details(p_request_id IN NUMBER)
171: IS

Line 679: l_request_num OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE;

675: l_msg_count NUMBER;
676: l_init_msg_list VARCHAR2(10) := OKL_API.G_FALSE;
677: l_msg_data VARCHAR2(2000);
678:
679: l_request_num OKL_TRX_REQUESTS.REQUEST_NUMBER%TYPE;
680: l_trx_id NUMBER;
681: l_nid NUMBER;
682: l_trq_rec okl_trq_pvt.trqv_rec_type;
683: lx_trq_rec okl_trq_pvt.trqv_rec_type;

Line 711: okl_trx_requests_pub.update_trx_requests(

707: END IF;
708:
709: l_trq_rec.id := l_trx_id;
710: l_trq_rec.request_status_code := l_sts_code;
711: okl_trx_requests_pub.update_trx_requests(
712: p_api_version => l_api_version,
713: p_init_msg_list => l_init_msg_list,
714: x_return_status => l_return_status,
715: x_msg_count => l_msg_count,