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

Line 243: l_status OKC_TERMS_TEMPLATES.STATUS_CODE%TYPE;

239: ) IS
240: l_api_version CONSTANT NUMBER := 1;
241: l_api_name CONSTANT VARCHAR2(30) := 'Delete_Doc';
242: l_found BOOLEAN;
243: l_status OKC_TERMS_TEMPLATES.STATUS_CODE%TYPE;
244: l_flag VARCHAR2(1);
245: l_objnum NUMBER;
246: l_msg_count NUMBER;
247: l_msg_data VARCHAR2(2000);

Line 250: SELECT STATUS_CODE FROM okc_terms_templates

246: l_msg_count NUMBER;
247: l_msg_data VARCHAR2(2000);
248:
249: CURSOR tmpl_sts_crs IS
250: SELECT STATUS_CODE FROM okc_terms_templates
251: WHERE TEMPLATE_ID = p_doc_id;
252:
253: CURSOR tmpl_prnt_crs IS
254: SELECT '!' FROM okc_terms_templates

Line 254: SELECT '!' FROM okc_terms_templates

250: SELECT STATUS_CODE FROM okc_terms_templates
251: WHERE TEMPLATE_ID = p_doc_id;
252:
253: CURSOR tmpl_prnt_crs IS
254: SELECT '!' FROM okc_terms_templates
255: WHERE parent_template_id = p_doc_id;
256:
257: CURSOR tmpl_usd_crs IS
258: SELECT '!' FROM okc_template_usages_v

Line 263: FROM okc_terms_templates

259: WHERE TEMPLATE_ID = p_doc_id AND ROWNUM=1;
260:
261: CURSOR tt_csr IS
262: SELECT TEMPLATE_ID, object_version_number,template_model_id
263: FROM okc_terms_templates
264: WHERE template_id=p_doc_id;
265:
266: CURSOR objnum_tu_csr IS
267: SELECT object_version_number

Line 346: -- Delete record from okc_terms_templates

342: RAISE FND_API.G_EXC_ERROR ;
343: END IF;
344: --------------------------------------------
345:
346: -- Delete record from okc_terms_templates
347: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
348: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3400: Delete each record from okc_terms_templates in a loop');
349: END IF;
350: FOR cr IN tt_csr LOOP

Line 348: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3400: Delete each record from okc_terms_templates in a loop');

344: --------------------------------------------
345:
346: -- Delete record from okc_terms_templates
347: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
348: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3400: Delete each record from okc_terms_templates in a loop');
349: END IF;
350: FOR cr IN tt_csr LOOP
351: --------------------------------------------
352: -- Delete each record from okc_terms_templates for

Line 352: -- Delete each record from okc_terms_templates for

348: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3400: Delete each record from okc_terms_templates in a loop');
349: END IF;
350: FOR cr IN tt_csr LOOP
351: --------------------------------------------
352: -- Delete each record from okc_terms_templates for
353: --------------------------------------------
354: OKC_TERMS_TEMPLATES_PVT.Delete_Row(
355: x_return_status => x_return_status,
356: p_template_id => cr.template_id,

Line 354: OKC_TERMS_TEMPLATES_PVT.Delete_Row(

350: FOR cr IN tt_csr LOOP
351: --------------------------------------------
352: -- Delete each record from okc_terms_templates for
353: --------------------------------------------
354: OKC_TERMS_TEMPLATES_PVT.Delete_Row(
355: x_return_status => x_return_status,
356: p_template_id => cr.template_id,
357: p_object_version_number => cr.object_version_number
358: );

Line 610: l_status OKC_TERMS_TEMPLATES.STATUS_CODE%TYPE;

606: ) IS
607: l_api_version CONSTANT NUMBER := 1;
608: l_api_name CONSTANT VARCHAR2(30) := 'delete_doc_version';
609: l_found BOOLEAN;
610: l_status OKC_TERMS_TEMPLATES.STATUS_CODE%TYPE;
611: l_flag VARCHAR2(1);
612: l_objnum NUMBER;
613: l_msg_count NUMBER;
614: l_msg_data VARCHAR2(2000);

Line 770: -- Update each record from okc_terms_templates for

766: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4500: Update each record from okc_K_ARTICLES in a loop');
767: END IF;
768: FOR cr IN idlist_crs LOOP
769: --------------------------------------------
770: -- Update each record from okc_terms_templates for
771: --------------------------------------------
772: OKC_K_ARTICLES_GRP.Update_article(
773: p_api_version => 1,
774: p_init_msg_list => FND_API.G_FALSE ,

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 916: OKC_TERMS_TEMPLATES_PVT.Delete_Row(

912: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
913: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5200: - Delete Base Template');
914: END IF;
915: --------------------------------------------
916: OKC_TERMS_TEMPLATES_PVT.Delete_Row(
917: x_return_status => x_return_status,
918: p_template_id => l_base_template_id,
919: p_object_version_number => NULL ,
920: p_delete_parent_yn => 'Y'

Line 1038: OKC_TERMS_TEMPLATES_PVT.Update_Template_Id(

1034: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1035: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5700: Update Template Id of working template to old template');
1036: END IF;
1037:
1038: OKC_TERMS_TEMPLATES_PVT.Update_Template_Id(
1039: x_return_status => x_return_status,
1040: p_old_template_id => p_template_id,
1041: p_new_template_id => l_base_template_id
1042: );

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