[Home] [Help]
398: l_prov_allowed VARCHAR2(1) ;
399: l_discard Boolean;
400: l_standard_yn VARCHAR2(1) ;
401: l_global_yn VARCHAR2(1) ;
402: l_org_id OKC_TERMS_TEMPLATES_ALL.ORG_ID%TYPE;
403: l_art_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE;
404: k NUMBER := 0;
405:
406: TYPE SavSaeIdList IS TABLE OF OKC_K_ARTICLES_B.SAV_SAE_ID%TYPE INDEX BY BINARY_INTEGER;
486: SELECT STANDARD_YN,ARTICLE_TITLE FROM OKC_ARTICLES_ALL
487: WHERE article_id=b_article_id;
488:
489: CURSOR l_get_global_csr IS
490: SELECT global_flag FROM OKC_TERMS_TEMPLATES_ALL
491: WHERE template_id=p_source_doc_id;
492:
493: CURSOR l_get_org_csr IS
494: SELECT org_id FROM OKC_TERMS_TEMPLATES_ALL
490: SELECT global_flag FROM OKC_TERMS_TEMPLATES_ALL
491: WHERE template_id=p_source_doc_id;
492:
493: CURSOR l_get_org_csr IS
494: SELECT org_id FROM OKC_TERMS_TEMPLATES_ALL
495: WHERE template_id=p_target_doc_id;
496:
497: CURSOR l_get_latest_article_csr(b_article_id NUMBER) IS
498: SELECT article_version_id FROM OKC_ARTICLE_VERSIONS
2046: l_api_name CONSTANT VARCHAR2(30) := 'copy_tc';
2047: l_dummy_var VARCHAR2(1) :='?';
2048: l_doc_type_name OKC_BUS_DOC_TYPES_V.NAME%TYPE;
2049: l_article_effective_date DATE;
2050: l_template_id OKC_TERMS_TEMPLATES_ALL.TEMPLATE_ID%TYPE;
2051: l_document_type OKC_BUS_DOC_TYPES_B.DOCUMENT_TYPE%TYPE;
2052: l_document_id NUMBER;
2053: l_get_from_library VARCHAR2(1);
2054: l_no_terms_found BOOLEAN :=FALSE;
2064: WHERE template_id=p_source_doc_id
2065: AND document_type = p_target_doc_type;
2066:
2067: CURSOR l_get_tmpl_csr IS
2068: SELECT * FROM OKC_TERMS_TEMPLATES_ALL
2069: WHERE template_id=p_source_doc_id;
2070:
2071: CURSOR l_get_doc_type_name_csr IS
2072: SELECT name FROM OKC_BUS_DOC_TYPES_V