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 316: l_interest_due := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(

312:
313:
314: --change for bug fix 4905791
315: IF (l_rev_rec_mthd = 'ACTUAL') THEN
316: l_interest_due := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(
317: p_api_version => l_api_version,
318: p_init_msg_list => OKL_API.G_FALSE,
319: x_return_status => x_return_status,
320: x_msg_count => x_msg_count,

Line 336: l_interest_due := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(

332: END IF;
333: ELSE
334:
335: IF l_principal_basis = 'ACTUAL' THEN
336: l_interest_due := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(
337: p_api_version => l_api_version,
338: p_init_msg_list => OKL_API.G_FALSE,
339: x_return_status => x_return_status,
340: x_msg_count => x_msg_count,

Line 385: l_interest_amt := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(

381: --dkagrawa handled nvl for fully billed contract bug#6660659
382: IF nvl(l_due_date,l_to_date) >= l_to_date THEN
383: l_due_date := l_to_date;
384: END IF;
385: l_interest_amt := OKL_VARIABLE_INTEREST_PVT.calculate_total_interest_due(
386: p_api_version => l_api_version,
387: p_init_msg_list => OKL_API.G_FALSE,
388: x_return_status => x_return_status,
389: x_msg_count => x_msg_count,

Line 472: l_principal_balance_tbl okl_variable_interest_pvt.principal_balance_tbl_typ;

468: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_PRINCIPAL_BAL';
469:
470: l_start_date DATE;
471: l_principal_basis okl_k_rate_params.principal_basis_code%TYPE;
472: l_principal_balance_tbl okl_variable_interest_pvt.principal_balance_tbl_typ;
473: l_principal_bal NUMBER;
474: l_stream_element_date DATE;
475:
476: CURSOR l_principal_basis_csr(cp_khr_id IN NUMBER) IS

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

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

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

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

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

561: -- But in OKL_VARIABLE_INTEREST_PVT, the code tries to fetch principal basis again from the
562: -- interst rate paramaters on the contract, and fails when not found. This check is done based upon the
563: -- value of OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID. If this global is not set, validation is done, but
564: -- If it is set, validation is by passed. Since in this case, validation is not needed, setting the
565: -- following 2 globals here, so OKL_VARIABLE_INTEREST_PVT can proceed with the default principal basis.
566: OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID := p_khr_id;
567: OPEN contract_csr (p_khr_id);
568: FETCH contract_csr INTO OKL_VARIABLE_INTEREST_PVT.G_DEAL_TYPE;
569: CLOSE contract_csr;

Line 566: OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID := p_khr_id;

562: -- interst rate paramaters on the contract, and fails when not found. This check is done based upon the
563: -- value of OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID. If this global is not set, validation is done, but
564: -- If it is set, validation is by passed. Since in this case, validation is not needed, setting the
565: -- following 2 globals here, so OKL_VARIABLE_INTEREST_PVT can proceed with the default principal basis.
566: OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID := p_khr_id;
567: OPEN contract_csr (p_khr_id);
568: FETCH contract_csr INTO OKL_VARIABLE_INTEREST_PVT.G_DEAL_TYPE;
569: CLOSE contract_csr;
570: -- sechawla 02-may-08 6939451 : end

Line 568: FETCH contract_csr INTO OKL_VARIABLE_INTEREST_PVT.G_DEAL_TYPE;

564: -- If it is set, validation is by passed. Since in this case, validation is not needed, setting the
565: -- following 2 globals here, so OKL_VARIABLE_INTEREST_PVT can proceed with the default principal basis.
566: OKL_VARIABLE_INTEREST_PVT.G_CONTRACT_ID := p_khr_id;
567: OPEN contract_csr (p_khr_id);
568: FETCH contract_csr INTO OKL_VARIABLE_INTEREST_PVT.G_DEAL_TYPE;
569: CLOSE contract_csr;
570: -- sechawla 02-may-08 6939451 : end
571:
572: END IF;

Line 582: OKL_VARIABLE_INTEREST_PVT.prin_date_range_var_rate_ctr (

578: CLOSE l_int_calc_basis_csr;
579:
580: --change for bug fix 4905791
581: IF (l_principal_basis = 'ACTUAL' OR l_rev_rec_mthd = 'ACTUAL') THEN
582: OKL_VARIABLE_INTEREST_PVT.prin_date_range_var_rate_ctr (
583: p_api_version => l_api_version,
584: p_init_msg_list => OKL_API.G_FALSE,
585: x_return_status => x_return_status,
586: x_msg_count => x_msg_count,

Line 610: OKL_VARIABLE_INTEREST_PVT.prin_date_range_var_rate_ctr (

606: IF (l_stream_element_date IS NULL) THEN
607: RETURN 0;
608: END IF;
609:
610: OKL_VARIABLE_INTEREST_PVT.prin_date_range_var_rate_ctr (
611: p_api_version => l_api_version,
612: p_init_msg_list => OKL_API.G_FALSE,
613: x_return_status => x_return_status,
614: x_msg_count => x_msg_count,

Line 993: l_interest_rate_tbl okl_variable_interest_pvt.interest_rate_tbl_type;

989: x_msg_data VARCHAR2(2000);
990: l_debug_enabled VARCHAR2(1);
991: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_VARIABLE_INT_UTIL_PVT.GET_EFFECTIVE_INT_RATE';
992:
993: l_interest_rate_tbl okl_variable_interest_pvt.interest_rate_tbl_type;
994: l_effective_int_rate NUMBER;
995: l_process_flag okl_product_parameters_v.interest_calculation_basis%TYPE;
996: l_end_date okl_k_headers_full_v.end_date%TYPE;
997: l_effective_date DATE := NULL;

Line 1020: OKL_VARIABLE_INTEREST_PVT.interest_date_range (

1016: IF (l_effective_date > l_end_date) THEN
1017: l_effective_date := l_end_date;
1018: END IF;
1019:
1020: OKL_VARIABLE_INTEREST_PVT.interest_date_range (
1021: p_api_version => l_api_version,
1022: p_init_msg_list => OKL_API.G_FALSE,
1023: x_return_status => x_return_status,
1024: x_msg_count => x_msg_count,

Line 1908: l_start_date := OKL_VARIABLE_INTEREST_PVT.get_next_period_start_date(p_khr_id => p_khr_id,

1904:
1905: --Bug# 14049528
1906: LOOP
1907: l_last_interest_date := l_start_date;
1908: l_start_date := OKL_VARIABLE_INTEREST_PVT.get_next_period_start_date(p_khr_id => p_khr_id,
1909: p_start_date => l_start_date);
1910:
1911: -- Below check is not needed since we need to use Invoice Date and not Due Date for comparison
1912: -- with Termination Date