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 OKC_K_HEADERS_B

Line 176: PROCEDURE reduce_pool_balance(p_khr_id IN okc_k_headers_b.id%TYPE

172: END pool_trx_khr_rbk;
173: -- local procedure 1. END
174:
175: -- local procedure 2. START
176: PROCEDURE reduce_pool_balance(p_khr_id IN okc_k_headers_b.id%TYPE
177: ,p_source_trx_date IN okl_trx_subsidy_pools.source_trx_date%TYPE
178: ,x_return_status OUT NOCOPY VARCHAR2) IS
179:
180: -- cursor to fetch all subsidies attached to assets on the contract

Line 181: CURSOR c_subsidy_csr(cp_chr_id IN okc_k_headers_b.id%TYPE) IS

177: ,p_source_trx_date IN okl_trx_subsidy_pools.source_trx_date%TYPE
178: ,x_return_status OUT NOCOPY VARCHAR2) IS
179:
180: -- cursor to fetch all subsidies attached to assets on the contract
181: CURSOR c_subsidy_csr(cp_chr_id IN okc_k_headers_b.id%TYPE) IS
182: SELECT kle.subsidy_id
183: ,clet.name
184: ,clet.item_description
185: ,kle.amount

Line 326: ,p_chr_id IN okc_k_headers_b.id%TYPE

322: ,p_init_msg_list IN VARCHAR2
323: ,x_return_status OUT NOCOPY VARCHAR2
324: ,x_msg_count OUT NOCOPY NUMBER
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

Line 347: FROM okc_k_headers_b

343: CURSOR c_chk_orig_source_csr IS
344: SELECT orig_system_id1
345: ,orig_system_source_code
346: ,scs_code
347: FROM okc_k_headers_b
348: WHERE id = p_chr_id;
349: cv_chk_orig_source c_chk_orig_source_csr%ROWTYPE;
350:
351: -- cursor to fetch the vendor details of the asset

Line 550: ,p_chr_id IN okc_k_headers_b.id%TYPE

546: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
547: ,x_return_status OUT NOCOPY VARCHAR2
548: ,x_msg_count OUT NOCOPY NUMBER
549: ,x_msg_data OUT NOCOPY VARCHAR2
550: ,p_chr_id IN okc_k_headers_b.id%TYPE
551: ,p_reversal_date IN DATE
552: ,p_override_trx_reason IN okl_trx_subsidy_pools.trx_reason_code%TYPE
553: ) IS
554:

Line 556: CURSOR c_subsidy_csr(cp_chr_id IN okc_k_headers_b.id%TYPE) IS

552: ,p_override_trx_reason IN okl_trx_subsidy_pools.trx_reason_code%TYPE
553: ) IS
554:
555: -- cursor to fetch all subsidies attached in the contract
556: CURSOR c_subsidy_csr(cp_chr_id IN okc_k_headers_b.id%TYPE) IS
557: SELECT clet_sub.name subsidy_name,
558: clet_asst.name asset_number,
559: subb.id subsidy_id
560: FROM okl_subsidies_b subb,

Line 586: CURSOR c_sub_pool_trx_csr (cp_chr_id IN okc_k_headers_b.id%TYPE

582: AND lseb_asst.lty_code = 'FREE_FORM1'
583: AND cleb_asst.sts_code <> 'ABANDONED';
584:
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

Line 795: ,p_rbk_chr_id IN okc_k_headers_b.id%TYPE

791: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
792: ,x_return_status OUT NOCOPY VARCHAR2
793: ,x_msg_count OUT NOCOPY NUMBER
794: ,x_msg_data OUT NOCOPY VARCHAR2
795: ,p_rbk_chr_id IN okc_k_headers_b.id%TYPE
796: ,p_orig_chr_id IN okc_k_headers_b.id%TYPE
797: ) IS
798:
799: ---------------------------------------------------------------------------

Line 796: ,p_orig_chr_id IN okc_k_headers_b.id%TYPE

792: ,x_return_status OUT NOCOPY VARCHAR2
793: ,x_msg_count OUT NOCOPY NUMBER
794: ,x_msg_data OUT NOCOPY VARCHAR2
795: ,p_rbk_chr_id IN okc_k_headers_b.id%TYPE
796: ,p_orig_chr_id IN okc_k_headers_b.id%TYPE
797: ) IS
798:
799: ---------------------------------------------------------------------------
800: --get subsidy elements from rebook copy contract

Line 802: CURSOR l_subelm_rbk_csr(p_chr_id okc_k_headers_b.id%TYPE) IS

798:
799: ---------------------------------------------------------------------------
800: --get subsidy elements from rebook copy contract
801: ---------------------------------------------------------------------------
802: CURSOR l_subelm_rbk_csr(p_chr_id okc_k_headers_b.id%TYPE) IS
803: SELECT kle.SUBSIDY_ID
804: ,clet.NAME
805: ,clet.ITEM_DESCRIPTION
806: ,kle.AMOUNT

Line 838: p_chr_id okc_k_headers_b.id%TYPE) is

834: ---------------------------------------------------------------------------
835: --get subsidy elements from original contract
836: ---------------------------------------------------------------------------
837: cursor l_subelm_orig_csr(p_cle_id in number,
838: p_chr_id okc_k_headers_b.id%TYPE) is
839: SELECT kle.SUBSIDY_ID
840: ,clet.NAME
841: ,clet.ITEM_DESCRIPTION
842: ,kle.AMOUNT

Line 872: cursor l_del_sub_csr (p_orig_chr_id okc_k_headers_b.id%TYPE,

868:
869: ------------------------------------------------------------------------------
870: --cursor to find out subsidy line which has been deleted
871: ------------------------------------------------------------------------------
872: cursor l_del_sub_csr (p_orig_chr_id okc_k_headers_b.id%TYPE,
873: p_rbk_chr_id okc_k_headers_b.id%TYPE) is
874: SELECT cleb.id subsidy_id
875: ,cplb.id cpl_id
876: ,cplb.object1_id1 vendor_id

Line 873: p_rbk_chr_id okc_k_headers_b.id%TYPE) is

869: ------------------------------------------------------------------------------
870: --cursor to find out subsidy line which has been deleted
871: ------------------------------------------------------------------------------
872: cursor l_del_sub_csr (p_orig_chr_id okc_k_headers_b.id%TYPE,
873: p_rbk_chr_id okc_k_headers_b.id%TYPE) is
874: SELECT cleb.id subsidy_id
875: ,cplb.id cpl_id
876: ,cplb.object1_id1 vendor_id
877: ,kle.AMOUNT

Line 908: CURSOR l_new_sub_csr (p_chr_id okc_k_headers_b.id%TYPE) IS

904:
905: ------------------------------------------------------------------------------
906: --cursor to find out new subsidy lines which have been added
907: ------------------------------------------------------------------------------
908: CURSOR l_new_sub_csr (p_chr_id okc_k_headers_b.id%TYPE) IS
909: SELECT kle.subsidy_id subsidy_id
910: ,cleb.id subsidy_cle_id
911: ,clet.name name
912: ,kle.amount amount

Line 973: FROM okc_k_headers_b chr

969: -- sjalasut, added variables for subsidy pools enhancement. END
970:
971: CURSOR l_chk_rbk_csr IS
972: SELECT ktrx.date_transaction_occurred
973: FROM okc_k_headers_b chr
974: ,okl_trx_contracts ktrx
975: WHERE ktrx.khr_id_new = chr.id
976: AND ktrx.tsu_code = 'ENTERED'
977: AND ktrx.rbr_code IS NOT NULL

Line 1250: ,p_new1_chr_id IN okc_k_headers_b.id%TYPE

1246: ,p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE
1247: ,x_return_status OUT NOCOPY VARCHAR2
1248: ,x_msg_count OUT NOCOPY NUMBER
1249: ,x_msg_data OUT NOCOPY VARCHAR2
1250: ,p_new1_chr_id IN okc_k_headers_b.id%TYPE
1251: ,p_new2_chr_id IN okc_k_headers_b.id%TYPE
1252: ) IS
1253:
1254: CURSOR c_get_orig_khr_csr(cp_chr_id okc_k_headers_b.id%TYPE) IS

Line 1251: ,p_new2_chr_id IN okc_k_headers_b.id%TYPE

1247: ,x_return_status OUT NOCOPY VARCHAR2
1248: ,x_msg_count OUT NOCOPY NUMBER
1249: ,x_msg_data OUT NOCOPY VARCHAR2
1250: ,p_new1_chr_id IN okc_k_headers_b.id%TYPE
1251: ,p_new2_chr_id IN okc_k_headers_b.id%TYPE
1252: ) IS
1253:
1254: CURSOR c_get_orig_khr_csr(cp_chr_id okc_k_headers_b.id%TYPE) IS
1255: SELECT orig_system_id1

Line 1254: CURSOR c_get_orig_khr_csr(cp_chr_id okc_k_headers_b.id%TYPE) IS

1250: ,p_new1_chr_id IN okc_k_headers_b.id%TYPE
1251: ,p_new2_chr_id IN okc_k_headers_b.id%TYPE
1252: ) IS
1253:
1254: CURSOR c_get_orig_khr_csr(cp_chr_id okc_k_headers_b.id%TYPE) IS
1255: SELECT orig_system_id1
1256: FROM okc_k_headers_b
1257: WHERE id = cp_chr_id
1258: AND orig_system_source_code = 'OKL_SPLIT';

Line 1256: FROM okc_k_headers_b

1252: ) IS
1253:
1254: CURSOR c_get_orig_khr_csr(cp_chr_id okc_k_headers_b.id%TYPE) IS
1255: SELECT orig_system_id1
1256: FROM okc_k_headers_b
1257: WHERE id = cp_chr_id
1258: AND orig_system_source_code = 'OKL_SPLIT';
1259: lv_orig_khr_id okc_k_headers_b.id%TYPE;
1260:

Line 1259: lv_orig_khr_id okc_k_headers_b.id%TYPE;

1255: SELECT orig_system_id1
1256: FROM okc_k_headers_b
1257: WHERE id = cp_chr_id
1258: AND orig_system_source_code = 'OKL_SPLIT';
1259: lv_orig_khr_id okc_k_headers_b.id%TYPE;
1260:
1261: CURSOR c_split_info_csr(cp_chr_id okc_k_headers_b.id%TYPE) IS
1262: SELECT khr.id, khr.contract_number, khr.start_date, trx.date_transaction_occurred
1263: FROM okc_k_headers_b khr

Line 1261: CURSOR c_split_info_csr(cp_chr_id okc_k_headers_b.id%TYPE) IS

1257: WHERE id = cp_chr_id
1258: AND orig_system_source_code = 'OKL_SPLIT';
1259: lv_orig_khr_id okc_k_headers_b.id%TYPE;
1260:
1261: CURSOR c_split_info_csr(cp_chr_id okc_k_headers_b.id%TYPE) IS
1262: SELECT khr.id, khr.contract_number, khr.start_date, trx.date_transaction_occurred
1263: FROM okc_k_headers_b khr
1264: ,okl_trx_contracts trx
1265: WHERE trx.khr_id = khr.id

Line 1263: FROM okc_k_headers_b khr

1259: lv_orig_khr_id okc_k_headers_b.id%TYPE;
1260:
1261: CURSOR c_split_info_csr(cp_chr_id okc_k_headers_b.id%TYPE) IS
1262: SELECT khr.id, khr.contract_number, khr.start_date, trx.date_transaction_occurred
1263: FROM okc_k_headers_b khr
1264: ,okl_trx_contracts trx
1265: WHERE trx.khr_id = khr.id
1266: AND trx.tsu_code = 'PROCESSED'
1267: AND trx.tcn_type = 'SPLC'