APPS.HXC_SUPERVISOR_DASHBOARD dependencies on DBMS_XMLGEN

Line 3071: qryCtx1 dbms_xmlgen.ctxType;

3067: l_report_info VARCHAR2(100);
3068:
3069: query1 varchar2(200);
3070:
3071: qryCtx1 dbms_xmlgen.ctxType;
3072: xmlresult1 CLOB;
3073: l_pre_xml CLOB DEFAULT empty_clob();
3074: l_resultOffset int;
3075:

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

3188: || 'TO_CHAR(SYSDATE, ''' || l_icx_date_format || ''') RUN_DATE '
3189: || 'from fnd_user '
3190: || 'where user_id = fnd_global.user_id' ;
3191:
3192: qryCtx1 := dbms_xmlgen.newContext(query1);
3193: dbms_xmlgen.setRowTag(qryCtx1, NULL);
3194: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
3195: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
3196: dbms_xmlgen.closecontext(qryctx1);

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

3189: || 'from fnd_user '
3190: || 'where user_id = fnd_global.user_id' ;
3191:
3192: qryCtx1 := dbms_xmlgen.newContext(query1);
3193: dbms_xmlgen.setRowTag(qryCtx1, NULL);
3194: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
3195: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
3196: dbms_xmlgen.closecontext(qryctx1);
3197: l_pre_xml := xmlresult1;

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

3190: || 'where user_id = fnd_global.user_id' ;
3191:
3192: qryCtx1 := dbms_xmlgen.newContext(query1);
3193: dbms_xmlgen.setRowTag(qryCtx1, NULL);
3194: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
3195: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
3196: dbms_xmlgen.closecontext(qryctx1);
3197: l_pre_xml := xmlresult1;
3198: dbms_lob.write(l_pre_xml, length(l_report_info), 1, l_report_info);

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

3191:
3192: qryCtx1 := dbms_xmlgen.newContext(query1);
3193: dbms_xmlgen.setRowTag(qryCtx1, NULL);
3194: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
3195: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
3196: dbms_xmlgen.closecontext(qryctx1);
3197: l_pre_xml := xmlresult1;
3198: dbms_lob.write(l_pre_xml, length(l_report_info), 1, l_report_info);
3199: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

Line 3196: dbms_xmlgen.closecontext(qryctx1);

3192: qryCtx1 := dbms_xmlgen.newContext(query1);
3193: dbms_xmlgen.setRowTag(qryCtx1, NULL);
3194: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
3195: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
3196: dbms_xmlgen.closecontext(qryctx1);
3197: l_pre_xml := xmlresult1;
3198: dbms_lob.write(l_pre_xml, length(l_report_info), 1, l_report_info);
3199: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
3200: dbms_lob.copy(l_pre_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);