APPS.OKC_K_ARTICLES_PVT dependencies on OKC_ARTICLES_ALL

Line 889: FROM okc_articles_all

885: l_dummy_var VARCHAR2(1) := '?';
886:
887: CURSOR lc_sav_sae_id is
888: SELECT '!'
889: FROM okc_articles_all
890: WHERE article_id = p_sav_sae_id;
891:
892: CURSOR lc_scn_id is
893: SELECT '!'

Line 2814: okc_articles_all art

2810: SELECT art.standard_yn,
2811: kart.sav_sae_id,
2812: kart.article_version_id
2813: FROM okc_k_articles_b kart,
2814: okc_articles_all art
2815: WHERE kart.id = cp_id
2816: AND art.article_id = kart.sav_sae_id;
2817:
2818: CURSOR l_non_std_exists_csr(cp_article_version_id IN NUMBER) IS

Line 3094: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE;

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;
3098: l_msg_data VARCHAR2(4000);

Line 3095: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;

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;
3098: l_msg_data VARCHAR2(4000);
3099:

Line 3105: OKC_ARTICLES_ALL ART

3101: SELECT KART.ID,
3102: KART.SAV_SAE_ID,
3103: KART.ARTICLE_VERSION_ID
3104: FROM OKC_K_ARTICLES_B KART,
3105: OKC_ARTICLES_ALL ART
3106: WHERE KART.document_type = p_doc_type
3107: AND KART.document_id = p_doc_id
3108: AND KART.SAV_SAE_ID = ART.ARTICLE_ID
3109: AND ART.STANDARD_YN = 'N';