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_ACCOUNT_DIST_PVT dependencies on OKL_STRM_TYPE_TL

Line 2432: l_sty_type_name OKL_STRM_TYPE_TL.NAME%TYPE;

2428: -- Added by Santonyr on 30-Jul-2003 to fix the bug 2941805
2429:
2430: l_product_name OKL_PRODUCTS.NAME%TYPE;
2431: l_trx_type_name OKL_TRX_TYPES_TL.NAME%TYPE;
2432: l_sty_type_name OKL_STRM_TYPE_TL.NAME%TYPE;
2433:
2434: -- Added by Santonyr on 12-Jul-2440 for the bug 3761026
2435:
2436: l_template_amount_tbl template_amount_tbl_type;

Line 2457: CURSOR sty_type_csr (l_sty_type_id OKL_STRM_TYPE_TL.ID%TYPE) IS

2453: SELECT name
2454: FROM okl_trx_types_tl
2455: WHERE id = l_trx_type_id ;
2456:
2457: CURSOR sty_type_csr (l_sty_type_id OKL_STRM_TYPE_TL.ID%TYPE) IS
2458: SELECT name
2459: FROM okl_strm_type_tl
2460: WHERE id = l_sty_type_id ;
2461:

Line 2459: FROM okl_strm_type_tl

2455: WHERE id = l_trx_type_id ;
2456:
2457: CURSOR sty_type_csr (l_sty_type_id OKL_STRM_TYPE_TL.ID%TYPE) IS
2458: SELECT name
2459: FROM okl_strm_type_tl
2460: WHERE id = l_sty_type_id ;
2461:
2462: --Added by kthiruva on 06-Feb-2007 for SLA Uptake
2463: --Bug 5707866 - Start of Changes

Line 3926: l_sty_type_name OKL_STRM_TYPE_TL.NAME%TYPE;

3922: -- Added by Santonyr on 30-Jul-2003 to fix the bug 2941805
3923:
3924: l_product_name OKL_PRODUCTS.NAME%TYPE;
3925: l_trx_type_name OKL_TRX_TYPES_TL.NAME%TYPE;
3926: l_sty_type_name OKL_STRM_TYPE_TL.NAME%TYPE;
3927:
3928: -- Added by Santonyr on 12-Jul-2440 for the bug 3761026
3929:
3930: l_template_amount_tbl tmp_bulk_amount_tbl_type;

Line 3954: CURSOR sty_type_csr (l_sty_type_id OKL_STRM_TYPE_TL.ID%TYPE) IS

3950: WHERE id = l_trx_type_id
3951: AND language = USERENV('LANG');
3952:
3953: -- Bug 4205156. SGIYER 07-MAR-05. Added language clause
3954: CURSOR sty_type_csr (l_sty_type_id OKL_STRM_TYPE_TL.ID%TYPE) IS
3955: SELECT name
3956: FROM okl_strm_type_tl
3957: WHERE id = l_sty_type_id
3958: AND language = USERENV('LANG');

Line 3956: FROM okl_strm_type_tl

3952:
3953: -- Bug 4205156. SGIYER 07-MAR-05. Added language clause
3954: CURSOR sty_type_csr (l_sty_type_id OKL_STRM_TYPE_TL.ID%TYPE) IS
3955: SELECT name
3956: FROM okl_strm_type_tl
3957: WHERE id = l_sty_type_id
3958: AND language = USERENV('LANG');
3959:
3960: l_dist_info_tbl DIST_INFO_TBL_TYPE:= p_dist_info_tbl;

Line 4571: l_sty_type_name OKL_STRM_TYPE_TL.NAME%TYPE;

4567: -- Added by Santonyr on 30-Jul-2003 to fix the bug 2941805
4568:
4569: l_product_name OKL_PRODUCTS.NAME%TYPE;
4570: l_trx_type_name OKL_TRX_TYPES_TL.NAME%TYPE;
4571: l_sty_type_name OKL_STRM_TYPE_TL.NAME%TYPE;
4572:
4573: CURSOR frml_csr(v_id NUMBER) IS
4574: SELECT name
4575: FROM okl_formulae_v

Line 4593: CURSOR sty_type_csr (l_sty_type_id OKL_STRM_TYPE_TL.ID%TYPE) IS

4589: WHERE id = l_trx_type_id
4590: AND language = USERENV('LANG');
4591:
4592: -- Bug 4205156. SGIYER 07-MAR-05. Added language clause
4593: CURSOR sty_type_csr (l_sty_type_id OKL_STRM_TYPE_TL.ID%TYPE) IS
4594: SELECT name
4595: FROM okl_strm_type_tl
4596: WHERE id = l_sty_type_id
4597: AND language = USERENV('LANG');

Line 4595: FROM okl_strm_type_tl

4591:
4592: -- Bug 4205156. SGIYER 07-MAR-05. Added language clause
4593: CURSOR sty_type_csr (l_sty_type_id OKL_STRM_TYPE_TL.ID%TYPE) IS
4594: SELECT name
4595: FROM okl_strm_type_tl
4596: WHERE id = l_sty_type_id
4597: AND language = USERENV('LANG');
4598:
4599: l_dist_info_tbl DIST_INFO_TBL_TYPE:= p_dist_info_tbl;

Line 5053: l_sty_type_name OKL_STRM_TYPE_TL.NAME%TYPE;

5049: -- Added by Santonyr on 30-Jul-2003 to fix the bug 2941805
5050:
5051: l_product_name OKL_PRODUCTS.NAME%TYPE;
5052: l_trx_type_name OKL_TRX_TYPES_TL.NAME%TYPE;
5053: l_sty_type_name OKL_STRM_TYPE_TL.NAME%TYPE;
5054:
5055: -- Added by Santonyr on 12-Jul-2440 for the bug 3761026
5056:
5057: l_template_amount_tbl template_amount_tbl_type;

Line 5077: CURSOR sty_type_csr (l_sty_type_id OKL_STRM_TYPE_TL.ID%TYPE) IS

5073: SELECT name
5074: FROM okl_trx_types_tl
5075: WHERE id = l_trx_type_id ;
5076:
5077: CURSOR sty_type_csr (l_sty_type_id OKL_STRM_TYPE_TL.ID%TYPE) IS
5078: SELECT name
5079: FROM okl_strm_type_tl
5080: WHERE id = l_sty_type_id ;
5081:

Line 5079: FROM okl_strm_type_tl

5075: WHERE id = l_trx_type_id ;
5076:
5077: CURSOR sty_type_csr (l_sty_type_id OKL_STRM_TYPE_TL.ID%TYPE) IS
5078: SELECT name
5079: FROM okl_strm_type_tl
5080: WHERE id = l_sty_type_id ;
5081:
5082: --Added by kthiruva on 06-Feb-2007 for SLA Uptake
5083: --Bug 5707866 - Start of Changes