eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

APPS.OKC_MRV_UTIL dependencies on XMLTYPE

Line 255: l_uda_xml XMLTYPE;

251: L_OP VARCHAR2(32767);
252: L_ATTR_GRP NUMBER;
253: L_CTR NUMBER;
254: L_O_CTR NUMBER;
255: l_uda_xml XMLTYPE;
256:
257: BEGIN
258:
259: L_O_CTR := 0;

Line 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,

457: l_doc_xml CLOB;
458:
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()',

Line 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

458:
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,

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 468: xmltable('//var' PASSING xmltype(''||regexp_replace(av.article_text,' ',' ')||'')

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,' ',' ')||'')
469: COLUMNS "varName" VARCHAR2(30) PATH '//var/@name',
470: "vartype" VARCHAR2(1) PATH '//var/@type',
471: "varMeaning" VARCHAR2(30) PATH '//var/@meaning'
472: ) t2,

Line 495: FROM xmltable('//row1' PASSING xmltype(l_mrStyle)

491: DECLARE
492: CURSOR allClasses IS
493: SELECT 'class="'||Trim(cl."className")||'"' srcStr,
494: 'style="'||Trim(cl."styleAttr")||'"' trgStr
495: FROM xmltable('//row1' PASSING xmltype(l_mrStyle)
496: COLUMNS "className" VARCHAR2(10) PATH '//row1/class1/text()',
497: "styleAttr" VARCHAR2(2000) PATH '//row1/styleAttr/text()') cl;
498:
499: BEGIN