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 4115: okc_k_headers_b CHR

4111: SELECT poc.id
4112: FROM okl_pool_contents poc,
4113: okl_pools pol,
4114: okl_strm_type_b sty,
4115: okc_k_headers_b CHR
4116: WHERE pol.id = p_pol_id
4117: AND pol.id = poc.pol_id
4118: AND poc.sty_id = sty.id
4119: AND sty.STREAM_TYPE_SUBCLASS ='RENT'

Line 4130: okc_k_headers_b chrb,

4126: IS
4127: -- to remove all contents pointing to invalid contracts
4128: SELECT poc.id
4129: FROM okl_pool_contents poc,
4130: okc_k_headers_b chrb,
4131: okl_k_headers khrb
4132: WHERE poc.pol_id = p_pol_id
4133: AND poc.khr_id = chrb.id
4134: AND poc.khr_id = khrb.id

Line 4160: okc_k_headers_b chrb

4156: IS
4157: -- and to remove all contents pointing to contracts under modification
4158: SELECT poc.id
4159: FROM okl_pool_contents poc,
4160: okc_k_headers_b chrb
4161: WHERE poc.pol_id = p_pol_id
4162: AND poc.khr_id = chrb.id
4163: -- cklee 04/10/2003 never reconcile historical data
4164: AND poc.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)

Line 4260: okc_k_headers_b chrb

4256: CURSOR l_okl_update_khr_dates_csr(p_pol_id IN NUMBER)
4257: IS
4258: SELECT poc.id, chrb.end_date
4259: FROM okl_pool_contents poc,
4260: okc_k_headers_b chrb
4261: WHERE poc.pol_id = p_pol_id
4262: AND poc.khr_id = chrb.id
4263: -- cklee 04/10/2003 never reconcile historical data
4264: AND poc.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)

Line 4300: okc_k_headers_b CHR

4296: SELECT poc.id
4297: FROM okl_pool_contents poc,
4298: okl_pools pol,
4299: okl_strm_type_b sty,
4300: okc_k_headers_b CHR
4301: WHERE pol.id = p_pol_id
4302: AND pol.id = poc.pol_id
4303: AND poc.sty_id = sty.id
4304: AND sty.STREAM_TYPE_SUBCLASS ='RENT'

Line 4315: okc_k_headers_b chrb,

4311: IS
4312: -- to remove all contents pointing to invalid contracts
4313: SELECT poc.id
4314: FROM okl_pool_contents poc,
4315: okc_k_headers_b chrb,
4316: okl_k_headers khrb
4317: WHERE poc.pol_id = p_pol_id
4318: AND poc.khr_id = chrb.id
4319: AND poc.khr_id = khrb.id

Line 4345: okc_k_headers_b chrb

4341: IS
4342: -- and to remove all contents pointing to contracts under modification
4343: SELECT poc.id
4344: FROM okl_pool_contents poc,
4345: okc_k_headers_b chrb
4346: WHERE poc.pol_id = p_pol_id
4347: AND poc.khr_id = chrb.id
4348: -- cklee 04/10/2003 never reconcile historical data
4349: AND poc.status_code IN (G_POC_STS_PENDING)

Line 4425: okc_k_headers_b chrb

4421: CURSOR l_okl_update_khr_dts_pend_csr(p_pol_id IN NUMBER)
4422: IS
4423: SELECT poc.id, chrb.end_date
4424: FROM okl_pool_contents poc,
4425: okc_k_headers_b chrb
4426: WHERE poc.pol_id = p_pol_id
4427: AND poc.khr_id = chrb.id
4428: -- cklee 04/10/2003 never reconcile historical data
4429: AND poc.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)

Line 5307: ,okc_k_headers_b chrb

5303: FROM okl_streams stmb
5304: ,okl_strm_elements selb
5305: ,okl_pool_contents pocb
5306: ,okl_strm_type_v styv
5307: ,okc_k_headers_b chrb
5308: WHERE pocb.stm_id = stmb.id
5309: AND stmb.id = selb.stm_id
5310: AND pocb.id = p_poc_id
5311: -- Bug#3520846,mvasudev, 3/22/2004