APPS.OKC_K_ARTICLES_PVT dependencies on OKC_ARTICLES_ALL

Line 875: FROM okc_articles_all

871: l_dummy_var VARCHAR2(1) := '?';
872:
873: CURSOR lc_sav_sae_id is
874: SELECT '!'
875: FROM okc_articles_all
876: WHERE article_id = p_sav_sae_id;
877:
878: CURSOR lc_scn_id is
879: SELECT '!'

Line 2780: okc_articles_all art

2776: SELECT art.standard_yn,
2777: kart.sav_sae_id,
2778: kart.article_version_id
2779: FROM okc_k_articles_b kart,
2780: okc_articles_all art
2781: WHERE kart.id = cp_id
2782: AND art.article_id = kart.sav_sae_id;
2783:
2784: CURSOR l_non_std_exists_csr(cp_article_version_id IN NUMBER) IS

Line 3050: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE;

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

Line 3051: l_article_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;

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

Line 3061: OKC_ARTICLES_ALL ART

3057: SELECT KART.ID,
3058: KART.SAV_SAE_ID,
3059: KART.ARTICLE_VERSION_ID
3060: FROM OKC_K_ARTICLES_B KART,
3061: OKC_ARTICLES_ALL ART
3062: WHERE KART.document_type = p_doc_type
3063: AND KART.document_id = p_doc_id
3064: AND KART.SAV_SAE_ID = ART.ARTICLE_ID
3065: AND ART.STANDARD_YN = 'N';