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 240: l_status OKC_TERMS_TEMPLATES.STATUS_CODE%TYPE;

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

Line 247: SELECT STATUS_CODE FROM okc_terms_templates

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

Line 251: SELECT '!' FROM okc_terms_templates

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

Line 260: FROM okc_terms_templates

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

Line 338: -- Delete record from okc_terms_templates

334: RAISE FND_API.G_EXC_ERROR ;
335: END IF;
336: --------------------------------------------
337:
338: -- Delete record from okc_terms_templates
339: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
340: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3400: Delete each record from okc_terms_templates in a loop');
341: END IF;
342: FOR cr IN tt_csr LOOP

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

336: --------------------------------------------
337:
338: -- Delete record from okc_terms_templates
339: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
340: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3400: Delete each record from okc_terms_templates in a loop');
341: END IF;
342: FOR cr IN tt_csr LOOP
343: --------------------------------------------
344: -- Delete each record from okc_terms_templates for

Line 344: -- Delete each record from okc_terms_templates for

340: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3400: Delete each record from okc_terms_templates in a loop');
341: END IF;
342: FOR cr IN tt_csr LOOP
343: --------------------------------------------
344: -- Delete each record from okc_terms_templates for
345: --------------------------------------------
346: OKC_TERMS_TEMPLATES_PVT.Delete_Row(
347: x_return_status => x_return_status,
348: p_template_id => cr.template_id,

Line 346: OKC_TERMS_TEMPLATES_PVT.Delete_Row(

342: FOR cr IN tt_csr LOOP
343: --------------------------------------------
344: -- Delete each record from okc_terms_templates for
345: --------------------------------------------
346: OKC_TERMS_TEMPLATES_PVT.Delete_Row(
347: x_return_status => x_return_status,
348: p_template_id => cr.template_id,
349: p_object_version_number => cr.object_version_number
350: );

Line 569: l_status OKC_TERMS_TEMPLATES.STATUS_CODE%TYPE;

565: ) IS
566: l_api_version CONSTANT NUMBER := 1;
567: l_api_name CONSTANT VARCHAR2(30) := 'delete_doc_version';
568: l_found BOOLEAN;
569: l_status OKC_TERMS_TEMPLATES.STATUS_CODE%TYPE;
570: l_flag VARCHAR2(1);
571: l_objnum NUMBER;
572: l_msg_count NUMBER;
573: l_msg_data VARCHAR2(2000);

Line 729: -- Update each record from okc_terms_templates for

725: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4500: Update each record from okc_K_ARTICLES in a loop');
726: END IF;
727: FOR cr IN idlist_crs LOOP
728: --------------------------------------------
729: -- Update each record from okc_terms_templates for
730: --------------------------------------------
731: OKC_K_ARTICLES_GRP.Update_article(
732: p_api_version => 1,
733: p_init_msg_list => FND_API.G_FALSE ,

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

871: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
872: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5200: - Delete Base Template');
873: END IF;
874: --------------------------------------------
875: OKC_TERMS_TEMPLATES_PVT.Delete_Row(
876: x_return_status => x_return_status,
877: p_template_id => l_base_template_id,
878: p_object_version_number => NULL ,
879: p_delete_parent_yn => 'Y'

Line 997: OKC_TERMS_TEMPLATES_PVT.Update_Template_Id(

993: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
994: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'5700: Update Template Id of working template to old template');
995: END IF;
996:
997: OKC_TERMS_TEMPLATES_PVT.Update_Template_Id(
998: x_return_status => x_return_status,
999: p_old_template_id => p_template_id,
1000: p_new_template_id => l_base_template_id
1001: );

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