APPS.OKC_K_ARTICLES_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 885: FROM okc_article_versions

881: WHERE ID = p_scn_id;
882:
883: CURSOR lc_article_version_id is
884: SELECT '!'
885: FROM okc_article_versions
886: WHERE ARTICLE_VERSION_ID = p_article_version_id;
887:
888: CURSOR l_doc_type_csr is
889: SELECT '!'

Line 1236: SELECT '!' FROM OKC_ARTICLE_VERSIONS

1232: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1233: l_dummy_var VARCHAR2(1) := '?';
1234:
1235: CURSOR l_validate_article_csr IS
1236: SELECT '!' FROM OKC_ARTICLE_VERSIONS
1237: WHERE ARTICLE_VERSION_ID = p_article_version_id
1238: AND ARTICLE_ID = p_sav_sae_id;
1239:
1240:

Line 3049: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;

3045: p_doc_id IN NUMBER,
3046: p_major_version IN NUMBER
3047: ) RETURN VARCHAR2 IS
3048:
3049: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
3050: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE;
3051: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
3052: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
3053: l_msg_count NUMBER;