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 305: l_xml_ctx := DBMS_XMLQuery.newcontext(l_xml_query);

301: dbms_lob.open(l_xml_clob,dbms_lob.lob_readwrite);
302:
303: dbg('set the context') ;
304:
305: l_xml_ctx := DBMS_XMLQuery.newcontext(l_xml_query);
306:
307: DBMS_XMLQuery.setRowsetTag(l_XML_ctx,'Format37') ;
308:
309: dbg('dbms_xmlquery getxml') ;

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

303: dbg('set the context') ;
304:
305: l_xml_ctx := DBMS_XMLQuery.newcontext(l_xml_query);
306:
307: DBMS_XMLQuery.setRowsetTag(l_XML_ctx,'Format37') ;
308:
309: dbg('dbms_xmlquery getxml') ;
310:
311: l_xml_clob:= dbms_xmlquery.getxml(l_xml_ctx);

Line 309: dbg('dbms_xmlquery getxml') ;

305: l_xml_ctx := DBMS_XMLQuery.newcontext(l_xml_query);
306:
307: DBMS_XMLQuery.setRowsetTag(l_XML_ctx,'Format37') ;
308:
309: dbg('dbms_xmlquery getxml') ;
310:
311: l_xml_clob:= dbms_xmlquery.getxml(l_xml_ctx);
312:
313: dbg('after dbms_xmlquery get_xml') ;

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

307: DBMS_XMLQuery.setRowsetTag(l_XML_ctx,'Format37') ;
308:
309: dbg('dbms_xmlquery getxml') ;
310:
311: l_xml_clob:= dbms_xmlquery.getxml(l_xml_ctx);
312:
313: dbg('after dbms_xmlquery get_xml') ;
314:
315: return l_xml_clob ;

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

309: dbg('dbms_xmlquery getxml') ;
310:
311: l_xml_clob:= dbms_xmlquery.getxml(l_xml_ctx);
312:
313: dbg('after dbms_xmlquery get_xml') ;
314:
315: return l_xml_clob ;
316:
317: exception