APPS.OKC_ARTICLE_STATUS_CHANGE_PVT dependencies on OKC_ARTICLES_ALL

Line 296: FROM okc_articles_all art, okc_article_versions ver

292: l_new_article_status VARCHAR2(30) := NULL;
293:
294: CURSOR l_article_version_csr (cp_article_version_id IN NUMBER) IS
295: SELECT org_id, article_status, global_yn, art.article_id
296: FROM okc_articles_all art, okc_article_versions ver
297: WHERE ver.article_id = art.article_id
298: AND ver.article_version_id = cp_article_version_id
299: AND art.standard_yn = 'Y'
300: FOR UPDATE OF start_date;

Line 565: FROM OKC_ARTICLE_VERSIONS VER,OKC_ARTICLES_ALL ART

561:
562: -- Below added for Bug 3737158
563: CURSOR l_article_lkup_csr(cp_article_version_id IN NUMBER) is
564: SELECT DEFAULT_SECTION, ARTICLE_TYPE
565: FROM OKC_ARTICLE_VERSIONS VER,OKC_ARTICLES_ALL ART
566: WHERE
567: ART.ARTICLE_ID = VER.ARTICLE_ID
568: AND VER.ARTICLE_VERSION_ID = cp_article_version_id;
569:

Line 572: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;

568: AND VER.ARTICLE_VERSION_ID = cp_article_version_id;
569:
570:
571: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
572: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
573:
574: -- Above added for Bug 3737158
575:
576: l_user_id NUMBER := FND_GLOBAL.USER_ID;

Line 1090: FROM okc_articles_all art, okc_article_versions ver

1086: l_delete_adoption VARCHAR2(1) := 'T';
1087: l_rowid ROWID;
1088: CURSOR l_article_version_csr (cp_article_version_id IN NUMBER) IS
1089: SELECT global_yn, org_id, art.article_id, start_date
1090: FROM okc_articles_all art, okc_article_versions ver
1091: WHERE ver.article_id = art.article_id
1092: AND ver.article_version_id = cp_article_version_id;
1093: l_article_version_rec l_article_version_csr%ROWTYPE;
1094: l_earlier_version_id NUMBER := NULL;

Line 1404: FROM okc_articles_all art, okc_article_versions ver

1400: l_delete_adoption VARCHAR2(1) := 'T';
1401: l_rowid ROWID;
1402: CURSOR l_article_version_csr (cp_article_version_id IN NUMBER) IS
1403: SELECT global_yn, org_id, art.article_id, start_date
1404: FROM okc_articles_all art, okc_article_versions ver
1405: WHERE ver.article_id = art.article_id
1406: AND ver.article_version_id = cp_article_version_id;
1407: l_article_version_rec l_article_version_csr%ROWTYPE;
1408: l_earlier_version_id NUMBER := NULL;