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 3157: FROM okl_pool_contents pol_cnts,

3153: */
3154: CURSOR l_okl_dup_pocs_csr(p_stream_type_subclass IN VARCHAR2,p_stm_id IN NUMBER)
3155: IS
3156: SELECT '1'
3157: FROM okl_pool_contents pol_cnts,
3158: okl_strm_type_b styb,
3159: okl_strm_elements sel
3160: WHERE pol_cnts.pol_id = pol_id
3161: AND pol_cnts.stm_id = p_stm_id

Line 3176: FROM okl_pool_contents pol_cnts

3172: /*Added by kthiruva to check whether the contract streams were bought back */
3173: CURSOR l_buyback_yes_csr(p_stm_id IN NUMBER)
3174: IS
3175: SELECT '1'
3176: FROM okl_pool_contents pol_cnts
3177: WHERE pol_cnts.pol_id = pol_id
3178: AND pol_cnts.stm_id = p_stm_id
3179: AND pol_cnts.status_code = 'INACTIVE';
3180:

Line 3185: FROM okl_pool_contents pol_cnts

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

Line 3875: FROM okl_pool_contents_uv pocv

3871: ,pocv.sty_subclass
3872: -- mvasudev, 09/28/2004, Bug#3909240
3873: ,pocv.stream_type_purpose
3874: ,hcp.credit_classification
3875: FROM okl_pool_contents_uv pocv
3876: ,hz_customer_profiles hcp
3877: -- pool_number
3878: WHERE pocv.pol_id = p_pol_id
3879: -- customer

Line 3916: FROM okl_pool_contents pc

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

Line 3941: ,okl_pool_contents cnt

3937: IS
3938: SELECT NVL(SUM(NVL(ele.AMOUNT,0)),0) STREAM_AMOUNT
3939: FROM okl_streams strm
3940: ,okl_strm_elements ele
3941: ,okl_pool_contents cnt
3942: WHERE strm.id = ele.stm_id
3943: AND cnt.ID = p_poc_id
3944: AND strm.ID = cnt.STM_ID
3945: AND strm.say_code = 'CURR'

Line 4112: FROM okl_pool_contents poc,

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

Line 4129: FROM okl_pool_contents poc,

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

Line 4144: FROM okl_pool_contents poc,

4140: CURSOR l_okl_delinq_khr_csr(p_pol_id IN NUMBER)
4141: IS
4142: -- to remove all contents pointing to delinquent contracts
4143: SELECT poc.id
4144: FROM okl_pool_contents poc,
4145: iex_case_objects ico,
4146: iex_delinquencies_all del
4147: WHERE poc.pol_id = p_pol_id
4148: AND poc.khr_id = ico.object_id

Line 4159: FROM okl_pool_contents poc,

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

Line 4197: FROM okl_pool_contents poc

4193: IS
4194: -- and to remove all contents pointing to lease contracts
4195: -- that have atleast one invalid asset
4196: SELECT poc.id
4197: FROM okl_pool_contents poc
4198: WHERE poc.khr_id
4199: IN
4200: (SELECT poc.khr_id
4201: FROM okl_pool_contents poc,

Line 4201: FROM okl_pool_contents poc,

4197: FROM okl_pool_contents poc
4198: WHERE poc.khr_id
4199: IN
4200: (SELECT poc.khr_id
4201: FROM okl_pool_contents poc,
4202: okc_k_lines_b cleb,
4203: okc_statuses_b stsb
4204: WHERE poc.pol_id = p_pol_id
4205: AND poc.kle_id = cleb.id

Line 4220: FROM okl_pool_contents poc,

4216: -- to remove all contents pointing to inactive streams
4217: --- or assets that do not have streams
4218: /*
4219: SELECT poc.id
4220: FROM okl_pool_contents poc,
4221: okl_streams stmb
4222: WHERE poc.pol_id = p_pol_id
4223: AND poc.kle_id = stmb.kle_id
4224: AND poc.sty_id = stmb.sty_id

Line 4239: FROM okl_pool_contents poc

4235: )
4236: );
4237: */
4238: SELECT poc.id
4239: FROM okl_pool_contents poc
4240: WHERE poc.pol_id = p_pol_id
4241: AND NOT EXISTS
4242: ( SELECT '1'
4243: FROM OKL_POOL_STREAMS_UV pols

Line 4259: FROM okl_pool_contents poc,

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

Line 4272: FROM okl_pool_contents poc

4268:
4269: CURSOR l_okl_update_dates_csr(p_pol_id IN NUMBER)
4270: IS
4271: SELECT poc.id, poc.stm_id
4272: FROM okl_pool_contents poc
4273: ,okl_streams stmb
4274: WHERE poc.pol_id = p_pol_id
4275: AND poc.stm_id = stmb.id
4276: AND stmb.say_code = 'CURR'

Line 4297: FROM okl_pool_contents poc,

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

Line 4314: FROM okl_pool_contents poc,

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

Line 4329: FROM okl_pool_contents poc,

4325: CURSOR l_okl_delinq_khr_pend_csr(p_pol_id IN NUMBER)
4326: IS
4327: -- to remove all contents pointing to delinquent contracts
4328: SELECT poc.id
4329: FROM okl_pool_contents poc,
4330: iex_case_objects ico,
4331: iex_delinquencies_all del
4332: WHERE poc.pol_id = p_pol_id
4333: AND poc.khr_id = ico.object_id

Line 4344: FROM okl_pool_contents poc,

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

Line 4382: FROM okl_pool_contents poc

4378: IS
4379: -- and to remove all contents pointing to lease contracts
4380: -- that have atleast one invalid asset
4381: SELECT poc.id
4382: FROM okl_pool_contents poc
4383: WHERE poc.khr_id
4384: IN
4385: (SELECT poc.khr_id
4386: FROM okl_pool_contents poc,

Line 4386: FROM okl_pool_contents poc,

4382: FROM okl_pool_contents poc
4383: WHERE poc.khr_id
4384: IN
4385: (SELECT poc.khr_id
4386: FROM okl_pool_contents poc,
4387: okc_k_lines_b cleb,
4388: okc_statuses_b stsb
4389: WHERE poc.pol_id = p_pol_id
4390: AND poc.kle_id = cleb.id

Line 4404: FROM okl_pool_contents poc

4400: IS
4401: -- to remove all contents pointing to inactive streams
4402: --- or assets that do not have streams
4403: SELECT poc.id
4404: FROM okl_pool_contents poc
4405: WHERE poc.pol_id = p_pol_id
4406: AND NOT EXISTS
4407: ( SELECT '1'
4408: FROM OKL_POOL_STREAMS_UV pols

Line 4424: FROM okl_pool_contents poc,

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

Line 4437: FROM okl_pool_contents poc

4433:
4434: CURSOR l_okl_update_dates_pend_csr(p_pol_id IN NUMBER)
4435: IS
4436: SELECT poc.id, poc.stm_id
4437: FROM okl_pool_contents poc
4438: ,okl_streams stmb
4439: WHERE poc.pol_id = p_pol_id
4440: AND poc.stm_id = stmb.id
4441: AND stmb.say_code = 'CURR'

Line 5289: ,p_poc_id IN okl_pool_contents.id%TYPE

5285: ,p_init_msg_list IN VARCHAR2 DEFAULT Okl_Api.G_FALSE
5286: ,x_return_status OUT NOCOPY VARCHAR2
5287: ,x_msg_count OUT NOCOPY NUMBER
5288: ,x_msg_data OUT NOCOPY VARCHAR2
5289: ,p_poc_id IN okl_pool_contents.id%TYPE
5290: ,p_stm_id IN okl_streams.id%TYPE
5291: ,x_amount OUT NOCOPY NUMBER
5292: )
5293: IS

Line 5305: ,okl_pool_contents pocb

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

Line 5339: ,okl_pool_contents pocb

5335: IS
5336: SELECT NVL(SUM(NVL(selb.amount,0)),0) amount
5337: FROM okl_streams stmb
5338: ,okl_strm_elements selb
5339: ,okl_pool_contents pocb
5340: WHERE pocb.stm_id = stmb.id
5341: AND stmb.id = selb.stm_id
5342: AND pocb.id = p_poc_id
5343: AND selb.stream_element_date