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.OKC_XPRT_UTIL_PVT dependencies on OKC_SECTIONS_B

Line 7827: l_scn_code okc_sections_b.scn_code%TYPE;

7823: l_api_name CONSTANT VARCHAR2(30) := 'get_article_details';
7824:
7825: l_xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE;
7826: l_def_scn_code okc_article_versions.default_section%TYPE;
7827: l_scn_code okc_sections_b.scn_code%TYPE;
7828:
7829:
7830: l_article_number OKC_ARTICLES_ALL.article_number%TYPE;
7831:

Line 7865: SELECT heading FROM OKC_SECTIONS_B

7861: AND u.document_type = p_document_type
7862: AND u.document_id = p_document_id ;
7863:
7864: CURSOR l_get_lib_scn_csr(b_scn_code VARCHAR2) IS
7865: SELECT heading FROM OKC_SECTIONS_B
7866: WHERE scn_code = b_scn_code
7867: AND rownum=1 ;
7868:
7869: -- From Document

Line 7873: FROM OKC_SECTIONS_B scn,

7869: -- From Document
7870:
7871: CURSOR l_get_doc_scn_csr (b_article_version_id NUMBER) IS
7872: SELECT scn.heading
7873: FROM OKC_SECTIONS_B scn,
7874: OKC_K_ARTICLES_B art
7875: WHERE art.document_type=p_document_type
7876: AND art.document_id =p_document_id
7877: AND art.article_version_id = b_article_version_id --Bug#4757731 replaced art.sav_sae_id with art.article_version_id