APPS.OKC_K_ARTICLE_PUB dependencies on OKC_TERMS_TEMPLATES_ALL

Line 604: SELECT TEMPLATE_ID FROM okc_terms_templates_all

600: CURSOR get_doc_usage_crs IS
601: SELECT TEMPLATE_ID FROM okc_template_usages_v
602: WHERE document_type = p_doc_type AND document_id = p_doc_id ;
603: CURSOR get_apps_upg_tmpl_id_crs IS
604: SELECT TEMPLATE_ID FROM okc_terms_templates_all
605: WHERE template_name = l_tmpl_name and nvl(org_id,-99)=nvl(l_org_id,-99);
606: BEGIN
607: IF (l_debug = 'Y') THEN
608: okc_debug.Set_Indentation(G_PKG_NAME);

Line 651: SELECT OKC_TERMS_TEMPLATES_ALL_S.NEXTVAL

647: OPEN get_apps_upg_tmpl_id_crs;
648: FETCH get_apps_upg_tmpl_id_crs INTO l_tmpl_id;
649: CLOSE get_apps_upg_tmpl_id_crs;
650: IF l_tmpl_id IS NULL THEN
651: SELECT OKC_TERMS_TEMPLATES_ALL_S.NEXTVAL
652: INTO l_tmpl_id FROM DUAL;
653: INSERT INTO OKC_TERMS_TEMPLATES_ALL(
654: TEMPLATE_NAME,
655: TEMPLATE_ID,

Line 653: INSERT INTO OKC_TERMS_TEMPLATES_ALL(

649: CLOSE get_apps_upg_tmpl_id_crs;
650: IF l_tmpl_id IS NULL THEN
651: SELECT OKC_TERMS_TEMPLATES_ALL_S.NEXTVAL
652: INTO l_tmpl_id FROM DUAL;
653: INSERT INTO OKC_TERMS_TEMPLATES_ALL(
654: TEMPLATE_NAME,
655: TEMPLATE_ID,
656: WORKING_COPY_FLAG,
657: INTENT,