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 OKL_POOL_CONTENTS

Line 90: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;

86: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
87:
88: lp_polv_rec polv_rec_type;
89: lx_polv_rec polv_rec_type;
90: l_poc_id OKL_POOL_CONTENTS.ID%TYPE;
91:
92: lp_pocv_rec pocv_rec_type;
93: lx_pocv_rec pocv_rec_type;
94:

Line 98: FROM okl_pool_contents poc

94:
95:
96: CURSOR c_poc IS
97: SELECT poc.id
98: FROM okl_pool_contents poc
99: WHERE poc.pol_id = p_pol_id
100: ;
101:
102: BEGIN

Line 855: CURSOR c_pol(p_id okl_pool_contents.id%TYPE) IS

851: -- x_pocv_rec pocv_rec_type;
852: lp_polv_rec polv_rec_type;
853: lx_polv_rec polv_rec_type;
854:
855: CURSOR c_pol(p_id okl_pool_contents.id%TYPE) IS
856: SELECT pol_id
857: FROM okl_pool_contents
858: WHERE id = p_id
859: ;

Line 857: FROM okl_pool_contents

853: lx_polv_rec polv_rec_type;
854:
855: CURSOR c_pol(p_id okl_pool_contents.id%TYPE) IS
856: SELECT pol_id
857: FROM okl_pool_contents
858: WHERE id = p_id
859: ;
860:
861: BEGIN

Line 1106: CURSOR c_pol(p_id okl_pool_contents.id%TYPE) IS

1102:
1103: lp_polv_rec polv_rec_type;
1104: lx_polv_rec polv_rec_type;
1105:
1106: CURSOR c_pol(p_id okl_pool_contents.id%TYPE) IS
1107: SELECT pol_id
1108: FROM okl_pool_contents
1109: WHERE id = p_id
1110: ;

Line 1108: FROM okl_pool_contents

1104: lx_polv_rec polv_rec_type;
1105:
1106: CURSOR c_pol(p_id okl_pool_contents.id%TYPE) IS
1107: SELECT pol_id
1108: FROM okl_pool_contents
1109: WHERE id = p_id
1110: ;
1111:
1112: BEGIN

Line 1650: p_poc_id IN okl_pool_contents.id%TYPE

1646: -- Version : 1.0
1647: -- End of comments
1648: ----------------------------------------------------------------------------------
1649: FUNCTION get_pool_stream_amout(
1650: p_poc_id IN okl_pool_contents.id%TYPE
1651: ) RETURN NUMBER
1652: IS
1653: l_amount NUMBER;
1654:

Line 1664: ,okl_pool_contents cnt

1660: --for streams
1661: FROM
1662: okl_streams strm
1663: ,okl_strm_elements ele
1664: ,okl_pool_contents cnt
1665: WHERE strm.id = ele.stm_id
1666: AND cnt.ID = p_poc_id
1667: -- mvasudev, 08/11/2003 , Restoring stm_id changes
1668: --AND strm.KHR_ID = cnt.KHR_ID

Line 1716: l_poc_id okl_pool_contents.id%TYPE;

1712: ) RETURN NUMBER
1713: IS
1714: l_amount NUMBER;
1715: l_tot_amount NUMBER := 0;
1716: l_poc_id okl_pool_contents.id%TYPE;
1717: i NUMBER := 0;
1718:
1719: CURSOR c_poc (p_pol_id NUMBER)
1720: IS

Line 1722: FROM okl_pool_contents poc

1718:
1719: CURSOR c_poc (p_pol_id NUMBER)
1720: IS
1721: SELECT poc.id
1722: FROM okl_pool_contents poc
1723: WHERE poc.pol_id = p_pol_id
1724: AND poc.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE)
1725: ;
1726:

Line 1782: l_poc_id okl_pool_contents.id%TYPE;

1778: ) RETURN NUMBER
1779: IS
1780: l_amount NUMBER;
1781: l_tot_amount NUMBER := 0;
1782: l_poc_id okl_pool_contents.id%TYPE;
1783: i NUMBER := 0;
1784:
1785: --Begin - Changes for bug#6658065 by VARANGAN on 30/11/2007
1786: CURSOR c_poc (p_pol_id NUMBER)

Line 1789: FROM okl_pool_contents poc

1785: --Begin - Changes for bug#6658065 by VARANGAN on 30/11/2007
1786: CURSOR c_poc (p_pol_id NUMBER)
1787: IS
1788: SELECT poc.id
1789: FROM okl_pool_contents poc
1790: WHERE poc.pol_id = p_pol_id
1791: AND poc.status_code IN (G_POC_STS_PENDING); -- Getting only pending POC - for Bug 6691554
1792: --Getting only pending POC stream amounts
1793: CURSOR c_strm_amount ( p_poc_id NUMBER)

Line 1798: ,okl_pool_contents cnt

1794: IS
1795: SELECT NVL(SUM(NVL(ele.AMOUNT,0)),0) STREAM_AMOUNT
1796: FROM okl_streams strm
1797: ,okl_strm_elements ele
1798: ,okl_pool_contents cnt
1799: WHERE strm.id = ele.stm_id
1800: AND cnt.ID = p_poc_id
1801: AND strm.ID = cnt.STM_ID
1802: AND strm.say_code = 'CURR'

Line 2162: l_khr_id okl_pool_contents.khr_id%TYPE;

2158: IS
2159: l_amount NUMBER := 0;
2160: l_tot_amount NUMBER := 0;
2161:
2162: l_khr_id okl_pool_contents.khr_id%TYPE;
2163: l_kle_id okl_pool_contents.kle_id%TYPE := NULL;
2164: l_start_date DATE;
2165: l_end_date DATE;
2166:

Line 2163: l_kle_id okl_pool_contents.kle_id%TYPE := NULL;

2159: l_amount NUMBER := 0;
2160: l_tot_amount NUMBER := 0;
2161:
2162: l_khr_id okl_pool_contents.khr_id%TYPE;
2163: l_kle_id okl_pool_contents.kle_id%TYPE := NULL;
2164: l_start_date DATE;
2165: l_end_date DATE;
2166:
2167: l_api_version NUMBER := 1;

Line 2189: FROM okl_pool_contents poc,

2185: , G_DEAL_TYPE_LEASEST, G_NET_INVESTMENT_DF
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

Line 2207: FROM okl_pool_contents poc

2203: , G_DEAL_TYPE_LEASEOP, G_NET_INVESTMENT_OP
2204: , G_NET_INVESTMENT_OTHERS)
2205: FROM okl_k_headers khr
2206: WHERE EXISTS (SELECT '1'
2207: FROM okl_pool_contents poc
2208: WHERE khr.id = poc.khr_id
2209: AND poc.pol_id = p_pol_id
2210: AND poc.status_code IN (G_POC_STS_NEW, G_POC_STS_ACTIVE))
2211: ;

Line 2655: AND NOT EXISTS -- okl_pool_contents

2651: AND pol.stream_element_due_date > SYSDATE
2652: -- multi-org
2653: -- non existing check
2654: -- start for 11.5.10 by cklee 08/06/03 stream_type_subclass ER
2655: AND NOT EXISTS -- okl_pool_contents
2656: (SELECT '1'
2657: FROM okl_pool_contents pol_cnts,
2658: okl_strm_type_b styb
2659: WHERE pol_cnts.pol_id = pol_id

Line 2657: FROM okl_pool_contents pol_cnts,

2653: -- non existing check
2654: -- start for 11.5.10 by cklee 08/06/03 stream_type_subclass ER
2655: AND NOT EXISTS -- okl_pool_contents
2656: (SELECT '1'
2657: FROM okl_pool_contents pol_cnts,
2658: okl_strm_type_b styb
2659: WHERE pol_cnts.pol_id = pol_id
2660: -- mvasudev, stm_id changes
2661: -- AND pol_cnts.sty_id = styb.id

Line 2783: AND NOT EXISTS -- okl_pool_contents

2779: AND pol.stream_element_due_date > SYSDATE
2780: -- multi-org
2781: -- non existing check
2782: -- start for 11.5.10 by cklee 08/06/03 stream_type_subclass ER
2783: AND NOT EXISTS -- okl_pool_contents
2784: (SELECT '1'
2785: FROM okl_pool_contents pol_cnts,
2786: okl_strm_type_b styb
2787: WHERE pol_cnts.pol_id = pol_id

Line 2785: FROM okl_pool_contents pol_cnts,

2781: -- non existing check
2782: -- start for 11.5.10 by cklee 08/06/03 stream_type_subclass ER
2783: AND NOT EXISTS -- okl_pool_contents
2784: (SELECT '1'
2785: FROM okl_pool_contents pol_cnts,
2786: okl_strm_type_b styb
2787: WHERE pol_cnts.pol_id = pol_id
2788: -- mvasudev, stm_id changes
2789: --AND pol_cnts.sty_id = styb.id

Line 3163: FROM okl_pool_contents pol_cnts,

3159: */
3160: CURSOR l_okl_dup_pocs_csr(p_stream_type_subclass IN VARCHAR2,p_stm_id IN NUMBER)
3161: IS
3162: SELECT '1'
3163: FROM okl_pool_contents pol_cnts,
3164: okl_strm_type_b styb,
3165: okl_strm_elements sel
3166: WHERE pol_cnts.pol_id = pol_id
3167: AND pol_cnts.stm_id = p_stm_id

Line 3182: FROM okl_pool_contents pol_cnts

3178: /*Added by kthiruva to check whether the contract streams were bought back */
3179: CURSOR l_buyback_yes_csr(p_stm_id IN NUMBER)
3180: IS
3181: SELECT '1'
3182: FROM okl_pool_contents pol_cnts
3183: WHERE pol_cnts.pol_id = pol_id
3184: AND pol_cnts.stm_id = p_stm_id
3185: AND pol_cnts.status_code = 'INACTIVE';
3186:

Line 3191: FROM okl_pool_contents pol_cnts

3187: /*Added by ankushar to fetch the maximum stream to_date to pick up the remaining streams after this date */
3188: CURSOR l_max_to_date_csr(p_stm_id IN NUMBER)
3189: IS
3190: SELECT MAX(nvl(pol_cnts.STREAMS_TO_DATE,pol_cnts.STREAMS_FROM_DATE)) eff_from_date
3191: FROM okl_pool_contents pol_cnts
3192: WHERE pol_cnts.pol_id = pol_id
3193: AND pol_cnts.stm_id = p_stm_id
3194: AND pol_cnts.status_code = 'ACTIVE';
3195:

Line 3881: FROM okl_pool_contents_uv pocv

3877: ,pocv.sty_subclass
3878: -- mvasudev, 09/28/2004, Bug#3909240
3879: ,pocv.stream_type_purpose
3880: ,hcp.credit_classification
3881: FROM okl_pool_contents_uv pocv
3882: ,hz_customer_profiles hcp
3883: -- pool_number
3884: WHERE pocv.pol_id = p_pol_id
3885: -- customer

Line 3922: FROM okl_pool_contents pc

3918: BETWEEN NVL(p_streams_from_date, NVL(pocv.streams_from_date, G_DEFAULT_DATE))
3919: AND NVL(p_streams_to_date, NVL(pocv.streams_to_date, G_FINAL_DATE))
3920: -- cklee 04/10/2003
3921: AND EXISTS (SELECT '1'
3922: FROM okl_pool_contents pc
3923: WHERE pc.id = pocv.POC_ID
3924: AND pc.status_code IN (p_allowed_sts))
3925: -- cklee 04/10/2003
3926: --Bug # 6691554 Changes for Cust Credit Classification Lov Start

Line 3947: ,okl_pool_contents cnt

3943: IS
3944: SELECT NVL(SUM(NVL(ele.AMOUNT,0)),0) STREAM_AMOUNT
3945: FROM okl_streams strm
3946: ,okl_strm_elements ele
3947: ,okl_pool_contents cnt
3948: WHERE strm.id = ele.stm_id
3949: AND cnt.ID = p_poc_id
3950: AND strm.ID = cnt.STM_ID
3951: AND strm.say_code = 'CURR'

Line 4118: FROM okl_pool_contents poc,

4114: CURSOR evg_rent_strms_csr (p_pol_id IN NUMBER)
4115: IS
4116: -- to remove all the rent strms if the contract turns to EVERGREEN--
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

Line 4135: FROM okl_pool_contents poc,

4131: CURSOR l_okl_invalid_khr_csr(p_pol_id IN NUMBER)
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

Line 4150: FROM okl_pool_contents poc,

4146: CURSOR l_okl_delinq_khr_csr(p_pol_id IN NUMBER)
4147: IS
4148: -- to remove all contents pointing to delinquent contracts
4149: SELECT poc.id
4150: FROM okl_pool_contents poc,
4151: iex_case_objects ico,
4152: iex_delinquencies_all del
4153: WHERE poc.pol_id = p_pol_id
4154: AND poc.khr_id = ico.object_id

Line 4165: FROM okl_pool_contents poc,

4161: CURSOR l_okl_rev_khr_csr(p_pol_id IN NUMBER)
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

Line 4203: FROM okl_pool_contents poc

4199: IS
4200: -- and to remove all contents pointing to lease contracts
4201: -- that have atleast one invalid asset
4202: SELECT poc.id
4203: FROM okl_pool_contents poc
4204: WHERE poc.khr_id
4205: IN
4206: (SELECT poc.khr_id
4207: FROM okl_pool_contents poc,

Line 4207: FROM okl_pool_contents poc,

4203: FROM okl_pool_contents poc
4204: WHERE poc.khr_id
4205: IN
4206: (SELECT poc.khr_id
4207: FROM okl_pool_contents poc,
4208: okc_k_lines_b cleb,
4209: okc_statuses_b stsb
4210: WHERE poc.pol_id = p_pol_id
4211: AND poc.kle_id = cleb.id

Line 4226: FROM okl_pool_contents poc,

4222: -- to remove all contents pointing to inactive streams
4223: --- or assets that do not have streams
4224: /*
4225: SELECT poc.id
4226: FROM okl_pool_contents poc,
4227: okl_streams stmb
4228: WHERE poc.pol_id = p_pol_id
4229: AND poc.kle_id = stmb.kle_id
4230: AND poc.sty_id = stmb.sty_id

Line 4245: FROM okl_pool_contents poc

4241: )
4242: );
4243: */
4244: SELECT poc.id
4245: FROM okl_pool_contents poc
4246: WHERE poc.pol_id = p_pol_id
4247: AND NOT EXISTS
4248: ( SELECT '1'
4249: FROM OKL_POOL_STREAMS_UV pols

Line 4265: FROM okl_pool_contents poc,

4261:
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

Line 4278: FROM okl_pool_contents poc

4274:
4275: CURSOR l_okl_update_dates_csr(p_pol_id IN NUMBER)
4276: IS
4277: SELECT poc.id, poc.stm_id
4278: FROM okl_pool_contents poc
4279: ,okl_streams stmb
4280: WHERE poc.pol_id = p_pol_id
4281: AND poc.stm_id = stmb.id
4282: AND stmb.say_code = 'CURR'

Line 4304: FROM okl_pool_contents poc,

4300: CURSOR evg_rent_strms_pend_csr (p_pol_id IN NUMBER)
4301: IS
4302: -- to remove all the rent strms if the contract turns to EVERGREEN--
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

Line 4321: FROM okl_pool_contents poc,

4317: CURSOR l_okl_invalid_khr_pend_csr(p_pol_id IN NUMBER)
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

Line 4336: FROM okl_pool_contents poc,

4332: CURSOR l_okl_delinq_khr_pend_csr(p_pol_id IN NUMBER)
4333: IS
4334: -- to remove all contents pointing to delinquent contracts
4335: SELECT poc.id
4336: FROM okl_pool_contents poc,
4337: iex_case_objects ico,
4338: iex_delinquencies_all del
4339: WHERE poc.pol_id = p_pol_id
4340: AND poc.khr_id = ico.object_id

Line 4351: FROM okl_pool_contents poc,

4347: CURSOR l_okl_rev_khr_pend_csr(p_pol_id IN NUMBER)
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

Line 4389: FROM okl_pool_contents poc

4385: IS
4386: -- and to remove all contents pointing to lease contracts
4387: -- that have atleast one invalid asset
4388: SELECT poc.id
4389: FROM okl_pool_contents poc
4390: WHERE poc.khr_id
4391: IN
4392: (SELECT poc.khr_id
4393: FROM okl_pool_contents poc,

Line 4393: FROM okl_pool_contents poc,

4389: FROM okl_pool_contents poc
4390: WHERE poc.khr_id
4391: IN
4392: (SELECT poc.khr_id
4393: FROM okl_pool_contents poc,
4394: okc_k_lines_b cleb,
4395: okc_statuses_b stsb
4396: WHERE poc.pol_id = p_pol_id
4397: AND poc.kle_id = cleb.id

Line 4411: FROM okl_pool_contents poc

4407: IS
4408: -- to remove all contents pointing to inactive streams
4409: --- or assets that do not have streams
4410: SELECT poc.id
4411: FROM okl_pool_contents poc
4412: WHERE poc.pol_id = p_pol_id
4413: AND NOT EXISTS
4414: ( SELECT '1'
4415: FROM OKL_POOL_STREAMS_UV pols

Line 4431: FROM okl_pool_contents poc,

4427:
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

Line 4444: FROM okl_pool_contents poc

4440:
4441: CURSOR l_okl_update_dates_pend_csr(p_pol_id IN NUMBER)
4442: IS
4443: SELECT poc.id, poc.stm_id
4444: FROM okl_pool_contents poc
4445: ,okl_streams stmb
4446: WHERE poc.pol_id = p_pol_id
4447: AND poc.stm_id = stmb.id
4448: AND stmb.say_code = 'CURR'

Line 5298: ,p_poc_id IN okl_pool_contents.id%TYPE

5294: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
5295: ,x_return_status OUT NOCOPY VARCHAR2
5296: ,x_msg_count OUT NOCOPY NUMBER
5297: ,x_msg_data OUT NOCOPY VARCHAR2
5298: ,p_poc_id IN okl_pool_contents.id%TYPE
5299: ,p_stm_id IN okl_streams.id%TYPE
5300: ,x_amount OUT NOCOPY NUMBER
5301: )
5302: IS

Line 5314: ,okl_pool_contents pocb

5310: IS
5311: SELECT NVL(SUM(NVL(selb.amount,0)),0) amount
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

Line 5348: ,okl_pool_contents pocb

5344: IS
5345: SELECT NVL(SUM(NVL(selb.amount,0)),0) amount
5346: FROM okl_streams stmb
5347: ,okl_strm_elements selb
5348: ,okl_pool_contents pocb
5349: WHERE pocb.stm_id = stmb.id
5350: AND stmb.id = selb.stm_id
5351: AND pocb.id = p_poc_id
5352: AND selb.stream_element_date