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_VAR_INT_REAMORT_PVT dependencies on OKL_VAR_INT_PARAMS

Line 1535: l_interest_rate okl_var_int_params.INTEREST_RATE%type;

1531: l_child_trx_id NUMBER := NULL;
1532: l_advance_or_arrears VARCHAR2(100) := NULL;
1533: initiate_request_failed EXCEPTION;
1534: -- Added by prasjain bug# 6142095
1535: l_interest_rate okl_var_int_params.INTEREST_RATE%type;
1536: l_rebook_flag BOOLEAN := TRUE;
1537: l_interest_calc_end_date DATE;
1538: -- End by prasjain bug# 6142095
1539: l_next_reamort_date DATE; --Added by bkatraga for bug 13693187

Line 1625: FROM okl_var_int_params

1621:
1622: -- Added by prasjain bug# 6142095
1623: CURSOR var_int_params_csr (p_contract_id NUMBER) IS
1624: SELECT interest_rate,interest_calc_end_date
1625: FROM okl_var_int_params
1626: WHERE khr_id = p_contract_id
1627: AND INTEREST_CALC_END_DATE = (SELECT max(INTEREST_CALC_END_DATE) FROM okl_var_int_params WHERE khr_id = p_contract_id);
1628:
1629: CURSOR c_last_int_cur (p_contract_id NUMBER) IS

Line 1627: AND INTEREST_CALC_END_DATE = (SELECT max(INTEREST_CALC_END_DATE) FROM okl_var_int_params WHERE khr_id = p_contract_id);

1623: CURSOR var_int_params_csr (p_contract_id NUMBER) IS
1624: SELECT interest_rate,interest_calc_end_date
1625: FROM okl_var_int_params
1626: WHERE khr_id = p_contract_id
1627: AND INTEREST_CALC_END_DATE = (SELECT max(INTEREST_CALC_END_DATE) FROM okl_var_int_params WHERE khr_id = p_contract_id);
1628:
1629: CURSOR c_last_int_cur (p_contract_id NUMBER) IS
1630: SELECT NVL(date_last_interim_interest_cal, start_date) reamort_date
1631: FROM okl_k_headers_full_v

Line 2443: OKL_VARIABLE_INTEREST_PVT.print_debug('Updating OKL_VAR_INT_PARAMS');

2439: IF (l_super_trump_request_id IS NOT NULL OR l_child_trx_id IS NOT NULL OR l_rebook_flag = FALSE) THEN
2440: -- End by prasjain bug# 6142095
2441:
2442: IF (l_interest_rate_tbl(l_interest_rate_tbl.first).derived_flag = 'Y')THEN
2443: OKL_VARIABLE_INTEREST_PVT.print_debug('Updating OKL_VAR_INT_PARAMS');
2444:
2445: IF (NVL(OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter, 0) = 0) THEN
2446: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter := NVL(OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter, 0) + 1;
2447: END IF;

Line 2597: OKL_VARIABLE_INTEREST_PVT.print_debug('Updating OKL_VAR_INT_PARAMS Successful');

2593: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
2594: OKL_VARIABLE_INTEREST_PVT.print_error_message('Error raised in call to INSERT_VIR_PARAMS');
2595: RAISE initiate_request_failed;
2596: END IF;
2597: OKL_VARIABLE_INTEREST_PVT.print_debug('Updating OKL_VAR_INT_PARAMS Successful');
2598: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl.delete;
2599:
2600: END IF;
2601: END IF;