APPS.OKL_LA_PAYMENTS_PVT dependencies on OKL_K_RATE_PARAMS

Line 213: FROM okl_k_rate_params rate

209:
210: CURSOR c_rates_csr(p_chr_id IN NUMBER,
211: p_parameter_type_code IN VARCHAR2) IS
212: SELECT rate.effective_from_date
213: FROM okl_k_rate_params rate
214: WHERE rate.khr_id = p_chr_id
215: AND rate.parameter_type_code = p_parameter_type_code;
216:
217: CURSOR c_principal_pymts_yn(p_chr_id IN NUMBER) IS

Line 236: l_krpdel_tbl OKL_K_RATE_PARAMS_PVT.krpdel_tbl_type;

232: AND cle.sts_code (+) <> 'ABANDONED';
233:
234: l_principal_pymts_yn VARCHAR2(1);
235: l_count NUMBER;
236: l_krpdel_tbl OKL_K_RATE_PARAMS_PVT.krpdel_tbl_type;
237: l_pdt_params_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
238:
239: BEGIN
240:

Line 241: OKL_K_RATE_PARAMS_PVT.get_product(

237: l_pdt_params_rec OKL_SETUPPRODUCTS_PUB.pdt_parameters_rec_type;
238:
239: BEGIN
240:
241: OKL_K_RATE_PARAMS_PVT.get_product(
242: p_api_version => p_api_version,
243: p_init_msg_list => p_init_msg_list,
244: x_return_status => x_return_status,
245: x_msg_count => x_msg_count,

Line 275: OKL_K_RATE_PARAMS_PVT.delete_k_rate_params(

271: l_krpdel_tbl(l_count).rate_type := 'INTEREST_RATE_PARAMS';
272: END LOOP;
273:
274: IF l_count > 0 THEN
275: OKL_K_RATE_PARAMS_PVT.delete_k_rate_params(
276: p_api_version => p_api_version,
277: p_init_msg_list => p_init_msg_list,
278: x_return_status => x_return_status,
279: x_msg_count => x_msg_count,

Line 353: OKL_K_RATE_PARAMS_PVT.get_product(

349: fetch c_stream_type_purpose into l_stream_type_purpose;
350: close c_stream_type_purpose;
351:
352: -- get product information: Book classification and interest_calc_basis
353: OKL_K_RATE_PARAMS_PVT.get_product(
354: p_api_version => l_api_version,
355: p_init_msg_list => l_init_msg_list,
356: x_return_status => x_return_status,
357: x_msg_count => x_msg_count,

Line 3447: OKL_K_RATE_PARAMS_PVT.get_product(

3443: END IF;
3444:
3445:
3446: /*
3447: OKL_K_RATE_PARAMS_PVT.get_product(
3448: p_api_version => p_api_version,
3449: p_init_msg_list => p_init_msg_list,
3450: x_return_status => x_return_status,
3451: x_msg_count => x_msg_count,