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.12020000.2 2012/08/07 13:36:26 rpillay ship $ */
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 3520: Okl_Pool_Pvt.create_pool_contents(

3516: END IF;
3517: l_pocv_rec.streams_to_date := l_okl_poc_rec.streams_to_date;
3518: l_pocv_rec.stm_id := l_okl_poc_rec.stm_id;
3519:
3520: Okl_Pool_Pvt.create_pool_contents(
3521: p_api_version => p_api_version,
3522: p_init_msg_list => p_init_msg_list,
3523: x_return_status => x_return_status,
3524: x_msg_count => x_msg_count,

Line 3618: Okl_Pool_Pvt.create_pool_transaction(p_api_version => p_api_version

3614: --sosharma 03/12/2007 added to enable status on pool transaction
3615: lp_poxv_rec.TRANSACTION_STATUS := G_POOL_TRX_STATUS_NEW;
3616:
3617: -- create ADD transaction for Adjustment
3618: Okl_Pool_Pvt.create_pool_transaction(p_api_version => p_api_version
3619: ,p_init_msg_list => p_init_msg_list
3620: ,x_return_status => l_return_status
3621: ,x_msg_count => x_msg_count
3622: ,x_msg_data => x_msg_data

Line 3639: Okl_Pool_Pvt.create_pool_contents(

3635: END LOOP;
3636:
3637: END IF;
3638: --- create pool contents for Adjustment ADD transaction
3639: Okl_Pool_Pvt.create_pool_contents(
3640: p_api_version => p_api_version,
3641: p_init_msg_list => p_init_msg_list,
3642: x_return_status => x_return_status,
3643: x_msg_count => x_msg_count,

Line 3666: Okl_Pool_Pvt.update_pool_transaction(p_api_version => p_api_version

3662: lp_poxv_rec.POL_ID := p_pol_id;
3663: lp_poxv_rec.ID := l_trx_id;
3664:
3665: -- create ADD transaction for Adjustment
3666: Okl_Pool_Pvt.update_pool_transaction(p_api_version => p_api_version
3667: ,p_init_msg_list => p_init_msg_list
3668: ,x_return_status => l_return_status
3669: ,x_msg_count => x_msg_count
3670: ,x_msg_data => x_msg_data

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

3998: OPEN c_strm_amount (l_okl_pool_cleanup_rec.poc_id) ;
3999: FETCH c_strm_amount INTO l_pool_amount;
4000: CLOSE c_strm_amount;
4001: ELSE -- follow the existing process
4002: l_pool_amount := Okl_Pool_Pvt.get_pool_stream_amout(l_okl_pool_cleanup_rec.poc_id);
4003: END IF;
4004:
4005: x_poc_uv_tbl(l_row_count).poc_id := l_okl_pool_cleanup_rec.poc_id;
4006: x_poc_uv_tbl(l_row_count).contract_number := l_okl_pool_cleanup_rec.contract_number;

Line 4021: IF p_action_code = Okl_Pool_Pvt.G_ACTION_REMOVE THEN

4017:
4018: END LOOP;
4019: -- End - Changes for Bug#6658065
4020:
4021: IF p_action_code = Okl_Pool_Pvt.G_ACTION_REMOVE THEN
4022: Okl_Pool_Pvt.delete_pool_contents(p_api_version => p_api_version
4023: ,p_init_msg_list => p_init_msg_list
4024: ,x_return_status => l_return_status
4025: ,x_msg_count => x_msg_count

Line 4022: Okl_Pool_Pvt.delete_pool_contents(p_api_version => p_api_version

4018: END LOOP;
4019: -- End - Changes for Bug#6658065
4020:
4021: IF p_action_code = Okl_Pool_Pvt.G_ACTION_REMOVE THEN
4022: Okl_Pool_Pvt.delete_pool_contents(p_api_version => p_api_version
4023: ,p_init_msg_list => p_init_msg_list
4024: ,x_return_status => l_return_status
4025: ,x_msg_count => x_msg_count
4026: ,x_msg_data => x_msg_data

Line 4047: Okl_Pool_Pvt.update_pool_transaction(p_api_version => p_api_version

4043: lp_poxv_rec.POL_ID := p_pol_id;
4044: lp_poxv_rec.ID := l_trx_id;
4045:
4046: -- create ADD transaction for Adjustment
4047: Okl_Pool_Pvt.update_pool_transaction(p_api_version => p_api_version
4048: ,p_init_msg_list => p_init_msg_list
4049: ,x_return_status => l_return_status
4050: ,x_msg_count => x_msg_count
4051: ,x_msg_data => x_msg_data

Line 4524: Okl_Pool_Pvt.delete_pool_contents(

4520:
4521: IF lp_pocv_tbl.COUNT > 0 THEN
4522:
4523: -- Remove rent streams for EVERGREEN contract from pool--
4524: Okl_Pool_Pvt.delete_pool_contents(
4525: p_api_version => p_api_version,
4526: p_init_msg_list => p_init_msg_list,
4527: x_return_status => l_return_status,
4528: x_msg_count => x_msg_count,

Line 4554: Okl_Pool_Pvt.delete_pool_contents(

4550:
4551: IF lp_pocv_tbl.COUNT > 0 THEN
4552:
4553: -- Remove the invalid khrs
4554: Okl_Pool_Pvt.delete_pool_contents(
4555: p_api_version => p_api_version,
4556: p_init_msg_list => p_init_msg_list,
4557: x_return_status => l_return_status,
4558: x_msg_count => x_msg_count,

Line 4584: Okl_Pool_Pvt.delete_pool_contents(

4580:
4581: IF lp_pocv_tbl.COUNT > 0 THEN
4582:
4583: -- Remove the delinquent khrs
4584: Okl_Pool_Pvt.delete_pool_contents(
4585: p_api_version => p_api_version,
4586: p_init_msg_list => p_init_msg_list,
4587: x_return_status => l_return_status,
4588: x_msg_count => x_msg_count,

Line 4618: Okl_Pool_Pvt.delete_pool_contents(

4614:
4615: IF lp_pocv_tbl.COUNT > 0 THEN
4616:
4617: -- Remove the rev khr rows
4618: Okl_Pool_Pvt.delete_pool_contents(
4619: p_api_version => p_api_version,
4620: p_init_msg_list => p_init_msg_list,
4621: x_return_status => l_return_status,
4622: x_msg_count => x_msg_count,

Line 4649: Okl_Pool_Pvt.delete_pool_contents(

4645:
4646: IF lp_pocv_tbl.COUNT > 0 THEN
4647:
4648: -- Remove the rows of invalid_assets
4649: Okl_Pool_Pvt.delete_pool_contents(
4650: p_api_version => p_api_version,
4651: p_init_msg_list => p_init_msg_list,
4652: x_return_status => l_return_status,
4653: x_msg_count => x_msg_count,

Line 4679: Okl_Pool_Pvt.delete_pool_contents(

4675:
4676: IF lp_pocv_tbl.COUNT > 0 THEN
4677:
4678: -- Remove the rows of invalid_streams
4679: Okl_Pool_Pvt.delete_pool_contents(
4680: p_api_version => p_api_version,
4681: p_init_msg_list => p_init_msg_list,
4682: x_return_status => l_return_status,
4683: x_msg_count => x_msg_count,

Line 4712: Okl_Pool_Pvt.update_pool_contents(

4708: END LOOP;
4709:
4710: IF lp_pocv_tbl.COUNT > 0 THEN
4711: -- Update the rows with correct stream dates
4712: Okl_Pool_Pvt.update_pool_contents(
4713: p_api_version => p_api_version,
4714: p_init_msg_list => p_init_msg_list,
4715: x_return_status => l_return_status,
4716: x_msg_count => x_msg_count,

Line 4750: Okl_Pool_Pvt.update_pool_contents(

4746: i := i + 1;
4747: END LOOP;
4748: IF lp_pocv_tbl.COUNT > 0 THEN
4749: -- Update the rows with correct stream dates
4750: Okl_Pool_Pvt.update_pool_contents(
4751: p_api_version => p_api_version,
4752: p_init_msg_list => p_init_msg_list,
4753: x_return_status => l_return_status,
4754: x_msg_count => x_msg_count,

Line 4781: Okl_Pool_Pvt.delete_pool_contents(

4777:
4778: IF lp_pocv_tbl.COUNT > 0 THEN
4779:
4780: -- Remove rent streams for EVERGREEN contract from pool--
4781: Okl_Pool_Pvt.delete_pool_contents(
4782: p_api_version => p_api_version,
4783: p_init_msg_list => p_init_msg_list,
4784: x_return_status => l_return_status,
4785: x_msg_count => x_msg_count,

Line 4811: Okl_Pool_Pvt.delete_pool_contents(

4807:
4808: IF lp_pocv_tbl.COUNT > 0 THEN
4809:
4810: -- Remove the invalid khrs
4811: Okl_Pool_Pvt.delete_pool_contents(
4812: p_api_version => p_api_version,
4813: p_init_msg_list => p_init_msg_list,
4814: x_return_status => l_return_status,
4815: x_msg_count => x_msg_count,

Line 4841: Okl_Pool_Pvt.delete_pool_contents(

4837:
4838: IF lp_pocv_tbl.COUNT > 0 THEN
4839:
4840: -- Remove the delinquent khrs
4841: Okl_Pool_Pvt.delete_pool_contents(
4842: p_api_version => p_api_version,
4843: p_init_msg_list => p_init_msg_list,
4844: x_return_status => l_return_status,
4845: x_msg_count => x_msg_count,

Line 4875: Okl_Pool_Pvt.delete_pool_contents(

4871:
4872: IF lp_pocv_tbl.COUNT > 0 THEN
4873:
4874: -- Remove the rev khr rows
4875: Okl_Pool_Pvt.delete_pool_contents(
4876: p_api_version => p_api_version,
4877: p_init_msg_list => p_init_msg_list,
4878: x_return_status => l_return_status,
4879: x_msg_count => x_msg_count,

Line 4906: Okl_Pool_Pvt.delete_pool_contents(

4902:
4903: IF lp_pocv_tbl.COUNT > 0 THEN
4904:
4905: -- Remove the rows of invalid_assets
4906: Okl_Pool_Pvt.delete_pool_contents(
4907: p_api_version => p_api_version,
4908: p_init_msg_list => p_init_msg_list,
4909: x_return_status => l_return_status,
4910: x_msg_count => x_msg_count,

Line 4936: Okl_Pool_Pvt.delete_pool_contents(

4932:
4933: IF lp_pocv_tbl.COUNT > 0 THEN
4934:
4935: -- Remove the rows of invalid_streams
4936: Okl_Pool_Pvt.delete_pool_contents(
4937: p_api_version => p_api_version,
4938: p_init_msg_list => p_init_msg_list,
4939: x_return_status => l_return_status,
4940: x_msg_count => x_msg_count,

Line 4969: Okl_Pool_Pvt.update_pool_contents(

4965: END LOOP;
4966:
4967: IF lp_pocv_tbl.COUNT > 0 THEN
4968: -- Update the rows with correct stream dates
4969: Okl_Pool_Pvt.update_pool_contents(
4970: p_api_version => p_api_version,
4971: p_init_msg_list => p_init_msg_list,
4972: x_return_status => l_return_status,
4973: x_msg_count => x_msg_count,

Line 5007: Okl_Pool_Pvt.update_pool_contents(

5003: i := i + 1;
5004: END LOOP;
5005: IF lp_pocv_tbl.COUNT > 0 THEN
5006: -- Update the rows with correct stream dates
5007: Okl_Pool_Pvt.update_pool_contents(
5008: p_api_version => p_api_version,
5009: p_init_msg_list => p_init_msg_list,
5010: x_return_status => l_return_status,
5011: x_msg_count => x_msg_count,

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

5492: ELSE
5493: FOR l_okl_pol_status_rec IN l_okl_pol_status_csr(p_polv_rec.id)
5494: LOOP
5495:
5496: IF l_okl_pol_status_rec.status_code <> Okl_Pool_Pvt.G_POL_STS_NEW THEN
5497: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME, p_msg_name => 'OKL_POOL_NO_MODIFY');
5498: RAISE OKL_API.G_EXCEPTION_ERROR;
5499: END IF;
5500: END LOOP;

Line 5569: END Okl_Pool_Pvt;

5565:
5566: END validate_pool;
5567: /* ankushar end changes 26-Jul-2007*/
5568:
5569: END Okl_Pool_Pvt;