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 7544: l_scn_code okc_sections_b.scn_code%TYPE;

7540: l_api_name CONSTANT VARCHAR2(30) := 'get_article_details';
7541:
7542: l_xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE;
7543: l_def_scn_code okc_article_versions.default_section%TYPE;
7544: l_scn_code okc_sections_b.scn_code%TYPE;
7545:
7546:
7547: --Bug#4757731 cursor to get clause title and clause description
7548: CURSOR csr_clause_details(b_article_id NUMBER, b_article_version_id NUMBER) IS

Line 7580: SELECT heading FROM OKC_SECTIONS_B

7576: AND u.document_type = p_document_type
7577: AND u.document_id = p_document_id ;
7578:
7579: CURSOR l_get_lib_scn_csr(b_scn_code VARCHAR2) IS
7580: SELECT heading FROM OKC_SECTIONS_B
7581: WHERE scn_code = b_scn_code
7582: AND rownum=1 ;
7583:
7584: -- From Document

Line 7588: FROM OKC_SECTIONS_B scn,

7584: -- From Document
7585:
7586: CURSOR l_get_doc_scn_csr (b_article_version_id NUMBER) IS
7587: SELECT scn.heading
7588: FROM OKC_SECTIONS_B scn,
7589: OKC_K_ARTICLES_B art
7590: WHERE art.document_type=p_document_type
7591: AND art.document_id =p_document_id
7592: AND art.article_version_id = b_article_version_id --Bug#4757731 replaced art.sav_sae_id with art.article_version_id