APPS.OKC_ARTICLE_STATUS_CHANGE_PVT dependencies on OKC_ARTICLES_ALL

Line 294: FROM okc_articles_all art, okc_article_versions ver

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

Line 553: FROM OKC_ARTICLE_VERSIONS VER,OKC_ARTICLES_ALL ART

549:
550: -- Below added for Bug 3737158
551: CURSOR l_article_lkup_csr(cp_article_version_id IN NUMBER) is
552: SELECT DEFAULT_SECTION, ARTICLE_TYPE
553: FROM OKC_ARTICLE_VERSIONS VER,OKC_ARTICLES_ALL ART
554: WHERE
555: ART.ARTICLE_ID = VER.ARTICLE_ID
556: AND VER.ARTICLE_VERSION_ID = cp_article_version_id;
557:

Line 560: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;

556: AND VER.ARTICLE_VERSION_ID = cp_article_version_id;
557:
558:
559: l_default_section OKC_ARTICLE_VERSIONS.DEFAULT_SECTION%TYPE;
560: l_article_type OKC_ARTICLES_ALL.ARTICLE_TYPE%TYPE;
561:
562: -- Above added for Bug 3737158
563:
564: l_user_id NUMBER := FND_GLOBAL.USER_ID;

Line 1072: FROM okc_articles_all art, okc_article_versions ver

1068: l_delete_adoption VARCHAR2(1) := 'T';
1069: l_rowid ROWID;
1070: CURSOR l_article_version_csr (cp_article_version_id IN NUMBER) IS
1071: SELECT global_yn, org_id, art.article_id, start_date
1072: FROM okc_articles_all art, okc_article_versions ver
1073: WHERE ver.article_id = art.article_id
1074: AND ver.article_version_id = cp_article_version_id;
1075: l_article_version_rec l_article_version_csr%ROWTYPE;
1076: l_earlier_version_id NUMBER := NULL;

Line 1382: FROM okc_articles_all art, okc_article_versions ver

1378: l_delete_adoption VARCHAR2(1) := 'T';
1379: l_rowid ROWID;
1380: CURSOR l_article_version_csr (cp_article_version_id IN NUMBER) IS
1381: SELECT global_yn, org_id, art.article_id, start_date
1382: FROM okc_articles_all art, okc_article_versions ver
1383: WHERE ver.article_id = art.article_id
1384: AND ver.article_version_id = cp_article_version_id;
1385: l_article_version_rec l_article_version_csr%ROWTYPE;
1386: l_earlier_version_id NUMBER := NULL;