[Home] [Help]
753: l_next_reamort_date DATE; --Added by bkatraga for bug 13693187
754:
755: CURSOR l_vip_csr (p_trx_id in NUMBER) IS
756: SELECT id
757: FROM okl_var_int_process_b
758: WHERE PARENT_TRX_ID = p_trx_id;
759:
760: --cursor to get existing payments
761: Cursor l_pmt_csr (p_khr_id in number, p_cle_id in number) is
1409: i := x_strm_trx_tbl.first;
1410: l_vipv_rec.child_trx_id := x_strm_trx_tbl(i).trx_number;
1411: i := null;
1412:
1413: OKL_VARIABLE_INTEREST_PVT.print_debug(p_trx_id || 'Before updating okl_var_int_process_b');
1414: OKL_VARIABLE_INTEREST_PVT.print_debug(p_trx_id|| 'l_vipv_rec.id =' || l_vipv_rec.id );
1415:
1416: -- Bug 10324172 : If ESG is behaving asynchronous, then only update it
1417: -- Asynchronous means, insertion has already happened before Update
1416: -- Bug 10324172 : If ESG is behaving asynchronous, then only update it
1417: -- Asynchronous means, insertion has already happened before Update
1418: IF l_vipv_rec.ID IS NOT NULL AND l_vipv_rec.ID <> OKL_API.G_MISS_NUM
1419: THEN
1420: OKL_VARIABLE_INTEREST_PVT.print_debug(p_trx_id || 'Before call to okl_var_int_process_b.update_row' );
1421: OKL_VIP_PVT.update_row(
1422: p_api_version => p_api_version,
1423: p_init_msg_list => p_init_msg_list,
1424: x_return_status => x_return_status,
1425: x_msg_count => x_msg_count,
1426: x_msg_data => x_msg_data,
1427: p_vipv_rec => l_vipv_rec,
1428: x_vipv_rec => x_vipv_rec);
1429: OKL_VARIABLE_INTEREST_PVT.print_debug(p_trx_id || 'After updating okl_var_int_process_b, Status => ' || x_return_status);
1430: OKL_VARIABLE_INTEREST_PVT.print_debug(p_trx_id || '****End-Creating Rent Levels and ReBooking.');
1431: OKL_VARIABLE_INTEREST_PVT.print_debug(p_trx_id || '****Exiting procedure VAR_INT_RENT_LEVEL****');
1432: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
1433: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
2467: LOOP
2468: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter + 1;
2469: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl(OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
2470: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl(OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter).khr_id := p_khr_id;
2471: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl(OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter).source_table := 'OKL_VAR_INT_PROCESS_B';
2472: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl(OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter).source_id := x_vipv_rec.id;
2473: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl(OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter).interest_rate := l_interest_rate_tbl(l_interest_rate_tbl.first).rate;
2474: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl(OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter).interest_calc_start_date := l_start_date;
2475: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl(OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter).interest_calc_end_date := l_start_date;
2515: FOR i IN l_line_prin_tbl.FIRST..l_line_prin_tbl.LAST LOOP
2516: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter := OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter + 1;
2517: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl(OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
2518: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl(OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter).khr_id := p_khr_id;
2519: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl(OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter).source_table := 'OKL_VAR_INT_PROCESS_B';
2520: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl(OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter).source_id := x_vipv_rec.id;
2521: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl(OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter).interest_rate := l_interest_rate_tbl(l_interest_rate_tbl.first).rate;
2522: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl(OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter).interest_calc_start_date := l_start_date;
2523: OKL_VARIABLE_INTEREST_PVT.g_vir_tbl(OKL_VARIABLE_INTEREST_PVT.g_vir_tbl_counter).interest_calc_end_date := l_start_date;