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_SUBSIDY_POOL_AUTH_TRX_PVT dependencies on OKL_SUBSIDY_POOLS_B

Line 25: CURSOR c_get_pool_dates_csr(cp_subsidy_pool_id okl_subsidy_pools_b.id%TYPE) IS

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
27: ,effective_to_date
28: ,subsidy_pool_name
29: FROM okl_subsidy_pools_b

Line 29: FROM okl_subsidy_pools_b

25: CURSOR c_get_pool_dates_csr(cp_subsidy_pool_id okl_subsidy_pools_b.id%TYPE) IS
26: SELECT effective_from_date
27: ,effective_to_date
28: ,subsidy_pool_name
29: FROM okl_subsidy_pools_b
30: WHERE id = cp_subsidy_pool_id;
31: cv_get_pool_dates_csr c_get_pool_dates_csr%ROWTYPE;
32:
33: CURSOR c_get_pool_trx_details(cp_source_object_id okl_trx_subsidy_pools.source_object_id%TYPE

Line 216: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;

212: FROM okc_k_lines_v clev_asst
213: WHERE clev_asst.id = cp_asset_id;
214: lv_asset_number okc_k_lines_v.name%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;

Line 217: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;

213: WHERE clev_asst.id = cp_asset_id;
214: lv_asset_number okc_k_lines_v.name%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;

Line 329: ,p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE

325: ,x_msg_data OUT NOCOPY VARCHAR2
326: ,p_chr_id IN okc_k_headers_b.id%TYPE
327: ,p_asset_id IN okc_k_lines_b.id%TYPE
328: ,p_subsidy_id IN okl_subsidies_b.id%TYPE
329: ,p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
330: ,p_trx_amount IN okl_k_lines.amount%TYPE
331: ) IS
332:
333: -- cursor to fetch asset details

Line 589: ,cp_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE

585: -- cursor to fetch the pool transaction records with REDUCTION operation, created when the contract was booked
586: CURSOR c_sub_pool_trx_csr (cp_chr_id IN okc_k_headers_b.id%TYPE
587: ,cp_asset_number IN okc_k_lines_tl.name%TYPE
588: ,cp_subsidy_id IN okl_subsidies_b.id%TYPE
589: ,cp_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE
590: ) IS
591: SELECT source_type_code
592: ,source_object_id
593: ,subsidy_pool_id

Line 614: lx_sub_pool_id okl_subsidy_pools_b.id%TYPE;

610: AND source_type_code = G_TRX_SOURCE_TYPE_CODE
611: AND trx_type_code = G_REDUCTION_TYPE_CODE;
612: cv_sub_pool_trx_rec c_sub_pool_trx_csr%ROWTYPE;
613:
614: lx_sub_pool_id okl_subsidy_pools_b.id%TYPE;
615: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
616: lv_sixv_tbl sixv_tbl_type;
617: lx_sixv_tbl sixv_tbl_type;
618: idx PLS_INTEGER;

Line 615: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;

611: AND trx_type_code = G_REDUCTION_TYPE_CODE;
612: cv_sub_pool_trx_rec c_sub_pool_trx_csr%ROWTYPE;
613:
614: lx_sub_pool_id okl_subsidy_pools_b.id%TYPE;
615: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
616: lv_sixv_tbl sixv_tbl_type;
617: lx_sixv_tbl sixv_tbl_type;
618: idx PLS_INTEGER;
619: l_sub_pool_applicable VARCHAR2(10);

Line 967: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;

963: cv_get_orig_asst c_get_orig_asst%ROWTYPE;
964:
965: lv_orig_subsidy_applic VARCHAR2(10);
966: lv_rbk_subsidy_applic VARCHAR2(10);
967: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
968: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
969: -- sjalasut, added variables for subsidy pools enhancement. END
970:
971: CURSOR l_chk_rbk_csr IS

Line 968: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;

964:
965: lv_orig_subsidy_applic VARCHAR2(10);
966: lv_rbk_subsidy_applic VARCHAR2(10);
967: lx_subsidy_pool_id okl_subsidy_pools_b.id%TYPE;
968: lx_sub_pool_curr_code okl_subsidy_pools_b.currency_code%TYPE;
969: -- sjalasut, added variables for subsidy pools enhancement. END
970:
971: CURSOR l_chk_rbk_csr IS
972: SELECT ktrx.date_transaction_occurred