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 745: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);

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

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

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

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

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

Line 748: DBMS_XMLGEN.closeContext(qryCtx);

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

Line 875: qryCtx DBMS_XMLGEN.ctxHandle;

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

Line 1904: it is recommended to use DBMS_XMLGEN package.DBMS_XMLGEN package is similar

1900: END;
1901: /*
1902: Bug# 10177944
1903: Starting with 10g DBMS_XMLQUERY package(written java) is deprecated and
1904: it is recommended to use DBMS_XMLGEN package.DBMS_XMLGEN package is similar
1905: to the DBMS_XMLQuery package, except that it is written in C and
1906: compiled into the database kernel.The issue with the DBMS_XMLGEN package is that
1907: it formats the number based on the preferences set.
1908: If the NLS NUMERIC CHARACTERS is set to ",." then the package generates the XML

Line 1906: compiled into the database kernel.The issue with the DBMS_XMLGEN package is that

1902: Bug# 10177944
1903: Starting with 10g DBMS_XMLQUERY package(written java) is deprecated and
1904: it is recommended to use DBMS_XMLGEN package.DBMS_XMLGEN package is similar
1905: to the DBMS_XMLQuery package, except that it is written in C and
1906: compiled into the database kernel.The issue with the DBMS_XMLGEN package is that
1907: it formats the number based on the preferences set.
1908: If the NLS NUMERIC CHARACTERS is set to ",." then the package generates the XML
1909: in such away that all the numbers are formatted using the NLS_NUMERIC_CHARACTERS.
1910: Say, if the number is 12840.5(Raw format) and if NLS_NUMERIC_CHARACTERS is set to ",.",

Line 1942: l_dyn_block := 'DECLARE TYPE l_xml_ref_cur IS REF CURSOR; l_cursor l_xml_ref_cur; qryCtx DBMS_XMLGEN.ctxHandle; v_cur INTEGER; v_ret NUMBER;

1938: --OPEN l_xml_ref FOR l_xml_query;
1939:
1940: /* DBMS_SQL.TO_REFCURSOR is a feature of 11G database so there will be a compilation error for the customers in 10G to overcome it we have used execute immediate to serve the purpose */
1941:
1942: l_dyn_block := 'DECLARE TYPE l_xml_ref_cur IS REF CURSOR; l_cursor l_xml_ref_cur; qryCtx DBMS_XMLGEN.ctxHandle; v_cur INTEGER; v_ret NUMBER;
1943: BEGIN v_cur:= DBMS_SQL.OPEN_CURSOR; DBMS_SQL.PARSE(v_cur,:p1,DBMS_SQL.NATIVE); v_ret := DBMS_SQL.EXECUTE(v_cur); l_cursor := DBMS_SQL.TO_REFCURSOR(v_cur);
1944: qryCtx:= DBMS_XMLGEN.newContext(l_cursor); :p2:= DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE); :p3:= DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
1945: DBMS_XMLGEN.closeContext(qryCtx); CLOSE l_cursor; END;';
1946: execute immediate l_dyn_block using in l_xml_query,out l_result,out l_rows_processed;

Line 1944: qryCtx:= DBMS_XMLGEN.newContext(l_cursor); :p2:= DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE); :p3:= DBMS_XMLGEN.getNumRowsProcessed(qryCtx);

1940: /* DBMS_SQL.TO_REFCURSOR is a feature of 11G database so there will be a compilation error for the customers in 10G to overcome it we have used execute immediate to serve the purpose */
1941:
1942: l_dyn_block := 'DECLARE TYPE l_xml_ref_cur IS REF CURSOR; l_cursor l_xml_ref_cur; qryCtx DBMS_XMLGEN.ctxHandle; v_cur INTEGER; v_ret NUMBER;
1943: BEGIN v_cur:= DBMS_SQL.OPEN_CURSOR; DBMS_SQL.PARSE(v_cur,:p1,DBMS_SQL.NATIVE); v_ret := DBMS_SQL.EXECUTE(v_cur); l_cursor := DBMS_SQL.TO_REFCURSOR(v_cur);
1944: qryCtx:= DBMS_XMLGEN.newContext(l_cursor); :p2:= DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE); :p3:= DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
1945: DBMS_XMLGEN.closeContext(qryCtx); CLOSE l_cursor; END;';
1946: execute immediate l_dyn_block using in l_xml_query,out l_result,out l_rows_processed;
1947:
1948: END IF;

Line 1945: DBMS_XMLGEN.closeContext(qryCtx); CLOSE l_cursor; END;';

1941:
1942: l_dyn_block := 'DECLARE TYPE l_xml_ref_cur IS REF CURSOR; l_cursor l_xml_ref_cur; qryCtx DBMS_XMLGEN.ctxHandle; v_cur INTEGER; v_ret NUMBER;
1943: BEGIN v_cur:= DBMS_SQL.OPEN_CURSOR; DBMS_SQL.PARSE(v_cur,:p1,DBMS_SQL.NATIVE); v_ret := DBMS_SQL.EXECUTE(v_cur); l_cursor := DBMS_SQL.TO_REFCURSOR(v_cur);
1944: qryCtx:= DBMS_XMLGEN.newContext(l_cursor); :p2:= DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE); :p3:= DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
1945: DBMS_XMLGEN.closeContext(qryCtx); CLOSE l_cursor; END;';
1946: execute immediate l_dyn_block using in l_xml_query,out l_result,out l_rows_processed;
1947:
1948: END IF;
1949:

Line 2094: qryCtx DBMS_XMLGEN.ctxHandle;

2090: l_xml_header_length number;
2091: l_errNo NUMBER;
2092: l_errMsg VARCHAR2(200);
2093: queryCtx DBMS_XMLquery.ctxType;
2094: qryCtx DBMS_XMLGEN.ctxHandle;
2095: l_xml_query CLOB;
2096: l_natural_segment_col VARCHAR2(50);
2097: l_flex_value_set_id NUMBER;
2098: l_code_combinations VARCHAR2(32767);

Line 3014: it is recommended to use DBMS_XMLGEN package.DBMS_XMLGEN package is similar

3010:
3011: /*
3012: Bug# 10177944
3013: Starting with 10g DBMS_XMLQUERY package(written java) is deprecated and
3014: it is recommended to use DBMS_XMLGEN package.DBMS_XMLGEN package is similar
3015: to the DBMS_XMLQuery package, except that it is written in C and
3016: compiled into the database kernel.The issue with the DBMS_XMLGEN package is that
3017: it formats the number based on the preferences set.
3018: If the NLS NUMERIC CHARACTERS is set to ",." then the package generates the XML

Line 3016: compiled into the database kernel.The issue with the DBMS_XMLGEN package is that

3012: Bug# 10177944
3013: Starting with 10g DBMS_XMLQUERY package(written java) is deprecated and
3014: it is recommended to use DBMS_XMLGEN package.DBMS_XMLGEN package is similar
3015: to the DBMS_XMLQuery package, except that it is written in C and
3016: compiled into the database kernel.The issue with the DBMS_XMLGEN package is that
3017: it formats the number based on the preferences set.
3018: If the NLS NUMERIC CHARACTERS is set to ",." then the package generates the XML
3019: in such away that all the numbers are formatted using the NLS_NUMERIC_CHARACTERS.
3020: Say, if the number is 12840.5(Raw format) and if NLS_NUMERIC_CHARACTERS is set to ",.",

Line 3049: l_dyn_block := 'DECLARE TYPE l_xml_ref_cur IS REF CURSOR; l_cursor l_xml_ref_cur; qryCtx DBMS_XMLGEN.ctxHandle; v_cur INTEGER; v_ret NUMBER;

3045: l_nls_altered := TRUE;
3046: l_alter_str:= NULL;
3047: END IF;
3048: --OPEN l_xml_ref FOR l_xml_query;
3049: l_dyn_block := 'DECLARE TYPE l_xml_ref_cur IS REF CURSOR; l_cursor l_xml_ref_cur; qryCtx DBMS_XMLGEN.ctxHandle; v_cur INTEGER; v_ret NUMBER;
3050: BEGIN v_cur:= DBMS_SQL.OPEN_CURSOR; DBMS_SQL.PARSE(v_cur,:p1,DBMS_SQL.NATIVE); v_ret := DBMS_SQL.EXECUTE(v_cur); l_cursor := DBMS_SQL.TO_REFCURSOR(v_cur);
3051: qryCtx:= DBMS_XMLGEN.newContext(l_cursor); :p2:= DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE); :p3:= DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
3052: DBMS_XMLGEN.closeContext(qryCtx); CLOSE l_cursor; END;';
3053: execute immediate l_dyn_block using in l_xml_query,out l_result,out l_rows_processed;

Line 3051: qryCtx:= DBMS_XMLGEN.newContext(l_cursor); :p2:= DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE); :p3:= DBMS_XMLGEN.getNumRowsProcessed(qryCtx);

3047: END IF;
3048: --OPEN l_xml_ref FOR l_xml_query;
3049: l_dyn_block := 'DECLARE TYPE l_xml_ref_cur IS REF CURSOR; l_cursor l_xml_ref_cur; qryCtx DBMS_XMLGEN.ctxHandle; v_cur INTEGER; v_ret NUMBER;
3050: BEGIN v_cur:= DBMS_SQL.OPEN_CURSOR; DBMS_SQL.PARSE(v_cur,:p1,DBMS_SQL.NATIVE); v_ret := DBMS_SQL.EXECUTE(v_cur); l_cursor := DBMS_SQL.TO_REFCURSOR(v_cur);
3051: qryCtx:= DBMS_XMLGEN.newContext(l_cursor); :p2:= DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE); :p3:= DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
3052: DBMS_XMLGEN.closeContext(qryCtx); CLOSE l_cursor; END;';
3053: execute immediate l_dyn_block using in l_xml_query,out l_result,out l_rows_processed;
3054:
3055: END IF;

Line 3052: DBMS_XMLGEN.closeContext(qryCtx); CLOSE l_cursor; END;';

3048: --OPEN l_xml_ref FOR l_xml_query;
3049: l_dyn_block := 'DECLARE TYPE l_xml_ref_cur IS REF CURSOR; l_cursor l_xml_ref_cur; qryCtx DBMS_XMLGEN.ctxHandle; v_cur INTEGER; v_ret NUMBER;
3050: BEGIN v_cur:= DBMS_SQL.OPEN_CURSOR; DBMS_SQL.PARSE(v_cur,:p1,DBMS_SQL.NATIVE); v_ret := DBMS_SQL.EXECUTE(v_cur); l_cursor := DBMS_SQL.TO_REFCURSOR(v_cur);
3051: qryCtx:= DBMS_XMLGEN.newContext(l_cursor); :p2:= DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE); :p3:= DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
3052: DBMS_XMLGEN.closeContext(qryCtx); CLOSE l_cursor; END;';
3053: execute immediate l_dyn_block using in l_xml_query,out l_result,out l_rows_processed;
3054:
3055: END IF;
3056:

Line 3200: qryCtx DBMS_XMLGEN.ctxHandle;

3196: l_xml_header_length number;
3197: l_errNo NUMBER;
3198: l_errMsg VARCHAR2(200);
3199: queryCtx DBMS_XMLquery.ctxType;
3200: qryCtx DBMS_XMLGEN.ctxHandle;
3201: l_xml_query VARCHAR2(32767);
3202: l_natural_segment_col VARCHAR2(50);
3203: l_flex_value_set_id NUMBER;
3204: l_code_combinations VARCHAR2(32767);

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

3538: END IF;
3539: DBMS_XMLQuery.closeContext(queryCtx);
3540: END;
3541: ELSIF (l_majorVersion >= 9 ) THEN
3542: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
3543: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
3544: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
3545: DBMS_XMLGEN.closeContext(qryCtx);
3546: END IF;

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

3539: DBMS_XMLQuery.closeContext(queryCtx);
3540: END;
3541: ELSIF (l_majorVersion >= 9 ) THEN
3542: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
3543: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
3544: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
3545: DBMS_XMLGEN.closeContext(qryCtx);
3546: END IF;
3547: IF l_rows_processed <> 0 THEN

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

3540: END;
3541: ELSIF (l_majorVersion >= 9 ) THEN
3542: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
3543: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
3544: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
3545: DBMS_XMLGEN.closeContext(qryCtx);
3546: END IF;
3547: IF l_rows_processed <> 0 THEN
3548: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');

Line 3545: DBMS_XMLGEN.closeContext(qryCtx);

3541: ELSIF (l_majorVersion >= 9 ) THEN
3542: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
3543: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
3544: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
3545: DBMS_XMLGEN.closeContext(qryCtx);
3546: END IF;
3547: IF l_rows_processed <> 0 THEN
3548: l_resultOffset := DBMS_LOB.INSTR(l_result,'>');
3549: tempResult := l_result;

Line 3672: qryCtx DBMS_XMLGEN.ctxHandle;

3668: l_rows_processed number;
3669: l_xml_header varchar2(3000);
3670: l_xml_header_length number;
3671: queryCtx DBMS_XMLquery.ctxType;
3672: qryCtx DBMS_XMLGEN.ctxHandle;
3673: l_xml_query VARCHAR2(32767);
3674: l_natural_segment_col VARCHAR2(50);
3675: l_flex_value_set_id NUMBER;
3676: l_code_combinations VARCHAR2(32767);

Line 4815: it is recommended to use DBMS_XMLGEN package.DBMS_XMLGEN package is similar

4811:
4812: /*
4813: Bug# 10177944
4814: Starting with 10g DBMS_XMLQUERY package(written java) is deprecated and
4815: it is recommended to use DBMS_XMLGEN package.DBMS_XMLGEN package is similar
4816: to the DBMS_XMLQuery package, except that it is written in C and
4817: compiled into the database kernel.The issue with the DBMS_XMLGEN package is that
4818: it formats the number based on the preferences set.
4819: If the NLS NUMERIC CHARACTERS is set to ",." then the package generates the XML

Line 4817: compiled into the database kernel.The issue with the DBMS_XMLGEN package is that

4813: Bug# 10177944
4814: Starting with 10g DBMS_XMLQUERY package(written java) is deprecated and
4815: it is recommended to use DBMS_XMLGEN package.DBMS_XMLGEN package is similar
4816: to the DBMS_XMLQuery package, except that it is written in C and
4817: compiled into the database kernel.The issue with the DBMS_XMLGEN package is that
4818: it formats the number based on the preferences set.
4819: If the NLS NUMERIC CHARACTERS is set to ",." then the package generates the XML
4820: in such away that all the numbers are formatted using the NLS_NUMERIC_CHARACTERS.
4821: Say, if the number is 12840.5(Raw format) and if NLS_NUMERIC_CHARACTERS is set to ",.",

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

4847: l_nls_altered := TRUE;
4848: l_alter_str:= NULL;
4849: END IF;
4850:
4851: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
4852: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
4853: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
4854: DBMS_XMLGEN.closeContext(qryCtx);
4855: END IF;

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

4848: l_alter_str:= NULL;
4849: END IF;
4850:
4851: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
4852: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
4853: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
4854: DBMS_XMLGEN.closeContext(qryCtx);
4855: END IF;
4856:

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

4849: END IF;
4850:
4851: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
4852: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
4853: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
4854: DBMS_XMLGEN.closeContext(qryCtx);
4855: END IF;
4856:
4857: /* Changes for bug 10177944 */

Line 4854: DBMS_XMLGEN.closeContext(qryCtx);

4850:
4851: qryCtx := DBMS_XMLGEN.newContext(l_xml_query);
4852: l_result := DBMS_XMLGEN.getXML(qryCtx,DBMS_XMLGEN.NONE);
4853: l_rows_processed := DBMS_XMLGEN.getNumRowsProcessed(qryCtx);
4854: DBMS_XMLGEN.closeContext(qryCtx);
4855: END IF;
4856:
4857: /* Changes for bug 10177944 */
4858: /*If NLS_NUMERIC_CHAR has been modified, restore the same*/