APPS.OKC_K_ARTICLES_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 899: FROM okc_article_versions

895: WHERE ID = p_scn_id;
896:
897: CURSOR lc_article_version_id is
898: SELECT '!'
899: FROM okc_article_versions
900: WHERE ARTICLE_VERSION_ID = p_article_version_id;
901:
902: CURSOR l_doc_type_csr is
903: SELECT '!'

Line 1251: SELECT '!' FROM OKC_ARTICLE_VERSIONS

1247: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
1248: l_dummy_var VARCHAR2(1) := '?';
1249:
1250: CURSOR l_validate_article_csr IS
1251: SELECT '!' FROM OKC_ARTICLE_VERSIONS
1252: WHERE ARTICLE_VERSION_ID = p_article_version_id
1253: AND ARTICLE_ID = p_sav_sae_id;
1254:
1255:

Line 3093: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;

3089: p_doc_id IN NUMBER,
3090: p_major_version IN NUMBER
3091: ) RETURN VARCHAR2 IS
3092:
3093: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
3094: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE;
3095: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
3096: l_return_status VARCHAR2(1) := G_RET_STS_SUCCESS;
3097: l_msg_count NUMBER;