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.ARP_RECON_REP dependencies on DBMS_XMLGEN

Line 376: qryCtx DBMS_XMLGEN.ctxHandle;

372: l_xml_header_length number;
373: l_errNo NUMBER;
374: l_errMsg VARCHAR2(200);
375: queryCtx DBMS_XMLquery.ctxType;
376: qryCtx DBMS_XMLGEN.ctxHandle;
377: l_xml_query VARCHAR2(32767);
378: l_natural_segment_col VARCHAR2(50);
379: l_flex_value_set_id NUMBER;
380: l_code_combinations VARCHAR2(32767);

Line 744: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);

740: END IF;
741: DBMS_XMLQuery.closeContext(queryCtx);
742: END;
743: ELSIF (l_majorVersion >= 9 ) THEN
744: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
745: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
746: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
747: DBMS_XMLGEN.closeContext(qryCtx);
748: END IF;

Line 745: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);

741: DBMS_XMLQuery.closeContext(queryCtx);
742: END;
743: ELSIF (l_majorVersion >= 9 ) THEN
744: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
745: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
746: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
747: DBMS_XMLGEN.closeContext(qryCtx);
748: END IF;
749:

Line 746: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);

742: END;
743: ELSIF (l_majorVersion >= 9 ) THEN
744: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
745: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
746: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
747: DBMS_XMLGEN.closeContext(qryCtx);
748: END IF;
749:
750: IF l_rows_processed <> 0 THEN

Line 747: DBMS_XMLGEN.closeContext(qryCtx);

743: ELSIF (l_majorVersion >= 9 ) THEN
744: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
745: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
746: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
747: DBMS_XMLGEN.closeContext(qryCtx);
748: END IF;
749:
750: IF l_rows_processed <> 0 THEN
751: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');

Line 874: qryCtx DBMS_XMLGEN.ctxHandle;

870: l_xml_header_length number;
871: l_errNo NUMBER;
872: l_errMsg VARCHAR2(200);
873: queryCtx DBMS_XMLquery.ctxType;
874: qryCtx DBMS_XMLGEN.ctxHandle;
875: l_xml_query VARCHAR2(32767);
876: l_natural_segment_col VARCHAR2(50);
877: l_flex_value_set_id NUMBER;
878: l_code_combinations VARCHAR2(32767);

Line 1338: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);

1334: DBMS_XMLQuery.closeContext(queryCtx);
1335: END;
1336:
1337: ELSIF (l_majorVersion >= 9 ) THEN
1338: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
1339: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
1340: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
1341: DBMS_XMLGEN.closeContext(qryCtx);
1342: END IF;

Line 1339: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);

1335: END;
1336:
1337: ELSIF (l_majorVersion >= 9 ) THEN
1338: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
1339: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
1340: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
1341: DBMS_XMLGEN.closeContext(qryCtx);
1342: END IF;
1343:

Line 1340: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);

1336:
1337: ELSIF (l_majorVersion >= 9 ) THEN
1338: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
1339: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
1340: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
1341: DBMS_XMLGEN.closeContext(qryCtx);
1342: END IF;
1343:
1344: IF l_rows_processed <> 0 THEN

Line 1341: DBMS_XMLGEN.closeContext(qryCtx);

1337: ELSIF (l_majorVersion >= 9 ) THEN
1338: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
1339: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
1340: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
1341: DBMS_XMLGEN.closeContext(qryCtx);
1342: END IF;
1343:
1344: IF l_rows_processed <> 0 THEN
1345: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');

Line 1469: qryCtx DBMS_XMLGEN.ctxHandle;

1465: l_xml_header_length number;
1466: l_errNo NUMBER;
1467: l_errMsg VARCHAR2(200);
1468: queryCtx DBMS_XMLquery.ctxType;
1469: qryCtx DBMS_XMLGEN.ctxHandle;
1470: l_xml_query VARCHAR2(32767);
1471: l_natural_segment_col VARCHAR2(50);
1472: l_flex_value_set_id NUMBER;
1473: l_code_combinations VARCHAR2(32767);

Line 1857: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);

1853: END IF;
1854: DBMS_XMLQuery.closeContext(queryCtx);
1855: END;
1856: ELSIF (l_majorVersion >= 9 ) THEN
1857: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
1858: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
1859: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
1860: DBMS_XMLGEN.closeContext(qryCtx);
1861: END IF;

Line 1858: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);

1854: DBMS_XMLQuery.closeContext(queryCtx);
1855: END;
1856: ELSIF (l_majorVersion >= 9 ) THEN
1857: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
1858: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
1859: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
1860: DBMS_XMLGEN.closeContext(qryCtx);
1861: END IF;
1862:

Line 1859: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);

1855: END;
1856: ELSIF (l_majorVersion >= 9 ) THEN
1857: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
1858: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
1859: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
1860: DBMS_XMLGEN.closeContext(qryCtx);
1861: END IF;
1862:
1863: IF l_rows_processed <> 0 THEN

Line 1860: DBMS_XMLGEN.closeContext(qryCtx);

1856: ELSIF (l_majorVersion >= 9 ) THEN
1857: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
1858: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
1859: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
1860: DBMS_XMLGEN.closeContext(qryCtx);
1861: END IF;
1862:
1863: IF l_rows_processed <> 0 THEN
1864: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');

Line 1987: qryCtx DBMS_XMLGEN.ctxHandle;

1983: l_xml_header_length number;
1984: l_errNo NUMBER;
1985: l_errMsg VARCHAR2(200);
1986: queryCtx DBMS_XMLquery.ctxType;
1987: qryCtx DBMS_XMLGEN.ctxHandle;
1988: l_xml_query VARCHAR2(32767);
1989: l_natural_segment_col VARCHAR2(50);
1990: l_flex_value_set_id NUMBER;
1991: l_code_combinations VARCHAR2(32767);

Line 2329: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);

2325: END IF;
2326: DBMS_XMLQuery.closeContext(queryCtx);
2327: END;
2328: ELSIF (l_majorVersion >= 9 ) THEN
2329: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
2330: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
2331: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
2332: DBMS_XMLGEN.closeContext(qryCtx);
2333: END IF;

Line 2330: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);

2326: DBMS_XMLQuery.closeContext(queryCtx);
2327: END;
2328: ELSIF (l_majorVersion >= 9 ) THEN
2329: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
2330: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
2331: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
2332: DBMS_XMLGEN.closeContext(qryCtx);
2333: END IF;
2334: IF l_rows_processed <> 0 THEN

Line 2331: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);

2327: END;
2328: ELSIF (l_majorVersion >= 9 ) THEN
2329: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
2330: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
2331: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
2332: DBMS_XMLGEN.closeContext(qryCtx);
2333: END IF;
2334: IF l_rows_processed <> 0 THEN
2335: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');

Line 2332: DBMS_XMLGEN.closeContext(qryCtx);

2328: ELSIF (l_majorVersion >= 9 ) THEN
2329: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
2330: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
2331: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
2332: DBMS_XMLGEN.closeContext(qryCtx);
2333: END IF;
2334: IF l_rows_processed <> 0 THEN
2335: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
2336: tempResult := l_result;

Line 2459: qryCtx DBMS_XMLGEN.ctxHandle;

2455: l_rows_processed number;
2456: l_xml_header varchar2(1000);
2457: l_xml_header_length number;
2458: queryCtx DBMS_XMLquery.ctxType;
2459: qryCtx DBMS_XMLGEN.ctxHandle;
2460: l_xml_query VARCHAR2(32767);
2461: l_natural_segment_col VARCHAR2(50);
2462: l_flex_value_set_id NUMBER;
2463: l_code_combinations VARCHAR2(32767);

Line 3038: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);

3034: END IF;
3035: DBMS_XMLQuery.closeContext(queryCtx);
3036: END;
3037: ELSIF (l_majorVersion >= 9 ) THEN
3038: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
3039: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
3040: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
3041: DBMS_XMLGEN.closeContext(qryCtx);
3042: END IF;

Line 3039: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);

3035: DBMS_XMLQuery.closeContext(queryCtx);
3036: END;
3037: ELSIF (l_majorVersion >= 9 ) THEN
3038: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
3039: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
3040: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
3041: DBMS_XMLGEN.closeContext(qryCtx);
3042: END IF;
3043:

Line 3040: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);

3036: END;
3037: ELSIF (l_majorVersion >= 9 ) THEN
3038: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
3039: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
3040: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
3041: DBMS_XMLGEN.closeContext(qryCtx);
3042: END IF;
3043:
3044: IF l_rows_processed <> 0 THEN

Line 3041: DBMS_XMLGEN.closeContext(qryCtx);

3037: ELSIF (l_majorVersion >= 9 ) THEN
3038: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
3039: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
3040: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
3041: DBMS_XMLGEN.closeContext(qryCtx);
3042: END IF;
3043:
3044: IF l_rows_processed <> 0 THEN
3045: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');