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_POOLS

Line 43: FROM okl_pools

39: --Bug 6640050 - Start of Changes
40: CURSOR pool_status_csr(p_pol_id IN NUMBER)
41: IS
42: SELECT status_code
43: FROM okl_pools
44: WHERE id = p_pol_id;
45: --Bug 6640050 - End of Changes
46:
47: -- Cursor for getting the status of the open transaction

Line 77: ,p_pool_status IN okl_pools.status_code%TYPE

73: ,p_init_msg_list IN VARCHAR2
74: ,x_return_status OUT NOCOPY VARCHAR2
75: ,x_msg_count OUT NOCOPY NUMBER
76: ,x_msg_data OUT NOCOPY VARCHAR2
77: ,p_pool_status IN okl_pools.status_code%TYPE
78: ,p_pol_id IN okl_pools.id%TYPE)
79: IS
80: l_api_name CONSTANT VARCHAR2(30) := 'update_pool_status';
81: l_api_version CONSTANT NUMBER := 1.0;

Line 78: ,p_pol_id IN okl_pools.id%TYPE)

74: ,x_return_status OUT NOCOPY VARCHAR2
75: ,x_msg_count OUT NOCOPY NUMBER
76: ,x_msg_data OUT NOCOPY VARCHAR2
77: ,p_pool_status IN okl_pools.status_code%TYPE
78: ,p_pol_id IN okl_pools.id%TYPE)
79: IS
80: l_api_name CONSTANT VARCHAR2(30) := 'update_pool_status';
81: l_api_version CONSTANT NUMBER := 1.0;
82: i NUMBER;

Line 83: l_pol_id OKL_POOLS.ID%TYPE;

79: IS
80: l_api_name CONSTANT VARCHAR2(30) := 'update_pool_status';
81: l_api_version CONSTANT NUMBER := 1.0;
82: i NUMBER;
83: l_pol_id OKL_POOLS.ID%TYPE;
84: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
85: l_org_id OKL_POOLS.ORG_ID%TYPE;
86: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
87:

Line 84: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;

80: l_api_name CONSTANT VARCHAR2(30) := 'update_pool_status';
81: l_api_version CONSTANT NUMBER := 1.0;
82: i NUMBER;
83: l_pol_id OKL_POOLS.ID%TYPE;
84: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
85: l_org_id OKL_POOLS.ORG_ID%TYPE;
86: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
87:
88: lp_polv_rec polv_rec_type;

Line 85: l_org_id OKL_POOLS.ORG_ID%TYPE;

81: l_api_version CONSTANT NUMBER := 1.0;
82: i NUMBER;
83: l_pol_id OKL_POOLS.ID%TYPE;
84: l_currency_code OKL_POOLS.CURRENCY_CODE%TYPE;
85: l_org_id OKL_POOLS.ORG_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;

Line 599: l_status_code okl_pools.status_Code%TYPE;

595:
596: l_pocv_rec pocv_rec_type := p_pocv_rec;
597: -- x_pocv_rec pocv_rec_type;
598: --Added by kthiruva on 21-Nov-2007 for Bug 6640050
599: l_status_code okl_pools.status_Code%TYPE;
600:
601: lp_polv_rec polv_rec_type;
602: lx_polv_rec polv_rec_type;
603:

Line 1703: -- Description : get stream elements amount from pool contents by okl_pools.id

1699: ----------------------------------------------------------------------------------
1700: -- Start of comments
1701: --
1702: -- Procedure Name : get_tot_receivable_amt
1703: -- Description : get stream elements amount from pool contents by okl_pools.id
1704: -- Business Rules :
1705: -- Parameters :
1706: -- Version : 1.0
1707: -- End of comments

Line 1710: p_pol_id IN okl_pools.id%TYPE

1706: -- Version : 1.0
1707: -- End of comments
1708: ----------------------------------------------------------------------------------
1709: FUNCTION get_tot_receivable_amt(
1710: p_pol_id IN okl_pools.id%TYPE
1711:
1712: ) RETURN NUMBER
1713: IS
1714: l_amount NUMBER;

Line 1769: -- Description : get stream elements amount from pool contents by okl_pools.id

1765: ----------------------------------------------------------------------------------
1766: -- Start of comments
1767: --
1768: -- Procedure Name : get_tot_recv_amt_for_pend
1769: -- Description : get stream elements amount from pool contents by okl_pools.id
1770: -- Business Rules :
1771: -- Parameters :
1772: -- Version : 1.0
1773: -- End of comments

Line 1776: p_pol_id IN okl_pools.id%TYPE

1772: -- Version : 1.0
1773: -- End of comments
1774: ----------------------------------------------------------------------------------
1775: FUNCTION get_tot_recv_amt_for_pend(
1776: p_pol_id IN okl_pools.id%TYPE
1777:
1778: ) RETURN NUMBER
1779: IS
1780: l_amount NUMBER;

Line 1809: l_status_code okl_pools.status_Code%TYPE;

1805: AND ele.STREAM_ELEMENT_DATE
1806: BETWEEN cnt.STREAMS_FROM_DATE AND NVL(cnt.STREAMS_TO_DATE,G_FINAL_DATE);
1807:
1808: l_allowed_status Varchar2(100);
1809: l_status_code okl_pools.status_Code%TYPE;
1810: --End - Changes for bug#6658065 by VARANGAN on 30/11/2007
1811: BEGIN
1812: -- Begin - Changes for Bug#6658065
1813: --(1) Check the pool status

Line 1870: ,p_pol_id IN okl_pools.id%TYPE

1866: ,x_return_status OUT NOCOPY VARCHAR2
1867: ,x_msg_count OUT NOCOPY NUMBER
1868: ,x_msg_data OUT NOCOPY VARCHAR2
1869: ,x_value OUT NOCOPY NUMBER
1870: ,p_pol_id IN okl_pools.id%TYPE
1871:
1872: )
1873: IS
1874: l_api_name CONSTANT VARCHAR2(30) := 'get_tot_receivable_amt_pvt2';

Line 1966: ,p_pol_id IN okl_pools.id%TYPE

1962: ,x_return_status OUT NOCOPY VARCHAR2
1963: ,x_msg_count OUT NOCOPY NUMBER
1964: ,x_msg_data OUT NOCOPY VARCHAR2
1965: ,x_value OUT NOCOPY NUMBER
1966: ,p_pol_id IN okl_pools.id%TYPE
1967:
1968: )
1969: IS
1970: l_api_name CONSTANT VARCHAR2(30) := 'get_tot_receivable_amt_pvt2';

Line 2065: l_pol_id okl_pools.id%TYPE;

2061: l_api_name CONSTANT VARCHAR2(30) := 'get_tot_receivable_amt_pvt2';
2062: l_api_version CONSTANT NUMBER := 1.0;
2063: i NUMBER;
2064: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2065: l_pol_id okl_pools.id%TYPE;
2066:
2067: CURSOR c_khr(p_khr_id okc_k_headers_b.id%TYPE) IS
2068: SELECT ph.id
2069: FROM okl_pools ph

Line 2069: FROM okl_pools ph

2065: l_pol_id okl_pools.id%TYPE;
2066:
2067: CURSOR c_khr(p_khr_id okc_k_headers_b.id%TYPE) IS
2068: SELECT ph.id
2069: FROM okl_pools ph
2070: WHERE ph.khr_id = p_khr_id
2071: ;
2072:
2073: BEGIN

Line 2148: -- Description : get asset principal amount from pool contents by okl_pools.id

2144: ----------------------------------------------------------------------------------
2145: -- Start of comments
2146: --
2147: -- Procedure Name : get_tot_principal_amt
2148: -- Description : get asset principal amount from pool contents by okl_pools.id
2149: -- Business Rules :
2150: -- Parameters :
2151:
2152: -- Version : 1.0

Line 2156: p_pol_id IN okl_pools.id%TYPE

2152: -- Version : 1.0
2153: -- End of comments
2154: ----------------------------------------------------------------------------------
2155: FUNCTION get_tot_principal_amt(
2156: p_pol_id IN okl_pools.id%TYPE
2157: ) RETURN NUMBER
2158: IS
2159: l_amount NUMBER := 0;
2160: l_tot_amount NUMBER := 0;

Line 2313: ,p_pol_id IN okl_pools.id%TYPE

2309: ,x_return_status OUT NOCOPY VARCHAR2
2310: ,x_msg_count OUT NOCOPY NUMBER
2311: ,x_msg_data OUT NOCOPY VARCHAR2
2312: ,x_value OUT NOCOPY NUMBER
2313: ,p_pol_id IN okl_pools.id%TYPE
2314: )
2315: IS
2316: l_api_name CONSTANT VARCHAR2(30) := 'recal_tot_princ_amt_pvt';
2317: l_api_version CONSTANT NUMBER := 1.0;

Line 2439: l_pol_id okl_pools.id%TYPE;

2435: l_api_name CONSTANT VARCHAR2(30) := 'recal_tot_principal_amt_pvt';
2436: l_api_version CONSTANT NUMBER := 1.0;
2437: i NUMBER;
2438: l_return_status VARCHAR2(1) := Okl_Api.G_RET_STS_SUCCESS;
2439: l_pol_id okl_pools.id%TYPE;
2440:
2441: lp_polv_rec polv_rec_type;
2442: lx_polv_rec polv_rec_type;
2443:

Line 2446: FROM okl_pools ph

2442: lx_polv_rec polv_rec_type;
2443:
2444: CURSOR c_khr(p_khr_id okc_k_headers_b.id%TYPE) IS
2445: SELECT ph.id
2446: FROM okl_pools ph
2447: WHERE ph.khr_id = p_khr_id
2448: ;
2449:
2450: BEGIN

Line 3274: okl_pools pol

3270: CURSOR l_okl_reject_le_csr(p_khr_id IN NUMBER)
3271: IS
3272: SELECT '1'
3273: FROM okl_k_headers khr,
3274: okl_pools pol
3275: WHERE pol.legal_entity_id <> khr.legal_entity_id
3276: AND pol.id =p_pol_id
3277: AND khr.id = p_khr_id;
3278:

Line 3303: FROM okl_pools

3299: -- Cursor to get the Legal Entity Id
3300: CURSOR l_okl_agrle_csr(p_pol_id IN NUMBER)
3301: IS
3302: SELECT legal_entity_id
3303: FROM okl_pools
3304: WHERE id = p_pol_id;
3305:
3306:
3307: /* sosharma end changes*/

Line 3318: l_status_code okl_pools.status_code%TYPE;

3314: l_pocv_rec pocv_rec_type;
3315: x_pocv_rec pocv_rec_type;
3316: --Added by kthiruva on 21-Nov-2007 for Bug 6640050
3317: l_pocv_tbl pocv_tbl_type;
3318: l_status_code okl_pools.status_code%TYPE;
3319: l_poc_count NUMBER := 0;
3320:
3321: -- l_discarded BOOLEAN := FALSE;
3322: l_discard_count NUMBER := 0;

Line 3958: l_status_code okl_pools.status_Code%TYPE;

3954: AND ele.STREAM_ELEMENT_DATE
3955: BETWEEN cnt.STREAMS_FROM_DATE AND NVL(cnt.STREAMS_TO_DATE,G_FINAL_DATE);
3956:
3957: l_allowed_status Varchar2(100);
3958: l_status_code okl_pools.status_Code%TYPE;
3959: --End - Changes for Bug 6640050 by varangan on 29-Nov-2007
3960:
3961: BEGIN
3962: l_return_status := Okl_Api.START_ACTIVITY(p_api_name => l_api_name,

Line 4119: okl_pools pol,

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
4123: AND pol.id = poc.pol_id

Line 4305: okl_pools pol,

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
4309: AND pol.id = poc.pol_id

Line 5096: ,p_pol_id IN okl_pools.id%TYPE)

5092: ,p_init_msg_list IN VARCHAR2
5093: ,x_return_status OUT NOCOPY VARCHAR2
5094: ,x_msg_count OUT NOCOPY NUMBER
5095: ,x_msg_data OUT NOCOPY VARCHAR2
5096: ,p_pol_id IN okl_pools.id%TYPE)
5097: IS
5098:
5099:
5100: l_api_name CONSTANT VARCHAR2(30) := 'update_pool_status_active';

Line 5197: ,p_pol_id IN okl_pools.id%TYPE)

5193: ,p_init_msg_list IN VARCHAR2
5194: ,x_return_status OUT NOCOPY VARCHAR2
5195: ,x_msg_count OUT NOCOPY NUMBER
5196: ,x_msg_data OUT NOCOPY VARCHAR2
5197: ,p_pol_id IN okl_pools.id%TYPE)
5198: IS
5199: l_api_name CONSTANT VARCHAR2(30) := 'update_pool_status_expired';
5200: l_api_version CONSTANT NUMBER := 1.0;
5201:

Line 5445: FROM okl_pools

5441:
5442: CURSOR l_okl_pol_status_csr(p_pol_id IN NUMBER)
5443: IS
5444: SELECT status_code
5445: FROM okl_pools
5446: WHERE id = p_pol_id;
5447:
5448: -- Cursor For OKL_CURRENCIES;
5449: CURSOR okl_fnd_curr_csr (p_code IN OKL_POOLS.currency_code%TYPE) IS

Line 5449: CURSOR okl_fnd_curr_csr (p_code IN OKL_POOLS.currency_code%TYPE) IS

5445: FROM okl_pools
5446: WHERE id = p_pol_id;
5447:
5448: -- Cursor For OKL_CURRENCIES;
5449: CURSOR okl_fnd_curr_csr (p_code IN OKL_POOLS.currency_code%TYPE) IS
5450: SELECT '1'
5451: FROM FND_CURRENCIES_VL
5452: WHERE FND_CURRENCIES_VL.currency_code = currency_code;
5453: