APPS.OKC_UTIL dependencies on OKC_ARTICLE_VERSIONS

Line 2149: UPDATE okc_article_versions

2145: l_return_status VARCHAR2(1) := 'S';
2146: length NUMBER;
2147: BEGIN
2148: IF (p_text IS NOT NULL) THEN
2149: UPDATE okc_article_versions
2150: SET article_text = p_text,
2151: object_version_number = object_version_number+1,
2152: last_updated_by = FND_GLOBAL.USER_ID,
2153: last_update_login = FND_GLOBAL.LOGIN_ID,

Line 2209: UPDATE okc_article_versions

2205: okc_debug.log('1000: Entered Copy_Articles_Varied_Text', 2);
2206: okc_debug.log('1001: p_article_id: '||p_article_id, 2);
2207: okc_debug.log('1002: p_sae_id: '||p_sae_id, 2);
2208: END IF;
2209: UPDATE okc_article_versions
2210: SET article_text
2211: = (SELECT article_text FROM okc_article_versions
2212: WHERE article_id=p_sae_id
2213: AND sysdate BETWEEN start_date AND Nvl(end_date,Sysdate+1) ),

Line 2211: = (SELECT article_text FROM okc_article_versions

2207: okc_debug.log('1002: p_sae_id: '||p_sae_id, 2);
2208: END IF;
2209: UPDATE okc_article_versions
2210: SET article_text
2211: = (SELECT article_text FROM okc_article_versions
2212: WHERE article_id=p_sae_id
2213: AND sysdate BETWEEN start_date AND Nvl(end_date,Sysdate+1) ),
2214: object_version_number = object_version_number+1,
2215: last_updated_by = FND_GLOBAL.USER_ID,