APPS.PAY_MX_ISR_FORMAT37_INFO dependencies on DBMS_XMLQUERY

Line 86: l_xml_ctx dbms_xmlquery.ctxType;

82: p_pai_eff_date DATE )
83: RETURN CLOB IS
84:
85: l_xml_query VARCHAR2(32000);
86: l_xml_ctx dbms_xmlquery.ctxType;
87:
88: l_xml_clob CLOB;
89:
90: is_temp varchar2(10);

Line 316: l_xml_ctx := DBMS_XMLQuery.newcontext(l_xml_query);

312: dbms_lob.open(l_xml_clob,dbms_lob.lob_readwrite);
313:
314: dbg('set the context') ;
315:
316: l_xml_ctx := DBMS_XMLQuery.newcontext(l_xml_query);
317:
318: DBMS_XMLQuery.setRowsetTag(l_XML_ctx,'Format37') ;
319:
320: dbg('dbms_xmlquery getxml') ;

Line 318: DBMS_XMLQuery.setRowsetTag(l_XML_ctx,'Format37') ;

314: dbg('set the context') ;
315:
316: l_xml_ctx := DBMS_XMLQuery.newcontext(l_xml_query);
317:
318: DBMS_XMLQuery.setRowsetTag(l_XML_ctx,'Format37') ;
319:
320: dbg('dbms_xmlquery getxml') ;
321:
322: l_xml_clob:= dbms_xmlquery.getxml(l_xml_ctx);

Line 320: dbg('dbms_xmlquery getxml') ;

316: l_xml_ctx := DBMS_XMLQuery.newcontext(l_xml_query);
317:
318: DBMS_XMLQuery.setRowsetTag(l_XML_ctx,'Format37') ;
319:
320: dbg('dbms_xmlquery getxml') ;
321:
322: l_xml_clob:= dbms_xmlquery.getxml(l_xml_ctx);
323:
324: dbg('after dbms_xmlquery get_xml') ;

Line 322: l_xml_clob:= dbms_xmlquery.getxml(l_xml_ctx);

318: DBMS_XMLQuery.setRowsetTag(l_XML_ctx,'Format37') ;
319:
320: dbg('dbms_xmlquery getxml') ;
321:
322: l_xml_clob:= dbms_xmlquery.getxml(l_xml_ctx);
323:
324: dbg('after dbms_xmlquery get_xml') ;
325: DBMS_XMLQuery.closeContext(l_xml_ctx);
326: dbg('Context closed') ;

Line 324: dbg('after dbms_xmlquery get_xml') ;

320: dbg('dbms_xmlquery getxml') ;
321:
322: l_xml_clob:= dbms_xmlquery.getxml(l_xml_ctx);
323:
324: dbg('after dbms_xmlquery get_xml') ;
325: DBMS_XMLQuery.closeContext(l_xml_ctx);
326: dbg('Context closed') ;
327: return l_xml_clob ;
328:

Line 325: DBMS_XMLQuery.closeContext(l_xml_ctx);

321:
322: l_xml_clob:= dbms_xmlquery.getxml(l_xml_ctx);
323:
324: dbg('after dbms_xmlquery get_xml') ;
325: DBMS_XMLQuery.closeContext(l_xml_ctx);
326: dbg('Context closed') ;
327: return l_xml_clob ;
328:
329: exception