APPS.OKC_TERMS_COPY_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 739: SELECT article_version_id FROM OKC_ARTICLE_VERSIONS

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
740: WHERE article_id= b_article_id
741: AND article_status in ('ON_HOLD','APPROVED')
742: AND nvl(p_article_effective_date,sysdate) >= Start_date
743: AND nvl(p_article_effective_date,sysdate) <= nvl(end_date, nvl(p_article_effective_date,sysdate) +1);

Line 746: SELECT article_version_id FROM OKC_ARTICLE_VERSIONS

742: AND nvl(p_article_effective_date,sysdate) >= Start_date
743: AND nvl(p_article_effective_date,sysdate) <= nvl(end_date, nvl(p_article_effective_date,sysdate) +1);
744:
745: CURSOR l_get_max_article_csr(b_article_id NUMBER) IS
746: SELECT article_version_id FROM OKC_ARTICLE_VERSIONS
747: WHERE article_id= b_article_id
748: AND article_status in ('ON_HOLD','APPROVED')
749: AND start_date = (select max(start_date) FROM OKC_ARTICLE_VERSIONS
750: WHERE article_id= b_article_id

Line 749: AND start_date = (select max(start_date) FROM OKC_ARTICLE_VERSIONS

745: CURSOR l_get_max_article_csr(b_article_id NUMBER) IS
746: SELECT article_version_id FROM OKC_ARTICLE_VERSIONS
747: WHERE article_id= b_article_id
748: AND article_status in ('ON_HOLD','APPROVED')
749: AND start_date = (select max(start_date) FROM OKC_ARTICLE_VERSIONS
750: WHERE article_id= b_article_id
751: AND article_status in ('ON_HOLD','APPROVED') );
752:
753: CURSOR l_get_no_std_ref_csr(b_version_ID NUMBER) IS

Line 755: FROM OKC_ARTICLE_VERSIONS VERS1,OKC_ARTICLE_VERSIONS VERS2

751: AND article_status in ('ON_HOLD','APPROVED') );
752:
753: CURSOR l_get_no_std_ref_csr(b_version_ID NUMBER) IS
754: SELECT VERS2.ARTICLE_ID,VERS2.ARTICLE_VERSION_ID
755: FROM OKC_ARTICLE_VERSIONS VERS1,OKC_ARTICLE_VERSIONS VERS2
756: WHERE VERS1.ARTICLE_VERSION_ID=b_version_id
757: AND VERS2.ARTICLE_VERSION_ID=VERS1.STD_ARTICLE_VERSION_ID;
758:
759: CURSOR l_get_art_csr IS

Line 906: FROM OKC_ARTICLE_VERSIONS VERS,

902: CURSOR l_get_local_article_csr(b_article_id IN NUMBER, b_local_org_id IN NUMBER) IS
903: SELECT ADP.LOCAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
904: ADP.ADOPTION_TYPE,
905: VERS1.ARTICLE_ID
906: FROM OKC_ARTICLE_VERSIONS VERS,
907: OKC_ARTICLE_ADOPTIONS ADP,
908: OKC_ARTICLE_VERSIONS VERS1
909: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
910: AND VERS.ARTICLE_ID = b_article_id

Line 908: OKC_ARTICLE_VERSIONS VERS1

904: ADP.ADOPTION_TYPE,
905: VERS1.ARTICLE_ID
906: FROM OKC_ARTICLE_VERSIONS VERS,
907: OKC_ARTICLE_ADOPTIONS ADP,
908: OKC_ARTICLE_VERSIONS VERS1
909: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
910: AND VERS.ARTICLE_ID = b_article_id
911: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE
912: AND nvl(p_article_effective_date,sysdate) <= nvl(VERS.end_date, nvl(p_article_effective_date,sysdate) +1)

Line 922: FROM OKC_ARTICLE_VERSIONS VERS,

918: UNION ALL
919: SELECT ADP.GLOBAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
920: ADP.ADOPTION_TYPE,
921: VERS.ARTICLE_ID
922: FROM OKC_ARTICLE_VERSIONS VERS,
923: OKC_ARTICLE_ADOPTIONS ADP
924: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
925: AND VERS.ARTICLE_ID = b_article_id
926: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE

Line 936: FROM OKC_ARTICLE_VERSIONS

932: ;
933:
934: CURSOR l_get_article_csr(b_article_version_id NUMBER) IS
935: SELECT nvl(PROVISION_YN,'N') provision_yn
936: FROM OKC_ARTICLE_VERSIONS
937: WHERE ARTICLE_VERSION_ID=b_article_version_id;
938:
939: l_article_rec l_get_article_csr%ROWTYPE;
940: l_local_article_rec l_get_local_article_csr%ROWTYPE;

Line 957: FROM OKC_ARTICLE_VERSIONS

953: FROM OKC_ARTICLE_ADOPTIONS ADP
954: WHERE ADP.LOCAL_ORG_ID = b_article_org_id
955: AND ADP.adoption_status IN ( 'APPROVED', 'ON_HOLD')
956: AND ADP.GLOBAL_ARTICLE_VERSION_ID IN (SELECT ARTICLE_VERSION_ID
957: FROM OKC_ARTICLE_VERSIONS
958: WHERE article_id = b_article_id)
959: ORDER BY ADP.creation_date desc;
960:
961: CURSOR l_get_local_article_id(b_article_version_id IN NUMBER) IS

Line 963: FROM okc_article_versions

959: ORDER BY ADP.creation_date desc;
960:
961: CURSOR l_get_local_article_id(b_article_version_id IN NUMBER) IS
962: SELECT article_id
963: FROM okc_article_versions
964: WHERE article_version_id = b_article_version_id;
965:
966: l_current_org_id VARCHAR2(100);
967: l_adoption_type VARCHAR2(100);