DBA Data[Home] [Help]

APPS.OKL_VARIABLE_INTEREST_PVT dependencies on OKL_VAR_INT_PROCESS_B

Line 6382: g_vir_tbl(g_vir_tbl_counter).source_table := 'OKL_VAR_INT_PROCESS_B';

6378: g_vir_tbl(g_vir_tbl_counter).khr_id := p_contract_id;
6379: IF (G_CALC_METHOD_CODE = 'DAILY_INTEREST') THEN
6380: g_vir_tbl(g_vir_tbl_counter).source_table := 'OKL_STRM_ELEMENTS_B';
6381: ELSIF (G_CALC_METHOD_CODE = 'REAMORT') THEN
6382: g_vir_tbl(g_vir_tbl_counter).source_table := 'OKL_VAR_INT_PROCESS_B';
6383: ELSE
6384: g_vir_tbl(g_vir_tbl_counter).source_table := 'OKL_TRX_AR_INVOICES_V';
6385: END IF;
6386: g_vir_tbl(g_vir_tbl_counter).interest_rate := l_interest_rate;

Line 8923: FROM okl_var_int_process_b

8919: l_strm_lalevl_tbl_out strm_lalevl_tbl;
8920:
8921: CURSOR l_vip_csr (p_trx_id in NUMBER) IS
8922: SELECT id
8923: FROM okl_var_int_process_b
8924: WHERE PARENT_TRX_ID = p_trx_id;
8925:
8926: --cursor to get existing payments
8927: Cursor l_pmt_csr (p_khr_id in number, p_cle_id in number) is

Line 9650: print_debug('Before updating okl_var_int_process_b');

9646: l_vipv_rec.child_trx_id := x_strm_trx_tbl(i).trx_number;
9647: i := null;
9648:
9649:
9650: print_debug('Before updating okl_var_int_process_b');
9651: OKL_VIP_PVT.update_row(
9652: p_api_version => p_api_version,
9653: p_init_msg_list => p_init_msg_list,
9654: x_return_status => x_return_status,

Line 9659: print_debug('After updating okl_var_int_process_b, Status => ' || x_return_status);

9655: x_msg_count => x_msg_count,
9656: x_msg_data => x_msg_data,
9657: p_vipv_rec => l_vipv_rec,
9658: x_vipv_rec => x_vipv_rec);
9659: print_debug('After updating okl_var_int_process_b, Status => ' || x_return_status);
9660: print_debug('****End-Creating Rent Levels and ReBooking.');
9661: print_debug('****Exiting procedure VAR_INT_RENT_LEVEL****');
9662:
9663:

Line 11118: g_vir_tbl(g_vir_tbl_counter).source_table := 'OKL_VAR_INT_PROCESS_B';

11114: g_vir_tbl.delete;
11115: g_vir_tbl_counter := g_vir_tbl_counter + 1;
11116: g_vir_tbl(g_vir_tbl_counter).id := okc_p_util.raw_to_number(sys_guid());
11117: g_vir_tbl(g_vir_tbl_counter).khr_id := p_khr_id;
11118: g_vir_tbl(g_vir_tbl_counter).source_table := 'OKL_VAR_INT_PROCESS_B';
11119: g_vir_tbl(g_vir_tbl_counter).source_id := x_vipv_rec.id;
11120: g_vir_tbl(g_vir_tbl_counter).interest_rate := l_interest_rate_tbl(l_interest_rate_tbl.first).rate;
11121: g_vir_tbl(g_vir_tbl_counter).interest_calc_start_date := l_start_date;
11122: g_vir_tbl(g_vir_tbl_counter).interest_calc_end_date := l_start_date;