APPS.HXC_RDB_POST_RETRIEVAL dependencies on DBMS_XMLGEN

Line 2382: qryCtx1 dbms_xmlgen.ctxType;

2378: l_report_info VARCHAR2(100);
2379:
2380: query1 varchar2(200);
2381:
2382: qryCtx1 dbms_xmlgen.ctxType;
2383: xmlresult1 CLOB;
2384: l_post_xml CLOB DEFAULT empty_clob();
2385: l_resultOffset int;
2386:

Line 2419: qryCtx1 := dbms_xmlgen.newContext(query1);

2415: || 'TO_CHAR(SYSDATE, ''' || l_icx_date_format || ''') RUN_DATE '
2416: || 'from fnd_user '
2417: || 'where user_id = fnd_global.user_id' ;
2418:
2419: qryCtx1 := dbms_xmlgen.newContext(query1);
2420: dbms_xmlgen.setRowTag(qryCtx1, NULL);
2421: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
2422: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
2423: dbms_xmlgen.closecontext(qryctx1);

Line 2420: dbms_xmlgen.setRowTag(qryCtx1, NULL);

2416: || 'from fnd_user '
2417: || 'where user_id = fnd_global.user_id' ;
2418:
2419: qryCtx1 := dbms_xmlgen.newContext(query1);
2420: dbms_xmlgen.setRowTag(qryCtx1, NULL);
2421: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
2422: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
2423: dbms_xmlgen.closecontext(qryctx1);
2424: l_post_xml := xmlresult1;

Line 2421: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');

2417: || 'where user_id = fnd_global.user_id' ;
2418:
2419: qryCtx1 := dbms_xmlgen.newContext(query1);
2420: dbms_xmlgen.setRowTag(qryCtx1, NULL);
2421: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
2422: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
2423: dbms_xmlgen.closecontext(qryctx1);
2424: l_post_xml := xmlresult1;
2425: dbms_lob.write(l_post_xml, length(l_report_info), 1, l_report_info);

Line 2422: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);

2418:
2419: qryCtx1 := dbms_xmlgen.newContext(query1);
2420: dbms_xmlgen.setRowTag(qryCtx1, NULL);
2421: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
2422: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
2423: dbms_xmlgen.closecontext(qryctx1);
2424: l_post_xml := xmlresult1;
2425: dbms_lob.write(l_post_xml, length(l_report_info), 1, l_report_info);
2426: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

Line 2423: dbms_xmlgen.closecontext(qryctx1);

2419: qryCtx1 := dbms_xmlgen.newContext(query1);
2420: dbms_xmlgen.setRowTag(qryCtx1, NULL);
2421: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
2422: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
2423: dbms_xmlgen.closecontext(qryctx1);
2424: l_post_xml := xmlresult1;
2425: dbms_lob.write(l_post_xml, length(l_report_info), 1, l_report_info);
2426: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
2427: dbms_lob.copy(l_post_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);