APPS.OKC_WORD_DOWNLOAD_UPLOAD dependencies on OKC_K_ARTICLES_B

Line 271: -- Get the Cat ID (OKC_K_ARTICLES_B.ID)

267: l_progress := '030';
268: while ((l_doc_xml.existsnode(l_xpath_clause_elem) > 0))
269: LOOP
270:
271: -- Get the Cat ID (OKC_K_ARTICLES_B.ID)
272: l_article_id := l_doc_xml.extract(l_xpath_clause_elem||'/@CatId').getNumberVal();
273:
274: --Get Article sub elements
275: l_var_XML := Xmltype(''||l_doc_xml.extract(l_xpath_clause_elem||'/ArticleText[1]/*').getClobVal()||'');

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 735: FROM OKC_K_ARTICLES_B

731: CURSOR get_doc_data is
732: SELECT OKC_WORD_DOWNLOAD_UPLOAD.blob_to_clob(FILE_DATA)
733: FROM OKC_REVIEW_UPLD_HEADER
734: WHERE (DOCUMENT_TYPE,DOCUMENT_ID) IN (SELECT DOCUMENT_TYPE,DOCUMENT_ID
735: FROM OKC_K_ARTICLES_B
736: WHERE ID = p_cat_id);
737:
738:
739: BEGIN

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;