APPS.OKC_WORD_DOWNLOAD_UPLOAD dependencies on OKC_ARTICLE_VERSIONS

Line 281: from okc_article_versions VER,okc_k_articles_b ART

277: l_progress := '040';
278: --Get the clause text from individual clauses Word doc.
279: select VER.INSERT_BY_REFERENCE,VER.REFERENCE_TEXT,VER.article_text_in_word
280: into l_insert_by_reference,l_reference_text,l_article_text_in_word
281: from okc_article_versions VER,okc_k_articles_b ART
282: where ART.id = l_article_id
283: and VER.article_id = ART.sav_sae_id
284: and VER.article_version_id = ART.article_version_id;
285: l_clob_temp := okc_word_download_upload.get_article_body(l_article_text_in_word);

Line 650: From okc_article_versions VER,okc_k_articles_b ART,okc_word_sync_t st

646: l_progress := '100';
647:
648: SELECT art.id
649: BULK COLLECT INTO cat_id1_tbl
650: From okc_article_versions VER,okc_k_articles_b ART,okc_word_sync_t st
651: WHERE st.doc_id = p_doc_id
652: AND st.doc_type = p_doc_type
653: AND st.action <> 'ADDED'
654: AND ART.id = st.cat_id

Line 936: UPDATE okc_article_versions

932: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT ,
933: G_MODULE||'INSERT_WML_TEXT',
934: '100: Entered '||G_PKG_NAME ||'.'||'INSERT_WML_TEXT');
935: END IF;
936: UPDATE okc_article_versions
937: SET article_text_in_word = p_article_text_in_word,
938: edited_in_word = 'Y'
939: WHERE article_version_id = p_article_version_id;
940: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1212: SELECT article_text INTO t_clob_data FROM okc_article_versions WHERE article_version_id = (SELECT article_version_id FROM okc_k_articles_b WHERE id = p_cat_id);

1208: FETCH get_none_csr INTO t_action;
1209:
1210: IF get_none_csr%FOUND THEN
1211:
1212: SELECT article_text INTO t_clob_data FROM okc_article_versions WHERE article_version_id = (SELECT article_version_id FROM okc_k_articles_b WHERE id = p_cat_id);
1213: t_blob_data := clob_to_blob(t_clob_data);
1214:
1215: x_action := t_action;
1216: x_wml_blob := t_blob_data;

Line 1292: SELECT article_text_in_word INTO t_blob_data FROM okc_article_versions WHERE article_version_id = (SELECT article_version_id FROM okc_k_articles_b WHERE id = p_cat_id);

1288: AND doc_type = p_doc_type
1289: AND cat_id = p_cat_id;
1290:
1291: IF t_action = 'NONEASSIGNED' THEN
1292: SELECT article_text_in_word INTO t_blob_data FROM okc_article_versions WHERE article_version_id = (SELECT article_version_id FROM okc_k_articles_b WHERE id = p_cat_id);
1293: END IF;
1294: EXCEPTION
1295: WHEN No_Data_Found THEN
1296: RETURN NULL;

Line 1341: from okc_article_versions VER

1337: AND wt.action = 'UPDATEDASSIGNED';
1338:
1339: ELSE
1340: select okc_word_download_upload.blob_to_clob(article_text_in_word) into x_art_wml
1341: from okc_article_versions VER
1342: where VER.article_version_id = p_art_ver_id
1343: and ver.edited_in_word = 'Y';
1344:
1345: END IF;