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_XMLQUERY

Line 375: queryCtx DBMS_XMLquery.ctxType;

371: l_xml_header varchar2(3000);
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;

Line 731: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);

727: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
728:
729: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
730: BEGIN
731: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
732: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
733: l_result := DBMS_XMLQuery.getXML(queryCtx);
734: DBMS_XMLQuery.closeContext(queryCtx);
735: l_rows_processed := 1;

Line 732: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);

728:
729: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
730: BEGIN
731: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
732: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
733: l_result := DBMS_XMLQuery.getXML(queryCtx);
734: DBMS_XMLQuery.closeContext(queryCtx);
735: l_rows_processed := 1;
736: EXCEPTION WHEN OTHERS THEN

Line 733: l_result := DBMS_XMLQuery.getXML(queryCtx);

729: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
730: BEGIN
731: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
732: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
733: l_result := DBMS_XMLQuery.getXML(queryCtx);
734: DBMS_XMLQuery.closeContext(queryCtx);
735: l_rows_processed := 1;
736: EXCEPTION WHEN OTHERS THEN
737: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);

Line 734: DBMS_XMLQuery.closeContext(queryCtx);

730: BEGIN
731: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
732: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
733: l_result := DBMS_XMLQuery.getXML(queryCtx);
734: DBMS_XMLQuery.closeContext(queryCtx);
735: l_rows_processed := 1;
736: EXCEPTION WHEN OTHERS THEN
737: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
738: IF l_errNo = 1403 THEN

Line 737: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);

733: l_result := DBMS_XMLQuery.getXML(queryCtx);
734: DBMS_XMLQuery.closeContext(queryCtx);
735: l_rows_processed := 1;
736: EXCEPTION WHEN OTHERS THEN
737: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
738: IF l_errNo = 1403 THEN
739: l_rows_processed := 0;
740: END IF;
741: DBMS_XMLQuery.closeContext(queryCtx);

Line 741: DBMS_XMLQuery.closeContext(queryCtx);

737: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
738: IF l_errNo = 1403 THEN
739: l_rows_processed := 0;
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);

Line 873: queryCtx DBMS_XMLquery.ctxType;

869: l_xml_header varchar2(3000);
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;

Line 1324: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);

1320: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
1321:
1322: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
1323: BEGIN
1324: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
1325: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
1326: l_result := DBMS_XMLQuery.getXML(queryCtx);
1327: DBMS_XMLQuery.closeContext(queryCtx);
1328: l_rows_processed := 1;

Line 1325: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);

1321:
1322: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
1323: BEGIN
1324: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
1325: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
1326: l_result := DBMS_XMLQuery.getXML(queryCtx);
1327: DBMS_XMLQuery.closeContext(queryCtx);
1328: l_rows_processed := 1;
1329: EXCEPTION WHEN OTHERS THEN

Line 1326: l_result := DBMS_XMLQuery.getXML(queryCtx);

1322: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
1323: BEGIN
1324: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
1325: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
1326: l_result := DBMS_XMLQuery.getXML(queryCtx);
1327: DBMS_XMLQuery.closeContext(queryCtx);
1328: l_rows_processed := 1;
1329: EXCEPTION WHEN OTHERS THEN
1330: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);

Line 1327: DBMS_XMLQuery.closeContext(queryCtx);

1323: BEGIN
1324: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
1325: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
1326: l_result := DBMS_XMLQuery.getXML(queryCtx);
1327: DBMS_XMLQuery.closeContext(queryCtx);
1328: l_rows_processed := 1;
1329: EXCEPTION WHEN OTHERS THEN
1330: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
1331: IF l_errNo = 1403 THEN

Line 1330: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);

1326: l_result := DBMS_XMLQuery.getXML(queryCtx);
1327: DBMS_XMLQuery.closeContext(queryCtx);
1328: l_rows_processed := 1;
1329: EXCEPTION WHEN OTHERS THEN
1330: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
1331: IF l_errNo = 1403 THEN
1332: l_rows_processed := 0;
1333: END IF;
1334: DBMS_XMLQuery.closeContext(queryCtx);

Line 1334: DBMS_XMLQuery.closeContext(queryCtx);

1330: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
1331: IF l_errNo = 1403 THEN
1332: l_rows_processed := 0;
1333: END IF;
1334: DBMS_XMLQuery.closeContext(queryCtx);
1335: END;
1336:
1337: ELSIF (l_majorVersion >= 9 ) THEN
1338: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);

Line 1468: queryCtx DBMS_XMLquery.ctxType;

1464: l_xml_header varchar2(3000);
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;

Line 1844: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);

1840: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
1841:
1842: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
1843: BEGIN
1844: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
1845: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
1846: l_result := DBMS_XMLQuery.getXML(queryCtx);
1847: DBMS_XMLQuery.closeContext(queryCtx);
1848: l_rows_processed := 1;

Line 1845: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);

1841:
1842: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
1843: BEGIN
1844: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
1845: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
1846: l_result := DBMS_XMLQuery.getXML(queryCtx);
1847: DBMS_XMLQuery.closeContext(queryCtx);
1848: l_rows_processed := 1;
1849: EXCEPTION WHEN OTHERS THEN

Line 1846: l_result := DBMS_XMLQuery.getXML(queryCtx);

1842: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
1843: BEGIN
1844: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
1845: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
1846: l_result := DBMS_XMLQuery.getXML(queryCtx);
1847: DBMS_XMLQuery.closeContext(queryCtx);
1848: l_rows_processed := 1;
1849: EXCEPTION WHEN OTHERS THEN
1850: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);

Line 1847: DBMS_XMLQuery.closeContext(queryCtx);

1843: BEGIN
1844: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
1845: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
1846: l_result := DBMS_XMLQuery.getXML(queryCtx);
1847: DBMS_XMLQuery.closeContext(queryCtx);
1848: l_rows_processed := 1;
1849: EXCEPTION WHEN OTHERS THEN
1850: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
1851: IF l_errNo = 1403 THEN

Line 1850: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);

1846: l_result := DBMS_XMLQuery.getXML(queryCtx);
1847: DBMS_XMLQuery.closeContext(queryCtx);
1848: l_rows_processed := 1;
1849: EXCEPTION WHEN OTHERS THEN
1850: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
1851: IF l_errNo = 1403 THEN
1852: l_rows_processed := 0;
1853: END IF;
1854: DBMS_XMLQuery.closeContext(queryCtx);

Line 1854: DBMS_XMLQuery.closeContext(queryCtx);

1850: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
1851: IF l_errNo = 1403 THEN
1852: l_rows_processed := 0;
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);

Line 1986: queryCtx DBMS_XMLquery.ctxType;

1982: l_xml_header varchar2(3000);
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;

Line 2316: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);

2312: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
2313:
2314: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
2315: BEGIN
2316: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
2317: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
2318: l_result := DBMS_XMLQuery.getXML(queryCtx);
2319: DBMS_XMLQuery.closeContext(queryCtx);
2320: l_rows_processed := 1;

Line 2317: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);

2313:
2314: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
2315: BEGIN
2316: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
2317: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
2318: l_result := DBMS_XMLQuery.getXML(queryCtx);
2319: DBMS_XMLQuery.closeContext(queryCtx);
2320: l_rows_processed := 1;
2321: EXCEPTION WHEN OTHERS THEN

Line 2318: l_result := DBMS_XMLQuery.getXML(queryCtx);

2314: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
2315: BEGIN
2316: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
2317: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
2318: l_result := DBMS_XMLQuery.getXML(queryCtx);
2319: DBMS_XMLQuery.closeContext(queryCtx);
2320: l_rows_processed := 1;
2321: EXCEPTION WHEN OTHERS THEN
2322: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);

Line 2319: DBMS_XMLQuery.closeContext(queryCtx);

2315: BEGIN
2316: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
2317: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
2318: l_result := DBMS_XMLQuery.getXML(queryCtx);
2319: DBMS_XMLQuery.closeContext(queryCtx);
2320: l_rows_processed := 1;
2321: EXCEPTION WHEN OTHERS THEN
2322: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
2323: IF l_errNo = 1403 THEN

Line 2322: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);

2318: l_result := DBMS_XMLQuery.getXML(queryCtx);
2319: DBMS_XMLQuery.closeContext(queryCtx);
2320: l_rows_processed := 1;
2321: EXCEPTION WHEN OTHERS THEN
2322: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
2323: IF l_errNo = 1403 THEN
2324: l_rows_processed := 0;
2325: END IF;
2326: DBMS_XMLQuery.closeContext(queryCtx);

Line 2326: DBMS_XMLQuery.closeContext(queryCtx);

2322: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
2323: IF l_errNo = 1403 THEN
2324: l_rows_processed := 0;
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);

Line 2458: queryCtx DBMS_XMLquery.ctxType;

2454: l_resultOffset number;
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;

Line 3025: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);

3021: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
3022:
3023: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
3024: BEGIN
3025: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
3026: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
3027: l_result := DBMS_XMLQuery.getXML(queryCtx);
3028: DBMS_XMLQuery.closeContext(queryCtx);
3029: l_rows_processed := 1;

Line 3026: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);

3022:
3023: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
3024: BEGIN
3025: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
3026: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
3027: l_result := DBMS_XMLQuery.getXML(queryCtx);
3028: DBMS_XMLQuery.closeContext(queryCtx);
3029: l_rows_processed := 1;
3030: EXCEPTION WHEN OTHERS THEN

Line 3027: l_result := DBMS_XMLQuery.getXML(queryCtx);

3023: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
3024: BEGIN
3025: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
3026: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
3027: l_result := DBMS_XMLQuery.getXML(queryCtx);
3028: DBMS_XMLQuery.closeContext(queryCtx);
3029: l_rows_processed := 1;
3030: EXCEPTION WHEN OTHERS THEN
3031: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);

Line 3028: DBMS_XMLQuery.closeContext(queryCtx);

3024: BEGIN
3025: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
3026: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
3027: l_result := DBMS_XMLQuery.getXML(queryCtx);
3028: DBMS_XMLQuery.closeContext(queryCtx);
3029: l_rows_processed := 1;
3030: EXCEPTION WHEN OTHERS THEN
3031: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
3032: IF l_errNo = 1403 THEN

Line 3031: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);

3027: l_result := DBMS_XMLQuery.getXML(queryCtx);
3028: DBMS_XMLQuery.closeContext(queryCtx);
3029: l_rows_processed := 1;
3030: EXCEPTION WHEN OTHERS THEN
3031: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
3032: IF l_errNo = 1403 THEN
3033: l_rows_processed := 0;
3034: END IF;
3035: DBMS_XMLQuery.closeContext(queryCtx);

Line 3035: DBMS_XMLQuery.closeContext(queryCtx);

3031: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
3032: IF l_errNo = 1403 THEN
3033: l_rows_processed := 0;
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);