APPS.HXC_RDB_PRE_RETRIEVAL dependencies on DBMS_XMLGEN

Line 1141: qryCtx1 dbms_xmlgen.ctxType;

1137: l_report_info VARCHAR2(100);
1138:
1139: query1 varchar2(200);
1140:
1141: qryCtx1 dbms_xmlgen.ctxType;
1142: xmlresult1 CLOB;
1143: l_pre_xml CLOB DEFAULT empty_clob();
1144: l_resultOffset int;
1145:

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

1174: || 'TO_CHAR(SYSDATE, ''' || l_icx_date_format || ''') RUN_DATE '
1175: || 'from fnd_user '
1176: || 'where user_id = fnd_global.user_id' ;
1177:
1178: qryCtx1 := dbms_xmlgen.newContext(query1);
1179: dbms_xmlgen.setRowTag(qryCtx1, NULL);
1180: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
1181: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
1182: dbms_xmlgen.closecontext(qryctx1);

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

1175: || 'from fnd_user '
1176: || 'where user_id = fnd_global.user_id' ;
1177:
1178: qryCtx1 := dbms_xmlgen.newContext(query1);
1179: dbms_xmlgen.setRowTag(qryCtx1, NULL);
1180: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
1181: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
1182: dbms_xmlgen.closecontext(qryctx1);
1183: l_pre_xml := xmlresult1;

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

1176: || 'where user_id = fnd_global.user_id' ;
1177:
1178: qryCtx1 := dbms_xmlgen.newContext(query1);
1179: dbms_xmlgen.setRowTag(qryCtx1, NULL);
1180: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
1181: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
1182: dbms_xmlgen.closecontext(qryctx1);
1183: l_pre_xml := xmlresult1;
1184: dbms_lob.write(l_pre_xml, length(l_report_info), 1, l_report_info);

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

1177:
1178: qryCtx1 := dbms_xmlgen.newContext(query1);
1179: dbms_xmlgen.setRowTag(qryCtx1, NULL);
1180: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
1181: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
1182: dbms_xmlgen.closecontext(qryctx1);
1183: l_pre_xml := xmlresult1;
1184: dbms_lob.write(l_pre_xml, length(l_report_info), 1, l_report_info);
1185: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');

Line 1182: dbms_xmlgen.closecontext(qryctx1);

1178: qryCtx1 := dbms_xmlgen.newContext(query1);
1179: dbms_xmlgen.setRowTag(qryCtx1, NULL);
1180: dbms_xmlgen.setRowSetTag(qryCtx1, 'G_REPORT_INFO');
1181: xmlresult1 := dbms_xmlgen.getXML(qryCtx1, dbms_xmlgen.NONE);
1182: dbms_xmlgen.closecontext(qryctx1);
1183: l_pre_xml := xmlresult1;
1184: dbms_lob.write(l_pre_xml, length(l_report_info), 1, l_report_info);
1185: l_resultOffset := DBMS_LOB.INSTR(xmlresult1,'>');
1186: dbms_lob.copy(l_pre_xml, xmlresult1, dbms_lob.getlength(xmlresult1) - l_resultOffset, length(l_report_info), l_resultOffset +1);