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_CONTRACT_PVT dependencies on OKL_PRODUCTS

Line 527: From okl_products pdt,

523: --Cursor to find out the product from_date and to_date
524: Cursor pdt_dts_csr(p_chr_id IN NUMBER) IS
525: Select pdt.from_date,
526: pdt.to_date
527: From okl_products pdt,
528: okl_k_headers khr
529: where pdt.id = khr.pdt_id
530: and khr.id = p_chr_id;
531:

Line 532: l_pdt_to_date okl_products.to_date%TYPE;

528: okl_k_headers khr
529: where pdt.id = khr.pdt_id
530: and khr.id = p_chr_id;
531:
532: l_pdt_to_date okl_products.to_date%TYPE;
533: l_pdt_from_date okl_products.from_date%TYPE;
534:
535: l_new_start_date date;
536: l_new_end_date date;

Line 533: l_pdt_from_date okl_products.from_date%TYPE;

529: where pdt.id = khr.pdt_id
530: and khr.id = p_chr_id;
531:
532: l_pdt_to_date okl_products.to_date%TYPE;
533: l_pdt_from_date okl_products.from_date%TYPE;
534:
535: l_new_start_date date;
536: l_new_end_date date;
537:

Line 1752: From OKL_PRODUCTS_V

1748:
1749: --cursor to get product name for exception conditions
1750: Cursor get_pdtname_csr (pdtid in Number) is
1751: Select name
1752: From OKL_PRODUCTS_V
1753: Where id = pdtid;
1754:
1755: l_pdt_name OKL_PRODUCTS_V.NAME%TYPE default null;
1756:

Line 1755: l_pdt_name OKL_PRODUCTS_V.NAME%TYPE default null;

1751: Select name
1752: From OKL_PRODUCTS_V
1753: Where id = pdtid;
1754:
1755: l_pdt_name OKL_PRODUCTS_V.NAME%TYPE default null;
1756:
1757: --Bug#2727161 : 11.5.9 Rebooks - product can not be modified
1758: -- cursor to get product of the original contract
1759: Cursor ger_orig_pdt_csr(p_rbk_chr_id IN NUMBER) is