APPS.OKL_SEC_CONCURRENT_PVT dependencies on OKL_POOL_PVT

Line 7: G_POC_STS_NEW CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_NEW;

3: ----------------------------------------------------------------------------
4: -- Global Message Constants
5: ----------------------------------------------------------------------------
6:
7: G_POC_STS_NEW CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_NEW;
8: G_POC_STS_ACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_ACTIVE;
9: G_POC_STS_INACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_INACTIVE;
10:
11: G_BUYBACK_AGREEMENT_HEAD CONSTANT VARCHAR2(30) := 'OKL_BUYBACK_AGREEMENT';

Line 8: G_POC_STS_ACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_ACTIVE;

4: -- Global Message Constants
5: ----------------------------------------------------------------------------
6:
7: G_POC_STS_NEW CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_NEW;
8: G_POC_STS_ACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_ACTIVE;
9: G_POC_STS_INACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_INACTIVE;
10:
11: G_BUYBACK_AGREEMENT_HEAD CONSTANT VARCHAR2(30) := 'OKL_BUYBACK_AGREEMENT';
12:

Line 9: G_POC_STS_INACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_INACTIVE;

5: ----------------------------------------------------------------------------
6:
7: G_POC_STS_NEW CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_NEW;
8: G_POC_STS_ACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_ACTIVE;
9: G_POC_STS_INACTIVE CONSTANT VARCHAR2(10) := Okl_Pool_Pvt.G_POC_STS_INACTIVE;
10:
11: G_BUYBACK_AGREEMENT_HEAD CONSTANT VARCHAR2(30) := 'OKL_BUYBACK_AGREEMENT';
12:
13: G_SET_OF_BOOKS CONSTANT VARCHAR2(30) := 'OKL_SET_OF_BOOKS';

Line 131: AND pocb.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE

127: ,okc_k_lines_tl clet
128: ,okl_strm_type_v styv
129: WHERE pocb.pol_id = polb.id
130: AND polb.khr_id = p_khr_id
131: AND pocb.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE
132: AND pocb.streams_to_date > p_effective_date
133: AND pocb.khr_id = chrb.id
134: AND pocb.kle_id = clet.id
135: AND pocb.sty_id = styv.id;

Line 161: AND pocb.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE;

157: FROM okl_pool_contents pocb
158: ,okl_pools polb
159: WHERE pocb.pol_id = polb.id
160: AND polb.khr_id = p_khr_id
161: AND pocb.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE;
162:
163: -- Cursor
164: CURSOR l_okl_pol_csr
165: IS

Line 176: AND pocb.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE --Added by VARANGAN -Pool Contents Impact(Bug#6658065)

172: ,okl_strm_type_b styb
173: WHERE pocb.pol_id = polb.id
174: AND polb.khr_id = p_khr_id
175: AND pocb.sty_id = styb.id
176: AND pocb.status_code = Okl_Pool_Pvt.G_POC_STS_ACTIVE --Added by VARANGAN -Pool Contents Impact(Bug#6658065)
177: ORDER BY pocb.khr_id,styb.stream_type_subclass;
178:
179:
180: -- Cursor