APPS.OKL_SUBSIDY_POOL_AUTH_TRX_PVT dependencies on OKL_SIX_PVT

Line 22: ,p_six_tbl IN okl_six_pvt.sixv_tbl_type

18: -- end: cklee 07/12/2005
19:
20: -- local procedure 1. START
21: PROCEDURE pool_trx_khr_rbk(p_source_trx_date IN okl_trx_subsidy_pools.source_trx_date%TYPE
22: ,p_six_tbl IN okl_six_pvt.sixv_tbl_type
23: ,x_return_status OUT NOCOPY VARCHAR2)IS
24:
25: CURSOR c_get_pool_dates_csr(cp_subsidy_pool_id okl_subsidy_pools_b.id%TYPE) IS
26: SELECT effective_from_date

Line 58: lv_six_tbl okl_six_pvt.sixv_tbl_type;

54: AND trx_amount = cp_trx_amount
55: AND trx_currency_code = cp_trx_currency_code;
56: cv_get_pool_trx_details c_get_pool_trx_details%ROWTYPE;
57:
58: lv_six_tbl okl_six_pvt.sixv_tbl_type;
59: lx_six_tbl okl_six_pvt.sixv_tbl_type;
60: idx PLS_INTEGER;
61: total_num_recs NUMBER;
62: x_msg_count NUMBER;

Line 59: lx_six_tbl okl_six_pvt.sixv_tbl_type;

55: AND trx_currency_code = cp_trx_currency_code;
56: cv_get_pool_trx_details c_get_pool_trx_details%ROWTYPE;
57:
58: lv_six_tbl okl_six_pvt.sixv_tbl_type;
59: lx_six_tbl okl_six_pvt.sixv_tbl_type;
60: idx PLS_INTEGER;
61: total_num_recs NUMBER;
62: x_msg_count NUMBER;
63: l_api_version CONSTANT NUMBER DEFAULT '1.0';

Line 219: lv_six_tbl okl_six_pvt.sixv_tbl_type;

215:
216: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
217: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
218: lv_subsidy_applic VARCHAR2(10);
219: lv_six_tbl okl_six_pvt.sixv_tbl_type;
220: lx_six_tbl okl_six_pvt.sixv_tbl_type;
221: idx NUMBER;
222: total_num_recs NUMBER;
223: x_msg_count NUMBER;

Line 220: lx_six_tbl okl_six_pvt.sixv_tbl_type;

216: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
217: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
218: lv_subsidy_applic VARCHAR2(10);
219: lv_six_tbl okl_six_pvt.sixv_tbl_type;
220: lx_six_tbl okl_six_pvt.sixv_tbl_type;
221: idx NUMBER;
222: total_num_recs NUMBER;
223: x_msg_count NUMBER;
224: l_api_version CONSTANT NUMBER DEFAULT 1.0;