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 854: FROM okc_terms_templates_all

850: l_found BOOLEAN;
851:
852: CURSOR get_par_id_csr IS
853: SELECT parent_template_id
854: FROM okc_terms_templates_all
855: WHERE template_id=p_template_id;
856:
857: CURSOR atu_csr IS
858: SELECT template_id, document_type

Line 1948: FROM okc_terms_templates_all

1944: x_msg_count number;
1945:
1946: CURSOR editable_csr IS
1947: SELECT 1
1948: FROM okc_terms_templates_all
1949: WHERE template_id = p_template_id
1950: AND working_copy_flag = 'Y'
1951: UNION ALL
1952: SELECT 1

Line 2525: and lookup_code = (select xprt_scn_code from okc_terms_templates_all

2521:
2522: cursor get_expert_section_name(l_template_id NUMBER) is
2523: select meaning from fnd_lookups
2524: where lookup_type = 'OKC_ARTICLE_SECTION'
2525: and lookup_code = (select xprt_scn_code from okc_terms_templates_all
2526: where template_id = l_template_id);
2527:
2528: cursor get_unassigned_section_name is
2529: select meaning from fnd_lookups where lookup_type = 'OKC_ARTICLE_SECTION'

Line 2632: FROM OKC_TERMS_TEMPLATES_ALL

2628:
2629: -- effectivity date for templates
2630: CURSOR csr_template_effective_date IS
2631: SELECT start_date, end_date
2632: FROM OKC_TERMS_TEMPLATES_ALL
2633: WHERE template_id=p_document_id;
2634:
2635: CURSOR l_get_latest_article_csr(p_article_effective_date IN DATE) IS
2636: SELECT article_version_id ,

Line 2930: FROM okc_terms_templates_all t,

2926: ) RETURN NUMBER IS
2927:
2928: CURSOR l_org_id_csr IS
2929: SELECT t.org_id
2930: FROM okc_terms_templates_all t,
2931: okc_template_usages u
2932: WHERE t.template_id = u.template_id
2933: AND u.document_type = p_doc_type
2934: AND u.document_id = p_doc_id ;

Line 2938: FROM okc_terms_templates_all t

2934: AND u.document_id = p_doc_id ;
2935:
2936: CURSOR l_tmpl_org_id_csr IS
2937: SELECT t.org_id
2938: FROM okc_terms_templates_all t
2939: WHERE t.template_id = p_doc_id ;
2940:
2941: l_current_org_id NUMBER;
2942: l_api_name CONSTANT VARCHAR2(30) := 'get_current_org_id';

Line 3155: from okc_template_usages a ,okc_terms_templates_all b

3151: select a.template_id, b.template_name, a.article_effective_date,
3152: a.doc_numbering_scheme,
3153: a.config_header_id, a.config_revision_number,
3154: a.valid_config_yn, b.org_id
3155: from okc_template_usages a ,okc_terms_templates_all b
3156: where a.template_id = b.template_id
3157: and a.document_id = p_document_id and a.document_type = p_document_type;
3158:
3159: cursor l_get_dflt_tmpl_dtls_csr is

Line 3162: okc_allowed_tmpl_usages a, okc_terms_templates_all b

3158:
3159: cursor l_get_dflt_tmpl_dtls_csr is
3160: select a.template_id, b.template_name
3161: from
3162: okc_allowed_tmpl_usages a, okc_terms_templates_all b
3163: where a.template_id = b.template_id
3164: and a.default_yn = 'Y'
3165: and b.status_code = 'APPROVED'
3166: and a.document_type = p_document_type

Line 3853: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;

3849: l_section_name OKC_SECTIONS_B.HEADING%TYPE;
3850: l_article_label OKC_SECTIONS_B.LABEL%TYPE;
3851: l_multiple_sections VARCHAR2(1);
3852: l_return_status VARCHAR2(1);
3853: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
3854: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
3855: l_row_notfound BOOLEAN;
3856: l_user_id NUMBER;
3857: l_login_id NUMBER;

Line 3854: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;

3850: l_article_label OKC_SECTIONS_B.LABEL%TYPE;
3851: l_multiple_sections VARCHAR2(1);
3852: l_return_status VARCHAR2(1);
3853: l_start_date OKC_TERMS_TEMPLATES_ALL.START_DATE%TYPE;
3854: l_end_date OKC_TERMS_TEMPLATES_ALL.END_DATE%TYPE;
3855: l_row_notfound BOOLEAN;
3856: l_user_id NUMBER;
3857: l_login_id NUMBER;
3858:

Line 3862: FROM OKC_TERMS_TEMPLATES_ALL

3858:
3859:
3860: CURSOR template_csr (cp_template_id NUMBER) is
3861: SELECT START_DATE, END_DATE
3862: FROM OKC_TERMS_TEMPLATES_ALL
3863: WHERE TEMPLATE_ID = cp_template_id;
3864:
3865: /* no longer used
3866: CURSOR expert_clauses_csr (cp_org_id NUMBER, cp_effective_date DATE,

Line 4208: FROM okc_terms_templates_all tmpl,

4204: -- Fix for the bug# 5011432, reframed the cursor query
4205: CURSOR unadopted_art_chk_csr(lc_tmpl_id NUMBER,
4206: lc_org_id NUMBER) IS
4207: SELECT 'Y'
4208: FROM okc_terms_templates_all tmpl,
4209: okc_k_articles_b kart,
4210: okc_article_versions ver
4211: WHERE tmpl.template_id = lc_tmpl_id
4212: AND kart.document_id = tmpl.template_id

Line 4817: okc_terms_templates_all otta,

4813: CURSOR get_rep_lay_templ_csr IS
4814: SELECT
4815: xdb.template_code
4816: FROM
4817: okc_terms_templates_all otta,
4818: okc_template_usages_v otuv,
4819: xdo_templates_b xdb
4820: WHERE otuv.document_id = p_doc_id
4821: AND otuv.document_type = p_doc_type