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_VARIABLE_INT_UTIL_PVT dependencies on OKL_VARIABLE_INTEREST_PVT

Line 402: l_interest_due := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(

398:
399:
400: --change for bug fix 4905791
401: IF (l_rev_rec_mthd = 'ACTUAL') THEN
402: l_interest_due := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(
403: p_api_version => l_api_version,
404: p_init_msg_list => OKL_API.G_FALSE,
405: x_return_status => x_return_status,
406: x_msg_count => x_msg_count,

Line 422: l_interest_due := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(

418: END IF;
419: ELSE
420:
421: IF l_principal_basis = 'ACTUAL' THEN
422: l_interest_due := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(
423: p_api_version => l_api_version,
424: p_init_msg_list => OKL_API.G_FALSE,
425: x_return_status => x_return_status,
426: x_msg_count => x_msg_count,

Line 471: l_interest_amt := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(

467: --dkagrawa handled nvl for fully billed contract bug#6660659
468: IF nvl(l_due_date,l_to_date) >= l_to_date THEN
469: l_due_date := l_to_date;
470: END IF;
471: l_interest_amt := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(
472: p_api_version => l_api_version,
473: p_init_msg_list => OKL_API.G_FALSE,
474: x_return_status => x_return_status,
475: x_msg_count => x_msg_count,

Line 558: l_principal_balance_tbl okl_variable_interest_pvt.principal_balance_tbl_typ;

554: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_PRINCIPAL_BAL';
555:
556: l_start_date DATE;
557: l_principal_basis okl_k_rate_params.principal_basis_code%TYPE;
558: l_principal_balance_tbl okl_variable_interest_pvt.principal_balance_tbl_typ;
559: l_principal_bal NUMBER;
560: l_stream_element_date DATE;
561:
562: CURSOR l_principal_basis_csr(cp_khr_id IN NUMBER) IS

Line 647: -- But in OKL_VARIABLE_INTEREST_PVT, the code tries to fetch principal basis again from the

643: l_principal_basis := 'SCHEDULED';
644:
645: -- sechawla 02-may-08 6939451 : When interest rate parametrs are not defined on the contract,
646: -- default principal basis 'SCHEDULED' is used, as per the existing assignment above
647: -- But in OKL_VARIABLE_INTEREST_PVT, the code tries to fetch principal basis again from the
648: -- interst rate paramaters on the contract, and fails when not found. This check is done based upon the
649: -- value of OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID. If this global is not set, validation is done, but
650: -- If it is set, validation is by passed. Since in this case, validation is not needed, setting the
651: -- following 2 globals here, so OKL_VARIABLE_INTEREST_PVT can proceed with the default principal basis.

Line 649: -- value of OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID. If this global is not set, validation is done, but

645: -- sechawla 02-may-08 6939451 : When interest rate parametrs are not defined on the contract,
646: -- default principal basis 'SCHEDULED' is used, as per the existing assignment above
647: -- But in OKL_VARIABLE_INTEREST_PVT, the code tries to fetch principal basis again from the
648: -- interst rate paramaters on the contract, and fails when not found. This check is done based upon the
649: -- value of OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID. If this global is not set, validation is done, but
650: -- If it is set, validation is by passed. Since in this case, validation is not needed, setting the
651: -- following 2 globals here, so OKL_VARIABLE_INTEREST_PVT can proceed with the default principal basis.
652: OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID := p_khr_id;
653: OPEN contract_csr (p_khr_id);

Line 651: -- following 2 globals here, so OKL_VARIABLE_INTEREST_PVT can proceed with the default principal basis.

647: -- But in OKL_VARIABLE_INTEREST_PVT, the code tries to fetch principal basis again from the
648: -- interst rate paramaters on the contract, and fails when not found. This check is done based upon the
649: -- value of OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID. If this global is not set, validation is done, but
650: -- If it is set, validation is by passed. Since in this case, validation is not needed, setting the
651: -- following 2 globals here, so OKL_VARIABLE_INTEREST_PVT can proceed with the default principal basis.
652: OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID := p_khr_id;
653: OPEN contract_csr (p_khr_id);
654: FETCH contract_csr INTO OKL_VARIABLE_INTEREST_PVT.G_DEAL_TYPE;
655: CLOSE contract_csr;

Line 652: OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID := p_khr_id;

648: -- interst rate paramaters on the contract, and fails when not found. This check is done based upon the
649: -- value of OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID. If this global is not set, validation is done, but
650: -- If it is set, validation is by passed. Since in this case, validation is not needed, setting the
651: -- following 2 globals here, so OKL_VARIABLE_INTEREST_PVT can proceed with the default principal basis.
652: OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID := p_khr_id;
653: OPEN contract_csr (p_khr_id);
654: FETCH contract_csr INTO OKL_VARIABLE_INTEREST_PVT.G_DEAL_TYPE;
655: CLOSE contract_csr;
656: -- sechawla 02-may-08 6939451 : end

Line 654: FETCH contract_csr INTO OKL_VARIABLE_INTEREST_PVT.G_DEAL_TYPE;

650: -- If it is set, validation is by passed. Since in this case, validation is not needed, setting the
651: -- following 2 globals here, so OKL_VARIABLE_INTEREST_PVT can proceed with the default principal basis.
652: OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID := p_khr_id;
653: OPEN contract_csr (p_khr_id);
654: FETCH contract_csr INTO OKL_VARIABLE_INTEREST_PVT.G_DEAL_TYPE;
655: CLOSE contract_csr;
656: -- sechawla 02-may-08 6939451 : end
657:
658: END IF;

Line 668: OKL_VARIABLE_INTEREST_PVT.prin_date_range_var_rate_ctr (

664: CLOSE l_int_calc_basis_csr;
665:
666: --change for bug fix 4905791
667: IF (l_principal_basis = 'ACTUAL' OR l_rev_rec_mthd = 'ACTUAL') THEN
668: OKL_VARIABLE_INTEREST_PVT.prin_date_range_var_rate_ctr (
669: p_api_version => l_api_version,
670: p_init_msg_list => OKL_API.G_FALSE,
671: x_return_status => x_return_status,
672: x_msg_count => x_msg_count,

Line 696: OKL_VARIABLE_INTEREST_PVT.prin_date_range_var_rate_ctr (

692: IF (l_stream_element_date IS NULL) THEN
693: RETURN 0;
694: END IF;
695:
696: OKL_VARIABLE_INTEREST_PVT.prin_date_range_var_rate_ctr (
697: p_api_version => l_api_version,
698: p_init_msg_list => OKL_API.G_FALSE,
699: x_return_status => x_return_status,
700: x_msg_count => x_msg_count,

Line 1040: l_interest_rate_tbl okl_variable_interest_pvt.interest_rate_tbl_type;

1036: x_msg_data VARCHAR2(2000);
1037: l_debug_enabled VARCHAR2(1);
1038: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_EFFECTIVE_INT_RATE';
1039:
1040: l_interest_rate_tbl okl_variable_interest_pvt.interest_rate_tbl_type;
1041: l_effective_int_rate NUMBER;
1042: l_process_flag okl_product_parameters_v.interest_calculation_basis%TYPE;
1043: l_end_date okl_k_headers_full_v.end_date%TYPE;
1044: l_effective_date DATE := NULL;

Line 1067: OKL_VARIABLE_INTEREST_PVT.interest_date_range (

1063: IF (l_effective_date > l_end_date) THEN
1064: l_effective_date := l_end_date;
1065: END IF;
1066:
1067: OKL_VARIABLE_INTEREST_PVT.interest_date_range (
1068: p_api_version => l_api_version,
1069: p_init_msg_list => OKL_API.G_FALSE,
1070: x_return_status => x_return_status,
1071: x_msg_count => x_msg_count,