APPS.OKC_MRV_UTIL dependencies on OKC_MRV_T

Line 463: FROM okc_mrv_t t,

459: CURSOR multiRow_vars IS
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,

Line 485: FROM okc_mrv_t;

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;
489: --replace style tags

Line 509: UPDATE okc_mrv_t

505: l_doc_xml := regexp_replace(l_doc_xml,l_mr_vars.mrVar,l_mrBody,1,1);
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: