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_STREAM_GENERATOR_PVT dependencies on OKL_POOL_PVT

Line 68: G_IA_STS_NEW CONSTANT VARCHAR2(6) := okl_pool_pvt.G_POL_STS_NEW;

64: r_rollover_pmnts G_ROLLOVER_PMNTS%ROWTYPE;
65: -- Added by RGOOTY : End
66:
67: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
68: G_IA_STS_NEW CONSTANT VARCHAR2(6) := okl_pool_pvt.G_POL_STS_NEW;
69: G_IA_STS_ACTIVE CONSTANT VARCHAR2(6) := okl_pool_pvt.G_POL_STS_ACTIVE;
70: G_IA_STS_INACTIVE CONSTANT VARCHAR2(8) := okl_pool_pvt.G_POL_STS_INACTIVE;
71: G_IA_STS_EXPIRED CONSTANT VARCHAR2(10) := okl_pool_pvt.G_POL_STS_EXPIRED;
72: --sosharma 14-12-2007 ,Added pending status

Line 69: G_IA_STS_ACTIVE CONSTANT VARCHAR2(6) := okl_pool_pvt.G_POL_STS_ACTIVE;

65: -- Added by RGOOTY : End
66:
67: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
68: G_IA_STS_NEW CONSTANT VARCHAR2(6) := okl_pool_pvt.G_POL_STS_NEW;
69: G_IA_STS_ACTIVE CONSTANT VARCHAR2(6) := okl_pool_pvt.G_POL_STS_ACTIVE;
70: G_IA_STS_INACTIVE CONSTANT VARCHAR2(8) := okl_pool_pvt.G_POL_STS_INACTIVE;
71: G_IA_STS_EXPIRED CONSTANT VARCHAR2(10) := okl_pool_pvt.G_POL_STS_EXPIRED;
72: --sosharma 14-12-2007 ,Added pending status
73: G_PC_STS_PENDING CONSTANT VARCHAR2(8) := 'PENDING';

Line 70: G_IA_STS_INACTIVE CONSTANT VARCHAR2(8) := okl_pool_pvt.G_POL_STS_INACTIVE;

66:
67: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
68: G_IA_STS_NEW CONSTANT VARCHAR2(6) := okl_pool_pvt.G_POL_STS_NEW;
69: G_IA_STS_ACTIVE CONSTANT VARCHAR2(6) := okl_pool_pvt.G_POL_STS_ACTIVE;
70: G_IA_STS_INACTIVE CONSTANT VARCHAR2(8) := okl_pool_pvt.G_POL_STS_INACTIVE;
71: G_IA_STS_EXPIRED CONSTANT VARCHAR2(10) := okl_pool_pvt.G_POL_STS_EXPIRED;
72: --sosharma 14-12-2007 ,Added pending status
73: G_PC_STS_PENDING CONSTANT VARCHAR2(8) := 'PENDING';
74:

Line 71: G_IA_STS_EXPIRED CONSTANT VARCHAR2(10) := okl_pool_pvt.G_POL_STS_EXPIRED;

67: G_API_TYPE CONSTANT VARCHAR2(4) := '_PVT';
68: G_IA_STS_NEW CONSTANT VARCHAR2(6) := okl_pool_pvt.G_POL_STS_NEW;
69: G_IA_STS_ACTIVE CONSTANT VARCHAR2(6) := okl_pool_pvt.G_POL_STS_ACTIVE;
70: G_IA_STS_INACTIVE CONSTANT VARCHAR2(8) := okl_pool_pvt.G_POL_STS_INACTIVE;
71: G_IA_STS_EXPIRED CONSTANT VARCHAR2(10) := okl_pool_pvt.G_POL_STS_EXPIRED;
72: --sosharma 14-12-2007 ,Added pending status
73: G_PC_STS_PENDING CONSTANT VARCHAR2(8) := 'PENDING';
74:
75: -- Added by RGOOTY: Start 4371472

Line 8212: and ele.stream_element_date <= nvl(pcn.STREAMS_TO_DATE, OKL_POOL_PVT.G_FINAL_DATE)

8208: and stm.kle_id = p_kle_id
8209: and stm.sty_id = p_sty_id
8210: and pol.status_code = p_pool_status
8211: and ele.stream_element_date >= nvl(pcn.streams_from_date, ele.stream_element_date-1)
8212: and ele.stream_element_date <= nvl(pcn.STREAMS_TO_DATE, OKL_POOL_PVT.G_FINAL_DATE)
8213: AND pcn.status_code IN (G_IA_STS_ACTIVE,G_IA_STS_NEW) -- Added by VARANGAN -Pool Contents Impact - 26/11/07
8214: order by pcn.khr_id, pcn.kle_id, pcn.sty_id;
8215:
8216: sec_strms_rec sec_strms_csr%ROWTYPE;

Line 8271: and ele.stream_element_date <= nvl(pcn.STREAMS_TO_DATE, OKL_POOL_PVT.G_FINAL_DATE)

8267: and stm.kle_id = p_kle_id
8268: and stm.sty_id = p_sty_id
8269: and pol.status_code = p_pool_status
8270: and ele.stream_element_date >= nvl(pcn.streams_from_date, ele.stream_element_date-1)
8271: and ele.stream_element_date <= nvl(pcn.STREAMS_TO_DATE, OKL_POOL_PVT.G_FINAL_DATE)
8272: AND pcn.status_code = G_PC_STS_PENDING
8273: order by pcn.khr_id, pcn.kle_id, pcn.sty_id;
8274:
8275:

Line 8883: and ele.stream_element_date <= nvl(pcn.STREAMS_TO_DATE, OKL_POOL_PVT.G_FINAL_DATE)

8879: and stm.kle_id = p_kle_id
8880: and stm.sty_id = p_sty_id
8881: and pol.status_code = p_pool_status
8882: and ele.stream_element_date >= nvl(pcn.streams_from_date, ele.stream_element_date-1)
8883: and ele.stream_element_date <= nvl(pcn.STREAMS_TO_DATE, OKL_POOL_PVT.G_FINAL_DATE)
8884: order by ele.stream_element_date,pcn.khr_id, pcn.kle_id, pcn.sty_id;
8885:
8886: sec_strms_rec sec_strms_csr%ROWTYPE;
8887:

Line 8945: and ele.stream_element_date <= nvl(pcn.STREAMS_TO_DATE, OKL_POOL_PVT.G_FINAL_DATE)

8941: and stm.kle_id = p_kle_id
8942: and stm.sty_id = p_sty_id
8943: and pol.status_code = p_pool_status
8944: and ele.stream_element_date >= nvl(pcn.streams_from_date, ele.stream_element_date-1)
8945: and ele.stream_element_date <= nvl(pcn.STREAMS_TO_DATE, OKL_POOL_PVT.G_FINAL_DATE)
8946: order by ele.stream_element_date,pcn.khr_id, pcn.kle_id, pcn.sty_id;
8947:
8948:
8949: Cursor ylds_pend_csr( agmntID NUMBER, khrId NUMBER) IS