[Home] [Help]
636: l_prov_allowed VARCHAR2(1) ;
637: l_discard Boolean;
638: l_standard_yn VARCHAR2(1) ;
639: l_global_yn VARCHAR2(1) ;
640: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
641: l_art_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
642: k NUMBER := 0;
643:
644: TYPE SavSaeIdList IS TABLE OF OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE INDEX BY BINARY_INTEGER;
727: SELECT STANDARD_YN,ARTICLE_TITLE FROM OKC_ARTICLES_ALL
728: WHERE article_id=b_article_id;
729:
730: CURSOR l_get_global_csr IS
731: SELECT global_flag FROM OKC_TERMS_TEMPLATES_ALL
732: WHERE template_id=p_source_doc_id;
733:
734: CURSOR l_get_org_csr IS
735: SELECT org_id FROM OKC_TERMS_TEMPLATES_ALL
731: SELECT global_flag FROM OKC_TERMS_TEMPLATES_ALL
732: WHERE template_id=p_source_doc_id;
733:
734: CURSOR l_get_org_csr IS
735: SELECT org_id FROM OKC_TERMS_TEMPLATES_ALL
736: WHERE template_id=p_target_doc_id;
737:
738: CURSOR l_get_latest_article_csr(b_article_id NUMBER) IS
739: SELECT article_version_id FROM OKC_ARTICLE_VERSIONS
2617: l_api_name CONSTANT VARCHAR2(30) := 'copy_tc';
2618: l_dummy_var VARCHAR2(1) :='?';
2619: l_doc_type_name OKC_BUS_DOC_TYPES_V.NAME%TYPE;
2620: l_article_effective_date DATE;
2621: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;
2622: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE;
2623: l_document_id NUMBER;
2624: l_get_from_library VARCHAR2(1);
2625: l_no_terms_found BOOLEAN :=FALSE;
2635: WHERE template_id=p_source_doc_id
2636: AND document_type = p_target_doc_type;
2637:
2638: CURSOR l_get_tmpl_csr IS
2639: SELECT * FROM OKC_TERMS_TEMPLATES_ALL
2640: WHERE template_id=p_source_doc_id;
2641:
2642: CURSOR l_get_doc_type_name_csr IS
2643: SELECT name FROM OKC_BUS_DOC_TYPES_V