1002: SELECT vers.article_id article_id,
1003: vers.article_version_id article_version_id,
1004: nvl(vers.default_section,'UNASSIGNED') scn_code,
1005: nvl(PROVISION_YN,'N') provision_yn
1006: FROM OKC_ARTICLE_VERSIONS VERS
1007: WHERE vers.article_id = b_article_id
1008: AND article_status in ('ON_HOLD','APPROVED')
1009: AND b_article_effective_date >= vers.start_date
1010: AND b_article_effective_date <= nvl(vers.end_date,b_article_effective_date+1);
1013: SELECT article_id,
1014: article_version_id,
1015: nvl(vers.default_section,'UNASSIGNED') scn_code,
1016: nvl(PROVISION_YN,'N') provision_yn
1017: FROM OKC_ARTICLE_VERSIONS VERS
1018: WHERE article_id= b_article_id
1019: AND article_status in ('ON_HOLD','APPROVED')
1020: AND start_date = (select max(start_date) FROM OKC_ARTICLE_VERSIONS
1021: WHERE article_id= b_article_id
1016: nvl(PROVISION_YN,'N') provision_yn
1017: FROM OKC_ARTICLE_VERSIONS VERS
1018: WHERE article_id= b_article_id
1019: AND article_status in ('ON_HOLD','APPROVED')
1020: AND start_date = (select max(start_date) FROM OKC_ARTICLE_VERSIONS
1021: WHERE article_id= b_article_id
1022: AND article_status in ('ON_HOLD','APPROVED') );
1023:
1024: CURSOR l_get_scn_csr(b_scn_code VARCHAR2) IS
1107: SELECT VERS.ARTICLE_ID article_id,
1108: ADP.GLOBAL_ARTICLE_VERSION_ID article_version_id,
1109: NVL(VERS.default_section,'UNASSIGNED') scn_code,
1110: NVL(VERS.PROVISION_YN,'N') provision_yn
1111: FROM OKC_ARTICLE_VERSIONS VERS,
1112: OKC_ARTICLE_ADOPTIONS ADP
1113: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
1114: AND VERS.ARTICLE_ID = b_article_id
1115: AND nvl(b_article_effective_date,sysdate) >= VERS.START_DATE
1124: SELECT VERS.ARTICLE_ID article_id,
1125: ADP.GLOBAL_ARTICLE_VERSION_ID article_version_id,
1126: NVL(VERS.default_section,'UNASSIGNED') scn_code,
1127: NVL(VERS.PROVISION_YN,'N') provision_yn
1128: FROM OKC_ARTICLE_VERSIONS VERS,
1129: OKC_ARTICLE_ADOPTIONS ADP
1130: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
1131: AND VERS.ARTICLE_ID = b_article_id
1132: AND VERS.ARTICLE_STATUS IN ('ON_HOLD','APPROVED')
1990:
1991: l_article_id NUMBER;
1992:
1993: CURSOR l_check_version(b_article_version_id NUMBER) IS
1994: SELECT article_id , 'x' FROM OKC_ARTICLE_VERSIONS
1995: WHERE article_version_id=b_article_version_id;
1996:
1997: BEGIN
1998:
2894: CURSOR article_properties(b_review_upld_terms_id NUMBER) is
2895: SELECT av.insert_by_reference,
2896: akb.mandatory_yn,
2897: av.lock_text
2898: FROM okc_article_versions av, okc_review_upld_terms ar, okc_k_articles_b akb
2899: WHERE av.article_version_id = ar.article_version_id
2900: AND akb.id = ar.object_id
2901: AND ar.review_upld_terms_id = b_review_upld_terms_id;
2902: