eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_K_RATE_PARAMS_PVT dependencies on OKL_K_RATE_PARAMS

Line 1: PACKAGE BODY OKL_K_RATE_PARAMS_PVT AS

1: PACKAGE BODY OKL_K_RATE_PARAMS_PVT AS
2: /* $Header: OKLRKRPB.pls 120.26.12010000.4 2008/11/21 09:11:58 rpillay ship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.stream.esg.okl_esg_transport_pvt';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

Line 240: FROM OKL_K_RATE_PARAMS

236: x_effective_from_date OUT NOCOPY DATE,
237: x_no_data_found OUT NOCOPY BOOLEAN) IS
238: CURSOR effective_from_date_csr(p_id NUMBER) IS
239: SELECT MAX(EFFECTIVE_FROM_DATE)
240: FROM OKL_K_RATE_PARAMS
241: WHERE KHR_ID = p_id
242: AND EFFECTIVE_TO_DATE IS NULL;
243: BEGIN
244: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 423: CURSOR okl_k_rate_params_v_u1_csr (p_effective_from_date IN DATE,

419: p_effective_from_date IN DATE,
420: x_krpv_rec OUT NOCOPY krpv_rec_type,
421: x_no_data_found OUT NOCOPY BOOLEAN
422: ) IS
423: CURSOR okl_k_rate_params_v_u1_csr (p_effective_from_date IN DATE,
424: p_khr_id IN NUMBER,
425: p_parameter_type_code IN VARCHAR2) IS
426: SELECT
427: KHR_ID,

Line 475: FROM Okl_K_Rate_Params_V

471: CREATION_DATE,
472: LAST_UPDATED_BY,
473: LAST_UPDATE_DATE,
474: LAST_UPDATE_LOGIN
475: FROM Okl_K_Rate_Params_V
476: WHERE effective_from_date = NVL(p_effective_from_date,effective_from_date)
477: AND khr_id = p_khr_id
478: AND parameter_type_code = NVL(p_parameter_type_code,parameter_type_code);
479: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;

Line 479: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;

475: FROM Okl_K_Rate_Params_V
476: WHERE effective_from_date = NVL(p_effective_from_date,effective_from_date)
477: AND khr_id = p_khr_id
478: AND parameter_type_code = NVL(p_parameter_type_code,parameter_type_code);
479: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;
480: BEGIN
481: x_no_data_found := TRUE;
482: -- Get current database values
483: OPEN okl_k_rate_params_v_u1_csr (p_effective_from_date,

Line 483: OPEN okl_k_rate_params_v_u1_csr (p_effective_from_date,

479: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;
480: BEGIN
481: x_no_data_found := TRUE;
482: -- Get current database values
483: OPEN okl_k_rate_params_v_u1_csr (p_effective_from_date,
484: p_chr_id,
485: p_parameter_type_code);
486: FETCH okl_k_rate_params_v_u1_csr INTO
487: x_krpv_rec.khr_id,

Line 486: FETCH okl_k_rate_params_v_u1_csr INTO

482: -- Get current database values
483: OPEN okl_k_rate_params_v_u1_csr (p_effective_from_date,
484: p_chr_id,
485: p_parameter_type_code);
486: FETCH okl_k_rate_params_v_u1_csr INTO
487: x_krpv_rec.khr_id,
488: x_krpv_rec.parameter_type_code,
489: x_krpv_rec.effective_from_date,
490: x_krpv_rec.effective_to_date,

Line 535: x_no_data_found := okl_k_rate_params_v_u1_csr%NOTFOUND;

531: x_krpv_rec.creation_date,
532: x_krpv_rec.last_updated_by,
533: x_krpv_rec.last_update_date,
534: x_krpv_rec.last_update_login;
535: x_no_data_found := okl_k_rate_params_v_u1_csr%NOTFOUND;
536: CLOSE okl_k_rate_params_v_u1_csr;
537: --RETURN(x_krpv_rec);
538:
539: END;

Line 536: CLOSE okl_k_rate_params_v_u1_csr;

532: x_krpv_rec.last_updated_by,
533: x_krpv_rec.last_update_date,
534: x_krpv_rec.last_update_login;
535: x_no_data_found := okl_k_rate_params_v_u1_csr%NOTFOUND;
536: CLOSE okl_k_rate_params_v_u1_csr;
537: --RETURN(x_krpv_rec);
538:
539: END;
540:

Line 942: FROM OKL_K_RATE_PARAMS

938: WHERE ID = p_id;
939:
940: CURSOR C2(p_id NUMBER, p_parameter_type_code VARCHAR2) IS
941: SELECT COUNT(1) COUNT1
942: FROM OKL_K_RATE_PARAMS
943: WHERE KHR_ID = p_id
944: AND PARAMETER_TYPE_CODE = p_parameter_type_code
945: AND EFFECTIVE_TO_DATE IS NULL;
946:

Line 975: FROM OKL_K_RATE_PARAMS rate,

971: select rate.effective_from_date,
972: contract.orig_system_source_code,
973: lease.date_last_interim_interest_cal,
974: contract.orig_system_id1
975: FROM OKL_K_RATE_PARAMS rate,
976: OKC_K_HEADERS_B contract,
977: OKL_K_HEADERS lease
978: WHERE rate.khr_id = p_khr_id
979: AND rate.parameter_type_code = p_parameter_type_code

Line 1103: FROM OKL_K_RATE_PARAMS

1099: l_krpv_rec.conversion_type_code := p_krpv_rec.conversion_type_code;
1100: print_krpv_rec(l_krpv_rec);
1101:
1102: select count(1) into l_count
1103: FROM OKL_K_RATE_PARAMS
1104: WHERE KHR_ID = p_krpv_rec.khr_id
1105: AND EFFECTIVE_FROM_DATE = p_krpv_rec.effective_from_date
1106: AND PARAMETER_TYPE_CODE = p_krpv_rec.parameter_type_code;
1107:

Line 1308: UPDATE OKL_K_RATE_PARAMS

1304: LOOP
1305: l_orig_effective_from_date := r.effective_from_date;
1306: END LOOP;
1307:
1308: UPDATE OKL_K_RATE_PARAMS
1309: SET EFFECTIVE_TO_DATE = p_krpv_rec.effective_from_Date - 1
1310: WHERE KHR_ID = p_krpv_rec.khr_id
1311: AND PARAMETER_TYPE_CODE = p_krpv_rec.parameter_type_code
1312: AND EFFECTIVE_FROM_DATE = l_effective_from_date

Line 1416: FROM OKL_K_RATE_PARAMS

1412: l_krpv_rec.days_in_a_year_code := p_krpr_rec.days_in_a_year_code;
1413: l_krpv_rec.interest_basis_code := p_krpr_rec.interest_basis_code;
1414:
1415: select count(1) into l_count
1416: FROM OKL_K_RATE_PARAMS
1417: WHERE KHR_ID = p_krpr_rec.khr_id
1418: AND EFFECTIVE_FROM_DATE = p_krpr_rec.effective_from_date
1419: AND PARAMETER_TYPE_CODE = p_krpr_rec.parameter_type_code;
1420:

Line 1523: FROM OKL_K_RATE_PARAMS

1519: p_api_type => G_API_TYPE,
1520: x_return_status => x_return_status);
1521:
1522: select count(1) into l_count
1523: FROM OKL_K_RATE_PARAMS
1524: WHERE KHR_ID = p_krpar_rec.khr_id
1525: AND EFFECTIVE_FROM_DATE = p_krpar_rec.effective_from_date
1526: AND PARAMETER_TYPE_CODE = p_krpar_rec.parameter_type_code;
1527:

Line 1644: FROM OKL_K_RATE_PARAMS

1640: p_api_type => G_API_TYPE,
1641: x_return_status => x_return_status);
1642:
1643: select count(1) into l_count
1644: FROM OKL_K_RATE_PARAMS
1645: WHERE KHR_ID = p_krpc_rec.khr_id
1646: AND EFFECTIVE_FROM_DATE = p_krpc_rec.effective_from_date
1647: AND PARAMETER_TYPE_CODE = p_krpc_rec.parameter_type_code;
1648:

Line 2370: FROM OKL_K_RATE_PARAMS rate,

2366: select rate.effective_to_date,
2367: contract.sts_code,
2368: contract.orig_system_source_code,
2369: contract.orig_system_id1
2370: FROM OKL_K_RATE_PARAMS rate,
2371: OKC_K_HEADERS_B contract
2372: WHERE rate.khr_id = p_khr_id
2373: AND rate.parameter_type_code = p_parameter_type_code
2374: AND rate.effective_from_date = p_effective_from_date

Line 2381: FROM OKL_K_RATE_PARAMS rate

2377: CURSOR get_orig_effective_from_dt_csr(
2378: p_khr_id NUMBER,
2379: p_parameter_type_code VARCHAR2) IS
2380: select rate.effective_from_date
2381: FROM OKL_K_RATE_PARAMS rate
2382: WHERE rate.khr_id = p_khr_id
2383: AND rate.parameter_type_code = p_parameter_type_code
2384: AND rate.effective_to_date IS NULL;
2385:

Line 2484: /*UPDATE OKL_K_RATE_PARAMS

2480: p_msg_name => 'OKL_LLA_VAR_RATE_DELETE_ERR2');
2481: RAISE OKL_API.G_EXCEPTION_ERROR;
2482: END IF;
2483:
2484: /*UPDATE OKL_K_RATE_PARAMS
2485: SET EFFECTIVE_TO_DATE = NULL
2486: WHERE KHR_ID = p_krpdel_tbl(i).khr_id
2487: AND PARAMETER_TYPE_CODE = l_parameter_type_code
2488: AND EFFECTIVE_TO_DATE = p_krpdel_tbl(i).effective_from_date - 1;*/

Line 2526: FROM OKL_K_RATE_PARAMS

2522: l_krpv_rec.ATTRIBUTE12, l_krpv_rec.ATTRIBUTE13, l_krpv_rec.ATTRIBUTE14,
2523: l_krpv_rec.ATTRIBUTE15, l_krpv_rec.CREATED_BY, l_krpv_rec.CREATION_DATE,
2524: l_krpv_rec.LAST_UPDATED_BY, l_krpv_rec.LAST_UPDATE_DATE, l_krpv_rec.LAST_UPDATE_LOGIN,
2525: l_krpv_rec.CATCHUP_FREQUENCY_CODE
2526: FROM OKL_K_RATE_PARAMS
2527: WHERE KHR_ID = p_krpdel_tbl(i).khr_id
2528: AND parameter_type_code = l_parameter_type_code
2529: AND effective_from_date = p_krpdel_tbl(i).effective_from_date;
2530:

Line 2556: UPDATE OKL_K_RATE_PARAMS

2552: l_krpv_rec.rate_change_frequency_code := null;
2553: l_krpv_rec.rate_change_start_date := null;
2554: l_krpv_rec.rate_change_value := null;
2555:
2556: UPDATE OKL_K_RATE_PARAMS
2557: SET interest_index_id = null,
2558: base_rate = null,
2559: adder_rate = null,
2560: minimum_rate = null,

Line 2588: UPDATE OKL_K_RATE_PARAMS

2584: l_krpv_rec.conversion_option_code := null;
2585: l_krpv_rec.next_conversion_date := null;
2586: l_krpv_rec.conversion_type_code := null;
2587:
2588: UPDATE OKL_K_RATE_PARAMS
2589: SET conversion_option_code = null,
2590: next_conversion_date = null,
2591: conversion_type_code = null
2592: WHERE KHR_ID = p_krpdel_tbl(i).khr_id

Line 2668: UPDATE OKL_K_RATE_PARAMS

2664: p_msg_name => 'OKL_LA_VAR_RATE_DELETE_ERR2');
2665: RAISE OKL_API.G_EXCEPTION_ERROR;
2666: END IF;*/
2667:
2668: UPDATE OKL_K_RATE_PARAMS
2669: SET EFFECTIVE_TO_DATE = NULL
2670: WHERE KHR_ID = p_krpdel_tbl(i).khr_id
2671: AND PARAMETER_TYPE_CODE = l_parameter_type_code
2672: AND EFFECTIVE_TO_DATE = p_krpdel_tbl(i).effective_from_date - 1;

Line 2818: FROM okl_k_rate_params

2814: ,last_updated_by
2815: ,last_update_date
2816: ,last_update_login
2817: ,catchup_frequency_code
2818: FROM okl_k_rate_params
2819: WHERE khr_id = p_id;
2820:
2821: l_deal_type VARCHAR2(30);
2822: l_interest_calculation_basis VARCHAR2(30);

Line 3181: FROM OKL_K_RATE_PARAMS

3177: rate_change_value,
3178: conversion_option_code,
3179: next_conversion_date,
3180: conversion_type_code
3181: FROM OKL_K_RATE_PARAMS
3182: WHERE KHR_ID = p_chr_id
3183: AND parameter_type_code IN ('ACTUAL', 'CONVERSION')
3184: ORDER BY effective_from_date, parameter_type_code;
3185:

Line 3484: FROM OKL_K_RATE_PARAMS

3480:
3481: --Bug 4735972
3482: CURSOR rate_csr(p_id NUMBER) IS
3483: SELECT COUNT(1) COUNT1
3484: FROM OKL_K_RATE_PARAMS
3485: WHERE KHR_ID = p_id
3486: AND EFFECTIVE_TO_DATE IS NULL;
3487: l_rate_count NUMBER;
3488: l_catchup_start_date DATE;

Line 3590: update OKL_K_RATE_PARAMS

3586: ELSE
3587: l_catchup_start_date := null;
3588: END IF;
3589:
3590: update OKL_K_RATE_PARAMS
3591: SET interest_start_date = p_new_start_date,
3592: rate_change_start_date = p_new_start_date,
3593: catchup_start_date = nvl(l_catchup_start_date,catchup_start_date)
3594: WHERE khr_id = p_chr_id

Line 3611: update okl_k_rate_params

3607: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3608: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3609: END IF; */
3610:
3611: update okl_k_rate_params
3612: set effective_from_date = p_new_start_date
3613: WHERE khr_id = p_chr_id
3614: AND effective_from_date = l_effective_from_date
3615: AND effective_to_date IS NULL;

Line 3619: update okl_k_rate_params

3615: AND effective_to_date IS NULL;
3616: --AND parameter_type_code = 'ACTUAL';
3617:
3618: /*ELSE
3619: update okl_k_rate_params
3620: set effective_from_date = p_new_start_date
3621: WHERE khr_id = p_chr_id
3622: AND effective_from_date = l_effective_from_date
3623: AND effective_to_date is NULL;

Line 3817: OKL_K_RATE_PARAMS_PVT.get_product(

3813: RAISE OKL_API.G_EXCEPTION_ERROR;
3814: END IF;
3815:
3816: -- Obtain the contract details - Book classification, Interest Calculation Basis, Revenue Recognition Method, Interest Processed flag
3817: OKL_K_RATE_PARAMS_PVT.get_product(
3818: p_api_version => p_api_version,
3819: p_init_msg_list => p_init_msg_list,
3820: x_return_status => x_return_status,
3821: x_msg_count => x_msg_count,

Line 4303: TYPE l_kkhr_id_type is table of okl_k_rate_params.khr_id%TYPE index by binary_integer;

4299:
4300: PROCEDURE SYNC_RATE_PARAMS(
4301: p_orig_contract_id IN NUMBER,
4302: p_new_contract_id IN NUMBER) IS
4303: TYPE l_kkhr_id_type is table of okl_k_rate_params.khr_id%TYPE index by binary_integer;
4304: TYPE l_kparameter_type_code_type is table of okl_k_rate_params.parameter_type_code%TYPE index by binary_integer;
4305: TYPE l_keffective_from_date_type is table of okl_k_rate_params.effective_from_date%TYPE index by binary_integer;
4306: TYPE l_keffective_to_date_type is table of okl_k_rate_params.effective_to_date%TYPE index by binary_integer;
4307: TYPE l_kinterest_index_id_type is table of okl_k_rate_params.interest_index_id%TYPE index by binary_integer;

Line 4304: TYPE l_kparameter_type_code_type is table of okl_k_rate_params.parameter_type_code%TYPE index by binary_integer;

4300: PROCEDURE SYNC_RATE_PARAMS(
4301: p_orig_contract_id IN NUMBER,
4302: p_new_contract_id IN NUMBER) IS
4303: TYPE l_kkhr_id_type is table of okl_k_rate_params.khr_id%TYPE index by binary_integer;
4304: TYPE l_kparameter_type_code_type is table of okl_k_rate_params.parameter_type_code%TYPE index by binary_integer;
4305: TYPE l_keffective_from_date_type is table of okl_k_rate_params.effective_from_date%TYPE index by binary_integer;
4306: TYPE l_keffective_to_date_type is table of okl_k_rate_params.effective_to_date%TYPE index by binary_integer;
4307: TYPE l_kinterest_index_id_type is table of okl_k_rate_params.interest_index_id%TYPE index by binary_integer;
4308: TYPE l_kbase_rate_type is table of okl_k_rate_params.base_rate%TYPE index by binary_integer;

Line 4305: TYPE l_keffective_from_date_type is table of okl_k_rate_params.effective_from_date%TYPE index by binary_integer;

4301: p_orig_contract_id IN NUMBER,
4302: p_new_contract_id IN NUMBER) IS
4303: TYPE l_kkhr_id_type is table of okl_k_rate_params.khr_id%TYPE index by binary_integer;
4304: TYPE l_kparameter_type_code_type is table of okl_k_rate_params.parameter_type_code%TYPE index by binary_integer;
4305: TYPE l_keffective_from_date_type is table of okl_k_rate_params.effective_from_date%TYPE index by binary_integer;
4306: TYPE l_keffective_to_date_type is table of okl_k_rate_params.effective_to_date%TYPE index by binary_integer;
4307: TYPE l_kinterest_index_id_type is table of okl_k_rate_params.interest_index_id%TYPE index by binary_integer;
4308: TYPE l_kbase_rate_type is table of okl_k_rate_params.base_rate%TYPE index by binary_integer;
4309: TYPE l_kinterest_start_date_type is table of okl_k_rate_params.interest_start_date%TYPE index by binary_integer;

Line 4306: TYPE l_keffective_to_date_type is table of okl_k_rate_params.effective_to_date%TYPE index by binary_integer;

4302: p_new_contract_id IN NUMBER) IS
4303: TYPE l_kkhr_id_type is table of okl_k_rate_params.khr_id%TYPE index by binary_integer;
4304: TYPE l_kparameter_type_code_type is table of okl_k_rate_params.parameter_type_code%TYPE index by binary_integer;
4305: TYPE l_keffective_from_date_type is table of okl_k_rate_params.effective_from_date%TYPE index by binary_integer;
4306: TYPE l_keffective_to_date_type is table of okl_k_rate_params.effective_to_date%TYPE index by binary_integer;
4307: TYPE l_kinterest_index_id_type is table of okl_k_rate_params.interest_index_id%TYPE index by binary_integer;
4308: TYPE l_kbase_rate_type is table of okl_k_rate_params.base_rate%TYPE index by binary_integer;
4309: TYPE l_kinterest_start_date_type is table of okl_k_rate_params.interest_start_date%TYPE index by binary_integer;
4310: TYPE l_kadder_rate_type is table of okl_k_rate_params.adder_rate%TYPE index by binary_integer;

Line 4307: TYPE l_kinterest_index_id_type is table of okl_k_rate_params.interest_index_id%TYPE index by binary_integer;

4303: TYPE l_kkhr_id_type is table of okl_k_rate_params.khr_id%TYPE index by binary_integer;
4304: TYPE l_kparameter_type_code_type is table of okl_k_rate_params.parameter_type_code%TYPE index by binary_integer;
4305: TYPE l_keffective_from_date_type is table of okl_k_rate_params.effective_from_date%TYPE index by binary_integer;
4306: TYPE l_keffective_to_date_type is table of okl_k_rate_params.effective_to_date%TYPE index by binary_integer;
4307: TYPE l_kinterest_index_id_type is table of okl_k_rate_params.interest_index_id%TYPE index by binary_integer;
4308: TYPE l_kbase_rate_type is table of okl_k_rate_params.base_rate%TYPE index by binary_integer;
4309: TYPE l_kinterest_start_date_type is table of okl_k_rate_params.interest_start_date%TYPE index by binary_integer;
4310: TYPE l_kadder_rate_type is table of okl_k_rate_params.adder_rate%TYPE index by binary_integer;
4311: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;

Line 4308: TYPE l_kbase_rate_type is table of okl_k_rate_params.base_rate%TYPE index by binary_integer;

4304: TYPE l_kparameter_type_code_type is table of okl_k_rate_params.parameter_type_code%TYPE index by binary_integer;
4305: TYPE l_keffective_from_date_type is table of okl_k_rate_params.effective_from_date%TYPE index by binary_integer;
4306: TYPE l_keffective_to_date_type is table of okl_k_rate_params.effective_to_date%TYPE index by binary_integer;
4307: TYPE l_kinterest_index_id_type is table of okl_k_rate_params.interest_index_id%TYPE index by binary_integer;
4308: TYPE l_kbase_rate_type is table of okl_k_rate_params.base_rate%TYPE index by binary_integer;
4309: TYPE l_kinterest_start_date_type is table of okl_k_rate_params.interest_start_date%TYPE index by binary_integer;
4310: TYPE l_kadder_rate_type is table of okl_k_rate_params.adder_rate%TYPE index by binary_integer;
4311: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;
4312: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;

Line 4309: TYPE l_kinterest_start_date_type is table of okl_k_rate_params.interest_start_date%TYPE index by binary_integer;

4305: TYPE l_keffective_from_date_type is table of okl_k_rate_params.effective_from_date%TYPE index by binary_integer;
4306: TYPE l_keffective_to_date_type is table of okl_k_rate_params.effective_to_date%TYPE index by binary_integer;
4307: TYPE l_kinterest_index_id_type is table of okl_k_rate_params.interest_index_id%TYPE index by binary_integer;
4308: TYPE l_kbase_rate_type is table of okl_k_rate_params.base_rate%TYPE index by binary_integer;
4309: TYPE l_kinterest_start_date_type is table of okl_k_rate_params.interest_start_date%TYPE index by binary_integer;
4310: TYPE l_kadder_rate_type is table of okl_k_rate_params.adder_rate%TYPE index by binary_integer;
4311: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;
4312: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;
4313: TYPE l_kprincipal_basis_code_type is table of okl_k_rate_params.principal_basis_code%TYPE index by binary_integer;

Line 4310: TYPE l_kadder_rate_type is table of okl_k_rate_params.adder_rate%TYPE index by binary_integer;

4306: TYPE l_keffective_to_date_type is table of okl_k_rate_params.effective_to_date%TYPE index by binary_integer;
4307: TYPE l_kinterest_index_id_type is table of okl_k_rate_params.interest_index_id%TYPE index by binary_integer;
4308: TYPE l_kbase_rate_type is table of okl_k_rate_params.base_rate%TYPE index by binary_integer;
4309: TYPE l_kinterest_start_date_type is table of okl_k_rate_params.interest_start_date%TYPE index by binary_integer;
4310: TYPE l_kadder_rate_type is table of okl_k_rate_params.adder_rate%TYPE index by binary_integer;
4311: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;
4312: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;
4313: TYPE l_kprincipal_basis_code_type is table of okl_k_rate_params.principal_basis_code%TYPE index by binary_integer;
4314: TYPE l_kdays_in_a_month_code_type is table of okl_k_rate_params.days_in_a_month_code%TYPE index by binary_integer;

Line 4311: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;

4307: TYPE l_kinterest_index_id_type is table of okl_k_rate_params.interest_index_id%TYPE index by binary_integer;
4308: TYPE l_kbase_rate_type is table of okl_k_rate_params.base_rate%TYPE index by binary_integer;
4309: TYPE l_kinterest_start_date_type is table of okl_k_rate_params.interest_start_date%TYPE index by binary_integer;
4310: TYPE l_kadder_rate_type is table of okl_k_rate_params.adder_rate%TYPE index by binary_integer;
4311: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;
4312: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;
4313: TYPE l_kprincipal_basis_code_type is table of okl_k_rate_params.principal_basis_code%TYPE index by binary_integer;
4314: TYPE l_kdays_in_a_month_code_type is table of okl_k_rate_params.days_in_a_month_code%TYPE index by binary_integer;
4315: TYPE l_kdays_in_a_year_code_type is table of okl_k_rate_params.days_in_a_year_code%TYPE index by binary_integer;

Line 4312: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;

4308: TYPE l_kbase_rate_type is table of okl_k_rate_params.base_rate%TYPE index by binary_integer;
4309: TYPE l_kinterest_start_date_type is table of okl_k_rate_params.interest_start_date%TYPE index by binary_integer;
4310: TYPE l_kadder_rate_type is table of okl_k_rate_params.adder_rate%TYPE index by binary_integer;
4311: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;
4312: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;
4313: TYPE l_kprincipal_basis_code_type is table of okl_k_rate_params.principal_basis_code%TYPE index by binary_integer;
4314: TYPE l_kdays_in_a_month_code_type is table of okl_k_rate_params.days_in_a_month_code%TYPE index by binary_integer;
4315: TYPE l_kdays_in_a_year_code_type is table of okl_k_rate_params.days_in_a_year_code%TYPE index by binary_integer;
4316: TYPE l_kinterest_basis_code_type is table of okl_k_rate_params.interest_basis_code%TYPE index by binary_integer;

Line 4313: TYPE l_kprincipal_basis_code_type is table of okl_k_rate_params.principal_basis_code%TYPE index by binary_integer;

4309: TYPE l_kinterest_start_date_type is table of okl_k_rate_params.interest_start_date%TYPE index by binary_integer;
4310: TYPE l_kadder_rate_type is table of okl_k_rate_params.adder_rate%TYPE index by binary_integer;
4311: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;
4312: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;
4313: TYPE l_kprincipal_basis_code_type is table of okl_k_rate_params.principal_basis_code%TYPE index by binary_integer;
4314: TYPE l_kdays_in_a_month_code_type is table of okl_k_rate_params.days_in_a_month_code%TYPE index by binary_integer;
4315: TYPE l_kdays_in_a_year_code_type is table of okl_k_rate_params.days_in_a_year_code%TYPE index by binary_integer;
4316: TYPE l_kinterest_basis_code_type is table of okl_k_rate_params.interest_basis_code%TYPE index by binary_integer;
4317: TYPE l_krate_delay_code_type is table of okl_k_rate_params.rate_delay_code%TYPE index by binary_integer;

Line 4314: TYPE l_kdays_in_a_month_code_type is table of okl_k_rate_params.days_in_a_month_code%TYPE index by binary_integer;

4310: TYPE l_kadder_rate_type is table of okl_k_rate_params.adder_rate%TYPE index by binary_integer;
4311: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;
4312: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;
4313: TYPE l_kprincipal_basis_code_type is table of okl_k_rate_params.principal_basis_code%TYPE index by binary_integer;
4314: TYPE l_kdays_in_a_month_code_type is table of okl_k_rate_params.days_in_a_month_code%TYPE index by binary_integer;
4315: TYPE l_kdays_in_a_year_code_type is table of okl_k_rate_params.days_in_a_year_code%TYPE index by binary_integer;
4316: TYPE l_kinterest_basis_code_type is table of okl_k_rate_params.interest_basis_code%TYPE index by binary_integer;
4317: TYPE l_krate_delay_code_type is table of okl_k_rate_params.rate_delay_code%TYPE index by binary_integer;
4318: TYPE l_krate_delay_frequency_type is table of okl_k_rate_params.rate_delay_frequency%TYPE index by binary_integer;

Line 4315: TYPE l_kdays_in_a_year_code_type is table of okl_k_rate_params.days_in_a_year_code%TYPE index by binary_integer;

4311: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;
4312: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;
4313: TYPE l_kprincipal_basis_code_type is table of okl_k_rate_params.principal_basis_code%TYPE index by binary_integer;
4314: TYPE l_kdays_in_a_month_code_type is table of okl_k_rate_params.days_in_a_month_code%TYPE index by binary_integer;
4315: TYPE l_kdays_in_a_year_code_type is table of okl_k_rate_params.days_in_a_year_code%TYPE index by binary_integer;
4316: TYPE l_kinterest_basis_code_type is table of okl_k_rate_params.interest_basis_code%TYPE index by binary_integer;
4317: TYPE l_krate_delay_code_type is table of okl_k_rate_params.rate_delay_code%TYPE index by binary_integer;
4318: TYPE l_krate_delay_frequency_type is table of okl_k_rate_params.rate_delay_frequency%TYPE index by binary_integer;
4319: TYPE l_kcompounding_frequ_code_type is table of okl_k_rate_params.compounding_frequency_code%TYPE index by binary_integer;

Line 4316: TYPE l_kinterest_basis_code_type is table of okl_k_rate_params.interest_basis_code%TYPE index by binary_integer;

4312: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;
4313: TYPE l_kprincipal_basis_code_type is table of okl_k_rate_params.principal_basis_code%TYPE index by binary_integer;
4314: TYPE l_kdays_in_a_month_code_type is table of okl_k_rate_params.days_in_a_month_code%TYPE index by binary_integer;
4315: TYPE l_kdays_in_a_year_code_type is table of okl_k_rate_params.days_in_a_year_code%TYPE index by binary_integer;
4316: TYPE l_kinterest_basis_code_type is table of okl_k_rate_params.interest_basis_code%TYPE index by binary_integer;
4317: TYPE l_krate_delay_code_type is table of okl_k_rate_params.rate_delay_code%TYPE index by binary_integer;
4318: TYPE l_krate_delay_frequency_type is table of okl_k_rate_params.rate_delay_frequency%TYPE index by binary_integer;
4319: TYPE l_kcompounding_frequ_code_type is table of okl_k_rate_params.compounding_frequency_code%TYPE index by binary_integer;
4320: TYPE l_kcalculation_formula_id_type is table of okl_k_rate_params.calculation_formula_id%TYPE index by binary_integer;

Line 4317: TYPE l_krate_delay_code_type is table of okl_k_rate_params.rate_delay_code%TYPE index by binary_integer;

4313: TYPE l_kprincipal_basis_code_type is table of okl_k_rate_params.principal_basis_code%TYPE index by binary_integer;
4314: TYPE l_kdays_in_a_month_code_type is table of okl_k_rate_params.days_in_a_month_code%TYPE index by binary_integer;
4315: TYPE l_kdays_in_a_year_code_type is table of okl_k_rate_params.days_in_a_year_code%TYPE index by binary_integer;
4316: TYPE l_kinterest_basis_code_type is table of okl_k_rate_params.interest_basis_code%TYPE index by binary_integer;
4317: TYPE l_krate_delay_code_type is table of okl_k_rate_params.rate_delay_code%TYPE index by binary_integer;
4318: TYPE l_krate_delay_frequency_type is table of okl_k_rate_params.rate_delay_frequency%TYPE index by binary_integer;
4319: TYPE l_kcompounding_frequ_code_type is table of okl_k_rate_params.compounding_frequency_code%TYPE index by binary_integer;
4320: TYPE l_kcalculation_formula_id_type is table of okl_k_rate_params.calculation_formula_id%TYPE index by binary_integer;
4321: TYPE l_kcatchup_basis_code_type is table of okl_k_rate_params.catchup_basis_code%TYPE index by binary_integer;

Line 4318: TYPE l_krate_delay_frequency_type is table of okl_k_rate_params.rate_delay_frequency%TYPE index by binary_integer;

4314: TYPE l_kdays_in_a_month_code_type is table of okl_k_rate_params.days_in_a_month_code%TYPE index by binary_integer;
4315: TYPE l_kdays_in_a_year_code_type is table of okl_k_rate_params.days_in_a_year_code%TYPE index by binary_integer;
4316: TYPE l_kinterest_basis_code_type is table of okl_k_rate_params.interest_basis_code%TYPE index by binary_integer;
4317: TYPE l_krate_delay_code_type is table of okl_k_rate_params.rate_delay_code%TYPE index by binary_integer;
4318: TYPE l_krate_delay_frequency_type is table of okl_k_rate_params.rate_delay_frequency%TYPE index by binary_integer;
4319: TYPE l_kcompounding_frequ_code_type is table of okl_k_rate_params.compounding_frequency_code%TYPE index by binary_integer;
4320: TYPE l_kcalculation_formula_id_type is table of okl_k_rate_params.calculation_formula_id%TYPE index by binary_integer;
4321: TYPE l_kcatchup_basis_code_type is table of okl_k_rate_params.catchup_basis_code%TYPE index by binary_integer;
4322: TYPE l_kcatchup_start_date_type is table of okl_k_rate_params.catchup_start_date%TYPE index by binary_integer;

Line 4319: TYPE l_kcompounding_frequ_code_type is table of okl_k_rate_params.compounding_frequency_code%TYPE index by binary_integer;

4315: TYPE l_kdays_in_a_year_code_type is table of okl_k_rate_params.days_in_a_year_code%TYPE index by binary_integer;
4316: TYPE l_kinterest_basis_code_type is table of okl_k_rate_params.interest_basis_code%TYPE index by binary_integer;
4317: TYPE l_krate_delay_code_type is table of okl_k_rate_params.rate_delay_code%TYPE index by binary_integer;
4318: TYPE l_krate_delay_frequency_type is table of okl_k_rate_params.rate_delay_frequency%TYPE index by binary_integer;
4319: TYPE l_kcompounding_frequ_code_type is table of okl_k_rate_params.compounding_frequency_code%TYPE index by binary_integer;
4320: TYPE l_kcalculation_formula_id_type is table of okl_k_rate_params.calculation_formula_id%TYPE index by binary_integer;
4321: TYPE l_kcatchup_basis_code_type is table of okl_k_rate_params.catchup_basis_code%TYPE index by binary_integer;
4322: TYPE l_kcatchup_start_date_type is table of okl_k_rate_params.catchup_start_date%TYPE index by binary_integer;
4323: TYPE l_kcatchup_settlemen_code_type is table of okl_k_rate_params.catchup_settlement_code%TYPE index by binary_integer;

Line 4320: TYPE l_kcalculation_formula_id_type is table of okl_k_rate_params.calculation_formula_id%TYPE index by binary_integer;

4316: TYPE l_kinterest_basis_code_type is table of okl_k_rate_params.interest_basis_code%TYPE index by binary_integer;
4317: TYPE l_krate_delay_code_type is table of okl_k_rate_params.rate_delay_code%TYPE index by binary_integer;
4318: TYPE l_krate_delay_frequency_type is table of okl_k_rate_params.rate_delay_frequency%TYPE index by binary_integer;
4319: TYPE l_kcompounding_frequ_code_type is table of okl_k_rate_params.compounding_frequency_code%TYPE index by binary_integer;
4320: TYPE l_kcalculation_formula_id_type is table of okl_k_rate_params.calculation_formula_id%TYPE index by binary_integer;
4321: TYPE l_kcatchup_basis_code_type is table of okl_k_rate_params.catchup_basis_code%TYPE index by binary_integer;
4322: TYPE l_kcatchup_start_date_type is table of okl_k_rate_params.catchup_start_date%TYPE index by binary_integer;
4323: TYPE l_kcatchup_settlemen_code_type is table of okl_k_rate_params.catchup_settlement_code%TYPE index by binary_integer;
4324: TYPE l_krate_change_start_date_type is table of okl_k_rate_params.rate_change_start_date%TYPE index by binary_integer;

Line 4321: TYPE l_kcatchup_basis_code_type is table of okl_k_rate_params.catchup_basis_code%TYPE index by binary_integer;

4317: TYPE l_krate_delay_code_type is table of okl_k_rate_params.rate_delay_code%TYPE index by binary_integer;
4318: TYPE l_krate_delay_frequency_type is table of okl_k_rate_params.rate_delay_frequency%TYPE index by binary_integer;
4319: TYPE l_kcompounding_frequ_code_type is table of okl_k_rate_params.compounding_frequency_code%TYPE index by binary_integer;
4320: TYPE l_kcalculation_formula_id_type is table of okl_k_rate_params.calculation_formula_id%TYPE index by binary_integer;
4321: TYPE l_kcatchup_basis_code_type is table of okl_k_rate_params.catchup_basis_code%TYPE index by binary_integer;
4322: TYPE l_kcatchup_start_date_type is table of okl_k_rate_params.catchup_start_date%TYPE index by binary_integer;
4323: TYPE l_kcatchup_settlemen_code_type is table of okl_k_rate_params.catchup_settlement_code%TYPE index by binary_integer;
4324: TYPE l_krate_change_start_date_type is table of okl_k_rate_params.rate_change_start_date%TYPE index by binary_integer;
4325: TYPE l_krate_change_frequ_code_type is table of okl_k_rate_params.rate_change_frequency_code%TYPE index by binary_integer;

Line 4322: TYPE l_kcatchup_start_date_type is table of okl_k_rate_params.catchup_start_date%TYPE index by binary_integer;

4318: TYPE l_krate_delay_frequency_type is table of okl_k_rate_params.rate_delay_frequency%TYPE index by binary_integer;
4319: TYPE l_kcompounding_frequ_code_type is table of okl_k_rate_params.compounding_frequency_code%TYPE index by binary_integer;
4320: TYPE l_kcalculation_formula_id_type is table of okl_k_rate_params.calculation_formula_id%TYPE index by binary_integer;
4321: TYPE l_kcatchup_basis_code_type is table of okl_k_rate_params.catchup_basis_code%TYPE index by binary_integer;
4322: TYPE l_kcatchup_start_date_type is table of okl_k_rate_params.catchup_start_date%TYPE index by binary_integer;
4323: TYPE l_kcatchup_settlemen_code_type is table of okl_k_rate_params.catchup_settlement_code%TYPE index by binary_integer;
4324: TYPE l_krate_change_start_date_type is table of okl_k_rate_params.rate_change_start_date%TYPE index by binary_integer;
4325: TYPE l_krate_change_frequ_code_type is table of okl_k_rate_params.rate_change_frequency_code%TYPE index by binary_integer;
4326: TYPE l_krate_change_value_type is table of okl_k_rate_params.rate_change_value%TYPE index by binary_integer;

Line 4323: TYPE l_kcatchup_settlemen_code_type is table of okl_k_rate_params.catchup_settlement_code%TYPE index by binary_integer;

4319: TYPE l_kcompounding_frequ_code_type is table of okl_k_rate_params.compounding_frequency_code%TYPE index by binary_integer;
4320: TYPE l_kcalculation_formula_id_type is table of okl_k_rate_params.calculation_formula_id%TYPE index by binary_integer;
4321: TYPE l_kcatchup_basis_code_type is table of okl_k_rate_params.catchup_basis_code%TYPE index by binary_integer;
4322: TYPE l_kcatchup_start_date_type is table of okl_k_rate_params.catchup_start_date%TYPE index by binary_integer;
4323: TYPE l_kcatchup_settlemen_code_type is table of okl_k_rate_params.catchup_settlement_code%TYPE index by binary_integer;
4324: TYPE l_krate_change_start_date_type is table of okl_k_rate_params.rate_change_start_date%TYPE index by binary_integer;
4325: TYPE l_krate_change_frequ_code_type is table of okl_k_rate_params.rate_change_frequency_code%TYPE index by binary_integer;
4326: TYPE l_krate_change_value_type is table of okl_k_rate_params.rate_change_value%TYPE index by binary_integer;
4327: TYPE l_kconversion_option_code_type is table of okl_k_rate_params.conversion_option_code%TYPE index by binary_integer;

Line 4324: TYPE l_krate_change_start_date_type is table of okl_k_rate_params.rate_change_start_date%TYPE index by binary_integer;

4320: TYPE l_kcalculation_formula_id_type is table of okl_k_rate_params.calculation_formula_id%TYPE index by binary_integer;
4321: TYPE l_kcatchup_basis_code_type is table of okl_k_rate_params.catchup_basis_code%TYPE index by binary_integer;
4322: TYPE l_kcatchup_start_date_type is table of okl_k_rate_params.catchup_start_date%TYPE index by binary_integer;
4323: TYPE l_kcatchup_settlemen_code_type is table of okl_k_rate_params.catchup_settlement_code%TYPE index by binary_integer;
4324: TYPE l_krate_change_start_date_type is table of okl_k_rate_params.rate_change_start_date%TYPE index by binary_integer;
4325: TYPE l_krate_change_frequ_code_type is table of okl_k_rate_params.rate_change_frequency_code%TYPE index by binary_integer;
4326: TYPE l_krate_change_value_type is table of okl_k_rate_params.rate_change_value%TYPE index by binary_integer;
4327: TYPE l_kconversion_option_code_type is table of okl_k_rate_params.conversion_option_code%TYPE index by binary_integer;
4328: TYPE l_knext_conversion_date_type is table of okl_k_rate_params.next_conversion_date%TYPE index by binary_integer;

Line 4325: TYPE l_krate_change_frequ_code_type is table of okl_k_rate_params.rate_change_frequency_code%TYPE index by binary_integer;

4321: TYPE l_kcatchup_basis_code_type is table of okl_k_rate_params.catchup_basis_code%TYPE index by binary_integer;
4322: TYPE l_kcatchup_start_date_type is table of okl_k_rate_params.catchup_start_date%TYPE index by binary_integer;
4323: TYPE l_kcatchup_settlemen_code_type is table of okl_k_rate_params.catchup_settlement_code%TYPE index by binary_integer;
4324: TYPE l_krate_change_start_date_type is table of okl_k_rate_params.rate_change_start_date%TYPE index by binary_integer;
4325: TYPE l_krate_change_frequ_code_type is table of okl_k_rate_params.rate_change_frequency_code%TYPE index by binary_integer;
4326: TYPE l_krate_change_value_type is table of okl_k_rate_params.rate_change_value%TYPE index by binary_integer;
4327: TYPE l_kconversion_option_code_type is table of okl_k_rate_params.conversion_option_code%TYPE index by binary_integer;
4328: TYPE l_knext_conversion_date_type is table of okl_k_rate_params.next_conversion_date%TYPE index by binary_integer;
4329: TYPE l_kconversion_type_code_type is table of okl_k_rate_params.conversion_type_code%TYPE index by binary_integer;

Line 4326: TYPE l_krate_change_value_type is table of okl_k_rate_params.rate_change_value%TYPE index by binary_integer;

4322: TYPE l_kcatchup_start_date_type is table of okl_k_rate_params.catchup_start_date%TYPE index by binary_integer;
4323: TYPE l_kcatchup_settlemen_code_type is table of okl_k_rate_params.catchup_settlement_code%TYPE index by binary_integer;
4324: TYPE l_krate_change_start_date_type is table of okl_k_rate_params.rate_change_start_date%TYPE index by binary_integer;
4325: TYPE l_krate_change_frequ_code_type is table of okl_k_rate_params.rate_change_frequency_code%TYPE index by binary_integer;
4326: TYPE l_krate_change_value_type is table of okl_k_rate_params.rate_change_value%TYPE index by binary_integer;
4327: TYPE l_kconversion_option_code_type is table of okl_k_rate_params.conversion_option_code%TYPE index by binary_integer;
4328: TYPE l_knext_conversion_date_type is table of okl_k_rate_params.next_conversion_date%TYPE index by binary_integer;
4329: TYPE l_kconversion_type_code_type is table of okl_k_rate_params.conversion_type_code%TYPE index by binary_integer;
4330: TYPE l_kattribute_category_type is table of okl_k_rate_params.attribute_category%TYPE index by binary_integer;

Line 4327: TYPE l_kconversion_option_code_type is table of okl_k_rate_params.conversion_option_code%TYPE index by binary_integer;

4323: TYPE l_kcatchup_settlemen_code_type is table of okl_k_rate_params.catchup_settlement_code%TYPE index by binary_integer;
4324: TYPE l_krate_change_start_date_type is table of okl_k_rate_params.rate_change_start_date%TYPE index by binary_integer;
4325: TYPE l_krate_change_frequ_code_type is table of okl_k_rate_params.rate_change_frequency_code%TYPE index by binary_integer;
4326: TYPE l_krate_change_value_type is table of okl_k_rate_params.rate_change_value%TYPE index by binary_integer;
4327: TYPE l_kconversion_option_code_type is table of okl_k_rate_params.conversion_option_code%TYPE index by binary_integer;
4328: TYPE l_knext_conversion_date_type is table of okl_k_rate_params.next_conversion_date%TYPE index by binary_integer;
4329: TYPE l_kconversion_type_code_type is table of okl_k_rate_params.conversion_type_code%TYPE index by binary_integer;
4330: TYPE l_kattribute_category_type is table of okl_k_rate_params.attribute_category%TYPE index by binary_integer;
4331: TYPE l_kattribute1_type is table of okl_k_rate_params.attribute1%TYPE index by binary_integer;

Line 4328: TYPE l_knext_conversion_date_type is table of okl_k_rate_params.next_conversion_date%TYPE index by binary_integer;

4324: TYPE l_krate_change_start_date_type is table of okl_k_rate_params.rate_change_start_date%TYPE index by binary_integer;
4325: TYPE l_krate_change_frequ_code_type is table of okl_k_rate_params.rate_change_frequency_code%TYPE index by binary_integer;
4326: TYPE l_krate_change_value_type is table of okl_k_rate_params.rate_change_value%TYPE index by binary_integer;
4327: TYPE l_kconversion_option_code_type is table of okl_k_rate_params.conversion_option_code%TYPE index by binary_integer;
4328: TYPE l_knext_conversion_date_type is table of okl_k_rate_params.next_conversion_date%TYPE index by binary_integer;
4329: TYPE l_kconversion_type_code_type is table of okl_k_rate_params.conversion_type_code%TYPE index by binary_integer;
4330: TYPE l_kattribute_category_type is table of okl_k_rate_params.attribute_category%TYPE index by binary_integer;
4331: TYPE l_kattribute1_type is table of okl_k_rate_params.attribute1%TYPE index by binary_integer;
4332: TYPE l_kattribute2_type is table of okl_k_rate_params.attribute2%TYPE index by binary_integer;

Line 4329: TYPE l_kconversion_type_code_type is table of okl_k_rate_params.conversion_type_code%TYPE index by binary_integer;

4325: TYPE l_krate_change_frequ_code_type is table of okl_k_rate_params.rate_change_frequency_code%TYPE index by binary_integer;
4326: TYPE l_krate_change_value_type is table of okl_k_rate_params.rate_change_value%TYPE index by binary_integer;
4327: TYPE l_kconversion_option_code_type is table of okl_k_rate_params.conversion_option_code%TYPE index by binary_integer;
4328: TYPE l_knext_conversion_date_type is table of okl_k_rate_params.next_conversion_date%TYPE index by binary_integer;
4329: TYPE l_kconversion_type_code_type is table of okl_k_rate_params.conversion_type_code%TYPE index by binary_integer;
4330: TYPE l_kattribute_category_type is table of okl_k_rate_params.attribute_category%TYPE index by binary_integer;
4331: TYPE l_kattribute1_type is table of okl_k_rate_params.attribute1%TYPE index by binary_integer;
4332: TYPE l_kattribute2_type is table of okl_k_rate_params.attribute2%TYPE index by binary_integer;
4333: TYPE l_kattribute3_type is table of okl_k_rate_params.attribute3%TYPE index by binary_integer;

Line 4330: TYPE l_kattribute_category_type is table of okl_k_rate_params.attribute_category%TYPE index by binary_integer;

4326: TYPE l_krate_change_value_type is table of okl_k_rate_params.rate_change_value%TYPE index by binary_integer;
4327: TYPE l_kconversion_option_code_type is table of okl_k_rate_params.conversion_option_code%TYPE index by binary_integer;
4328: TYPE l_knext_conversion_date_type is table of okl_k_rate_params.next_conversion_date%TYPE index by binary_integer;
4329: TYPE l_kconversion_type_code_type is table of okl_k_rate_params.conversion_type_code%TYPE index by binary_integer;
4330: TYPE l_kattribute_category_type is table of okl_k_rate_params.attribute_category%TYPE index by binary_integer;
4331: TYPE l_kattribute1_type is table of okl_k_rate_params.attribute1%TYPE index by binary_integer;
4332: TYPE l_kattribute2_type is table of okl_k_rate_params.attribute2%TYPE index by binary_integer;
4333: TYPE l_kattribute3_type is table of okl_k_rate_params.attribute3%TYPE index by binary_integer;
4334: TYPE l_kattribute4_type is table of okl_k_rate_params.attribute4%TYPE index by binary_integer;

Line 4331: TYPE l_kattribute1_type is table of okl_k_rate_params.attribute1%TYPE index by binary_integer;

4327: TYPE l_kconversion_option_code_type is table of okl_k_rate_params.conversion_option_code%TYPE index by binary_integer;
4328: TYPE l_knext_conversion_date_type is table of okl_k_rate_params.next_conversion_date%TYPE index by binary_integer;
4329: TYPE l_kconversion_type_code_type is table of okl_k_rate_params.conversion_type_code%TYPE index by binary_integer;
4330: TYPE l_kattribute_category_type is table of okl_k_rate_params.attribute_category%TYPE index by binary_integer;
4331: TYPE l_kattribute1_type is table of okl_k_rate_params.attribute1%TYPE index by binary_integer;
4332: TYPE l_kattribute2_type is table of okl_k_rate_params.attribute2%TYPE index by binary_integer;
4333: TYPE l_kattribute3_type is table of okl_k_rate_params.attribute3%TYPE index by binary_integer;
4334: TYPE l_kattribute4_type is table of okl_k_rate_params.attribute4%TYPE index by binary_integer;
4335: TYPE l_kattribute5_type is table of okl_k_rate_params.attribute5%TYPE index by binary_integer;

Line 4332: TYPE l_kattribute2_type is table of okl_k_rate_params.attribute2%TYPE index by binary_integer;

4328: TYPE l_knext_conversion_date_type is table of okl_k_rate_params.next_conversion_date%TYPE index by binary_integer;
4329: TYPE l_kconversion_type_code_type is table of okl_k_rate_params.conversion_type_code%TYPE index by binary_integer;
4330: TYPE l_kattribute_category_type is table of okl_k_rate_params.attribute_category%TYPE index by binary_integer;
4331: TYPE l_kattribute1_type is table of okl_k_rate_params.attribute1%TYPE index by binary_integer;
4332: TYPE l_kattribute2_type is table of okl_k_rate_params.attribute2%TYPE index by binary_integer;
4333: TYPE l_kattribute3_type is table of okl_k_rate_params.attribute3%TYPE index by binary_integer;
4334: TYPE l_kattribute4_type is table of okl_k_rate_params.attribute4%TYPE index by binary_integer;
4335: TYPE l_kattribute5_type is table of okl_k_rate_params.attribute5%TYPE index by binary_integer;
4336: TYPE l_kattribute6_type is table of okl_k_rate_params.attribute6%TYPE index by binary_integer;

Line 4333: TYPE l_kattribute3_type is table of okl_k_rate_params.attribute3%TYPE index by binary_integer;

4329: TYPE l_kconversion_type_code_type is table of okl_k_rate_params.conversion_type_code%TYPE index by binary_integer;
4330: TYPE l_kattribute_category_type is table of okl_k_rate_params.attribute_category%TYPE index by binary_integer;
4331: TYPE l_kattribute1_type is table of okl_k_rate_params.attribute1%TYPE index by binary_integer;
4332: TYPE l_kattribute2_type is table of okl_k_rate_params.attribute2%TYPE index by binary_integer;
4333: TYPE l_kattribute3_type is table of okl_k_rate_params.attribute3%TYPE index by binary_integer;
4334: TYPE l_kattribute4_type is table of okl_k_rate_params.attribute4%TYPE index by binary_integer;
4335: TYPE l_kattribute5_type is table of okl_k_rate_params.attribute5%TYPE index by binary_integer;
4336: TYPE l_kattribute6_type is table of okl_k_rate_params.attribute6%TYPE index by binary_integer;
4337: TYPE l_kattribute7_type is table of okl_k_rate_params.attribute7%TYPE index by binary_integer;

Line 4334: TYPE l_kattribute4_type is table of okl_k_rate_params.attribute4%TYPE index by binary_integer;

4330: TYPE l_kattribute_category_type is table of okl_k_rate_params.attribute_category%TYPE index by binary_integer;
4331: TYPE l_kattribute1_type is table of okl_k_rate_params.attribute1%TYPE index by binary_integer;
4332: TYPE l_kattribute2_type is table of okl_k_rate_params.attribute2%TYPE index by binary_integer;
4333: TYPE l_kattribute3_type is table of okl_k_rate_params.attribute3%TYPE index by binary_integer;
4334: TYPE l_kattribute4_type is table of okl_k_rate_params.attribute4%TYPE index by binary_integer;
4335: TYPE l_kattribute5_type is table of okl_k_rate_params.attribute5%TYPE index by binary_integer;
4336: TYPE l_kattribute6_type is table of okl_k_rate_params.attribute6%TYPE index by binary_integer;
4337: TYPE l_kattribute7_type is table of okl_k_rate_params.attribute7%TYPE index by binary_integer;
4338: TYPE l_kattribute8_type is table of okl_k_rate_params.attribute8%TYPE index by binary_integer;

Line 4335: TYPE l_kattribute5_type is table of okl_k_rate_params.attribute5%TYPE index by binary_integer;

4331: TYPE l_kattribute1_type is table of okl_k_rate_params.attribute1%TYPE index by binary_integer;
4332: TYPE l_kattribute2_type is table of okl_k_rate_params.attribute2%TYPE index by binary_integer;
4333: TYPE l_kattribute3_type is table of okl_k_rate_params.attribute3%TYPE index by binary_integer;
4334: TYPE l_kattribute4_type is table of okl_k_rate_params.attribute4%TYPE index by binary_integer;
4335: TYPE l_kattribute5_type is table of okl_k_rate_params.attribute5%TYPE index by binary_integer;
4336: TYPE l_kattribute6_type is table of okl_k_rate_params.attribute6%TYPE index by binary_integer;
4337: TYPE l_kattribute7_type is table of okl_k_rate_params.attribute7%TYPE index by binary_integer;
4338: TYPE l_kattribute8_type is table of okl_k_rate_params.attribute8%TYPE index by binary_integer;
4339: TYPE l_kattribute9_type is table of okl_k_rate_params.attribute9%TYPE index by binary_integer;

Line 4336: TYPE l_kattribute6_type is table of okl_k_rate_params.attribute6%TYPE index by binary_integer;

4332: TYPE l_kattribute2_type is table of okl_k_rate_params.attribute2%TYPE index by binary_integer;
4333: TYPE l_kattribute3_type is table of okl_k_rate_params.attribute3%TYPE index by binary_integer;
4334: TYPE l_kattribute4_type is table of okl_k_rate_params.attribute4%TYPE index by binary_integer;
4335: TYPE l_kattribute5_type is table of okl_k_rate_params.attribute5%TYPE index by binary_integer;
4336: TYPE l_kattribute6_type is table of okl_k_rate_params.attribute6%TYPE index by binary_integer;
4337: TYPE l_kattribute7_type is table of okl_k_rate_params.attribute7%TYPE index by binary_integer;
4338: TYPE l_kattribute8_type is table of okl_k_rate_params.attribute8%TYPE index by binary_integer;
4339: TYPE l_kattribute9_type is table of okl_k_rate_params.attribute9%TYPE index by binary_integer;
4340: TYPE l_kattribute10_type is table of okl_k_rate_params.attribute10%TYPE index by binary_integer;

Line 4337: TYPE l_kattribute7_type is table of okl_k_rate_params.attribute7%TYPE index by binary_integer;

4333: TYPE l_kattribute3_type is table of okl_k_rate_params.attribute3%TYPE index by binary_integer;
4334: TYPE l_kattribute4_type is table of okl_k_rate_params.attribute4%TYPE index by binary_integer;
4335: TYPE l_kattribute5_type is table of okl_k_rate_params.attribute5%TYPE index by binary_integer;
4336: TYPE l_kattribute6_type is table of okl_k_rate_params.attribute6%TYPE index by binary_integer;
4337: TYPE l_kattribute7_type is table of okl_k_rate_params.attribute7%TYPE index by binary_integer;
4338: TYPE l_kattribute8_type is table of okl_k_rate_params.attribute8%TYPE index by binary_integer;
4339: TYPE l_kattribute9_type is table of okl_k_rate_params.attribute9%TYPE index by binary_integer;
4340: TYPE l_kattribute10_type is table of okl_k_rate_params.attribute10%TYPE index by binary_integer;
4341: TYPE l_kattribute11_type is table of okl_k_rate_params.attribute11%TYPE index by binary_integer;

Line 4338: TYPE l_kattribute8_type is table of okl_k_rate_params.attribute8%TYPE index by binary_integer;

4334: TYPE l_kattribute4_type is table of okl_k_rate_params.attribute4%TYPE index by binary_integer;
4335: TYPE l_kattribute5_type is table of okl_k_rate_params.attribute5%TYPE index by binary_integer;
4336: TYPE l_kattribute6_type is table of okl_k_rate_params.attribute6%TYPE index by binary_integer;
4337: TYPE l_kattribute7_type is table of okl_k_rate_params.attribute7%TYPE index by binary_integer;
4338: TYPE l_kattribute8_type is table of okl_k_rate_params.attribute8%TYPE index by binary_integer;
4339: TYPE l_kattribute9_type is table of okl_k_rate_params.attribute9%TYPE index by binary_integer;
4340: TYPE l_kattribute10_type is table of okl_k_rate_params.attribute10%TYPE index by binary_integer;
4341: TYPE l_kattribute11_type is table of okl_k_rate_params.attribute11%TYPE index by binary_integer;
4342: TYPE l_kattribute12_type is table of okl_k_rate_params.attribute12%TYPE index by binary_integer;

Line 4339: TYPE l_kattribute9_type is table of okl_k_rate_params.attribute9%TYPE index by binary_integer;

4335: TYPE l_kattribute5_type is table of okl_k_rate_params.attribute5%TYPE index by binary_integer;
4336: TYPE l_kattribute6_type is table of okl_k_rate_params.attribute6%TYPE index by binary_integer;
4337: TYPE l_kattribute7_type is table of okl_k_rate_params.attribute7%TYPE index by binary_integer;
4338: TYPE l_kattribute8_type is table of okl_k_rate_params.attribute8%TYPE index by binary_integer;
4339: TYPE l_kattribute9_type is table of okl_k_rate_params.attribute9%TYPE index by binary_integer;
4340: TYPE l_kattribute10_type is table of okl_k_rate_params.attribute10%TYPE index by binary_integer;
4341: TYPE l_kattribute11_type is table of okl_k_rate_params.attribute11%TYPE index by binary_integer;
4342: TYPE l_kattribute12_type is table of okl_k_rate_params.attribute12%TYPE index by binary_integer;
4343: TYPE l_kattribute13_type is table of okl_k_rate_params.attribute13%TYPE index by binary_integer;

Line 4340: TYPE l_kattribute10_type is table of okl_k_rate_params.attribute10%TYPE index by binary_integer;

4336: TYPE l_kattribute6_type is table of okl_k_rate_params.attribute6%TYPE index by binary_integer;
4337: TYPE l_kattribute7_type is table of okl_k_rate_params.attribute7%TYPE index by binary_integer;
4338: TYPE l_kattribute8_type is table of okl_k_rate_params.attribute8%TYPE index by binary_integer;
4339: TYPE l_kattribute9_type is table of okl_k_rate_params.attribute9%TYPE index by binary_integer;
4340: TYPE l_kattribute10_type is table of okl_k_rate_params.attribute10%TYPE index by binary_integer;
4341: TYPE l_kattribute11_type is table of okl_k_rate_params.attribute11%TYPE index by binary_integer;
4342: TYPE l_kattribute12_type is table of okl_k_rate_params.attribute12%TYPE index by binary_integer;
4343: TYPE l_kattribute13_type is table of okl_k_rate_params.attribute13%TYPE index by binary_integer;
4344: TYPE l_kattribute14_type is table of okl_k_rate_params.attribute14%TYPE index by binary_integer;

Line 4341: TYPE l_kattribute11_type is table of okl_k_rate_params.attribute11%TYPE index by binary_integer;

4337: TYPE l_kattribute7_type is table of okl_k_rate_params.attribute7%TYPE index by binary_integer;
4338: TYPE l_kattribute8_type is table of okl_k_rate_params.attribute8%TYPE index by binary_integer;
4339: TYPE l_kattribute9_type is table of okl_k_rate_params.attribute9%TYPE index by binary_integer;
4340: TYPE l_kattribute10_type is table of okl_k_rate_params.attribute10%TYPE index by binary_integer;
4341: TYPE l_kattribute11_type is table of okl_k_rate_params.attribute11%TYPE index by binary_integer;
4342: TYPE l_kattribute12_type is table of okl_k_rate_params.attribute12%TYPE index by binary_integer;
4343: TYPE l_kattribute13_type is table of okl_k_rate_params.attribute13%TYPE index by binary_integer;
4344: TYPE l_kattribute14_type is table of okl_k_rate_params.attribute14%TYPE index by binary_integer;
4345: TYPE l_kattribute15_type is table of okl_k_rate_params.attribute15%TYPE index by binary_integer;

Line 4342: TYPE l_kattribute12_type is table of okl_k_rate_params.attribute12%TYPE index by binary_integer;

4338: TYPE l_kattribute8_type is table of okl_k_rate_params.attribute8%TYPE index by binary_integer;
4339: TYPE l_kattribute9_type is table of okl_k_rate_params.attribute9%TYPE index by binary_integer;
4340: TYPE l_kattribute10_type is table of okl_k_rate_params.attribute10%TYPE index by binary_integer;
4341: TYPE l_kattribute11_type is table of okl_k_rate_params.attribute11%TYPE index by binary_integer;
4342: TYPE l_kattribute12_type is table of okl_k_rate_params.attribute12%TYPE index by binary_integer;
4343: TYPE l_kattribute13_type is table of okl_k_rate_params.attribute13%TYPE index by binary_integer;
4344: TYPE l_kattribute14_type is table of okl_k_rate_params.attribute14%TYPE index by binary_integer;
4345: TYPE l_kattribute15_type is table of okl_k_rate_params.attribute15%TYPE index by binary_integer;
4346: TYPE l_kcatchup_frequency_code_type is table of okl_k_rate_params.catchup_frequency_code%TYPE index by binary_integer;

Line 4343: TYPE l_kattribute13_type is table of okl_k_rate_params.attribute13%TYPE index by binary_integer;

4339: TYPE l_kattribute9_type is table of okl_k_rate_params.attribute9%TYPE index by binary_integer;
4340: TYPE l_kattribute10_type is table of okl_k_rate_params.attribute10%TYPE index by binary_integer;
4341: TYPE l_kattribute11_type is table of okl_k_rate_params.attribute11%TYPE index by binary_integer;
4342: TYPE l_kattribute12_type is table of okl_k_rate_params.attribute12%TYPE index by binary_integer;
4343: TYPE l_kattribute13_type is table of okl_k_rate_params.attribute13%TYPE index by binary_integer;
4344: TYPE l_kattribute14_type is table of okl_k_rate_params.attribute14%TYPE index by binary_integer;
4345: TYPE l_kattribute15_type is table of okl_k_rate_params.attribute15%TYPE index by binary_integer;
4346: TYPE l_kcatchup_frequency_code_type is table of okl_k_rate_params.catchup_frequency_code%TYPE index by binary_integer;
4347:

Line 4344: TYPE l_kattribute14_type is table of okl_k_rate_params.attribute14%TYPE index by binary_integer;

4340: TYPE l_kattribute10_type is table of okl_k_rate_params.attribute10%TYPE index by binary_integer;
4341: TYPE l_kattribute11_type is table of okl_k_rate_params.attribute11%TYPE index by binary_integer;
4342: TYPE l_kattribute12_type is table of okl_k_rate_params.attribute12%TYPE index by binary_integer;
4343: TYPE l_kattribute13_type is table of okl_k_rate_params.attribute13%TYPE index by binary_integer;
4344: TYPE l_kattribute14_type is table of okl_k_rate_params.attribute14%TYPE index by binary_integer;
4345: TYPE l_kattribute15_type is table of okl_k_rate_params.attribute15%TYPE index by binary_integer;
4346: TYPE l_kcatchup_frequency_code_type is table of okl_k_rate_params.catchup_frequency_code%TYPE index by binary_integer;
4347:
4348: l_kkhr_id_tab l_kkhr_id_type;

Line 4345: TYPE l_kattribute15_type is table of okl_k_rate_params.attribute15%TYPE index by binary_integer;

4341: TYPE l_kattribute11_type is table of okl_k_rate_params.attribute11%TYPE index by binary_integer;
4342: TYPE l_kattribute12_type is table of okl_k_rate_params.attribute12%TYPE index by binary_integer;
4343: TYPE l_kattribute13_type is table of okl_k_rate_params.attribute13%TYPE index by binary_integer;
4344: TYPE l_kattribute14_type is table of okl_k_rate_params.attribute14%TYPE index by binary_integer;
4345: TYPE l_kattribute15_type is table of okl_k_rate_params.attribute15%TYPE index by binary_integer;
4346: TYPE l_kcatchup_frequency_code_type is table of okl_k_rate_params.catchup_frequency_code%TYPE index by binary_integer;
4347:
4348: l_kkhr_id_tab l_kkhr_id_type;
4349: l_kparameter_type_code_tab l_kparameter_type_code_type;

Line 4346: TYPE l_kcatchup_frequency_code_type is table of okl_k_rate_params.catchup_frequency_code%TYPE index by binary_integer;

4342: TYPE l_kattribute12_type is table of okl_k_rate_params.attribute12%TYPE index by binary_integer;
4343: TYPE l_kattribute13_type is table of okl_k_rate_params.attribute13%TYPE index by binary_integer;
4344: TYPE l_kattribute14_type is table of okl_k_rate_params.attribute14%TYPE index by binary_integer;
4345: TYPE l_kattribute15_type is table of okl_k_rate_params.attribute15%TYPE index by binary_integer;
4346: TYPE l_kcatchup_frequency_code_type is table of okl_k_rate_params.catchup_frequency_code%TYPE index by binary_integer;
4347:
4348: l_kkhr_id_tab l_kkhr_id_type;
4349: l_kparameter_type_code_tab l_kparameter_type_code_type;
4350: l_keffective_from_date_tab l_keffective_from_date_type;

Line 4458: FROM OKL_K_RATE_PARAMS a

4454: a.attribute6, a.attribute7, a.attribute8,
4455: a.attribute9, a.attribute10, a.attribute11,
4456: a.attribute12, a.attribute13, a.attribute14,
4457: a.attribute15, a.catchup_frequency_code
4458: FROM OKL_K_RATE_PARAMS a
4459: WHERE a.khr_id = p_id;
4460: --AND (effective_to_date is NULL OR
4461: -- effective_to_date = p_date);
4462:

Line 4465: FROM OKL_K_RATE_PARAMS

4461: -- effective_to_date = p_date);
4462:
4463: /*CURSOR max_effective_to_date_csr(p_id NUMBER) IS
4464: SELECT max(effective_to_date) effective_to_date
4465: FROM OKL_K_RATE_PARAMS
4466: WHERE KHR_ID = p_id;
4467:
4468: l_max_effective_to_date DATE;*/
4469: BEGIN

Line 4473: DELETE OKL_K_RATE_PARAMS

4469: BEGIN
4470: IF (G_DEBUG_ENABLED = 'Y') THEN
4471: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
4472: END IF;
4473: DELETE OKL_K_RATE_PARAMS
4474: WHERE KHR_ID = p_new_contract_id;
4475: --AND effective_to_date is NULL;
4476:
4477: /*FOR r IN max_effective_to_date_csr(p_orig_contract_id)

Line 4563: INSERT INTO okl_k_rate_params (

4559: CLOSE C30;
4560:
4561: IF l_k_rate_params_counter > 1 THEN
4562: FORALL i IN l_kkhr_id_tab.FIRST..l_kkhr_id_tab.LAST
4563: INSERT INTO okl_k_rate_params (
4564: khr_id, parameter_type_code, effective_from_date,
4565: effective_to_date, interest_index_id, base_rate,
4566: interest_start_date, adder_rate, maximum_rate,
4567: minimum_rate, principal_basis_code, days_in_a_month_code,

Line 4671: FROM OKL_K_RATE_PARAMS

4667: x_base_rate_defined OUT NOCOPY BOOLEAN,
4668: x_return_status OUT NOCOPY VARCHAR2) IS
4669: CURSOR base_rate_csr(p_id NUMBER) IS
4670: SELECT base_rate
4671: FROM OKL_K_RATE_PARAMS
4672: WHERE KHR_ID = p_id
4673: AND PARAMETER_TYPE_CODE = 'ACTUAL'
4674: AND EFFECTIVE_TO_DATE IS NULL;
4675:

Line 4837: FROM OKL_K_RATE_PARAMS rate,

4833: select rate.effective_from_date,
4834: contract.orig_system_source_code,
4835: lease.date_last_interim_interest_cal,
4836: contract.orig_system_id1
4837: FROM OKL_K_RATE_PARAMS rate,
4838: OKC_K_HEADERS_B contract,
4839: OKL_K_HEADERS lease
4840: WHERE rate.khr_id = p_khr_id
4841: AND rate.parameter_type_code = p_parameter_type_code

Line 4888: OKL_K_RATE_PARAMS_PVT.get_product(

4884: p_api_version => p_api_version,
4885: p_api_type => G_API_TYPE,
4886: x_return_status => x_return_status);
4887:
4888: OKL_K_RATE_PARAMS_PVT.get_product(
4889: p_api_version => p_api_version,
4890: p_init_msg_list => p_init_msg_list,
4891: x_return_status => x_return_status,
4892: x_msg_count => x_msg_count,

Line 5047: FROM OKL_K_RATE_PARAMS

5043: x_krpv_rec.ATTRIBUTE12, x_krpv_rec.ATTRIBUTE13, x_krpv_rec.ATTRIBUTE14,
5044: x_krpv_rec.ATTRIBUTE15, x_krpv_rec.CREATED_BY, x_krpv_rec.CREATION_DATE,
5045: x_krpv_rec.LAST_UPDATED_BY, x_krpv_rec.LAST_UPDATE_DATE, x_krpv_rec.LAST_UPDATE_LOGIN,
5046: x_krpv_rec.CATCHUP_FREQUENCY_CODE
5047: FROM OKL_K_RATE_PARAMS
5048: WHERE KHR_ID = p_khr_id
5049: AND PARAMETER_TYPE_CODE = l_parameter_type_code
5050: AND EFFECTIVE_FROM_DATE = l_effective_from_date
5051: AND EFFECTIVE_TO_DATE IS NULL;

Line 5053: INSERT INTO OKL_K_RATE_PARAMS (

5049: AND PARAMETER_TYPE_CODE = l_parameter_type_code
5050: AND EFFECTIVE_FROM_DATE = l_effective_from_date
5051: AND EFFECTIVE_TO_DATE IS NULL;
5052:
5053: INSERT INTO OKL_K_RATE_PARAMS (
5054: KHR_ID, PARAMETER_TYPE_CODE, EFFECTIVE_FROM_DATE,
5055: EFFECTIVE_TO_DATE, INTEREST_INDEX_ID, BASE_RATE,
5056: INTEREST_START_DATE, ADDER_RATE, MAXIMUM_RATE,
5057: MINIMUM_RATE, PRINCIPAL_BASIS_CODE, DAYS_IN_A_MONTH_CODE,

Line 5091: UPDATE OKL_K_RATE_PARAMS

5087: x_krpv_rec.ATTRIBUTE15, x_krpv_rec.CREATED_BY, x_krpv_rec.CREATION_DATE,
5088: x_krpv_rec.LAST_UPDATED_BY, x_krpv_rec.LAST_UPDATE_DATE, x_krpv_rec.LAST_UPDATE_LOGIN,
5089: x_krpv_rec.CATCHUP_FREQUENCY_CODE);
5090:
5091: UPDATE OKL_K_RATE_PARAMS
5092: SET EFFECTIVE_TO_DATE = p_effective_from_date - 1
5093: WHERE KHR_ID = p_khr_id
5094: AND PARAMETER_TYPE_CODE = l_parameter_type_code
5095: AND EFFECTIVE_FROM_DATE = l_effective_from_date

Line 5163: FROM OKL_K_RATE_PARAMS

5159: x_return_status => x_return_status);
5160:
5161: SELECT COUNT(1)
5162: INTO l_base_count
5163: FROM OKL_K_RATE_PARAMS
5164: WHERE khr_id = p_khr_id
5165: AND PARAMETER_TYPE_CODE = 'ACTUAL'
5166: AND EFFECTIVE_TO_DATE IS NULL
5167: AND BASE_RATE IS NULL;

Line 5180: UPDATE OKL_K_RATE_PARAMS

5176:
5177: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5178: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_implicit_interest_rate=' || l_implicit_interest_rate);
5179: END IF;
5180: UPDATE OKL_K_RATE_PARAMS
5181: SET BASE_RATE = l_implicit_interest_rate
5182: WHERE khr_id = p_khr_id
5183: AND PARAMETER_TYPE_CODE = 'ACTUAL'
5184: AND EFFECTIVE_TO_DATE IS NULL

Line 5220: END OKL_K_RATE_PARAMS_PVT;

5216: p_api_type => g_api_type);
5217:
5218: END;
5219:
5220: END OKL_K_RATE_PARAMS_PVT;