APPS.OKC_ARTICLE_VERSIONS_PVT dependencies on OKC_ARTICLES_ALL

Line 975: FROM OKC_ARTICLES_ALL

971:
972:
973: CURSOR l_article_language_csr(p_article_id IN NUMBER, p_article_language IN VARCHAR2) is
974: SELECT '!'
975: FROM OKC_ARTICLES_ALL
976: WHERE ARTICLE_LANGUAGE = p_article_language
977: AND ARTICLE_ID = p_article_id;
978:
979: CURSOR l_std_article_version_id_csr is

Line 981: FROM OKC_ARTICLES_ALL AA,OKC_ARTICLE_VERSIONS AV

977: AND ARTICLE_ID = p_article_id;
978:
979: CURSOR l_std_article_version_id_csr is
980: SELECT '!'
981: FROM OKC_ARTICLES_ALL AA,OKC_ARTICLE_VERSIONS AV
982: WHERE AA.ARTICLE_ID = AV.ARTICLE_ID
983: AND AV.ARTICLE_VERSION_ID = p_std_article_version_id
984: AND AA.STANDARD_YN = 'Y';
985:

Line 1450: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;

1446: l_dummy_var1 VARCHAR2(1) ;
1447: l_dummy_var2 VARCHAR2(1) ;
1448:
1449: l_standard_yn VARCHAR2(1) ;
1450: l_article_language OKC_ARTICLES_ALL.ARTICLE_LANGUAGE%TYPE;
1451: l_global_start_date DATE := TO_DATE('12313999','MMDDYYYY');
1452: l_rownotfound BOOLEAN := FALSE;
1453:
1454:

Line 1510: FROM OKC_ARTICLES_ALL

1506: */
1507:
1508: CURSOR l_article_id_csr(p_article_id IN NUMBER) is
1509: SELECT standard_yn, article_language
1510: FROM OKC_ARTICLES_ALL
1511: WHERE ARTICLE_ID = p_article_id;
1512:
1513: -- Bug#3672511: Validation of start date of a localized clause should be >= start date of global clause.
1514: