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 72: G_IA_STS_NEW CONSTANT VARCHAR2(6) := okl_pool_pvt.G_POL_STS_NEW;

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

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

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

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

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

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

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

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

10663: and stm.kle_id = p_kle_id
10664: and stm.sty_id = p_sty_id
10665: and pol.status_code = p_pool_status
10666: and ele.stream_element_date >= nvl(pcn.streams_from_date, ele.stream_element_date-1)
10667: and ele.stream_element_date <= nvl(pcn.STREAMS_TO_DATE, OKL_POOL_PVT.G_FINAL_DATE)
10668: AND pcn.status_code IN (G_IA_STS_ACTIVE,G_IA_STS_NEW) -- Added by VARANGAN -Pool Contents Impact - 26/11/07
10669: order by pcn.khr_id, pcn.kle_id, pcn.sty_id;
10670:
10671: sec_strms_rec sec_strms_csr%ROWTYPE;

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

10722: and stm.kle_id = p_kle_id
10723: and stm.sty_id = p_sty_id
10724: and pol.status_code = p_pool_status
10725: and ele.stream_element_date >= nvl(pcn.streams_from_date, ele.stream_element_date-1)
10726: and ele.stream_element_date <= nvl(pcn.STREAMS_TO_DATE, OKL_POOL_PVT.G_FINAL_DATE)
10727: AND pcn.status_code = G_PC_STS_PENDING
10728: order by pcn.khr_id, pcn.kle_id, pcn.sty_id;
10729:
10730:

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

11334: and stm.kle_id = p_kle_id
11335: and stm.sty_id = p_sty_id
11336: and pol.status_code = p_pool_status
11337: and ele.stream_element_date >= nvl(pcn.streams_from_date, ele.stream_element_date-1)
11338: and ele.stream_element_date <= nvl(pcn.STREAMS_TO_DATE, OKL_POOL_PVT.G_FINAL_DATE)
11339: order by ele.stream_element_date,pcn.khr_id, pcn.kle_id, pcn.sty_id;
11340:
11341: sec_strms_rec sec_strms_csr%ROWTYPE;
11342:

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

11396: and stm.kle_id = p_kle_id
11397: and stm.sty_id = p_sty_id
11398: and pol.status_code = p_pool_status
11399: and ele.stream_element_date >= nvl(pcn.streams_from_date, ele.stream_element_date-1)
11400: and ele.stream_element_date <= nvl(pcn.STREAMS_TO_DATE, OKL_POOL_PVT.G_FINAL_DATE)
11401: order by ele.stream_element_date,pcn.khr_id, pcn.kle_id, pcn.sty_id;
11402:
11403:
11404: Cursor ylds_pend_csr( agmntID NUMBER, khrId NUMBER) IS