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_TRX_TYPES_TL

Line 2431: l_trx_type_name OKL_TRX_TYPES_TL.NAME%TYPE;

2427:
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:

Line 2452: CURSOR trx_type_csr (l_trx_type_id OKL_TRX_TYPES_TL.ID%TYPE) IS

2448: SELECT name
2449: FROM okl_products
2450: WHERE id = l_pdt_id ;
2451:
2452: CURSOR trx_type_csr (l_trx_type_id OKL_TRX_TYPES_TL.ID%TYPE) IS
2453: SELECT name
2454: FROM okl_trx_types_tl
2455: WHERE id = l_trx_type_id ;
2456:

Line 2454: FROM okl_trx_types_tl

2450: WHERE id = l_pdt_id ;
2451:
2452: CURSOR trx_type_csr (l_trx_type_id OKL_TRX_TYPES_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

Line 2475: l_try_name OKL_TRX_TYPES_TL.NAME%TYPE;

2471: l_gl_short_name GL_LEDGERS.SHORT_NAME%TYPE;
2472: l_tabv_tbl tabv_tbl_type ;
2473: l_tabv_tbl_out tabv_tbl_type ;
2474: x_tabv_tbl tabv_tbl_type ;
2475: l_try_name OKL_TRX_TYPES_TL.NAME%TYPE;
2476: l_tcnv_rec okl_sla_acc_sources_pvt.tehv_rec_type;
2477: l_tclv_rec okl_sla_acc_sources_pvt.telv_rec_type;
2478: l_tclv_tbl okl_sla_acc_sources_pvt.telv_tbl_type;
2479: l_tabv_tbl_final tabv_tbl_type;

Line 3925: l_trx_type_name OKL_TRX_TYPES_TL.NAME%TYPE;

3921:
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:

Line 3947: CURSOR trx_type_csr (l_trx_type_id OKL_TRX_TYPES_TL.ID%TYPE) IS

3943: FROM okl_products
3944: WHERE id = l_pdt_id ;
3945:
3946: -- Bug 4205156. SGIYER 07-MAR-05. Added language clause
3947: CURSOR trx_type_csr (l_trx_type_id OKL_TRX_TYPES_TL.ID%TYPE) IS
3948: SELECT name
3949: FROM okl_trx_types_tl
3950: WHERE id = l_trx_type_id
3951: AND language = USERENV('LANG');

Line 3949: FROM okl_trx_types_tl

3945:
3946: -- Bug 4205156. SGIYER 07-MAR-05. Added language clause
3947: CURSOR trx_type_csr (l_trx_type_id OKL_TRX_TYPES_TL.ID%TYPE) IS
3948: SELECT name
3949: FROM okl_trx_types_tl
3950: WHERE id = l_trx_type_id
3951: AND language = USERENV('LANG');
3952:
3953: -- Bug 4205156. SGIYER 07-MAR-05. Added language clause

Line 4570: l_trx_type_name OKL_TRX_TYPES_TL.NAME%TYPE;

4566:
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

Line 4586: CURSOR trx_type_csr (l_trx_type_id OKL_TRX_TYPES_TL.ID%TYPE) IS

4582: FROM okl_products
4583: WHERE id = l_pdt_id ;
4584:
4585: -- Bug 4205156. SGIYER 07-MAR-05. Added language clause
4586: CURSOR trx_type_csr (l_trx_type_id OKL_TRX_TYPES_TL.ID%TYPE) IS
4587: SELECT name
4588: FROM okl_trx_types_tl
4589: WHERE id = l_trx_type_id
4590: AND language = USERENV('LANG');

Line 4588: FROM okl_trx_types_tl

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

Line 5052: l_trx_type_name OKL_TRX_TYPES_TL.NAME%TYPE;

5048:
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:

Line 5072: CURSOR trx_type_csr (l_trx_type_id OKL_TRX_TYPES_TL.ID%TYPE) IS

5068: SELECT name
5069: FROM okl_products
5070: WHERE id = l_pdt_id ;
5071:
5072: CURSOR trx_type_csr (l_trx_type_id OKL_TRX_TYPES_TL.ID%TYPE) IS
5073: SELECT name
5074: FROM okl_trx_types_tl
5075: WHERE id = l_trx_type_id ;
5076:

Line 5074: FROM okl_trx_types_tl

5070: WHERE id = l_pdt_id ;
5071:
5072: CURSOR trx_type_csr (l_trx_type_id OKL_TRX_TYPES_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

Line 5111: l_try_name OKL_TRX_TYPES_TL.NAME%TYPE;

5107: l_tcnv_rec okl_sla_acc_sources_pvt.tehv_rec_type;
5108: l_tclv_tbl okl_sla_acc_sources_pvt.telv_tbl_type;
5109: l_tclv_tbl_final okl_sla_acc_sources_pvt.telv_tbl_type;
5110: x_tclv_tbl okl_sla_acc_sources_pvt.telv_tbl_type;
5111: l_try_name OKL_TRX_TYPES_TL.NAME%TYPE;
5112: l_source_table VARCHAR2(30);
5113: l_asev_rec asev_rec_type;
5114: l_asev_tbl asev_tbl_type;
5115: l_asev_count NUMBER := 0;