APPS.OKC_XPRT_UTIL_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 3265: FROM OKC_ARTICLE_VERSIONS VERS

3261: );
3262:
3263: CURSOR csr_provision (p_article_version_id NUMBER) IS
3264: SELECT NVL(PROVISION_YN,'N')
3265: FROM OKC_ARTICLE_VERSIONS VERS
3266: WHERE vers.article_version_id = p_article_version_id;
3267:
3268:
3269: CURSOR l_get_max_article_csr(p_article_id NUMBER) IS

Line 3271: FROM okc_article_versions

3267:
3268:
3269: CURSOR l_get_max_article_csr(p_article_id NUMBER) IS
3270: SELECT article_version_id
3271: FROM okc_article_versions
3272: WHERE article_id= p_article_id
3273: AND article_status in ('ON_HOLD','APPROVED')
3274: AND start_date = (SELECT MAX(start_date)
3275: FROM okc_article_versions

Line 3275: FROM okc_article_versions

3271: FROM okc_article_versions
3272: WHERE article_id= p_article_id
3273: AND article_status in ('ON_HOLD','APPROVED')
3274: AND start_date = (SELECT MAX(start_date)
3275: FROM okc_article_versions
3276: WHERE article_id= p_article_id
3277: AND article_status in ('ON_HOLD','APPROVED')
3278: );
3279:

Line 3775: FROM OKC_ARTICLE_VERSIONS VERS

3771: --
3772: --
3773: CURSOR csr_art_provision (p_article_id NUMBER) IS
3774: SELECT NVL(PROVISION_YN,'N')
3775: FROM OKC_ARTICLE_VERSIONS VERS
3776: WHERE vers.article_id = p_article_id;
3777:
3778:
3779: BEGIN

Line 4448: okc_article_versions ver

4444:
4445: CURSOR l_approved_ver_csr(p_article_id NUMBER, effective_date DATE) IS
4446: SELECT ver.article_id, ver.article_version_id, 'L'
4447: FROM okc_articles_all art,
4448: okc_article_versions ver
4449: WHERE art.article_id = p_article_id
4450: AND art.article_id = ver.article_id
4451: AND ver.article_status IN ('APPROVED','ON_HOLD')
4452: AND nvl(effective_date,trunc(SYSDATE)) BETWEEN ver.start_date AND NVL(ver.end_date,TRUNC(SYSDATE));

Line 4457: FROM okc_article_versions ver

4453:
4454: -- bug 4106513
4455: CURSOR l_approved_latest_ver_csr(p_article_id NUMBER ) IS
4456: SELECT ver.article_id, ver.article_version_id, 'L'
4457: FROM okc_article_versions ver
4458: WHERE ver.article_id = p_article_id
4459: AND ver.article_status IN ('APPROVED','ON_HOLD')
4460: AND ver.start_date = (SELECT max(start_date)
4461: FROM okc_article_versions ver1

Line 4461: FROM okc_article_versions ver1

4457: FROM okc_article_versions ver
4458: WHERE ver.article_id = p_article_id
4459: AND ver.article_status IN ('APPROVED','ON_HOLD')
4460: AND ver.start_date = (SELECT max(start_date)
4461: FROM okc_article_versions ver1
4462: WHERE ver1.article_id = p_article_id
4463: AND ver1.article_status IN ('APPROVED','ON_HOLD'));
4464:
4465: BEGIN

Line 5584: from okc_article_versions

5580: FROM okc_articles_v art
5581: WHERE article_id=to_number(p_object_value_code)
5582: AND article_version_number=
5583: (select max(article_version_number)
5584: from okc_article_versions
5585: where article_id= Art.article_id);*/
5586: CURSOR c1 IS
5587: SELECT article_description
5588: FROM okc_article_versions art

Line 5588: FROM okc_article_versions art

5584: from okc_article_versions
5585: where article_id= Art.article_id);*/
5586: CURSOR c1 IS
5587: SELECT article_description
5588: FROM okc_article_versions art
5589: WHERE article_id=to_number(p_object_value_code)
5590: AND article_version_number=
5591: (select max(article_version_number)
5592: from okc_article_versions

Line 5592: from okc_article_versions

5588: FROM okc_article_versions art
5589: WHERE article_id=to_number(p_object_value_code)
5590: AND article_version_number=
5591: (select max(article_version_number)
5592: from okc_article_versions
5593: where article_id= to_number(p_object_value_code));
5594: --End:Perf Bug#5032199
5595:
5596: CURSOR C2 IS

Line 6152: FROM okc_article_versions Art

6148: RETURN VARCHAR2 IS
6149:
6150: Cursor c1 is
6151: SELECT decode(article_status,'ON_HOLD','N','EXPIRED','N','Y') valid_yn
6152: FROM okc_article_versions Art
6153: WHERE article_id= p_object_id
6154: AND article_version_number=
6155: (select max(article_version_number)
6156: from okc_article_versions

Line 6156: from okc_article_versions

6152: FROM okc_article_versions Art
6153: WHERE article_id= p_object_id
6154: AND article_version_number=
6155: (select max(article_version_number)
6156: from okc_article_versions
6157: where article_id= Art.article_id);
6158:
6159:
6160: Cursor c2 is

Line 6854: FROM OKC_ARTICLE_VERSIONS VERS

6850: --
6851: --
6852: CURSOR csr_art_provision (p_article_id NUMBER) IS
6853: SELECT NVL(PROVISION_YN,'N')
6854: FROM OKC_ARTICLE_VERSIONS VERS
6855: WHERE vers.article_id = p_article_id;
6856:
6857: --
6858: -- Currsor to Get Line number for deviation

Line 7543: l_def_scn_code okc_article_versions.default_section%TYPE;

7539: l_api_version CONSTANT NUMBER := 1;
7540: l_api_name CONSTANT VARCHAR2(30) := 'get_article_details';
7541:
7542: l_xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE;
7543: l_def_scn_code okc_article_versions.default_section%TYPE;
7544: l_scn_code okc_sections_b.scn_code%TYPE;
7545:
7546:
7547: --Bug#4757731 cursor to get clause title and clause description

Line 7550: FROM okc_articles_all a,okc_article_versions ver

7546:
7547: --Bug#4757731 cursor to get clause title and clause description
7548: CURSOR csr_clause_details(b_article_id NUMBER, b_article_version_id NUMBER) IS
7549: SELECT article_title,article_description
7550: FROM okc_articles_all a,okc_article_versions ver
7551: WHERE a.article_id = b_article_id
7552: AND a.article_id = ver.article_id
7553: AND ver.article_version_id = b_article_version_id;
7554:

Line 7567: FROM OKC_ARTICLE_VERSIONS VERS

7563: -- From Library
7564:
7565: CURSOR csr_lib_clause_desc_scn (b_article_id NUMBER, b_article_version_id NUMBER) IS
7566: SELECT nvl(default_section,'UNASSIGNED') scn_code
7567: FROM OKC_ARTICLE_VERSIONS VERS
7568: WHERE vers.article_id = b_article_id
7569: AND vers.article_version_id = b_article_version_id;
7570:
7571: CURSOR csr_xprt_scn_code IS