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_PVT

Line 1: PACKAGE BODY Okl_Pool_Pvt AS

1: PACKAGE BODY Okl_Pool_Pvt AS
2: /* $Header: OKLRSZPB.pls 120.30 2008/02/14 05:12:07 ankushar noship $ */
3: ----------------------------------------------------------------------------
4: -- Global Message Constants
5: ----------------------------------------------------------------------------

Line 129: --DBMS_OUTPUT.PUT_LINE('OKL_POOL_PVT.update_pool start');

125: ----------------------------------------------------------------------------
126: --1. update pool status
127: ----------------------------------------------------------------------------
128: --DBMS_OUTPUT.PUT_LINE('1. update pool header status');
129: --DBMS_OUTPUT.PUT_LINE('OKL_POOL_PVT.update_pool start');
130:
131: lp_polv_rec.ID := p_pol_id;
132: lp_polv_rec.status_code := p_pool_status;
133:

Line 134: Okl_Pool_Pvt.update_pool(

130:
131: lp_polv_rec.ID := p_pol_id;
132: lp_polv_rec.status_code := p_pool_status;
133:
134: Okl_Pool_Pvt.update_pool(
135: p_api_version => p_api_version,
136: p_init_msg_list => p_init_msg_list,
137: x_return_status => x_return_status,
138: x_msg_count => x_msg_count,

Line 153: --DBMS_OUTPUT.PUT_LINE('OKL_POOL_PVT.update_pool_contents start');

149: ----------------------------------------------------------------------------
150: --2. update pool contents status
151: ----------------------------------------------------------------------------
152: --DBMS_OUTPUT.PUT_LINE('2. update pool contents status');
153: --DBMS_OUTPUT.PUT_LINE('OKL_POOL_PVT.update_pool_contents start');
154:
155: OPEN c_poc;
156: LOOP
157: FETCH c_poc INTO

Line 164: Okl_Pool_Pvt.update_pool_contents(

160:
161: lp_pocv_rec.id := l_poc_id;
162: lp_pocv_rec.status_code := p_pool_status;
163:
164: Okl_Pool_Pvt.update_pool_contents(
165: p_api_version => p_api_version,
166: p_init_msg_list => p_init_msg_list,
167: x_return_status => x_return_status,
168: x_msg_count => x_msg_count,

Line 182: --DBMS_OUTPUT.PUT_LINE('OKL_POOL_PVT.update_pool_status end');

178:
179: END LOOP;
180: CLOSE c_poc;
181:
182: --DBMS_OUTPUT.PUT_LINE('OKL_POOL_PVT.update_pool_status end');
183:
184: /*** End API body ******************************************************/
185:
186: -- Get message count and if count is 1, get message info

Line 660: Okl_Pool_Pvt.update_pool(

656: END IF;
657:
658: lp_polv_rec.ID := p_pocv_rec.POL_ID;
659:
660: Okl_Pool_Pvt.update_pool(
661: p_api_version => p_api_version,
662: p_init_msg_list => p_init_msg_list,
663: x_return_status => x_return_status,
664: x_msg_count => x_msg_count,

Line 769: Okl_Pool_Pvt.create_pool_contents(

765: IF (l_pocv_tbl.COUNT > 0) THEN
766: i := l_pocv_tbl.FIRST;
767: LOOP
768:
769: Okl_Pool_Pvt.create_pool_contents(
770: p_api_version => p_api_version,
771: p_init_msg_list => p_init_msg_list,
772: x_return_status => x_return_status,
773: x_msg_count => x_msg_count,

Line 907: Okl_Pool_Pvt.update_pool(

903: END IF;
904:
905: -- lp_polv_rec.ID := p_pocv_rec.POL_ID;
906:
907: Okl_Pool_Pvt.update_pool(
908: p_api_version => p_api_version,
909: p_init_msg_list => p_init_msg_list,
910: x_return_status => x_return_status,
911: x_msg_count => x_msg_count,

Line 1020: Okl_Pool_Pvt.update_pool_contents(

1016: IF (l_pocv_tbl.COUNT > 0) THEN
1017: i := l_pocv_tbl.FIRST;
1018: LOOP
1019:
1020: Okl_Pool_Pvt.update_pool_contents(
1021: p_api_version => p_api_version,
1022: p_init_msg_list => p_init_msg_list,
1023: x_return_status => x_return_status,
1024: x_msg_count => x_msg_count,

Line 1156: Okl_Pool_Pvt.update_pool(

1152: END IF;
1153:
1154: -- lp_polv_rec.ID := p_pocv_rec.POL_ID;
1155:
1156: Okl_Pool_Pvt.update_pool(
1157: p_api_version => p_api_version,
1158: p_init_msg_list => p_init_msg_list,
1159: x_return_status => x_return_status,
1160: x_msg_count => x_msg_count,

Line 1266: Okl_Pool_Pvt.delete_pool_contents(

1262: IF (l_pocv_tbl.COUNT > 0) THEN
1263: i := l_pocv_tbl.FIRST;
1264: LOOP
1265:
1266: Okl_Pool_Pvt.delete_pool_contents(
1267: p_api_version => p_api_version,
1268: p_init_msg_list => p_init_msg_list,
1269: x_return_status => x_return_status,
1270: x_msg_count => x_msg_count,

Line 2361: Okl_Pool_Pvt.update_pool(

2357: lp_polv_rec.ID := p_pol_id;
2358: lp_polv_rec.TOTAL_PRINCIPAL_AMOUNT := x_value;
2359: lp_polv_rec.DATE_TOTAL_PRINCIPAL_CALC := SYSDATE;
2360:
2361: Okl_Pool_Pvt.update_pool(
2362: p_api_version => p_api_version,
2363: p_init_msg_list => p_init_msg_list,
2364: x_return_status => x_return_status,
2365: x_msg_count => x_msg_count,

Line 2490: Okl_Pool_Pvt.update_pool(

2486: lp_polv_rec.ID := l_pol_id;
2487: lp_polv_rec.TOTAL_PRINCIPAL_AMOUNT := x_value;
2488: lp_polv_rec.DATE_TOTAL_PRINCIPAL_CALC := SYSDATE;
2489:
2490: Okl_Pool_Pvt.update_pool(
2491: p_api_version => p_api_version,
2492: p_init_msg_list => p_init_msg_list,
2493: x_return_status => x_return_status,
2494: x_msg_count => x_msg_count,

Line 2909: Okl_Pool_Pvt.create_pool_contents(

2905: ,l_pocv_rec.STM_ID;
2906:
2907: EXIT WHEN c_pool_payfreq%NOTFOUND;
2908:
2909: Okl_Pool_Pvt.create_pool_contents(
2910: p_api_version => p_api_version,
2911: p_init_msg_list => p_init_msg_list,
2912: x_return_status => x_return_status,
2913: x_msg_count => x_msg_count,

Line 2949: Okl_Pool_Pvt.create_pool_contents(

2945:
2946:
2947: EXIT WHEN c_pool%NOTFOUND;
2948:
2949: Okl_Pool_Pvt.create_pool_contents(
2950: p_api_version => p_api_version,
2951: p_init_msg_list => p_init_msg_list,
2952: x_return_status => x_return_status,
2953: x_msg_count => x_msg_count,

Line 3514: Okl_Pool_Pvt.create_pool_contents(

3510: END IF;
3511: l_pocv_rec.streams_to_date := l_okl_poc_rec.streams_to_date;
3512: l_pocv_rec.stm_id := l_okl_poc_rec.stm_id;
3513:
3514: Okl_Pool_Pvt.create_pool_contents(
3515: p_api_version => p_api_version,
3516: p_init_msg_list => p_init_msg_list,
3517: x_return_status => x_return_status,
3518: x_msg_count => x_msg_count,

Line 3612: Okl_Pool_Pvt.create_pool_transaction(p_api_version => p_api_version

3608: --sosharma 03/12/2007 added to enable status on pool transaction
3609: lp_poxv_rec.TRANSACTION_STATUS := G_POOL_TRX_STATUS_NEW;
3610:
3611: -- create ADD transaction for Adjustment
3612: Okl_Pool_Pvt.create_pool_transaction(p_api_version => p_api_version
3613: ,p_init_msg_list => p_init_msg_list
3614: ,x_return_status => l_return_status
3615: ,x_msg_count => x_msg_count
3616: ,x_msg_data => x_msg_data

Line 3633: Okl_Pool_Pvt.create_pool_contents(

3629: END LOOP;
3630:
3631: END IF;
3632: --- create pool contents for Adjustment ADD transaction
3633: Okl_Pool_Pvt.create_pool_contents(
3634: p_api_version => p_api_version,
3635: p_init_msg_list => p_init_msg_list,
3636: x_return_status => x_return_status,
3637: x_msg_count => x_msg_count,

Line 3660: Okl_Pool_Pvt.update_pool_transaction(p_api_version => p_api_version

3656: lp_poxv_rec.POL_ID := p_pol_id;
3657: lp_poxv_rec.ID := l_trx_id;
3658:
3659: -- create ADD transaction for Adjustment
3660: Okl_Pool_Pvt.update_pool_transaction(p_api_version => p_api_version
3661: ,p_init_msg_list => p_init_msg_list
3662: ,x_return_status => l_return_status
3663: ,x_msg_count => x_msg_count
3664: ,x_msg_data => x_msg_data

Line 3996: l_pool_amount := Okl_Pool_Pvt.get_pool_stream_amout(l_okl_pool_cleanup_rec.poc_id);

3992: OPEN c_strm_amount (l_okl_pool_cleanup_rec.poc_id) ;
3993: FETCH c_strm_amount INTO l_pool_amount;
3994: CLOSE c_strm_amount;
3995: ELSE -- follow the existing process
3996: l_pool_amount := Okl_Pool_Pvt.get_pool_stream_amout(l_okl_pool_cleanup_rec.poc_id);
3997: END IF;
3998:
3999: x_poc_uv_tbl(l_row_count).poc_id := l_okl_pool_cleanup_rec.poc_id;
4000: x_poc_uv_tbl(l_row_count).contract_number := l_okl_pool_cleanup_rec.contract_number;

Line 4015: IF p_action_code = Okl_Pool_Pvt.G_ACTION_REMOVE THEN

4011:
4012: END LOOP;
4013: -- End - Changes for Bug#6658065
4014:
4015: IF p_action_code = Okl_Pool_Pvt.G_ACTION_REMOVE THEN
4016: Okl_Pool_Pvt.delete_pool_contents(p_api_version => p_api_version
4017: ,p_init_msg_list => p_init_msg_list
4018: ,x_return_status => l_return_status
4019: ,x_msg_count => x_msg_count

Line 4016: Okl_Pool_Pvt.delete_pool_contents(p_api_version => p_api_version

4012: END LOOP;
4013: -- End - Changes for Bug#6658065
4014:
4015: IF p_action_code = Okl_Pool_Pvt.G_ACTION_REMOVE THEN
4016: Okl_Pool_Pvt.delete_pool_contents(p_api_version => p_api_version
4017: ,p_init_msg_list => p_init_msg_list
4018: ,x_return_status => l_return_status
4019: ,x_msg_count => x_msg_count
4020: ,x_msg_data => x_msg_data

Line 4041: Okl_Pool_Pvt.update_pool_transaction(p_api_version => p_api_version

4037: lp_poxv_rec.POL_ID := p_pol_id;
4038: lp_poxv_rec.ID := l_trx_id;
4039:
4040: -- create ADD transaction for Adjustment
4041: Okl_Pool_Pvt.update_pool_transaction(p_api_version => p_api_version
4042: ,p_init_msg_list => p_init_msg_list
4043: ,x_return_status => l_return_status
4044: ,x_msg_count => x_msg_count
4045: ,x_msg_data => x_msg_data

Line 4515: Okl_Pool_Pvt.delete_pool_contents(

4511:
4512: IF lp_pocv_tbl.COUNT > 0 THEN
4513:
4514: -- Remove rent streams for EVERGREEN contract from pool--
4515: Okl_Pool_Pvt.delete_pool_contents(
4516: p_api_version => p_api_version,
4517: p_init_msg_list => p_init_msg_list,
4518: x_return_status => l_return_status,
4519: x_msg_count => x_msg_count,

Line 4545: Okl_Pool_Pvt.delete_pool_contents(

4541:
4542: IF lp_pocv_tbl.COUNT > 0 THEN
4543:
4544: -- Remove the invalid khrs
4545: Okl_Pool_Pvt.delete_pool_contents(
4546: p_api_version => p_api_version,
4547: p_init_msg_list => p_init_msg_list,
4548: x_return_status => l_return_status,
4549: x_msg_count => x_msg_count,

Line 4575: Okl_Pool_Pvt.delete_pool_contents(

4571:
4572: IF lp_pocv_tbl.COUNT > 0 THEN
4573:
4574: -- Remove the delinquent khrs
4575: Okl_Pool_Pvt.delete_pool_contents(
4576: p_api_version => p_api_version,
4577: p_init_msg_list => p_init_msg_list,
4578: x_return_status => l_return_status,
4579: x_msg_count => x_msg_count,

Line 4609: Okl_Pool_Pvt.delete_pool_contents(

4605:
4606: IF lp_pocv_tbl.COUNT > 0 THEN
4607:
4608: -- Remove the rev khr rows
4609: Okl_Pool_Pvt.delete_pool_contents(
4610: p_api_version => p_api_version,
4611: p_init_msg_list => p_init_msg_list,
4612: x_return_status => l_return_status,
4613: x_msg_count => x_msg_count,

Line 4640: Okl_Pool_Pvt.delete_pool_contents(

4636:
4637: IF lp_pocv_tbl.COUNT > 0 THEN
4638:
4639: -- Remove the rows of invalid_assets
4640: Okl_Pool_Pvt.delete_pool_contents(
4641: p_api_version => p_api_version,
4642: p_init_msg_list => p_init_msg_list,
4643: x_return_status => l_return_status,
4644: x_msg_count => x_msg_count,

Line 4670: Okl_Pool_Pvt.delete_pool_contents(

4666:
4667: IF lp_pocv_tbl.COUNT > 0 THEN
4668:
4669: -- Remove the rows of invalid_streams
4670: Okl_Pool_Pvt.delete_pool_contents(
4671: p_api_version => p_api_version,
4672: p_init_msg_list => p_init_msg_list,
4673: x_return_status => l_return_status,
4674: x_msg_count => x_msg_count,

Line 4703: Okl_Pool_Pvt.update_pool_contents(

4699: END LOOP;
4700:
4701: IF lp_pocv_tbl.COUNT > 0 THEN
4702: -- Update the rows with correct stream dates
4703: Okl_Pool_Pvt.update_pool_contents(
4704: p_api_version => p_api_version,
4705: p_init_msg_list => p_init_msg_list,
4706: x_return_status => l_return_status,
4707: x_msg_count => x_msg_count,

Line 4741: Okl_Pool_Pvt.update_pool_contents(

4737: i := i + 1;
4738: END LOOP;
4739: IF lp_pocv_tbl.COUNT > 0 THEN
4740: -- Update the rows with correct stream dates
4741: Okl_Pool_Pvt.update_pool_contents(
4742: p_api_version => p_api_version,
4743: p_init_msg_list => p_init_msg_list,
4744: x_return_status => l_return_status,
4745: x_msg_count => x_msg_count,

Line 4772: Okl_Pool_Pvt.delete_pool_contents(

4768:
4769: IF lp_pocv_tbl.COUNT > 0 THEN
4770:
4771: -- Remove rent streams for EVERGREEN contract from pool--
4772: Okl_Pool_Pvt.delete_pool_contents(
4773: p_api_version => p_api_version,
4774: p_init_msg_list => p_init_msg_list,
4775: x_return_status => l_return_status,
4776: x_msg_count => x_msg_count,

Line 4802: Okl_Pool_Pvt.delete_pool_contents(

4798:
4799: IF lp_pocv_tbl.COUNT > 0 THEN
4800:
4801: -- Remove the invalid khrs
4802: Okl_Pool_Pvt.delete_pool_contents(
4803: p_api_version => p_api_version,
4804: p_init_msg_list => p_init_msg_list,
4805: x_return_status => l_return_status,
4806: x_msg_count => x_msg_count,

Line 4832: Okl_Pool_Pvt.delete_pool_contents(

4828:
4829: IF lp_pocv_tbl.COUNT > 0 THEN
4830:
4831: -- Remove the delinquent khrs
4832: Okl_Pool_Pvt.delete_pool_contents(
4833: p_api_version => p_api_version,
4834: p_init_msg_list => p_init_msg_list,
4835: x_return_status => l_return_status,
4836: x_msg_count => x_msg_count,

Line 4866: Okl_Pool_Pvt.delete_pool_contents(

4862:
4863: IF lp_pocv_tbl.COUNT > 0 THEN
4864:
4865: -- Remove the rev khr rows
4866: Okl_Pool_Pvt.delete_pool_contents(
4867: p_api_version => p_api_version,
4868: p_init_msg_list => p_init_msg_list,
4869: x_return_status => l_return_status,
4870: x_msg_count => x_msg_count,

Line 4897: Okl_Pool_Pvt.delete_pool_contents(

4893:
4894: IF lp_pocv_tbl.COUNT > 0 THEN
4895:
4896: -- Remove the rows of invalid_assets
4897: Okl_Pool_Pvt.delete_pool_contents(
4898: p_api_version => p_api_version,
4899: p_init_msg_list => p_init_msg_list,
4900: x_return_status => l_return_status,
4901: x_msg_count => x_msg_count,

Line 4927: Okl_Pool_Pvt.delete_pool_contents(

4923:
4924: IF lp_pocv_tbl.COUNT > 0 THEN
4925:
4926: -- Remove the rows of invalid_streams
4927: Okl_Pool_Pvt.delete_pool_contents(
4928: p_api_version => p_api_version,
4929: p_init_msg_list => p_init_msg_list,
4930: x_return_status => l_return_status,
4931: x_msg_count => x_msg_count,

Line 4960: Okl_Pool_Pvt.update_pool_contents(

4956: END LOOP;
4957:
4958: IF lp_pocv_tbl.COUNT > 0 THEN
4959: -- Update the rows with correct stream dates
4960: Okl_Pool_Pvt.update_pool_contents(
4961: p_api_version => p_api_version,
4962: p_init_msg_list => p_init_msg_list,
4963: x_return_status => l_return_status,
4964: x_msg_count => x_msg_count,

Line 4998: Okl_Pool_Pvt.update_pool_contents(

4994: i := i + 1;
4995: END LOOP;
4996: IF lp_pocv_tbl.COUNT > 0 THEN
4997: -- Update the rows with correct stream dates
4998: Okl_Pool_Pvt.update_pool_contents(
4999: p_api_version => p_api_version,
5000: p_init_msg_list => p_init_msg_list,
5001: x_return_status => l_return_status,
5002: x_msg_count => x_msg_count,

Line 5487: IF l_okl_pol_status_rec.status_code <> Okl_Pool_Pvt.G_POL_STS_NEW THEN

5483: ELSE
5484: FOR l_okl_pol_status_rec IN l_okl_pol_status_csr(p_polv_rec.id)
5485: LOOP
5486:
5487: IF l_okl_pol_status_rec.status_code <> Okl_Pool_Pvt.G_POL_STS_NEW THEN
5488: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME, p_msg_name => 'OKL_POOL_NO_MODIFY');
5489: RAISE OKL_API.G_EXCEPTION_ERROR;
5490: END IF;
5491: END LOOP;

Line 5560: END Okl_Pool_Pvt;

5556:
5557: END validate_pool;
5558: /* ankushar end changes 26-Jul-2007*/
5559:
5560: END Okl_Pool_Pvt;