DBA Data[Home] [Help]

APPS.OKC_UTIL dependencies on OKC_STD_ART_VERSIONS_TL

Line 2126: update okc_std_art_versions_tl set text=(select text from okc_std_art_versions_tl

2122: FUNCTION Copy_CLOB(id number,release varchar2,lang varchar2)
2123: RETURN VARCHAR2 IS
2124: l_stat VARCHAR2(1):='S';
2125: begin
2126: update okc_std_art_versions_tl set text=(select text from okc_std_art_versions_tl
2127: where sae_id=id and sav_release=release and language=lang)
2128: where sae_id=id and sav_release=release and source_lang=lang and language<>lang;
2129: return l_stat;
2130: EXCEPTION

Line 2267: from okc_std_art_versions_tl

2263: Close l_savv_scr;
2264:
2265: update okc_k_articles_tl
2266: set text = (select text
2267: from okc_std_art_versions_tl
2268: where sae_id = p_sae_id
2269: and sav_release = l_release
2270: and language = lang)
2271: where id = p_article_id;