eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_US_EEO5_EXP_PKG dependencies on DBMS_XMLGEN

Line 46: qryCtx DBMS_XMLGEN.ctxHandle;

42: ,retcode OUT NOCOPY NUMBER
43: ,p_business_group_id varchar2
44: , p_reporting_year number) is
45:
46: qryCtx DBMS_XMLGEN.ctxHandle;
47: l_result CLOB;
48: -- Commented for bug#11736960
49: --l_query varchar2(10000);
50: l_report_date date;

Line 255: qryCtx := dbms_xmlgen.newContext (l_query3);

251: Commneted for bug#11736960 ends */
252:
253: -- Added for bug#12570805
254: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query3);
255: qryCtx := dbms_xmlgen.newContext (l_query3);
256:
257: l_xml_string := '';
258: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
259: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

Line 266: DBMS_XMLGEN.setMaxRows(qryCtx, 5);

262: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
263: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
264:
265: --Load 5 records at a time
266: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
267: LOOP
268: --save the XML into the CLOB field
269: l_result := DBMS_XMLGEN.getXML(qryCtx);
270: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));

Line 269: l_result := DBMS_XMLGEN.getXML(qryCtx);

265: --Load 5 records at a time
266: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
267: LOOP
268: --save the XML into the CLOB field
269: l_result := DBMS_XMLGEN.getXML(qryCtx);
270: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
271: --insert into tab_clob values (to_char(l_xml_string));
272: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
273: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

Line 272: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;

268: --save the XML into the CLOB field
269: l_result := DBMS_XMLGEN.getXML(qryCtx);
270: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
271: --insert into tab_clob values (to_char(l_xml_string));
272: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
273: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
274: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
275:
276: END LOOP;

Line 280: qryCtx := dbms_xmlgen.newContext (l_query4);

276: END LOOP;
277:
278: -- Added for bug#12570805
279: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query4);
280: qryCtx := dbms_xmlgen.newContext (l_query4);
281:
282: --Load 5 records at a time
283: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
284: LOOP

Line 283: DBMS_XMLGEN.setMaxRows(qryCtx, 5);

279: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query4);
280: qryCtx := dbms_xmlgen.newContext (l_query4);
281:
282: --Load 5 records at a time
283: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
284: LOOP
285: --save the XML into the CLOB field
286: l_result := DBMS_XMLGEN.getXML(qryCtx);
287: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));

Line 286: l_result := DBMS_XMLGEN.getXML(qryCtx);

282: --Load 5 records at a time
283: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
284: LOOP
285: --save the XML into the CLOB field
286: l_result := DBMS_XMLGEN.getXML(qryCtx);
287: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
288: --insert into tab_clob values (to_char(l_xml_string));
289: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
290: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

Line 289: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;

285: --save the XML into the CLOB field
286: l_result := DBMS_XMLGEN.getXML(qryCtx);
287: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
288: --insert into tab_clob values (to_char(l_xml_string));
289: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
290: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
292:
293: END LOOP;

Line 300: qryCtx := dbms_xmlgen.newContext (l_query1);

296: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query1);
297: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_query);
298:
299: -- Added for bug#11736960
300: qryCtx := dbms_xmlgen.newContext (l_query1);
301: --qryCtx := dbms_xmlgen.newContext (l_query);
302:
303: --Load 5 records at a time
304: DBMS_XMLGEN.setMaxRows(qryCtx, 5);

Line 301: --qryCtx := dbms_xmlgen.newContext (l_query);

297: --FND_FILE.PUT_LINE(FND_FILE.LOG,l_query);
298:
299: -- Added for bug#11736960
300: qryCtx := dbms_xmlgen.newContext (l_query1);
301: --qryCtx := dbms_xmlgen.newContext (l_query);
302:
303: --Load 5 records at a time
304: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
305: LOOP

Line 304: DBMS_XMLGEN.setMaxRows(qryCtx, 5);

300: qryCtx := dbms_xmlgen.newContext (l_query1);
301: --qryCtx := dbms_xmlgen.newContext (l_query);
302:
303: --Load 5 records at a time
304: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
305: LOOP
306: --save the XML into the CLOB field
307: l_result := DBMS_XMLGEN.getXML(qryCtx);
308: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));

Line 307: l_result := DBMS_XMLGEN.getXML(qryCtx);

303: --Load 5 records at a time
304: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
305: LOOP
306: --save the XML into the CLOB field
307: l_result := DBMS_XMLGEN.getXML(qryCtx);
308: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
309: --insert into tab_clob values (to_char(l_xml_string));
310: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
311: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

Line 310: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;

306: --save the XML into the CLOB field
307: l_result := DBMS_XMLGEN.getXML(qryCtx);
308: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
309: --insert into tab_clob values (to_char(l_xml_string));
310: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
311: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
312: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
313:
314: END LOOP;

Line 319: qryCtx := dbms_xmlgen.newContext (l_query2);

315:
316: -- Added for bug#11736960
317: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query2);
318:
319: qryCtx := dbms_xmlgen.newContext (l_query2);
320:
321: --Load 5 records at a time
322: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
323: LOOP

Line 322: DBMS_XMLGEN.setMaxRows(qryCtx, 5);

318:
319: qryCtx := dbms_xmlgen.newContext (l_query2);
320:
321: --Load 5 records at a time
322: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
323: LOOP
324: --save the XML into the CLOB field
325: l_result := DBMS_XMLGEN.getXML(qryCtx);
326: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));

Line 325: l_result := DBMS_XMLGEN.getXML(qryCtx);

321: --Load 5 records at a time
322: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
323: LOOP
324: --save the XML into the CLOB field
325: l_result := DBMS_XMLGEN.getXML(qryCtx);
326: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
327: --insert into tab_clob values (to_char(l_xml_string));
328: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
329: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

Line 328: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;

324: --save the XML into the CLOB field
325: l_result := DBMS_XMLGEN.getXML(qryCtx);
326: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
327: --insert into tab_clob values (to_char(l_xml_string));
328: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
329: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
330: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
331:
332: END LOOP;