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 3924: l_sty_type_name OKL_STRM_TYPE_TL.NAME%TYPE;

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

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

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

Line 3954: FROM okl_strm_type_tl

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

Line 4567: l_sty_type_name OKL_STRM_TYPE_TL.NAME%TYPE;

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

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

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

Line 4591: FROM okl_strm_type_tl

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

Line 5049: l_sty_type_name OKL_STRM_TYPE_TL.NAME%TYPE;

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

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

5069: SELECT name
5070: FROM okl_trx_types_tl
5071: WHERE id = l_trx_type_id ;
5072:
5073: CURSOR sty_type_csr (l_sty_type_id OKL_STRM_TYPE_TL.ID%TYPE) IS
5074: SELECT name
5075: FROM okl_strm_type_tl
5076: WHERE id = l_sty_type_id ;
5077:

Line 5075: FROM okl_strm_type_tl

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