DBA Data[Home] [Help]

APPS.OKC_ARTICLES_ALL_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 1049: FROM okc_articles_all art, okc_article_adoptions adp, okc_article_versions artv

1045: AND article_id <> nvl(p_article_id,-99)
1046: AND rownum < 2
1047: UNION ALL
1048: SELECT '1'
1049: FROM okc_articles_all art, okc_article_adoptions adp, okc_article_versions artv
1050: WHERE adp.local_org_id = p_org_id
1051: AND art.article_title = p_article_title
1052: AND adp.adoption_type = 'ADOPTED'
1053: AND adp.global_article_version_id = artv.article_version_id

Line 2133: update OKC_ARTICLE_VERSIONS

2129: END IF;
2130:
2131: -- if article_title updated - notify context index
2132: if pending then
2133: update OKC_ARTICLE_VERSIONS
2134: set article_text = article_text
2135: where article_id = p_article_id;
2136: end if;
2137: