APPS.OKC_ARTICLE_VERSIONS_PVT dependencies on OKC_ARTICLES_ALL

Line 928: FROM OKC_ARTICLES_ALL

924:
925:
926: CURSOR l_article_language_csr(p_article_id IN NUMBER, p_article_language IN VARCHAR2) is
927: SELECT '!'
928: FROM OKC_ARTICLES_ALL
929: WHERE ARTICLE_LANGUAGE = p_article_language
930: AND ARTICLE_ID = p_article_id;
931:
932: CURSOR l_std_article_version_id_csr is

Line 934: FROM OKC_ARTICLES_ALL AA,OKC_ARTICLE_VERSIONS AV

930: AND ARTICLE_ID = p_article_id;
931:
932: CURSOR l_std_article_version_id_csr is
933: SELECT '!'
934: FROM OKC_ARTICLES_ALL AA,OKC_ARTICLE_VERSIONS AV
935: WHERE AA.ARTICLE_ID = AV.ARTICLE_ID
936: AND AV.ARTICLE_VERSION_ID = p_std_article_version_id
937: AND AA.STANDARD_YN = 'Y';
938:

Line 1360: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;

1356: l_dummy_var1 VARCHAR2(1) ;
1357: l_dummy_var2 VARCHAR2(1) ;
1358:
1359: l_standard_yn VARCHAR2(1) ;
1360: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
1361: l_global_start_date DATE := TO_DATE('12313999','MMDDYYYY');
1362: l_rownotfound BOOLEAN := FALSE;
1363:
1364:

Line 1420: FROM OKC_ARTICLES_ALL

1416: */
1417:
1418: CURSOR l_article_id_csr(p_article_id IN NUMBER) is
1419: SELECT standard_yn, article_language
1420: FROM OKC_ARTICLES_ALL
1421: WHERE ARTICLE_ID = p_article_id;
1422:
1423: -- Bug#3672511: Validation of start date of a localized clause should be >= start date of global clause.
1424: