APPS.OKC_ARTICLE_RELATIONSHIPS_PVT dependencies on OKC_ARTICLES_ALL

Line 62: SELECT OKC_ARTICLES_ALL_S1.NEXTVAL FROM DUAL;

58: x_target_article_id OUT NOCOPY NUMBER,
59: x_org_id OUT NOCOPY NUMBER
60: ) RETURN VARCHAR2 IS
61: CURSOR l_seq_csr IS
62: SELECT OKC_ARTICLES_ALL_S1.NEXTVAL FROM DUAL;
63: BEGIN
64: IF (l_debug = 'Y') THEN
65: Okc_Debug.Log('100: Entered get_seq_id', 2);
66: END IF;

Line 287: FROM OKC_ARTICLES_ALL

283: l_dummy_var VARCHAR2(1) := '?';
284:
285: CURSOR l_source_article_id_csr is
286: SELECT '!'
287: FROM OKC_ARTICLES_ALL
288: WHERE ARTICLE_ID = p_source_article_id;
289:
290: CURSOR l_target_article_id_csr is
291: SELECT '!'

Line 292: FROM OKC_ARTICLES_ALL

288: WHERE ARTICLE_ID = p_source_article_id;
289:
290: CURSOR l_target_article_id_csr is
291: SELECT '!'
292: FROM OKC_ARTICLES_ALL
293: WHERE ARTICLE_ID = p_target_article_id;
294:
295: CURSOR l_org_id_csr is
296: SELECT '!'