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 3923: l_trx_type_name OKL_TRX_TYPES_TL.NAME%TYPE;

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

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

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

Line 3947: FROM okl_trx_types_tl

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

Line 4566: l_trx_type_name OKL_TRX_TYPES_TL.NAME%TYPE;

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

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

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

Line 4584: FROM okl_trx_types_tl

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

Line 5048: l_trx_type_name OKL_TRX_TYPES_TL.NAME%TYPE;

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

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

5064: SELECT name
5065: FROM okl_products
5066: WHERE id = l_pdt_id ;
5067:
5068: CURSOR trx_type_csr (l_trx_type_id OKL_TRX_TYPES_TL.ID%TYPE) IS
5069: SELECT name
5070: FROM okl_trx_types_tl
5071: WHERE id = l_trx_type_id ;
5072:

Line 5070: FROM okl_trx_types_tl

5066: WHERE id = l_pdt_id ;
5067:
5068: CURSOR trx_type_csr (l_trx_type_id OKL_TRX_TYPES_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

Line 5107: l_try_name OKL_TRX_TYPES_TL.NAME%TYPE;

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