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_POOL_PVT dependencies on OKC_K_HEADERS_B

Line 2058: ,p_khr_id IN okc_k_headers_b.id%TYPE

2054: ,x_return_status OUT NOCOPY VARCHAR2
2055: ,x_msg_count OUT NOCOPY NUMBER
2056: ,x_msg_data OUT NOCOPY VARCHAR2
2057: ,x_value OUT NOCOPY NUMBER
2058: ,p_khr_id IN okc_k_headers_b.id%TYPE
2059: )
2060: IS
2061: l_api_name CONSTANT VARCHAR2(30) := 'get_tot_receivable_amt_pvt2';
2062: l_api_version CONSTANT NUMBER := 1.0;

Line 2067: CURSOR c_khr(p_khr_id okc_k_headers_b.id%TYPE) IS

2063: i NUMBER;
2064: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2065: l_pol_id okl_pools.id%TYPE;
2066:
2067: CURSOR c_khr(p_khr_id okc_k_headers_b.id%TYPE) IS
2068: SELECT ph.id
2069: FROM okl_pools ph
2070: WHERE ph.khr_id = p_khr_id
2071: ;

Line 2175: l_contract_number okc_k_headers_b.contract_number%TYPE;

2171: x_msg_data VARCHAR2(1999);
2172: x_value NUMBER := 0;
2173: l_ctxt_val_tbl Okl_Execute_Formula_Pvt.ctxt_val_tbl_type;
2174: l_deal_type okl_k_headers.deal_type%TYPE;
2175: l_contract_number okc_k_headers_b.contract_number%TYPE;
2176:
2177: l_formula_name VARCHAR2(100);
2178: /*
2179: CURSOR c_poc (p_pol_id NUMBER)

Line 2190: okc_k_headers_b CHR,

2186: , G_DEAL_TYPE_LOAN, G_NET_INVESTMENT_LOAN
2187: , G_DEAL_TYPE_LEASEOP, G_NET_INVESTMENT_OP
2188: , G_NET_INVESTMENT_OTHERS)
2189: FROM okl_pool_contents poc,
2190: okc_k_headers_b CHR,
2191: okl_k_headers khr
2192: WHERE poc.khr_id = CHR.id
2193: AND khr.id = CHR.id
2194: AND poc.pol_id = p_pol_id

Line 2218: FROM okc_k_headers_b CHR,

2214: CURSOR c_chr (p_chr_id NUMBER)
2215: IS
2216: SELECT CHR.contract_number,
2217: khr.deal_type
2218: FROM okc_k_headers_b CHR,
2219: okl_k_headers khr
2220: WHERE CHR.id = khr.id
2221: AND CHR.id = p_chr_id
2222: ;

Line 2432: ,p_khr_id IN okc_k_headers_b.id%TYPE

2428: ,x_return_status OUT NOCOPY VARCHAR2
2429: ,x_msg_count OUT NOCOPY NUMBER
2430: ,x_msg_data OUT NOCOPY VARCHAR2
2431: ,x_value OUT NOCOPY NUMBER
2432: ,p_khr_id IN okc_k_headers_b.id%TYPE
2433: )
2434: IS
2435: l_api_name CONSTANT VARCHAR2(30) := 'recal_tot_principal_amt_pvt';
2436: l_api_version CONSTANT NUMBER := 1.0;

Line 2444: CURSOR c_khr(p_khr_id okc_k_headers_b.id%TYPE) IS

2440:
2441: lp_polv_rec polv_rec_type;
2442: lx_polv_rec polv_rec_type;
2443:
2444: CURSOR c_khr(p_khr_id okc_k_headers_b.id%TYPE) IS
2445: SELECT ph.id
2446: FROM okl_pools ph
2447: WHERE ph.khr_id = p_khr_id
2448: ;

Line 4121: okc_k_headers_b CHR

4117: SELECT poc.id
4118: FROM okl_pool_contents poc,
4119: okl_pools pol,
4120: okl_strm_type_b sty,
4121: okc_k_headers_b CHR
4122: WHERE pol.id = p_pol_id
4123: AND pol.id = poc.pol_id
4124: AND poc.sty_id = sty.id
4125: AND sty.STREAM_TYPE_SUBCLASS ='RENT'

Line 4136: okc_k_headers_b chrb,

4132: IS
4133: -- to remove all contents pointing to invalid contracts
4134: SELECT poc.id
4135: FROM okl_pool_contents poc,
4136: okc_k_headers_b chrb,
4137: okl_k_headers khrb
4138: WHERE poc.pol_id = p_pol_id
4139: AND poc.khr_id = chrb.id
4140: AND poc.khr_id = khrb.id

Line 4166: okc_k_headers_b chrb

4162: IS
4163: -- and to remove all contents pointing to contracts under modification
4164: SELECT poc.id
4165: FROM okl_pool_contents poc,
4166: okc_k_headers_b chrb
4167: WHERE poc.pol_id = p_pol_id
4168: AND poc.khr_id = chrb.id
4169: -- cklee 04/10/2003 never reconcile historical data
4170: AND poc.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)

Line 4266: okc_k_headers_b chrb

4262: CURSOR l_okl_update_khr_dates_csr(p_pol_id IN NUMBER)
4263: IS
4264: SELECT poc.id, chrb.end_date
4265: FROM okl_pool_contents poc,
4266: okc_k_headers_b chrb
4267: WHERE poc.pol_id = p_pol_id
4268: AND poc.khr_id = chrb.id
4269: -- cklee 04/10/2003 never reconcile historical data
4270: AND poc.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)

Line 4307: okc_k_headers_b CHR

4303: SELECT poc.id
4304: FROM okl_pool_contents poc,
4305: okl_pools pol,
4306: okl_strm_type_b sty,
4307: okc_k_headers_b CHR
4308: WHERE pol.id = p_pol_id
4309: AND pol.id = poc.pol_id
4310: AND poc.sty_id = sty.id
4311: AND sty.STREAM_TYPE_SUBCLASS ='RENT'

Line 4322: okc_k_headers_b chrb,

4318: IS
4319: -- to remove all contents pointing to invalid contracts
4320: SELECT poc.id
4321: FROM okl_pool_contents poc,
4322: okc_k_headers_b chrb,
4323: okl_k_headers khrb
4324: WHERE poc.pol_id = p_pol_id
4325: AND poc.khr_id = chrb.id
4326: AND poc.khr_id = khrb.id

Line 4352: okc_k_headers_b chrb

4348: IS
4349: -- and to remove all contents pointing to contracts under modification
4350: SELECT poc.id
4351: FROM okl_pool_contents poc,
4352: okc_k_headers_b chrb
4353: WHERE poc.pol_id = p_pol_id
4354: AND poc.khr_id = chrb.id
4355: -- cklee 04/10/2003 never reconcile historical data
4356: AND poc.status_code IN (G_POC_STS_PENDING)

Line 4432: okc_k_headers_b chrb

4428: CURSOR l_okl_update_khr_dts_pend_csr(p_pol_id IN NUMBER)
4429: IS
4430: SELECT poc.id, chrb.end_date
4431: FROM okl_pool_contents poc,
4432: okc_k_headers_b chrb
4433: WHERE poc.pol_id = p_pol_id
4434: AND poc.khr_id = chrb.id
4435: -- cklee 04/10/2003 never reconcile historical data
4436: AND poc.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)

Line 5316: ,okc_k_headers_b chrb

5312: FROM okl_streams stmb
5313: ,okl_strm_elements selb
5314: ,okl_pool_contents pocb
5315: ,okl_strm_type_v styv
5316: ,okc_k_headers_b chrb
5317: WHERE pocb.stm_id = stmb.id
5318: AND stmb.id = selb.stm_id
5319: AND pocb.id = p_poc_id
5320: -- Bug#3520846,mvasudev, 3/22/2004