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_TERMS_UTIL_PVT dependencies on OKC_TERMS_TEMPLATES_ALL

Line 813: FROM okc_terms_templates_all

809: l_found BOOLEAN;
810:
811: CURSOR get_par_id_csr IS
812: SELECT parent_template_id
813: FROM okc_terms_templates_all
814: WHERE template_id=p_template_id;
815:
816: CURSOR atu_csr IS
817: SELECT template_id, document_type

Line 1906: FROM okc_terms_templates_all

1902: x_msg_count number;
1903:
1904: CURSOR editable_csr IS
1905: SELECT 1
1906: FROM okc_terms_templates_all
1907: WHERE template_id = p_template_id
1908: AND working_copy_flag = 'Y'
1909: UNION ALL
1910: SELECT 1

Line 2483: and lookup_code = (select xprt_scn_code from okc_terms_templates_all

2479:
2480: cursor get_expert_section_name(l_template_id NUMBER) is
2481: select meaning from fnd_lookups
2482: where lookup_type = 'OKC_ARTICLE_SECTION'
2483: and lookup_code = (select xprt_scn_code from okc_terms_templates_all
2484: where template_id = l_template_id);
2485:
2486: cursor get_unassigned_section_name is
2487: select meaning from fnd_lookups where lookup_type = 'OKC_ARTICLE_SECTION'

Line 2590: FROM OKC_TERMS_TEMPLATES_ALL

2586:
2587: -- effectivity date for templates
2588: CURSOR csr_template_effective_date IS
2589: SELECT start_date, end_date
2590: FROM OKC_TERMS_TEMPLATES_ALL
2591: WHERE template_id=p_document_id;
2592:
2593: CURSOR l_get_latest_article_csr(p_article_effective_date IN DATE) IS
2594: SELECT article_version_id ,

Line 2888: FROM okc_terms_templates_all t,

2884: ) RETURN NUMBER IS
2885:
2886: CURSOR l_org_id_csr IS
2887: SELECT t.org_id
2888: FROM okc_terms_templates_all t,
2889: okc_template_usages u
2890: WHERE t.template_id = u.template_id
2891: AND u.document_type = p_doc_type
2892: AND u.document_id = p_doc_id ;

Line 2896: FROM okc_terms_templates_all t

2892: AND u.document_id = p_doc_id ;
2893:
2894: CURSOR l_tmpl_org_id_csr IS
2895: SELECT t.org_id
2896: FROM okc_terms_templates_all t
2897: WHERE t.template_id = p_doc_id ;
2898:
2899: l_current_org_id NUMBER;
2900: l_api_name CONSTANT VARCHAR2(30) := 'get_current_org_id';

Line 3113: from okc_template_usages a ,okc_terms_templates_all b

3109: select a.template_id, b.template_name, a.article_effective_date,
3110: a.doc_numbering_scheme,
3111: a.config_header_id, a.config_revision_number,
3112: a.valid_config_yn, b.org_id
3113: from okc_template_usages a ,okc_terms_templates_all b
3114: where a.template_id = b.template_id
3115: and a.document_id = p_document_id and a.document_type = p_document_type;
3116:
3117: cursor l_get_dflt_tmpl_dtls_csr is

Line 3120: okc_allowed_tmpl_usages a, okc_terms_templates_all b

3116:
3117: cursor l_get_dflt_tmpl_dtls_csr is
3118: select a.template_id, b.template_name
3119: from
3120: okc_allowed_tmpl_usages a, okc_terms_templates_all b
3121: where a.template_id = b.template_id
3122: and a.default_yn = 'Y'
3123: and b.status_code = 'APPROVED'
3124: and a.document_type = p_document_type

Line 3804: l_start_date OKC.OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;

3800: l_section_name OKC.OKC_SECTIONS_B.HEADING%TYPE;
3801: l_article_label OKC.OKC_SECTIONS_B.LABEL%TYPE;
3802: l_multiple_sections VARCHAR2(1);
3803: l_return_status VARCHAR2(1);
3804: l_start_date OKC.OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
3805: l_end_date OKC.OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
3806: l_row_notfound BOOLEAN;
3807: l_user_id NUMBER;
3808: l_login_id NUMBER;

Line 3805: l_end_date OKC.OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;

3801: l_article_label OKC.OKC_SECTIONS_B.LABEL%TYPE;
3802: l_multiple_sections VARCHAR2(1);
3803: l_return_status VARCHAR2(1);
3804: l_start_date OKC.OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
3805: l_end_date OKC.OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
3806: l_row_notfound BOOLEAN;
3807: l_user_id NUMBER;
3808: l_login_id NUMBER;
3809:

Line 3813: FROM OKC_TERMS_TEMPLATES_ALL

3809:
3810:
3811: CURSOR template_csr (cp_template_id NUMBER) is
3812: SELECT START_DATE, END_DATE
3813: FROM OKC_TERMS_TEMPLATES_ALL
3814: WHERE TEMPLATE_ID = cp_template_id;
3815:
3816: /* no longer used
3817: CURSOR expert_clauses_csr (cp_org_id NUMBER, cp_effective_date DATE,

Line 4159: FROM okc_terms_templates_all tmpl,

4155: -- Fix for the bug# 5011432, reframed the cursor query
4156: CURSOR unadopted_art_chk_csr(lc_tmpl_id NUMBER,
4157: lc_org_id NUMBER) IS
4158: SELECT 'Y'
4159: FROM okc_terms_templates_all tmpl,
4160: okc_k_articles_b kart,
4161: okc_article_versions ver
4162: WHERE tmpl.template_id = lc_tmpl_id
4163: AND kart.document_id = tmpl.template_id

Line 4768: okc_terms_templates_all otta,

4764: CURSOR get_rep_lay_templ_csr IS
4765: SELECT
4766: xdb.template_code
4767: FROM
4768: okc_terms_templates_all otta,
4769: okc_template_usages_v otuv,
4770: xdo_templates_b xdb
4771: WHERE otuv.document_id = p_doc_id
4772: AND otuv.document_type = p_doc_type