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_PRODUCTS

Line 367: FROM OKL_PRODUCTS_V

363: l_rev_rec_flag VARCHAR2(1) := NVL(P_TMPL_IDENTIFY_REC.REV_REC_FLAG, 'N');
364:
365: CURSOR prod_csr(v_prod_id NUMBER) IS
366: SELECT aes_id
367: FROM OKL_PRODUCTS_V
368: WHERE ID = v_prod_id;
369:
370: BEGIN
371: IF (G_DEBUG_ENABLED = 'Y') THEN

Line 2430: l_product_name OKL_PRODUCTS.NAME%TYPE;

2426: l_api_version NUMBER := 1.0;
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

Line 2447: CURSOR prdt_csr (l_pdt_id OKL_PRODUCTS.ID%TYPE) IS

2443: WHERE id = v_id;
2444:
2445: -- Added by Santonyr on 30-Jul-2003 to fix the bug 2941805
2446:
2447: CURSOR prdt_csr (l_pdt_id OKL_PRODUCTS.ID%TYPE) IS
2448: SELECT name
2449: FROM okl_products
2450: WHERE id = l_pdt_id ;
2451:

Line 2449: FROM okl_products

2445: -- Added by Santonyr on 30-Jul-2003 to fix the bug 2941805
2446:
2447: CURSOR prdt_csr (l_pdt_id OKL_PRODUCTS.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

Line 3922: l_product_name OKL_PRODUCTS.NAME%TYPE;

3918: l_api_version NUMBER := 1.0;
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

Line 3939: CURSOR prdt_csr (l_pdt_id OKL_PRODUCTS.ID%TYPE) IS

3935: WHERE id = v_id;
3936:
3937: -- Added by Santonyr on 30-Jul-2003 to fix the bug 2941805
3938:
3939: CURSOR prdt_csr (l_pdt_id OKL_PRODUCTS.ID%TYPE) IS
3940: SELECT name
3941: FROM okl_products
3942: WHERE id = l_pdt_id ;
3943:

Line 3941: FROM okl_products

3937: -- Added by Santonyr on 30-Jul-2003 to fix the bug 2941805
3938:
3939: CURSOR prdt_csr (l_pdt_id OKL_PRODUCTS.ID%TYPE) IS
3940: SELECT name
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

Line 4565: l_product_name OKL_PRODUCTS.NAME%TYPE;

4561: l_api_version NUMBER := 1.0;
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

Line 4576: CURSOR prdt_csr (l_pdt_id OKL_PRODUCTS.ID%TYPE) IS

4572: WHERE id = v_id;
4573:
4574: -- Added by Santonyr on 30-Jul-2003 to fix the bug 2941805
4575:
4576: CURSOR prdt_csr (l_pdt_id OKL_PRODUCTS.ID%TYPE) IS
4577: SELECT name
4578: FROM okl_products
4579: WHERE id = l_pdt_id ;
4580:

Line 4578: FROM okl_products

4574: -- Added by Santonyr on 30-Jul-2003 to fix the bug 2941805
4575:
4576: CURSOR prdt_csr (l_pdt_id OKL_PRODUCTS.ID%TYPE) IS
4577: SELECT name
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

Line 5047: l_product_name OKL_PRODUCTS.NAME%TYPE;

5043: l_api_version NUMBER := 1.0;
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

Line 5063: CURSOR prdt_csr (l_pdt_id OKL_PRODUCTS.ID%TYPE) IS

5059: WHERE id = v_id;
5060:
5061: -- Added by Santonyr on 30-Jul-2003 to fix the bug 2941805
5062:
5063: CURSOR prdt_csr (l_pdt_id OKL_PRODUCTS.ID%TYPE) IS
5064: SELECT name
5065: FROM okl_products
5066: WHERE id = l_pdt_id ;
5067:

Line 5065: FROM okl_products

5061: -- Added by Santonyr on 30-Jul-2003 to fix the bug 2941805
5062:
5063: CURSOR prdt_csr (l_pdt_id OKL_PRODUCTS.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