APPS.OKC_MRV_UTIL dependencies on OKC_WORD_DOWNLOAD_UPLOAD

Line 167: l_clob := okc_word_download_upload.blob_to_clob (p_blobdata);

163: )
164: IS
165: l_clob CLOB;
166: BEGIN
167: l_clob := okc_word_download_upload.blob_to_clob (p_blobdata);
168:
169: IF p_type = 'XML'
170: THEN
171: --

Line 202: RETURN (okc_word_download_upload.clob_to_blob (l_clob));

198: INTO l_clob
199: FROM okc_k_art_variables
200: WHERE variable_code = p_variable_code AND cat_id = p_cat_id;
201:
202: RETURN (okc_word_download_upload.clob_to_blob (l_clob));
203: ELSIF p_type = 'XML'
204: THEN
205: SELECT mr_variable_xml
206: INTO l_clob

Line 210: RETURN (okc_word_download_upload.clob_to_blob (l_clob));

206: INTO l_clob
207: FROM okc_k_art_variables
208: WHERE variable_code = p_variable_code AND cat_id = p_cat_id;
209:
210: RETURN (okc_word_download_upload.clob_to_blob (l_clob));
211: END IF;
212: EXCEPTION
213: WHEN OTHERS THEN
214: RAISE;

Line 464: xmltable('//SectionsArticlesToPrintVORow' PASSING xmltype(''||regexp_replace(OKC_WORD_DOWNLOAD_UPLOAD.blob_to_clob(blob_data),' ',' ')||'')

460: SELECT '' mrVar,
461: xmltype(''||Dbms_Lob.SubStr(MR_VARIABLE_HTML,dbms_lob.getLength(MR_VARIABLE_HTML),Dbms_Lob.InStr(MR_VARIABLE_HTML,''))).extract('//style/text()').getClobVal() mrStyle,
462: xmltype(''||Dbms_Lob.SubStr(MR_VARIABLE_HTML,dbms_lob.getLength(MR_VARIABLE_HTML),Dbms_Lob.InStr(MR_VARIABLE_HTML,''))).extract('//body/*|text()').getClobVal() mrBody
463: FROM okc_mrv_t t,
464: xmltable('//SectionsArticlesToPrintVORow' PASSING xmltype(''||regexp_replace(OKC_WORD_DOWNLOAD_UPLOAD.blob_to_clob(blob_data),' ',' ')||'')
465: COLUMNS "artVersionId" NUMBER PATH '//SectionsArticlesToPrintVORow/ArticleVersionId/text()',
466: "catId" NUMBER PATH '//SectionsArticlesToPrintVORow/CatId/text()') t1,
467: okc_article_versions av,
468: xmltable('//var' PASSING xmltype(''||regexp_replace(av.article_text,' ',' ')||'')

Line 484: SELECT OKC_WORD_DOWNLOAD_UPLOAD.blob_to_clob(blob_data) INTO l_doc_xml

480: l_mrStyle CLOB;
481: l_mrBody CLOB;
482: l_mrHtml CLOB;
483: BEGIN
484: SELECT OKC_WORD_DOWNLOAD_UPLOAD.blob_to_clob(blob_data) INTO l_doc_xml
485: FROM okc_mrv_t;
486:
487: FOR l_mr_vars IN multiRow_vars LOOP
488: l_mrBody := l_mr_vars.mrBody;

Line 510: SET blob_output = OKC_WORD_DOWNLOAD_UPLOAD.clob_to_blob(l_doc_xml)

506: END LOOP;
507:
508:
509: UPDATE okc_mrv_t
510: SET blob_output = OKC_WORD_DOWNLOAD_UPLOAD.clob_to_blob(l_doc_xml)
511: WHERE doc_id= DocID
512: AND doc_type =DocType;
513:
514: EXCEPTION