[Home] [Help]
201: SELECT x_id, ART.article_id, VER.article_version_id, ART.org_id,
202: ART.ARTICLE_TITLE, VER.DISPLAY_NAME, ART.ARTICLE_TYPE,
203: nvl(VER.DEFAULT_SECTION, 'UNASSIGNED'), nvl(VER.ARTICLE_STATUS,'DRAFT'),
204: VER.start_date, 'N', nvl(VER.GLOBAL_YN, 'N'), 'N'
205: FROM OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
206: WHERE VER.article_version_id = p_art_ver_tbl(i)
207: AND ART.ARTICLE_ID = VER.ARTICLE_ID
208: AND ART.ORG_ID = G_GLOBAL_ORG_ID;
209:
230: SELECT x_id, ART.article_id, VER.article_version_id, ART.org_id,
231: ART.ARTICLE_TITLE, VER.DISPLAY_NAME, ART.ARTICLE_TYPE,
232: nvl(VER.DEFAULT_SECTION, 'UNASSIGNED'), nvl(VER.ARTICLE_STATUS,'DRAFT'),
233: VER.start_date,'N', 'N', decode(VER.ADOPTION_TYPE, 'LOCALIZED', 'Y', 'N')
234: FROM OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
235: WHERE VER.article_version_id = p_art_ver_tbl(i)
236: AND ART.ARTICLE_ID = VER.ARTICLE_ID
237: AND ART.ORG_ID = p_org_id;
238:
257: SELECT x_id, ART.article_id, VER.article_version_id, ART.org_id,
258: ART.ARTICLE_TITLE, VER.DISPLAY_NAME, ART.ARTICLE_TYPE,
259: nvl(VER.DEFAULT_SECTION, 'UNASSIGNED'), nvl(ADP.ADOPTION_STATUS,'DRAFT'),
260: VER.start_date,'Y', 'N', 'N'
261: FROM OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER, OKC_ARTICLE_ADOPTIONS ADP
262: WHERE VER.article_version_id = p_art_ver_tbl(i)
263: AND ART.ARTICLE_ID = VER.ARTICLE_ID
264: AND ART.ORG_ID = G_GLOBAL_ORG_ID
265: AND ADP.GLOBAL_ARTICLE_VERSION_ID = VER.ARTICLE_VERSION_ID
1586: CURSOR l_non_uniq_title_csr(cp_id IN NUMBER, cp_global_org_id IN NUMBER) IS
1587: -- check if article title is unique for the local org also
1588: -- if title is not unique in the local org, set to 'AVAILABLE' and NULL
1589: SELECT TMP.article_version_id , ART.org_id
1590: FROM OKC_ART_BLK_TEMP TMP, OKC_ARTICLES_ALL ART
1591: WHERE TMP.id = cp_id AND
1592: TMP.global_yn = 'Y' AND
1593: ART.article_title = TMP.article_title AND
1594: ART.org_id <> cp_global_org_id ;