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_POOLCONC_PVT dependencies on OKL_POOLS

Line 107: FROM okl_pools

103: -- Bug#2829983, v115.13
104: CURSOR l_okl_pol_status_csr(p_pol_id IN NUMBER)
105: IS
106: SELECT status_code
107: FROM okl_pools
108: WHERE id = p_pol_id;
109:
110: -- /* Following Cursors for Report purposes */
111: CURSOR l_okl_pol_csr IS

Line 114: FROM OKL_POOLS polv -- to take care of org_id

110: -- /* Following Cursors for Report purposes */
111: CURSOR l_okl_pol_csr IS
112: SELECT polv.pool_number pool_number
113: ,psts.meaning pool_status
114: FROM OKL_POOLS polv -- to take care of org_id
115: ,okc_statuses_tl psts
116: WHERE polv.id = p_pol_id
117: AND polv.status_code = psts.code
118: AND psts.LANGUAGE = USERENV('LANG');

Line 549: -- update total principal amount at okl_pools

545:
546:
547: /* v115.16, mvasudev
548: --
549: -- update total principal amount at okl_pools
550: --
551: FND_FILE.PUT_LINE(FND_FILE.LOG, get_message('Okl_Pool_Pvt.GET_TOT_PRINCIPAL_AMT','',G_PROCESS_START));
552:
553: Okl_Pool_Pvt.recal_tot_princ_amt(

Line 787: -- Description : update asset principal amount from pool contents by okl_pools.id to okl_pools.TOTAL_PRINCIPAL_AMOUNT

783: ----------------------------------------------------------------------------------
784: -- Start of comments
785: --
786: -- Procedure Name : recal_tot_princ_amt
787: -- Description : update asset principal amount from pool contents by okl_pools.id to okl_pools.TOTAL_PRINCIPAL_AMOUNT
788: -- This is a wrapper procedure for concurrent program to call private API
789: -- Business Rules :
790: -- Parameters :
791: -- Version : 1.0

Line 797: ,p_pool_number IN okl_pools.POOL_NUMBER%TYPE)

793: ----------------------------------------------------------------------------------
794:
795: PROCEDURE recal_tot_princ_amt(x_errbuf OUT NOCOPY VARCHAR2
796: ,x_retcode OUT NOCOPY NUMBER
797: ,p_pool_number IN okl_pools.POOL_NUMBER%TYPE)
798: IS
799: l_api_name CONSTANT VARCHAR2(40) := 'recal_tot_princ_amt';
800: l_api_version CONSTANT NUMBER := 1.0;
801: p_api_version CONSTANT NUMBER := 1.0;

Line 808: l_pol_id okl_pools.id%TYPE;

804: l_msg_count NUMBER;
805: l_row_count NUMBER;
806: l_amount NUMBER;
807: i NUMBER;
808: l_pol_id okl_pools.id%TYPE;
809:
810: l_msg_data VARCHAR2(2000);
811: l_RecordsProcessed NUMBER := 0;
812: l_error_msg_rec Error_message_Type;

Line 816: FROM okl_pools pol

812: l_error_msg_rec Error_message_Type;
813:
814: CURSOR c_pol IS
815: SELECT pol.id
816: FROM okl_pools pol
817: WHERE EXISTS
818: (SELECT '1'
819: FROM okl_pool_contents poc
820: WHERE poc.pol_id = pol.id

Line 826: FROM okl_pools pol

822: ;
823:
824: CURSOR c_pool IS
825: SELECT pol.id
826: FROM okl_pools pol
827: WHERE pol.pool_number = p_pool_number
828: ;
829:
830: BEGIN

Line 987: -- Description : update asset principal amount from pool contents by okl_pools.id to okl_pools.TOTAL_PRINCIPAL_AMOUNT

983: ----------------------------------------------------------------------------------
984: -- Start of comments
985: --
986: -- Procedure Name : recal_tot_princ_amt_ui
987: -- Description : update asset principal amount from pool contents by okl_pools.id to okl_pools.TOTAL_PRINCIPAL_AMOUNT
988: -- This is a wrapper procedure for concurrent program call from jsp/UI
989: -- Business Rules :
990: -- Parameters :
991: -- Version : 1.0

Line 1003: ,p_pool_number IN okl_pools.POOL_NUMBER%TYPE)

999: ,x_msg_count OUT NOCOPY NUMBER
1000: ,x_msg_data OUT NOCOPY VARCHAR2
1001: -- concurent out parameter
1002: ,x_request_id OUT NOCOPY NUMBER
1003: ,p_pool_number IN okl_pools.POOL_NUMBER%TYPE)
1004: AS
1005: l_api_name VARCHAR2(30) := 'recal_tot_princ_amt_ui';
1006: l_api_version NUMBER := 1.0;
1007: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;

Line 1091: ,p_pool_number IN okl_pools.POOL_NUMBER%TYPE DEFAULT NULL)

1087: ----------------------------------------------------------------------------------
1088:
1089: PROCEDURE reconcile_pool_contents(x_errbuf OUT NOCOPY VARCHAR2
1090: ,x_retcode OUT NOCOPY NUMBER
1091: ,p_pool_number IN okl_pools.POOL_NUMBER%TYPE DEFAULT NULL)
1092: IS
1093: -- Bug#2837819, 03/10/2003
1094: -- mvasudev, modified to take care of null khrs in pools
1095: CURSOR l_okl_pols_csr

Line 1098: FROM okl_pools polb

1094: -- mvasudev, modified to take care of null khrs in pools
1095: CURSOR l_okl_pols_csr
1096: IS
1097: SELECT polb.id
1098: FROM okl_pools polb
1099: WHERE EXISTS
1100: (SELECT '1'
1101: FROM okl_pool_contents pocb
1102: WHERE pocb.pol_id = polb.id

Line 1113: FROM okl_pools polb

1109: -- mvasudev, modified to take care of null khrs in pools
1110: CURSOR l_okl_pol_csr(p_pool_number IN VARCHAR2)
1111: IS
1112: SELECT polb.id
1113: FROM okl_pools polb
1114: WHERE polb.pool_number = p_pool_number
1115: -- Bug#2829983
1116: AND polb.status_code = 'NEW';
1117:

Line 1296: ,p_pool_number IN okl_pools.POOL_NUMBER%TYPE DEFAULT NULL)

1292: ----------------------------------------------------------------------------------
1293:
1294: PROCEDURE recon_pnd_pool_con(x_errbuf OUT NOCOPY VARCHAR2
1295: ,x_retcode OUT NOCOPY NUMBER
1296: ,p_pool_number IN okl_pools.POOL_NUMBER%TYPE DEFAULT NULL)
1297: IS
1298: -- Bug#2837819, 03/10/2003
1299: -- mvasudev, modified to take care of null khrs in pools
1300: CURSOR l_okl_pols_csr

Line 1303: FROM okl_pools polb

1299: -- mvasudev, modified to take care of null khrs in pools
1300: CURSOR l_okl_pols_csr
1301: IS
1302: SELECT polb.id
1303: FROM okl_pools polb
1304: WHERE EXISTS
1305: (SELECT '1'
1306: FROM okl_pool_contents pocb
1307: WHERE pocb.pol_id = polb.id

Line 1317: FROM okl_pools polb

1313: -- mvasudev, modified to take care of null khrs in pools
1314: CURSOR l_okl_pol_csr(p_pool_number IN VARCHAR2)
1315: IS
1316: SELECT polb.id
1317: FROM okl_pools polb
1318: WHERE polb.pool_number = p_pool_number
1319: AND polb.status_code = 'ACTIVE';
1320:
1321: l_api_name CONSTANT VARCHAR2(40) := 'recon_pnd_pool_con';

Line 1509: ,p_pool_number IN okl_pools.POOL_NUMBER%TYPE DEFAULT NULL

1505: ----------------------------------------------------------------------------------
1506: PROCEDURE reconcile_pool_contents_ui(
1507: p_api_version IN NUMBER
1508: ,p_init_msg_list IN VARCHAR2 DEFAULT OKL_API.G_FALSE
1509: ,p_pool_number IN okl_pools.POOL_NUMBER%TYPE DEFAULT NULL
1510: ,x_return_status OUT NOCOPY VARCHAR2
1511: ,x_msg_count OUT NOCOPY NUMBER
1512: ,x_msg_data OUT NOCOPY VARCHAR2
1513: ,x_request_id OUT NOCOPY NUMBER)

Line 1639: FROM okl_pools

1635: -- Bug#2829983, v115.13
1636: CURSOR l_okl_pol_status_csr(p_pol_id IN NUMBER)
1637: IS
1638: SELECT status_code
1639: FROM okl_pools
1640: WHERE id = p_pol_id;
1641:
1642: CURSOR l_okl_pol_csr IS
1643: SELECT polv.pool_number pool_number

Line 1650: FROM OKL_POOLS polv -- to take care of org_id

1646: ,polv.date_last_updated date_last_updated
1647: ,polv.date_last_reconciled date_last_reconciled
1648: ,polv.total_principal_amount total_net_asset_net_investment
1649: ,polv.date_total_principal_calc date_last_calculated
1650: FROM OKL_POOLS polv -- to take care of org_id
1651: ,okc_statuses_tl psts
1652: WHERE polv.id = p_pol_id
1653: AND polv.status_code = psts.code
1654: AND psts.LANGUAGE = USERENV('LANG');