APPS.OKC_TERMS_COPY_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 498: SELECT article_version_id FROM OKC_ARTICLE_VERSIONS

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
499: WHERE article_id= b_article_id
500: AND article_status in ('ON_HOLD','APPROVED')
501: AND nvl(p_article_effective_date,sysdate) >= Start_date
502: AND nvl(p_article_effective_date,sysdate) <= nvl(end_date, nvl(p_article_effective_date,sysdate) +1);

Line 505: SELECT article_version_id FROM OKC_ARTICLE_VERSIONS

501: AND nvl(p_article_effective_date,sysdate) >= Start_date
502: AND nvl(p_article_effective_date,sysdate) <= nvl(end_date, nvl(p_article_effective_date,sysdate) +1);
503:
504: CURSOR l_get_max_article_csr(b_article_id NUMBER) IS
505: SELECT article_version_id FROM OKC_ARTICLE_VERSIONS
506: WHERE article_id= b_article_id
507: AND article_status in ('ON_HOLD','APPROVED')
508: AND start_date = (select max(start_date) FROM OKC_ARTICLE_VERSIONS
509: WHERE article_id= b_article_id

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

504: CURSOR l_get_max_article_csr(b_article_id NUMBER) IS
505: SELECT article_version_id FROM OKC_ARTICLE_VERSIONS
506: WHERE article_id= b_article_id
507: AND article_status in ('ON_HOLD','APPROVED')
508: AND start_date = (select max(start_date) FROM OKC_ARTICLE_VERSIONS
509: WHERE article_id= b_article_id
510: AND article_status in ('ON_HOLD','APPROVED') );
511:
512: CURSOR l_get_no_std_ref_csr(b_version_ID NUMBER) IS

Line 514: FROM OKC_ARTICLE_VERSIONS VERS1,OKC_ARTICLE_VERSIONS VERS2

510: AND article_status in ('ON_HOLD','APPROVED') );
511:
512: CURSOR l_get_no_std_ref_csr(b_version_ID NUMBER) IS
513: SELECT VERS2.ARTICLE_ID,VERS2.ARTICLE_VERSION_ID
514: FROM OKC_ARTICLE_VERSIONS VERS1,OKC_ARTICLE_VERSIONS VERS2
515: WHERE VERS1.ARTICLE_VERSION_ID=b_version_id
516: AND VERS2.ARTICLE_VERSION_ID=VERS1.STD_ARTICLE_VERSION_ID;
517:
518: CURSOR l_get_art_csr IS

Line 650: FROM OKC_ARTICLE_VERSIONS VERS,

646: CURSOR l_get_local_article_csr(b_article_id IN NUMBER, b_local_org_id IN NUMBER) IS
647: SELECT ADP.LOCAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
648: ADP.ADOPTION_TYPE,
649: VERS1.ARTICLE_ID
650: FROM OKC_ARTICLE_VERSIONS VERS,
651: OKC_ARTICLE_ADOPTIONS ADP,
652: OKC_ARTICLE_VERSIONS VERS1
653: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
654: AND VERS.ARTICLE_ID = b_article_id

Line 652: OKC_ARTICLE_VERSIONS VERS1

648: ADP.ADOPTION_TYPE,
649: VERS1.ARTICLE_ID
650: FROM OKC_ARTICLE_VERSIONS VERS,
651: OKC_ARTICLE_ADOPTIONS ADP,
652: OKC_ARTICLE_VERSIONS VERS1
653: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
654: AND VERS.ARTICLE_ID = b_article_id
655: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE
656: AND nvl(p_article_effective_date,sysdate) <= nvl(VERS.end_date, nvl(p_article_effective_date,sysdate) +1)

Line 666: FROM OKC_ARTICLE_VERSIONS VERS,

662: UNION ALL
663: SELECT ADP.GLOBAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
664: ADP.ADOPTION_TYPE,
665: VERS.ARTICLE_ID
666: FROM OKC_ARTICLE_VERSIONS VERS,
667: OKC_ARTICLE_ADOPTIONS ADP
668: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
669: AND VERS.ARTICLE_ID = b_article_id
670: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE

Line 680: FROM OKC_ARTICLE_VERSIONS

676: ;
677:
678: CURSOR l_get_article_csr(b_article_version_id NUMBER) IS
679: SELECT nvl(PROVISION_YN,'N') provision_yn
680: FROM OKC_ARTICLE_VERSIONS
681: WHERE ARTICLE_VERSION_ID=b_article_version_id;
682:
683: l_article_rec l_get_article_csr%ROWTYPE;
684: l_local_article_rec l_get_local_article_csr%ROWTYPE;

Line 701: FROM OKC_ARTICLE_VERSIONS

697: FROM OKC_ARTICLE_ADOPTIONS ADP
698: WHERE ADP.LOCAL_ORG_ID = b_article_org_id
699: AND ADP.adoption_status IN ( 'APPROVED', 'ON_HOLD')
700: AND ADP.GLOBAL_ARTICLE_VERSION_ID IN (SELECT ARTICLE_VERSION_ID
701: FROM OKC_ARTICLE_VERSIONS
702: WHERE article_id = b_article_id)
703: ORDER BY ADP.creation_date desc;
704:
705: CURSOR l_get_local_article_id(b_article_version_id IN NUMBER) IS

Line 707: FROM okc_article_versions

703: ORDER BY ADP.creation_date desc;
704:
705: CURSOR l_get_local_article_id(b_article_version_id IN NUMBER) IS
706: SELECT article_id
707: FROM okc_article_versions
708: WHERE article_version_id = b_article_version_id;
709:
710: l_current_org_id VARCHAR2(100);
711: l_adoption_type VARCHAR2(100);