APPS.OKC_K_ARTICLE_PUB dependencies on OKC_TERMS_TEMPLATES_ALL

Line 607: SELECT TEMPLATE_ID FROM okc_terms_templates_all

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

Line 654: SELECT OKC_TERMS_TEMPLATES_ALL_S.NEXTVAL

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

Line 656: INSERT INTO OKC_TERMS_TEMPLATES_ALL(

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