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.33.12020000.3 2012/08/28 14:13:27 racheruv 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 250: FROM OKL_K_RATE_PARAMS

246: x_effective_from_date OUT NOCOPY DATE,
247: x_no_data_found OUT NOCOPY BOOLEAN) IS
248: CURSOR effective_from_date_csr(p_id NUMBER) IS
249: SELECT MAX(EFFECTIVE_FROM_DATE)
250: FROM OKL_K_RATE_PARAMS
251: WHERE KHR_ID = p_id
252: AND EFFECTIVE_TO_DATE IS NULL;
253: BEGIN
254: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 433: CURSOR okl_k_rate_params_v_u1_csr (p_effective_from_date IN DATE,

429: p_effective_from_date IN DATE,
430: x_krpv_rec OUT NOCOPY krpv_rec_type,
431: x_no_data_found OUT NOCOPY BOOLEAN
432: ) IS
433: CURSOR okl_k_rate_params_v_u1_csr (p_effective_from_date IN DATE,
434: p_khr_id IN NUMBER,
435: p_parameter_type_code IN VARCHAR2) IS
436: SELECT
437: KHR_ID,

Line 485: FROM Okl_K_Rate_Params_V

481: CREATION_DATE,
482: LAST_UPDATED_BY,
483: LAST_UPDATE_DATE,
484: LAST_UPDATE_LOGIN
485: FROM Okl_K_Rate_Params_V
486: WHERE effective_from_date = NVL(p_effective_from_date,effective_from_date)
487: AND khr_id = p_khr_id
488: AND parameter_type_code = NVL(p_parameter_type_code,parameter_type_code);
489: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;

Line 489: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;

485: FROM Okl_K_Rate_Params_V
486: WHERE effective_from_date = NVL(p_effective_from_date,effective_from_date)
487: AND khr_id = p_khr_id
488: AND parameter_type_code = NVL(p_parameter_type_code,parameter_type_code);
489: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;
490: BEGIN
491: x_no_data_found := TRUE;
492: -- Get current database values
493: OPEN okl_k_rate_params_v_u1_csr (p_effective_from_date,

Line 493: OPEN okl_k_rate_params_v_u1_csr (p_effective_from_date,

489: l_okl_k_rate_params_v_u1 okl_k_rate_params_v_u1_csr%ROWTYPE;
490: BEGIN
491: x_no_data_found := TRUE;
492: -- Get current database values
493: OPEN okl_k_rate_params_v_u1_csr (p_effective_from_date,
494: p_chr_id,
495: p_parameter_type_code);
496: FETCH okl_k_rate_params_v_u1_csr INTO
497: x_krpv_rec.khr_id,

Line 496: FETCH okl_k_rate_params_v_u1_csr INTO

492: -- Get current database values
493: OPEN okl_k_rate_params_v_u1_csr (p_effective_from_date,
494: p_chr_id,
495: p_parameter_type_code);
496: FETCH okl_k_rate_params_v_u1_csr INTO
497: x_krpv_rec.khr_id,
498: x_krpv_rec.parameter_type_code,
499: x_krpv_rec.effective_from_date,
500: x_krpv_rec.effective_to_date,

Line 545: x_no_data_found := okl_k_rate_params_v_u1_csr%NOTFOUND;

541: x_krpv_rec.creation_date,
542: x_krpv_rec.last_updated_by,
543: x_krpv_rec.last_update_date,
544: x_krpv_rec.last_update_login;
545: x_no_data_found := okl_k_rate_params_v_u1_csr%NOTFOUND;
546: CLOSE okl_k_rate_params_v_u1_csr;
547: --RETURN(x_krpv_rec);
548:
549: END;

Line 546: CLOSE okl_k_rate_params_v_u1_csr;

542: x_krpv_rec.last_updated_by,
543: x_krpv_rec.last_update_date,
544: x_krpv_rec.last_update_login;
545: x_no_data_found := okl_k_rate_params_v_u1_csr%NOTFOUND;
546: CLOSE okl_k_rate_params_v_u1_csr;
547: --RETURN(x_krpv_rec);
548:
549: END;
550:

Line 952: FROM OKL_K_RATE_PARAMS

948: WHERE ID = p_id;
949:
950: CURSOR C2(p_id NUMBER, p_parameter_type_code VARCHAR2) IS
951: SELECT COUNT(1) COUNT1
952: FROM OKL_K_RATE_PARAMS
953: WHERE KHR_ID = p_id
954: AND PARAMETER_TYPE_CODE = p_parameter_type_code
955: AND EFFECTIVE_TO_DATE IS NULL;
956:

Line 985: FROM OKL_K_RATE_PARAMS rate,

981: select rate.effective_from_date,
982: contract.orig_system_source_code,
983: lease.date_last_interim_interest_cal,
984: contract.orig_system_id1
985: FROM OKL_K_RATE_PARAMS rate,
986: OKC_K_HEADERS_B contract,
987: OKL_K_HEADERS lease
988: WHERE rate.khr_id = p_khr_id
989: AND rate.parameter_type_code = p_parameter_type_code

Line 1113: FROM OKL_K_RATE_PARAMS

1109: l_krpv_rec.conversion_type_code := p_krpv_rec.conversion_type_code;
1110: print_krpv_rec(l_krpv_rec);
1111:
1112: select count(1) into l_count
1113: FROM OKL_K_RATE_PARAMS
1114: WHERE KHR_ID = p_krpv_rec.khr_id
1115: AND EFFECTIVE_FROM_DATE = p_krpv_rec.effective_from_date
1116: AND PARAMETER_TYPE_CODE = p_krpv_rec.parameter_type_code;
1117:

Line 1318: UPDATE OKL_K_RATE_PARAMS

1314: LOOP
1315: l_orig_effective_from_date := r.effective_from_date;
1316: END LOOP;
1317:
1318: UPDATE OKL_K_RATE_PARAMS
1319: SET EFFECTIVE_TO_DATE = p_krpv_rec.effective_from_Date - 1
1320: WHERE KHR_ID = p_krpv_rec.khr_id
1321: AND PARAMETER_TYPE_CODE = p_krpv_rec.parameter_type_code
1322: AND EFFECTIVE_FROM_DATE = l_effective_from_date

Line 1426: FROM OKL_K_RATE_PARAMS

1422: l_krpv_rec.days_in_a_year_code := p_krpr_rec.days_in_a_year_code;
1423: l_krpv_rec.interest_basis_code := p_krpr_rec.interest_basis_code;
1424:
1425: select count(1) into l_count
1426: FROM OKL_K_RATE_PARAMS
1427: WHERE KHR_ID = p_krpr_rec.khr_id
1428: AND EFFECTIVE_FROM_DATE = p_krpr_rec.effective_from_date
1429: AND PARAMETER_TYPE_CODE = p_krpr_rec.parameter_type_code;
1430:

Line 1533: FROM OKL_K_RATE_PARAMS

1529: p_api_type => G_API_TYPE,
1530: x_return_status => x_return_status);
1531:
1532: select count(1) into l_count
1533: FROM OKL_K_RATE_PARAMS
1534: WHERE KHR_ID = p_krpar_rec.khr_id
1535: AND EFFECTIVE_FROM_DATE = p_krpar_rec.effective_from_date
1536: AND PARAMETER_TYPE_CODE = p_krpar_rec.parameter_type_code;
1537:

Line 1654: FROM OKL_K_RATE_PARAMS

1650: p_api_type => G_API_TYPE,
1651: x_return_status => x_return_status);
1652:
1653: select count(1) into l_count
1654: FROM OKL_K_RATE_PARAMS
1655: WHERE KHR_ID = p_krpc_rec.khr_id
1656: AND EFFECTIVE_FROM_DATE = p_krpc_rec.effective_from_date
1657: AND PARAMETER_TYPE_CODE = p_krpc_rec.parameter_type_code;
1658:

Line 2380: FROM OKL_K_RATE_PARAMS rate,

2376: select rate.effective_to_date,
2377: contract.sts_code,
2378: contract.orig_system_source_code,
2379: contract.orig_system_id1
2380: FROM OKL_K_RATE_PARAMS rate,
2381: OKC_K_HEADERS_B contract
2382: WHERE rate.khr_id = p_khr_id
2383: AND rate.parameter_type_code = p_parameter_type_code
2384: AND rate.effective_from_date = p_effective_from_date

Line 2391: FROM OKL_K_RATE_PARAMS rate

2387: CURSOR get_orig_effective_from_dt_csr(
2388: p_khr_id NUMBER,
2389: p_parameter_type_code VARCHAR2) IS
2390: select rate.effective_from_date
2391: FROM OKL_K_RATE_PARAMS rate
2392: WHERE rate.khr_id = p_khr_id
2393: AND rate.parameter_type_code = p_parameter_type_code
2394: AND rate.effective_to_date IS NULL;
2395:

Line 2494: /*UPDATE OKL_K_RATE_PARAMS

2490: p_msg_name => 'OKL_LLA_VAR_RATE_DELETE_ERR2');
2491: RAISE OKL_API.G_EXCEPTION_ERROR;
2492: END IF;
2493:
2494: /*UPDATE OKL_K_RATE_PARAMS
2495: SET EFFECTIVE_TO_DATE = NULL
2496: WHERE KHR_ID = p_krpdel_tbl(i).khr_id
2497: AND PARAMETER_TYPE_CODE = l_parameter_type_code
2498: AND EFFECTIVE_TO_DATE = p_krpdel_tbl(i).effective_from_date - 1;*/

Line 2536: FROM OKL_K_RATE_PARAMS

2532: l_krpv_rec.ATTRIBUTE12, l_krpv_rec.ATTRIBUTE13, l_krpv_rec.ATTRIBUTE14,
2533: l_krpv_rec.ATTRIBUTE15, l_krpv_rec.CREATED_BY, l_krpv_rec.CREATION_DATE,
2534: l_krpv_rec.LAST_UPDATED_BY, l_krpv_rec.LAST_UPDATE_DATE, l_krpv_rec.LAST_UPDATE_LOGIN,
2535: l_krpv_rec.CATCHUP_FREQUENCY_CODE
2536: FROM OKL_K_RATE_PARAMS
2537: WHERE KHR_ID = p_krpdel_tbl(i).khr_id
2538: AND parameter_type_code = l_parameter_type_code
2539: AND effective_from_date = p_krpdel_tbl(i).effective_from_date;
2540:

Line 2566: UPDATE OKL_K_RATE_PARAMS

2562: l_krpv_rec.rate_change_frequency_code := null;
2563: l_krpv_rec.rate_change_start_date := null;
2564: l_krpv_rec.rate_change_value := null;
2565:
2566: UPDATE OKL_K_RATE_PARAMS
2567: SET interest_index_id = null,
2568: base_rate = null,
2569: adder_rate = null,
2570: minimum_rate = null,

Line 2598: UPDATE OKL_K_RATE_PARAMS

2594: l_krpv_rec.conversion_option_code := null;
2595: l_krpv_rec.next_conversion_date := null;
2596: l_krpv_rec.conversion_type_code := null;
2597:
2598: UPDATE OKL_K_RATE_PARAMS
2599: SET conversion_option_code = null,
2600: next_conversion_date = null,
2601: conversion_type_code = null
2602: WHERE KHR_ID = p_krpdel_tbl(i).khr_id

Line 2678: UPDATE OKL_K_RATE_PARAMS

2674: p_msg_name => 'OKL_LA_VAR_RATE_DELETE_ERR2');
2675: RAISE OKL_API.G_EXCEPTION_ERROR;
2676: END IF;*/
2677:
2678: UPDATE OKL_K_RATE_PARAMS
2679: SET EFFECTIVE_TO_DATE = NULL
2680: WHERE KHR_ID = p_krpdel_tbl(i).khr_id
2681: AND PARAMETER_TYPE_CODE = l_parameter_type_code
2682: AND EFFECTIVE_TO_DATE = p_krpdel_tbl(i).effective_from_date - 1;

Line 2828: FROM okl_k_rate_params

2824: ,last_updated_by
2825: ,last_update_date
2826: ,last_update_login
2827: ,catchup_frequency_code
2828: FROM okl_k_rate_params
2829: WHERE khr_id = p_id;
2830:
2831: l_deal_type VARCHAR2(30);
2832: l_interest_calculation_basis VARCHAR2(30);

Line 3191: FROM OKL_K_RATE_PARAMS

3187: rate_change_value,
3188: conversion_option_code,
3189: next_conversion_date,
3190: conversion_type_code
3191: FROM OKL_K_RATE_PARAMS
3192: WHERE KHR_ID = p_chr_id
3193: AND parameter_type_code IN ('ACTUAL', 'CONVERSION')
3194: ORDER BY effective_from_date, parameter_type_code;
3195:

Line 3494: FROM OKL_K_RATE_PARAMS

3490:
3491: --Bug 4735972
3492: CURSOR rate_csr(p_id NUMBER) IS
3493: SELECT COUNT(1) COUNT1
3494: FROM OKL_K_RATE_PARAMS
3495: WHERE KHR_ID = p_id
3496: AND EFFECTIVE_TO_DATE IS NULL;
3497: l_rate_count NUMBER;
3498: l_catchup_start_date DATE;

Line 3600: update OKL_K_RATE_PARAMS

3596: ELSE
3597: l_catchup_start_date := null;
3598: END IF;
3599:
3600: update OKL_K_RATE_PARAMS
3601: SET interest_start_date = p_new_start_date,
3602: rate_change_start_date = p_new_start_date,
3603: catchup_start_date = nvl(l_catchup_start_date,catchup_start_date)
3604: WHERE khr_id = p_chr_id

Line 3621: update okl_k_rate_params

3617: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) THEN
3618: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
3619: END IF; */
3620:
3621: update okl_k_rate_params
3622: set effective_from_date = p_new_start_date
3623: WHERE khr_id = p_chr_id
3624: AND effective_from_date = l_effective_from_date
3625: AND effective_to_date IS NULL;

Line 3629: update okl_k_rate_params

3625: AND effective_to_date IS NULL;
3626: --AND parameter_type_code = 'ACTUAL';
3627:
3628: /*ELSE
3629: update okl_k_rate_params
3630: set effective_from_date = p_new_start_date
3631: WHERE khr_id = p_chr_id
3632: AND effective_from_date = l_effective_from_date
3633: AND effective_to_date is NULL;

Line 3839: OKL_K_RATE_PARAMS_PVT.get_product(

3835:
3836: IF (l_mass_rebook_flag = OKL_API.G_FALSE) THEN
3837:
3838: -- Obtain the contract details - Book classification, Interest Calculation Basis, Revenue Recognition Method, Interest Processed flag
3839: OKL_K_RATE_PARAMS_PVT.get_product(
3840: p_api_version => p_api_version,
3841: p_init_msg_list => p_init_msg_list,
3842: x_return_status => x_return_status,
3843: x_msg_count => x_msg_count,

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

4396:
4397: PROCEDURE SYNC_RATE_PARAMS(
4398: p_orig_contract_id IN NUMBER,
4399: p_new_contract_id IN NUMBER) IS
4400: TYPE l_kkhr_id_type is table of okl_k_rate_params.khr_id%TYPE index by binary_integer;
4401: TYPE l_kparameter_type_code_type is table of okl_k_rate_params.parameter_type_code%TYPE index by binary_integer;
4402: TYPE l_keffective_from_date_type is table of okl_k_rate_params.effective_from_date%TYPE index by binary_integer;
4403: TYPE l_keffective_to_date_type is table of okl_k_rate_params.effective_to_date%TYPE index by binary_integer;
4404: TYPE l_kinterest_index_id_type is table of okl_k_rate_params.interest_index_id%TYPE index by binary_integer;

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

4397: PROCEDURE SYNC_RATE_PARAMS(
4398: p_orig_contract_id IN NUMBER,
4399: p_new_contract_id IN NUMBER) IS
4400: TYPE l_kkhr_id_type is table of okl_k_rate_params.khr_id%TYPE index by binary_integer;
4401: TYPE l_kparameter_type_code_type is table of okl_k_rate_params.parameter_type_code%TYPE index by binary_integer;
4402: TYPE l_keffective_from_date_type is table of okl_k_rate_params.effective_from_date%TYPE index by binary_integer;
4403: TYPE l_keffective_to_date_type is table of okl_k_rate_params.effective_to_date%TYPE index by binary_integer;
4404: TYPE l_kinterest_index_id_type is table of okl_k_rate_params.interest_index_id%TYPE index by binary_integer;
4405: TYPE l_kbase_rate_type is table of okl_k_rate_params.base_rate%TYPE index by binary_integer;

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

4398: p_orig_contract_id IN NUMBER,
4399: p_new_contract_id IN NUMBER) IS
4400: TYPE l_kkhr_id_type is table of okl_k_rate_params.khr_id%TYPE index by binary_integer;
4401: TYPE l_kparameter_type_code_type is table of okl_k_rate_params.parameter_type_code%TYPE index by binary_integer;
4402: TYPE l_keffective_from_date_type is table of okl_k_rate_params.effective_from_date%TYPE index by binary_integer;
4403: TYPE l_keffective_to_date_type is table of okl_k_rate_params.effective_to_date%TYPE index by binary_integer;
4404: TYPE l_kinterest_index_id_type is table of okl_k_rate_params.interest_index_id%TYPE index by binary_integer;
4405: TYPE l_kbase_rate_type is table of okl_k_rate_params.base_rate%TYPE index by binary_integer;
4406: TYPE l_kinterest_start_date_type is table of okl_k_rate_params.interest_start_date%TYPE index by binary_integer;

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

4399: p_new_contract_id IN NUMBER) IS
4400: TYPE l_kkhr_id_type is table of okl_k_rate_params.khr_id%TYPE index by binary_integer;
4401: TYPE l_kparameter_type_code_type is table of okl_k_rate_params.parameter_type_code%TYPE index by binary_integer;
4402: TYPE l_keffective_from_date_type is table of okl_k_rate_params.effective_from_date%TYPE index by binary_integer;
4403: TYPE l_keffective_to_date_type is table of okl_k_rate_params.effective_to_date%TYPE index by binary_integer;
4404: TYPE l_kinterest_index_id_type is table of okl_k_rate_params.interest_index_id%TYPE index by binary_integer;
4405: TYPE l_kbase_rate_type is table of okl_k_rate_params.base_rate%TYPE index by binary_integer;
4406: TYPE l_kinterest_start_date_type is table of okl_k_rate_params.interest_start_date%TYPE index by binary_integer;
4407: TYPE l_kadder_rate_type is table of okl_k_rate_params.adder_rate%TYPE index by binary_integer;

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

4400: TYPE l_kkhr_id_type is table of okl_k_rate_params.khr_id%TYPE index by binary_integer;
4401: TYPE l_kparameter_type_code_type is table of okl_k_rate_params.parameter_type_code%TYPE index by binary_integer;
4402: TYPE l_keffective_from_date_type is table of okl_k_rate_params.effective_from_date%TYPE index by binary_integer;
4403: TYPE l_keffective_to_date_type is table of okl_k_rate_params.effective_to_date%TYPE index by binary_integer;
4404: TYPE l_kinterest_index_id_type is table of okl_k_rate_params.interest_index_id%TYPE index by binary_integer;
4405: TYPE l_kbase_rate_type is table of okl_k_rate_params.base_rate%TYPE index by binary_integer;
4406: TYPE l_kinterest_start_date_type is table of okl_k_rate_params.interest_start_date%TYPE index by binary_integer;
4407: TYPE l_kadder_rate_type is table of okl_k_rate_params.adder_rate%TYPE index by binary_integer;
4408: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;

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

4401: TYPE l_kparameter_type_code_type is table of okl_k_rate_params.parameter_type_code%TYPE index by binary_integer;
4402: TYPE l_keffective_from_date_type is table of okl_k_rate_params.effective_from_date%TYPE index by binary_integer;
4403: TYPE l_keffective_to_date_type is table of okl_k_rate_params.effective_to_date%TYPE index by binary_integer;
4404: TYPE l_kinterest_index_id_type is table of okl_k_rate_params.interest_index_id%TYPE index by binary_integer;
4405: TYPE l_kbase_rate_type is table of okl_k_rate_params.base_rate%TYPE index by binary_integer;
4406: TYPE l_kinterest_start_date_type is table of okl_k_rate_params.interest_start_date%TYPE index by binary_integer;
4407: TYPE l_kadder_rate_type is table of okl_k_rate_params.adder_rate%TYPE index by binary_integer;
4408: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;
4409: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;

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

4402: TYPE l_keffective_from_date_type is table of okl_k_rate_params.effective_from_date%TYPE index by binary_integer;
4403: TYPE l_keffective_to_date_type is table of okl_k_rate_params.effective_to_date%TYPE index by binary_integer;
4404: TYPE l_kinterest_index_id_type is table of okl_k_rate_params.interest_index_id%TYPE index by binary_integer;
4405: TYPE l_kbase_rate_type is table of okl_k_rate_params.base_rate%TYPE index by binary_integer;
4406: TYPE l_kinterest_start_date_type is table of okl_k_rate_params.interest_start_date%TYPE index by binary_integer;
4407: TYPE l_kadder_rate_type is table of okl_k_rate_params.adder_rate%TYPE index by binary_integer;
4408: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;
4409: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;
4410: TYPE l_kprincipal_basis_code_type is table of okl_k_rate_params.principal_basis_code%TYPE index by binary_integer;

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

4403: TYPE l_keffective_to_date_type is table of okl_k_rate_params.effective_to_date%TYPE index by binary_integer;
4404: TYPE l_kinterest_index_id_type is table of okl_k_rate_params.interest_index_id%TYPE index by binary_integer;
4405: TYPE l_kbase_rate_type is table of okl_k_rate_params.base_rate%TYPE index by binary_integer;
4406: TYPE l_kinterest_start_date_type is table of okl_k_rate_params.interest_start_date%TYPE index by binary_integer;
4407: TYPE l_kadder_rate_type is table of okl_k_rate_params.adder_rate%TYPE index by binary_integer;
4408: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;
4409: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;
4410: TYPE l_kprincipal_basis_code_type is table of okl_k_rate_params.principal_basis_code%TYPE index by binary_integer;
4411: 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 4408: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;

4404: TYPE l_kinterest_index_id_type is table of okl_k_rate_params.interest_index_id%TYPE index by binary_integer;
4405: TYPE l_kbase_rate_type is table of okl_k_rate_params.base_rate%TYPE index by binary_integer;
4406: TYPE l_kinterest_start_date_type is table of okl_k_rate_params.interest_start_date%TYPE index by binary_integer;
4407: TYPE l_kadder_rate_type is table of okl_k_rate_params.adder_rate%TYPE index by binary_integer;
4408: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;
4409: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;
4410: TYPE l_kprincipal_basis_code_type is table of okl_k_rate_params.principal_basis_code%TYPE index by binary_integer;
4411: 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;
4412: 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 4409: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;

4405: TYPE l_kbase_rate_type is table of okl_k_rate_params.base_rate%TYPE index by binary_integer;
4406: TYPE l_kinterest_start_date_type is table of okl_k_rate_params.interest_start_date%TYPE index by binary_integer;
4407: TYPE l_kadder_rate_type is table of okl_k_rate_params.adder_rate%TYPE index by binary_integer;
4408: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;
4409: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;
4410: TYPE l_kprincipal_basis_code_type is table of okl_k_rate_params.principal_basis_code%TYPE index by binary_integer;
4411: 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;
4412: 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;
4413: TYPE l_kinterest_basis_code_type is table of okl_k_rate_params.interest_basis_code%TYPE index by binary_integer;

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

4406: TYPE l_kinterest_start_date_type is table of okl_k_rate_params.interest_start_date%TYPE index by binary_integer;
4407: TYPE l_kadder_rate_type is table of okl_k_rate_params.adder_rate%TYPE index by binary_integer;
4408: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;
4409: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;
4410: TYPE l_kprincipal_basis_code_type is table of okl_k_rate_params.principal_basis_code%TYPE index by binary_integer;
4411: 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;
4412: 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;
4413: TYPE l_kinterest_basis_code_type is table of okl_k_rate_params.interest_basis_code%TYPE index by binary_integer;
4414: TYPE l_krate_delay_code_type is table of okl_k_rate_params.rate_delay_code%TYPE index by binary_integer;

Line 4411: 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;

4407: TYPE l_kadder_rate_type is table of okl_k_rate_params.adder_rate%TYPE index by binary_integer;
4408: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;
4409: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;
4410: TYPE l_kprincipal_basis_code_type is table of okl_k_rate_params.principal_basis_code%TYPE index by binary_integer;
4411: 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;
4412: 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;
4413: TYPE l_kinterest_basis_code_type is table of okl_k_rate_params.interest_basis_code%TYPE index by binary_integer;
4414: TYPE l_krate_delay_code_type is table of okl_k_rate_params.rate_delay_code%TYPE index by binary_integer;
4415: TYPE l_krate_delay_frequency_type is table of okl_k_rate_params.rate_delay_frequency%TYPE index by binary_integer;

Line 4412: 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;

4408: TYPE l_kmaximum_rate_type is table of okl_k_rate_params.maximum_rate%TYPE index by binary_integer;
4409: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;
4410: TYPE l_kprincipal_basis_code_type is table of okl_k_rate_params.principal_basis_code%TYPE index by binary_integer;
4411: 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;
4412: 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;
4413: TYPE l_kinterest_basis_code_type is table of okl_k_rate_params.interest_basis_code%TYPE index by binary_integer;
4414: TYPE l_krate_delay_code_type is table of okl_k_rate_params.rate_delay_code%TYPE index by binary_integer;
4415: TYPE l_krate_delay_frequency_type is table of okl_k_rate_params.rate_delay_frequency%TYPE index by binary_integer;
4416: TYPE l_kcompounding_frequ_code_type is table of okl_k_rate_params.compounding_frequency_code%TYPE index by binary_integer;

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

4409: TYPE l_kminimum_rate_type is table of okl_k_rate_params.minimum_rate%TYPE index by binary_integer;
4410: TYPE l_kprincipal_basis_code_type is table of okl_k_rate_params.principal_basis_code%TYPE index by binary_integer;
4411: 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;
4412: 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;
4413: TYPE l_kinterest_basis_code_type is table of okl_k_rate_params.interest_basis_code%TYPE index by binary_integer;
4414: TYPE l_krate_delay_code_type is table of okl_k_rate_params.rate_delay_code%TYPE index by binary_integer;
4415: TYPE l_krate_delay_frequency_type is table of okl_k_rate_params.rate_delay_frequency%TYPE index by binary_integer;
4416: TYPE l_kcompounding_frequ_code_type is table of okl_k_rate_params.compounding_frequency_code%TYPE index by binary_integer;
4417: TYPE l_kcalculation_formula_id_type is table of okl_k_rate_params.calculation_formula_id%TYPE index by binary_integer;

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

4410: TYPE l_kprincipal_basis_code_type is table of okl_k_rate_params.principal_basis_code%TYPE index by binary_integer;
4411: 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;
4412: 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;
4413: TYPE l_kinterest_basis_code_type is table of okl_k_rate_params.interest_basis_code%TYPE index by binary_integer;
4414: TYPE l_krate_delay_code_type is table of okl_k_rate_params.rate_delay_code%TYPE index by binary_integer;
4415: TYPE l_krate_delay_frequency_type is table of okl_k_rate_params.rate_delay_frequency%TYPE index by binary_integer;
4416: TYPE l_kcompounding_frequ_code_type is table of okl_k_rate_params.compounding_frequency_code%TYPE index by binary_integer;
4417: TYPE l_kcalculation_formula_id_type is table of okl_k_rate_params.calculation_formula_id%TYPE index by binary_integer;
4418: TYPE l_kcatchup_basis_code_type is table of okl_k_rate_params.catchup_basis_code%TYPE index by binary_integer;

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

4411: 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;
4412: 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;
4413: TYPE l_kinterest_basis_code_type is table of okl_k_rate_params.interest_basis_code%TYPE index by binary_integer;
4414: TYPE l_krate_delay_code_type is table of okl_k_rate_params.rate_delay_code%TYPE index by binary_integer;
4415: TYPE l_krate_delay_frequency_type is table of okl_k_rate_params.rate_delay_frequency%TYPE index by binary_integer;
4416: TYPE l_kcompounding_frequ_code_type is table of okl_k_rate_params.compounding_frequency_code%TYPE index by binary_integer;
4417: TYPE l_kcalculation_formula_id_type is table of okl_k_rate_params.calculation_formula_id%TYPE index by binary_integer;
4418: TYPE l_kcatchup_basis_code_type is table of okl_k_rate_params.catchup_basis_code%TYPE index by binary_integer;
4419: TYPE l_kcatchup_start_date_type is table of okl_k_rate_params.catchup_start_date%TYPE index by binary_integer;

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

4412: 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;
4413: TYPE l_kinterest_basis_code_type is table of okl_k_rate_params.interest_basis_code%TYPE index by binary_integer;
4414: TYPE l_krate_delay_code_type is table of okl_k_rate_params.rate_delay_code%TYPE index by binary_integer;
4415: TYPE l_krate_delay_frequency_type is table of okl_k_rate_params.rate_delay_frequency%TYPE index by binary_integer;
4416: TYPE l_kcompounding_frequ_code_type is table of okl_k_rate_params.compounding_frequency_code%TYPE index by binary_integer;
4417: TYPE l_kcalculation_formula_id_type is table of okl_k_rate_params.calculation_formula_id%TYPE index by binary_integer;
4418: TYPE l_kcatchup_basis_code_type is table of okl_k_rate_params.catchup_basis_code%TYPE index by binary_integer;
4419: TYPE l_kcatchup_start_date_type is table of okl_k_rate_params.catchup_start_date%TYPE index by binary_integer;
4420: TYPE l_kcatchup_settlemen_code_type is table of okl_k_rate_params.catchup_settlement_code%TYPE index by binary_integer;

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

4413: TYPE l_kinterest_basis_code_type is table of okl_k_rate_params.interest_basis_code%TYPE index by binary_integer;
4414: TYPE l_krate_delay_code_type is table of okl_k_rate_params.rate_delay_code%TYPE index by binary_integer;
4415: TYPE l_krate_delay_frequency_type is table of okl_k_rate_params.rate_delay_frequency%TYPE index by binary_integer;
4416: TYPE l_kcompounding_frequ_code_type is table of okl_k_rate_params.compounding_frequency_code%TYPE index by binary_integer;
4417: TYPE l_kcalculation_formula_id_type is table of okl_k_rate_params.calculation_formula_id%TYPE index by binary_integer;
4418: TYPE l_kcatchup_basis_code_type is table of okl_k_rate_params.catchup_basis_code%TYPE index by binary_integer;
4419: TYPE l_kcatchup_start_date_type is table of okl_k_rate_params.catchup_start_date%TYPE index by binary_integer;
4420: TYPE l_kcatchup_settlemen_code_type is table of okl_k_rate_params.catchup_settlement_code%TYPE index by binary_integer;
4421: TYPE l_krate_change_start_date_type is table of okl_k_rate_params.rate_change_start_date%TYPE index by binary_integer;

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

4414: TYPE l_krate_delay_code_type is table of okl_k_rate_params.rate_delay_code%TYPE index by binary_integer;
4415: TYPE l_krate_delay_frequency_type is table of okl_k_rate_params.rate_delay_frequency%TYPE index by binary_integer;
4416: TYPE l_kcompounding_frequ_code_type is table of okl_k_rate_params.compounding_frequency_code%TYPE index by binary_integer;
4417: TYPE l_kcalculation_formula_id_type is table of okl_k_rate_params.calculation_formula_id%TYPE index by binary_integer;
4418: TYPE l_kcatchup_basis_code_type is table of okl_k_rate_params.catchup_basis_code%TYPE index by binary_integer;
4419: TYPE l_kcatchup_start_date_type is table of okl_k_rate_params.catchup_start_date%TYPE index by binary_integer;
4420: TYPE l_kcatchup_settlemen_code_type is table of okl_k_rate_params.catchup_settlement_code%TYPE index by binary_integer;
4421: TYPE l_krate_change_start_date_type is table of okl_k_rate_params.rate_change_start_date%TYPE index by binary_integer;
4422: TYPE l_krate_change_frequ_code_type is table of okl_k_rate_params.rate_change_frequency_code%TYPE index by binary_integer;

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

4415: TYPE l_krate_delay_frequency_type is table of okl_k_rate_params.rate_delay_frequency%TYPE index by binary_integer;
4416: TYPE l_kcompounding_frequ_code_type is table of okl_k_rate_params.compounding_frequency_code%TYPE index by binary_integer;
4417: TYPE l_kcalculation_formula_id_type is table of okl_k_rate_params.calculation_formula_id%TYPE index by binary_integer;
4418: TYPE l_kcatchup_basis_code_type is table of okl_k_rate_params.catchup_basis_code%TYPE index by binary_integer;
4419: TYPE l_kcatchup_start_date_type is table of okl_k_rate_params.catchup_start_date%TYPE index by binary_integer;
4420: TYPE l_kcatchup_settlemen_code_type is table of okl_k_rate_params.catchup_settlement_code%TYPE index by binary_integer;
4421: TYPE l_krate_change_start_date_type is table of okl_k_rate_params.rate_change_start_date%TYPE index by binary_integer;
4422: TYPE l_krate_change_frequ_code_type is table of okl_k_rate_params.rate_change_frequency_code%TYPE index by binary_integer;
4423: TYPE l_krate_change_value_type is table of okl_k_rate_params.rate_change_value%TYPE index by binary_integer;

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

4416: TYPE l_kcompounding_frequ_code_type is table of okl_k_rate_params.compounding_frequency_code%TYPE index by binary_integer;
4417: TYPE l_kcalculation_formula_id_type is table of okl_k_rate_params.calculation_formula_id%TYPE index by binary_integer;
4418: TYPE l_kcatchup_basis_code_type is table of okl_k_rate_params.catchup_basis_code%TYPE index by binary_integer;
4419: TYPE l_kcatchup_start_date_type is table of okl_k_rate_params.catchup_start_date%TYPE index by binary_integer;
4420: TYPE l_kcatchup_settlemen_code_type is table of okl_k_rate_params.catchup_settlement_code%TYPE index by binary_integer;
4421: TYPE l_krate_change_start_date_type is table of okl_k_rate_params.rate_change_start_date%TYPE index by binary_integer;
4422: TYPE l_krate_change_frequ_code_type is table of okl_k_rate_params.rate_change_frequency_code%TYPE index by binary_integer;
4423: TYPE l_krate_change_value_type is table of okl_k_rate_params.rate_change_value%TYPE index by binary_integer;
4424: TYPE l_kconversion_option_code_type is table of okl_k_rate_params.conversion_option_code%TYPE index by binary_integer;

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

4417: TYPE l_kcalculation_formula_id_type is table of okl_k_rate_params.calculation_formula_id%TYPE index by binary_integer;
4418: TYPE l_kcatchup_basis_code_type is table of okl_k_rate_params.catchup_basis_code%TYPE index by binary_integer;
4419: TYPE l_kcatchup_start_date_type is table of okl_k_rate_params.catchup_start_date%TYPE index by binary_integer;
4420: TYPE l_kcatchup_settlemen_code_type is table of okl_k_rate_params.catchup_settlement_code%TYPE index by binary_integer;
4421: TYPE l_krate_change_start_date_type is table of okl_k_rate_params.rate_change_start_date%TYPE index by binary_integer;
4422: TYPE l_krate_change_frequ_code_type is table of okl_k_rate_params.rate_change_frequency_code%TYPE index by binary_integer;
4423: TYPE l_krate_change_value_type is table of okl_k_rate_params.rate_change_value%TYPE index by binary_integer;
4424: TYPE l_kconversion_option_code_type is table of okl_k_rate_params.conversion_option_code%TYPE index by binary_integer;
4425: TYPE l_knext_conversion_date_type is table of okl_k_rate_params.next_conversion_date%TYPE index by binary_integer;

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

4418: TYPE l_kcatchup_basis_code_type is table of okl_k_rate_params.catchup_basis_code%TYPE index by binary_integer;
4419: TYPE l_kcatchup_start_date_type is table of okl_k_rate_params.catchup_start_date%TYPE index by binary_integer;
4420: TYPE l_kcatchup_settlemen_code_type is table of okl_k_rate_params.catchup_settlement_code%TYPE index by binary_integer;
4421: TYPE l_krate_change_start_date_type is table of okl_k_rate_params.rate_change_start_date%TYPE index by binary_integer;
4422: TYPE l_krate_change_frequ_code_type is table of okl_k_rate_params.rate_change_frequency_code%TYPE index by binary_integer;
4423: TYPE l_krate_change_value_type is table of okl_k_rate_params.rate_change_value%TYPE index by binary_integer;
4424: TYPE l_kconversion_option_code_type is table of okl_k_rate_params.conversion_option_code%TYPE index by binary_integer;
4425: TYPE l_knext_conversion_date_type is table of okl_k_rate_params.next_conversion_date%TYPE index by binary_integer;
4426: TYPE l_kconversion_type_code_type is table of okl_k_rate_params.conversion_type_code%TYPE index by binary_integer;

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

4419: TYPE l_kcatchup_start_date_type is table of okl_k_rate_params.catchup_start_date%TYPE index by binary_integer;
4420: TYPE l_kcatchup_settlemen_code_type is table of okl_k_rate_params.catchup_settlement_code%TYPE index by binary_integer;
4421: TYPE l_krate_change_start_date_type is table of okl_k_rate_params.rate_change_start_date%TYPE index by binary_integer;
4422: TYPE l_krate_change_frequ_code_type is table of okl_k_rate_params.rate_change_frequency_code%TYPE index by binary_integer;
4423: TYPE l_krate_change_value_type is table of okl_k_rate_params.rate_change_value%TYPE index by binary_integer;
4424: TYPE l_kconversion_option_code_type is table of okl_k_rate_params.conversion_option_code%TYPE index by binary_integer;
4425: TYPE l_knext_conversion_date_type is table of okl_k_rate_params.next_conversion_date%TYPE index by binary_integer;
4426: TYPE l_kconversion_type_code_type is table of okl_k_rate_params.conversion_type_code%TYPE index by binary_integer;
4427: TYPE l_kattribute_category_type is table of okl_k_rate_params.attribute_category%TYPE index by binary_integer;

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

4420: TYPE l_kcatchup_settlemen_code_type is table of okl_k_rate_params.catchup_settlement_code%TYPE index by binary_integer;
4421: TYPE l_krate_change_start_date_type is table of okl_k_rate_params.rate_change_start_date%TYPE index by binary_integer;
4422: TYPE l_krate_change_frequ_code_type is table of okl_k_rate_params.rate_change_frequency_code%TYPE index by binary_integer;
4423: TYPE l_krate_change_value_type is table of okl_k_rate_params.rate_change_value%TYPE index by binary_integer;
4424: TYPE l_kconversion_option_code_type is table of okl_k_rate_params.conversion_option_code%TYPE index by binary_integer;
4425: TYPE l_knext_conversion_date_type is table of okl_k_rate_params.next_conversion_date%TYPE index by binary_integer;
4426: TYPE l_kconversion_type_code_type is table of okl_k_rate_params.conversion_type_code%TYPE index by binary_integer;
4427: TYPE l_kattribute_category_type is table of okl_k_rate_params.attribute_category%TYPE index by binary_integer;
4428: TYPE l_kattribute1_type is table of okl_k_rate_params.attribute1%TYPE index by binary_integer;

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

4421: TYPE l_krate_change_start_date_type is table of okl_k_rate_params.rate_change_start_date%TYPE index by binary_integer;
4422: TYPE l_krate_change_frequ_code_type is table of okl_k_rate_params.rate_change_frequency_code%TYPE index by binary_integer;
4423: TYPE l_krate_change_value_type is table of okl_k_rate_params.rate_change_value%TYPE index by binary_integer;
4424: TYPE l_kconversion_option_code_type is table of okl_k_rate_params.conversion_option_code%TYPE index by binary_integer;
4425: TYPE l_knext_conversion_date_type is table of okl_k_rate_params.next_conversion_date%TYPE index by binary_integer;
4426: TYPE l_kconversion_type_code_type is table of okl_k_rate_params.conversion_type_code%TYPE index by binary_integer;
4427: TYPE l_kattribute_category_type is table of okl_k_rate_params.attribute_category%TYPE index by binary_integer;
4428: TYPE l_kattribute1_type is table of okl_k_rate_params.attribute1%TYPE index by binary_integer;
4429: TYPE l_kattribute2_type is table of okl_k_rate_params.attribute2%TYPE index by binary_integer;

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

4422: TYPE l_krate_change_frequ_code_type is table of okl_k_rate_params.rate_change_frequency_code%TYPE index by binary_integer;
4423: TYPE l_krate_change_value_type is table of okl_k_rate_params.rate_change_value%TYPE index by binary_integer;
4424: TYPE l_kconversion_option_code_type is table of okl_k_rate_params.conversion_option_code%TYPE index by binary_integer;
4425: TYPE l_knext_conversion_date_type is table of okl_k_rate_params.next_conversion_date%TYPE index by binary_integer;
4426: TYPE l_kconversion_type_code_type is table of okl_k_rate_params.conversion_type_code%TYPE index by binary_integer;
4427: TYPE l_kattribute_category_type is table of okl_k_rate_params.attribute_category%TYPE index by binary_integer;
4428: TYPE l_kattribute1_type is table of okl_k_rate_params.attribute1%TYPE index by binary_integer;
4429: TYPE l_kattribute2_type is table of okl_k_rate_params.attribute2%TYPE index by binary_integer;
4430: TYPE l_kattribute3_type is table of okl_k_rate_params.attribute3%TYPE index by binary_integer;

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

4423: TYPE l_krate_change_value_type is table of okl_k_rate_params.rate_change_value%TYPE index by binary_integer;
4424: TYPE l_kconversion_option_code_type is table of okl_k_rate_params.conversion_option_code%TYPE index by binary_integer;
4425: TYPE l_knext_conversion_date_type is table of okl_k_rate_params.next_conversion_date%TYPE index by binary_integer;
4426: TYPE l_kconversion_type_code_type is table of okl_k_rate_params.conversion_type_code%TYPE index by binary_integer;
4427: TYPE l_kattribute_category_type is table of okl_k_rate_params.attribute_category%TYPE index by binary_integer;
4428: TYPE l_kattribute1_type is table of okl_k_rate_params.attribute1%TYPE index by binary_integer;
4429: TYPE l_kattribute2_type is table of okl_k_rate_params.attribute2%TYPE index by binary_integer;
4430: TYPE l_kattribute3_type is table of okl_k_rate_params.attribute3%TYPE index by binary_integer;
4431: TYPE l_kattribute4_type is table of okl_k_rate_params.attribute4%TYPE index by binary_integer;

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

4424: TYPE l_kconversion_option_code_type is table of okl_k_rate_params.conversion_option_code%TYPE index by binary_integer;
4425: TYPE l_knext_conversion_date_type is table of okl_k_rate_params.next_conversion_date%TYPE index by binary_integer;
4426: TYPE l_kconversion_type_code_type is table of okl_k_rate_params.conversion_type_code%TYPE index by binary_integer;
4427: TYPE l_kattribute_category_type is table of okl_k_rate_params.attribute_category%TYPE index by binary_integer;
4428: TYPE l_kattribute1_type is table of okl_k_rate_params.attribute1%TYPE index by binary_integer;
4429: TYPE l_kattribute2_type is table of okl_k_rate_params.attribute2%TYPE index by binary_integer;
4430: TYPE l_kattribute3_type is table of okl_k_rate_params.attribute3%TYPE index by binary_integer;
4431: TYPE l_kattribute4_type is table of okl_k_rate_params.attribute4%TYPE index by binary_integer;
4432: TYPE l_kattribute5_type is table of okl_k_rate_params.attribute5%TYPE index by binary_integer;

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

4425: TYPE l_knext_conversion_date_type is table of okl_k_rate_params.next_conversion_date%TYPE index by binary_integer;
4426: TYPE l_kconversion_type_code_type is table of okl_k_rate_params.conversion_type_code%TYPE index by binary_integer;
4427: TYPE l_kattribute_category_type is table of okl_k_rate_params.attribute_category%TYPE index by binary_integer;
4428: TYPE l_kattribute1_type is table of okl_k_rate_params.attribute1%TYPE index by binary_integer;
4429: TYPE l_kattribute2_type is table of okl_k_rate_params.attribute2%TYPE index by binary_integer;
4430: TYPE l_kattribute3_type is table of okl_k_rate_params.attribute3%TYPE index by binary_integer;
4431: TYPE l_kattribute4_type is table of okl_k_rate_params.attribute4%TYPE index by binary_integer;
4432: TYPE l_kattribute5_type is table of okl_k_rate_params.attribute5%TYPE index by binary_integer;
4433: TYPE l_kattribute6_type is table of okl_k_rate_params.attribute6%TYPE index by binary_integer;

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

4426: TYPE l_kconversion_type_code_type is table of okl_k_rate_params.conversion_type_code%TYPE index by binary_integer;
4427: TYPE l_kattribute_category_type is table of okl_k_rate_params.attribute_category%TYPE index by binary_integer;
4428: TYPE l_kattribute1_type is table of okl_k_rate_params.attribute1%TYPE index by binary_integer;
4429: TYPE l_kattribute2_type is table of okl_k_rate_params.attribute2%TYPE index by binary_integer;
4430: TYPE l_kattribute3_type is table of okl_k_rate_params.attribute3%TYPE index by binary_integer;
4431: TYPE l_kattribute4_type is table of okl_k_rate_params.attribute4%TYPE index by binary_integer;
4432: TYPE l_kattribute5_type is table of okl_k_rate_params.attribute5%TYPE index by binary_integer;
4433: TYPE l_kattribute6_type is table of okl_k_rate_params.attribute6%TYPE index by binary_integer;
4434: TYPE l_kattribute7_type is table of okl_k_rate_params.attribute7%TYPE index by binary_integer;

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

4427: TYPE l_kattribute_category_type is table of okl_k_rate_params.attribute_category%TYPE index by binary_integer;
4428: TYPE l_kattribute1_type is table of okl_k_rate_params.attribute1%TYPE index by binary_integer;
4429: TYPE l_kattribute2_type is table of okl_k_rate_params.attribute2%TYPE index by binary_integer;
4430: TYPE l_kattribute3_type is table of okl_k_rate_params.attribute3%TYPE index by binary_integer;
4431: TYPE l_kattribute4_type is table of okl_k_rate_params.attribute4%TYPE index by binary_integer;
4432: TYPE l_kattribute5_type is table of okl_k_rate_params.attribute5%TYPE index by binary_integer;
4433: TYPE l_kattribute6_type is table of okl_k_rate_params.attribute6%TYPE index by binary_integer;
4434: TYPE l_kattribute7_type is table of okl_k_rate_params.attribute7%TYPE index by binary_integer;
4435: TYPE l_kattribute8_type is table of okl_k_rate_params.attribute8%TYPE index by binary_integer;

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

4428: TYPE l_kattribute1_type is table of okl_k_rate_params.attribute1%TYPE index by binary_integer;
4429: TYPE l_kattribute2_type is table of okl_k_rate_params.attribute2%TYPE index by binary_integer;
4430: TYPE l_kattribute3_type is table of okl_k_rate_params.attribute3%TYPE index by binary_integer;
4431: TYPE l_kattribute4_type is table of okl_k_rate_params.attribute4%TYPE index by binary_integer;
4432: TYPE l_kattribute5_type is table of okl_k_rate_params.attribute5%TYPE index by binary_integer;
4433: TYPE l_kattribute6_type is table of okl_k_rate_params.attribute6%TYPE index by binary_integer;
4434: TYPE l_kattribute7_type is table of okl_k_rate_params.attribute7%TYPE index by binary_integer;
4435: TYPE l_kattribute8_type is table of okl_k_rate_params.attribute8%TYPE index by binary_integer;
4436: TYPE l_kattribute9_type is table of okl_k_rate_params.attribute9%TYPE index by binary_integer;

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

4429: TYPE l_kattribute2_type is table of okl_k_rate_params.attribute2%TYPE index by binary_integer;
4430: TYPE l_kattribute3_type is table of okl_k_rate_params.attribute3%TYPE index by binary_integer;
4431: TYPE l_kattribute4_type is table of okl_k_rate_params.attribute4%TYPE index by binary_integer;
4432: TYPE l_kattribute5_type is table of okl_k_rate_params.attribute5%TYPE index by binary_integer;
4433: TYPE l_kattribute6_type is table of okl_k_rate_params.attribute6%TYPE index by binary_integer;
4434: TYPE l_kattribute7_type is table of okl_k_rate_params.attribute7%TYPE index by binary_integer;
4435: TYPE l_kattribute8_type is table of okl_k_rate_params.attribute8%TYPE index by binary_integer;
4436: TYPE l_kattribute9_type is table of okl_k_rate_params.attribute9%TYPE index by binary_integer;
4437: TYPE l_kattribute10_type is table of okl_k_rate_params.attribute10%TYPE index by binary_integer;

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

4430: TYPE l_kattribute3_type is table of okl_k_rate_params.attribute3%TYPE index by binary_integer;
4431: TYPE l_kattribute4_type is table of okl_k_rate_params.attribute4%TYPE index by binary_integer;
4432: TYPE l_kattribute5_type is table of okl_k_rate_params.attribute5%TYPE index by binary_integer;
4433: TYPE l_kattribute6_type is table of okl_k_rate_params.attribute6%TYPE index by binary_integer;
4434: TYPE l_kattribute7_type is table of okl_k_rate_params.attribute7%TYPE index by binary_integer;
4435: TYPE l_kattribute8_type is table of okl_k_rate_params.attribute8%TYPE index by binary_integer;
4436: TYPE l_kattribute9_type is table of okl_k_rate_params.attribute9%TYPE index by binary_integer;
4437: TYPE l_kattribute10_type is table of okl_k_rate_params.attribute10%TYPE index by binary_integer;
4438: TYPE l_kattribute11_type is table of okl_k_rate_params.attribute11%TYPE index by binary_integer;

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

4431: TYPE l_kattribute4_type is table of okl_k_rate_params.attribute4%TYPE index by binary_integer;
4432: TYPE l_kattribute5_type is table of okl_k_rate_params.attribute5%TYPE index by binary_integer;
4433: TYPE l_kattribute6_type is table of okl_k_rate_params.attribute6%TYPE index by binary_integer;
4434: TYPE l_kattribute7_type is table of okl_k_rate_params.attribute7%TYPE index by binary_integer;
4435: TYPE l_kattribute8_type is table of okl_k_rate_params.attribute8%TYPE index by binary_integer;
4436: TYPE l_kattribute9_type is table of okl_k_rate_params.attribute9%TYPE index by binary_integer;
4437: TYPE l_kattribute10_type is table of okl_k_rate_params.attribute10%TYPE index by binary_integer;
4438: TYPE l_kattribute11_type is table of okl_k_rate_params.attribute11%TYPE index by binary_integer;
4439: TYPE l_kattribute12_type is table of okl_k_rate_params.attribute12%TYPE index by binary_integer;

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

4432: TYPE l_kattribute5_type is table of okl_k_rate_params.attribute5%TYPE index by binary_integer;
4433: TYPE l_kattribute6_type is table of okl_k_rate_params.attribute6%TYPE index by binary_integer;
4434: TYPE l_kattribute7_type is table of okl_k_rate_params.attribute7%TYPE index by binary_integer;
4435: TYPE l_kattribute8_type is table of okl_k_rate_params.attribute8%TYPE index by binary_integer;
4436: TYPE l_kattribute9_type is table of okl_k_rate_params.attribute9%TYPE index by binary_integer;
4437: TYPE l_kattribute10_type is table of okl_k_rate_params.attribute10%TYPE index by binary_integer;
4438: TYPE l_kattribute11_type is table of okl_k_rate_params.attribute11%TYPE index by binary_integer;
4439: TYPE l_kattribute12_type is table of okl_k_rate_params.attribute12%TYPE index by binary_integer;
4440: TYPE l_kattribute13_type is table of okl_k_rate_params.attribute13%TYPE index by binary_integer;

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

4433: TYPE l_kattribute6_type is table of okl_k_rate_params.attribute6%TYPE index by binary_integer;
4434: TYPE l_kattribute7_type is table of okl_k_rate_params.attribute7%TYPE index by binary_integer;
4435: TYPE l_kattribute8_type is table of okl_k_rate_params.attribute8%TYPE index by binary_integer;
4436: TYPE l_kattribute9_type is table of okl_k_rate_params.attribute9%TYPE index by binary_integer;
4437: TYPE l_kattribute10_type is table of okl_k_rate_params.attribute10%TYPE index by binary_integer;
4438: TYPE l_kattribute11_type is table of okl_k_rate_params.attribute11%TYPE index by binary_integer;
4439: TYPE l_kattribute12_type is table of okl_k_rate_params.attribute12%TYPE index by binary_integer;
4440: TYPE l_kattribute13_type is table of okl_k_rate_params.attribute13%TYPE index by binary_integer;
4441: TYPE l_kattribute14_type is table of okl_k_rate_params.attribute14%TYPE index by binary_integer;

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

4434: TYPE l_kattribute7_type is table of okl_k_rate_params.attribute7%TYPE index by binary_integer;
4435: TYPE l_kattribute8_type is table of okl_k_rate_params.attribute8%TYPE index by binary_integer;
4436: TYPE l_kattribute9_type is table of okl_k_rate_params.attribute9%TYPE index by binary_integer;
4437: TYPE l_kattribute10_type is table of okl_k_rate_params.attribute10%TYPE index by binary_integer;
4438: TYPE l_kattribute11_type is table of okl_k_rate_params.attribute11%TYPE index by binary_integer;
4439: TYPE l_kattribute12_type is table of okl_k_rate_params.attribute12%TYPE index by binary_integer;
4440: TYPE l_kattribute13_type is table of okl_k_rate_params.attribute13%TYPE index by binary_integer;
4441: TYPE l_kattribute14_type is table of okl_k_rate_params.attribute14%TYPE index by binary_integer;
4442: TYPE l_kattribute15_type is table of okl_k_rate_params.attribute15%TYPE index by binary_integer;

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

4435: TYPE l_kattribute8_type is table of okl_k_rate_params.attribute8%TYPE index by binary_integer;
4436: TYPE l_kattribute9_type is table of okl_k_rate_params.attribute9%TYPE index by binary_integer;
4437: TYPE l_kattribute10_type is table of okl_k_rate_params.attribute10%TYPE index by binary_integer;
4438: TYPE l_kattribute11_type is table of okl_k_rate_params.attribute11%TYPE index by binary_integer;
4439: TYPE l_kattribute12_type is table of okl_k_rate_params.attribute12%TYPE index by binary_integer;
4440: TYPE l_kattribute13_type is table of okl_k_rate_params.attribute13%TYPE index by binary_integer;
4441: TYPE l_kattribute14_type is table of okl_k_rate_params.attribute14%TYPE index by binary_integer;
4442: TYPE l_kattribute15_type is table of okl_k_rate_params.attribute15%TYPE index by binary_integer;
4443: TYPE l_kcatchup_frequency_code_type is table of okl_k_rate_params.catchup_frequency_code%TYPE index by binary_integer;

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

4436: TYPE l_kattribute9_type is table of okl_k_rate_params.attribute9%TYPE index by binary_integer;
4437: TYPE l_kattribute10_type is table of okl_k_rate_params.attribute10%TYPE index by binary_integer;
4438: TYPE l_kattribute11_type is table of okl_k_rate_params.attribute11%TYPE index by binary_integer;
4439: TYPE l_kattribute12_type is table of okl_k_rate_params.attribute12%TYPE index by binary_integer;
4440: TYPE l_kattribute13_type is table of okl_k_rate_params.attribute13%TYPE index by binary_integer;
4441: TYPE l_kattribute14_type is table of okl_k_rate_params.attribute14%TYPE index by binary_integer;
4442: TYPE l_kattribute15_type is table of okl_k_rate_params.attribute15%TYPE index by binary_integer;
4443: TYPE l_kcatchup_frequency_code_type is table of okl_k_rate_params.catchup_frequency_code%TYPE index by binary_integer;
4444:

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

4437: TYPE l_kattribute10_type is table of okl_k_rate_params.attribute10%TYPE index by binary_integer;
4438: TYPE l_kattribute11_type is table of okl_k_rate_params.attribute11%TYPE index by binary_integer;
4439: TYPE l_kattribute12_type is table of okl_k_rate_params.attribute12%TYPE index by binary_integer;
4440: TYPE l_kattribute13_type is table of okl_k_rate_params.attribute13%TYPE index by binary_integer;
4441: TYPE l_kattribute14_type is table of okl_k_rate_params.attribute14%TYPE index by binary_integer;
4442: TYPE l_kattribute15_type is table of okl_k_rate_params.attribute15%TYPE index by binary_integer;
4443: TYPE l_kcatchup_frequency_code_type is table of okl_k_rate_params.catchup_frequency_code%TYPE index by binary_integer;
4444:
4445: l_kkhr_id_tab l_kkhr_id_type;

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

4438: TYPE l_kattribute11_type is table of okl_k_rate_params.attribute11%TYPE index by binary_integer;
4439: TYPE l_kattribute12_type is table of okl_k_rate_params.attribute12%TYPE index by binary_integer;
4440: TYPE l_kattribute13_type is table of okl_k_rate_params.attribute13%TYPE index by binary_integer;
4441: TYPE l_kattribute14_type is table of okl_k_rate_params.attribute14%TYPE index by binary_integer;
4442: TYPE l_kattribute15_type is table of okl_k_rate_params.attribute15%TYPE index by binary_integer;
4443: TYPE l_kcatchup_frequency_code_type is table of okl_k_rate_params.catchup_frequency_code%TYPE index by binary_integer;
4444:
4445: l_kkhr_id_tab l_kkhr_id_type;
4446: l_kparameter_type_code_tab l_kparameter_type_code_type;

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

4439: TYPE l_kattribute12_type is table of okl_k_rate_params.attribute12%TYPE index by binary_integer;
4440: TYPE l_kattribute13_type is table of okl_k_rate_params.attribute13%TYPE index by binary_integer;
4441: TYPE l_kattribute14_type is table of okl_k_rate_params.attribute14%TYPE index by binary_integer;
4442: TYPE l_kattribute15_type is table of okl_k_rate_params.attribute15%TYPE index by binary_integer;
4443: TYPE l_kcatchup_frequency_code_type is table of okl_k_rate_params.catchup_frequency_code%TYPE index by binary_integer;
4444:
4445: l_kkhr_id_tab l_kkhr_id_type;
4446: l_kparameter_type_code_tab l_kparameter_type_code_type;
4447: l_keffective_from_date_tab l_keffective_from_date_type;

Line 4555: FROM OKL_K_RATE_PARAMS a

4551: a.attribute6, a.attribute7, a.attribute8,
4552: a.attribute9, a.attribute10, a.attribute11,
4553: a.attribute12, a.attribute13, a.attribute14,
4554: a.attribute15, a.catchup_frequency_code
4555: FROM OKL_K_RATE_PARAMS a
4556: WHERE a.khr_id = p_id;
4557: --AND (effective_to_date is NULL OR
4558: -- effective_to_date = p_date);
4559:

Line 4562: FROM OKL_K_RATE_PARAMS

4558: -- effective_to_date = p_date);
4559:
4560: /*CURSOR max_effective_to_date_csr(p_id NUMBER) IS
4561: SELECT max(effective_to_date) effective_to_date
4562: FROM OKL_K_RATE_PARAMS
4563: WHERE KHR_ID = p_id;
4564:
4565: l_max_effective_to_date DATE;*/
4566: BEGIN

Line 4570: DELETE OKL_K_RATE_PARAMS

4566: BEGIN
4567: IF (G_DEBUG_ENABLED = 'Y') THEN
4568: G_IS_DEBUG_STATEMENT_ON := OKL_DEBUG_PUB.CHECK_LOG_ON(G_MODULE, FND_LOG.LEVEL_STATEMENT);
4569: END IF;
4570: DELETE OKL_K_RATE_PARAMS
4571: WHERE KHR_ID = p_new_contract_id;
4572: --AND effective_to_date is NULL;
4573:
4574: /*FOR r IN max_effective_to_date_csr(p_orig_contract_id)

Line 4660: INSERT INTO okl_k_rate_params (

4656: CLOSE C30;
4657:
4658: IF l_k_rate_params_counter > 1 THEN
4659: FORALL i IN l_kkhr_id_tab.FIRST..l_kkhr_id_tab.LAST
4660: INSERT INTO okl_k_rate_params (
4661: khr_id, parameter_type_code, effective_from_date,
4662: effective_to_date, interest_index_id, base_rate,
4663: interest_start_date, adder_rate, maximum_rate,
4664: minimum_rate, principal_basis_code, days_in_a_month_code,

Line 4768: FROM OKL_K_RATE_PARAMS

4764: x_base_rate_defined OUT NOCOPY BOOLEAN,
4765: x_return_status OUT NOCOPY VARCHAR2) IS
4766: CURSOR base_rate_csr(p_id NUMBER) IS
4767: SELECT base_rate
4768: FROM OKL_K_RATE_PARAMS
4769: WHERE KHR_ID = p_id
4770: AND PARAMETER_TYPE_CODE = 'ACTUAL'
4771: AND EFFECTIVE_TO_DATE IS NULL;
4772:

Line 4934: FROM OKL_K_RATE_PARAMS rate,

4930: select rate.effective_from_date,
4931: contract.orig_system_source_code,
4932: lease.date_last_interim_interest_cal,
4933: contract.orig_system_id1
4934: FROM OKL_K_RATE_PARAMS rate,
4935: OKC_K_HEADERS_B contract,
4936: OKL_K_HEADERS lease
4937: WHERE rate.khr_id = p_khr_id
4938: AND rate.parameter_type_code = p_parameter_type_code

Line 4985: OKL_K_RATE_PARAMS_PVT.get_product(

4981: p_api_version => p_api_version,
4982: p_api_type => G_API_TYPE,
4983: x_return_status => x_return_status);
4984:
4985: OKL_K_RATE_PARAMS_PVT.get_product(
4986: p_api_version => p_api_version,
4987: p_init_msg_list => p_init_msg_list,
4988: x_return_status => x_return_status,
4989: x_msg_count => x_msg_count,

Line 5144: FROM OKL_K_RATE_PARAMS

5140: x_krpv_rec.ATTRIBUTE12, x_krpv_rec.ATTRIBUTE13, x_krpv_rec.ATTRIBUTE14,
5141: x_krpv_rec.ATTRIBUTE15, x_krpv_rec.CREATED_BY, x_krpv_rec.CREATION_DATE,
5142: x_krpv_rec.LAST_UPDATED_BY, x_krpv_rec.LAST_UPDATE_DATE, x_krpv_rec.LAST_UPDATE_LOGIN,
5143: x_krpv_rec.CATCHUP_FREQUENCY_CODE
5144: FROM OKL_K_RATE_PARAMS
5145: WHERE KHR_ID = p_khr_id
5146: AND PARAMETER_TYPE_CODE = l_parameter_type_code
5147: AND EFFECTIVE_FROM_DATE = l_effective_from_date
5148: AND EFFECTIVE_TO_DATE IS NULL;

Line 5150: INSERT INTO OKL_K_RATE_PARAMS (

5146: AND PARAMETER_TYPE_CODE = l_parameter_type_code
5147: AND EFFECTIVE_FROM_DATE = l_effective_from_date
5148: AND EFFECTIVE_TO_DATE IS NULL;
5149:
5150: INSERT INTO OKL_K_RATE_PARAMS (
5151: KHR_ID, PARAMETER_TYPE_CODE, EFFECTIVE_FROM_DATE,
5152: EFFECTIVE_TO_DATE, INTEREST_INDEX_ID, BASE_RATE,
5153: INTEREST_START_DATE, ADDER_RATE, MAXIMUM_RATE,
5154: MINIMUM_RATE, PRINCIPAL_BASIS_CODE, DAYS_IN_A_MONTH_CODE,

Line 5188: UPDATE OKL_K_RATE_PARAMS

5184: x_krpv_rec.ATTRIBUTE15, x_krpv_rec.CREATED_BY, x_krpv_rec.CREATION_DATE,
5185: x_krpv_rec.LAST_UPDATED_BY, x_krpv_rec.LAST_UPDATE_DATE, x_krpv_rec.LAST_UPDATE_LOGIN,
5186: x_krpv_rec.CATCHUP_FREQUENCY_CODE);
5187:
5188: UPDATE OKL_K_RATE_PARAMS
5189: SET EFFECTIVE_TO_DATE = p_effective_from_date - 1
5190: WHERE KHR_ID = p_khr_id
5191: AND PARAMETER_TYPE_CODE = l_parameter_type_code
5192: AND EFFECTIVE_FROM_DATE = l_effective_from_date

Line 5260: FROM OKL_K_RATE_PARAMS

5256: x_return_status => x_return_status);
5257:
5258: SELECT COUNT(1)
5259: INTO l_base_count
5260: FROM OKL_K_RATE_PARAMS
5261: WHERE khr_id = p_khr_id
5262: AND PARAMETER_TYPE_CODE = 'ACTUAL'
5263: AND EFFECTIVE_TO_DATE IS NULL
5264: AND BASE_RATE IS NULL;

Line 5277: UPDATE OKL_K_RATE_PARAMS

5273:
5274: IF (G_IS_DEBUG_STATEMENT_ON = true) THEN
5275: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'l_implicit_interest_rate=' || l_implicit_interest_rate);
5276: END IF;
5277: UPDATE OKL_K_RATE_PARAMS
5278: SET BASE_RATE = l_implicit_interest_rate
5279: WHERE khr_id = p_khr_id
5280: AND PARAMETER_TYPE_CODE = 'ACTUAL'
5281: AND EFFECTIVE_TO_DATE IS NULL

Line 5317: END OKL_K_RATE_PARAMS_PVT;

5313: p_api_type => g_api_type);
5314:
5315: END;
5316:
5317: END OKL_K_RATE_PARAMS_PVT;