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 3924: l_product_name OKL_PRODUCTS.NAME%TYPE;

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

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

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

Line 3943: FROM okl_products

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

Line 4569: l_product_name OKL_PRODUCTS.NAME%TYPE;

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

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

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

Line 4582: FROM okl_products

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

Line 5051: l_product_name OKL_PRODUCTS.NAME%TYPE;

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

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

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

Line 5069: FROM okl_products

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