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 732: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);

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

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

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

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

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

Line 735: DBMS_XMLQuery.closeContext(queryCtx);

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

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

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

Line 742: DBMS_XMLQuery.closeContext(queryCtx);

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

Line 874: queryCtx DBMS_XMLquery.ctxType;

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

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

1885: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
1886:
1887: IF (l_majorVersion > 8 and l_majorVersion < 11) THEN
1888: BEGIN
1889: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
1890: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
1891: l_result := DBMS_XMLQuery.getXML(queryCtx);
1892: DBMS_XMLQuery.closeContext(queryCtx);
1893: l_rows_processed := 1;

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

1886:
1887: IF (l_majorVersion > 8 and l_majorVersion < 11) THEN
1888: BEGIN
1889: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
1890: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
1891: l_result := DBMS_XMLQuery.getXML(queryCtx);
1892: DBMS_XMLQuery.closeContext(queryCtx);
1893: l_rows_processed := 1;
1894: EXCEPTION WHEN OTHERS THEN

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

1887: IF (l_majorVersion > 8 and l_majorVersion < 11) THEN
1888: BEGIN
1889: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
1890: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
1891: l_result := DBMS_XMLQuery.getXML(queryCtx);
1892: DBMS_XMLQuery.closeContext(queryCtx);
1893: l_rows_processed := 1;
1894: EXCEPTION WHEN OTHERS THEN
1895: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);

Line 1892: DBMS_XMLQuery.closeContext(queryCtx);

1888: BEGIN
1889: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
1890: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
1891: l_result := DBMS_XMLQuery.getXML(queryCtx);
1892: DBMS_XMLQuery.closeContext(queryCtx);
1893: l_rows_processed := 1;
1894: EXCEPTION WHEN OTHERS THEN
1895: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
1896: IF l_errNo = 1403 THEN

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

1891: l_result := DBMS_XMLQuery.getXML(queryCtx);
1892: DBMS_XMLQuery.closeContext(queryCtx);
1893: l_rows_processed := 1;
1894: EXCEPTION WHEN OTHERS THEN
1895: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
1896: IF l_errNo = 1403 THEN
1897: l_rows_processed := 0;
1898: END IF;
1899: DBMS_XMLQuery.closeContext(queryCtx);

Line 1899: DBMS_XMLQuery.closeContext(queryCtx);

1895: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
1896: IF l_errNo = 1403 THEN
1897: l_rows_processed := 0;
1898: END IF;
1899: DBMS_XMLQuery.closeContext(queryCtx);
1900: END;
1901: /*
1902: Bug# 10177944
1903: Starting with 10g DBMS_XMLQUERY package(written java) is deprecated and

Line 1903: Starting with 10g DBMS_XMLQUERY package(written java) is deprecated and

1899: DBMS_XMLQuery.closeContext(queryCtx);
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.

Line 1905: to the DBMS_XMLQuery package, except that it is written in C and

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
1909: in such away that all the numbers are formatted using the NLS_NUMERIC_CHARACTERS.

Line 2093: queryCtx DBMS_XMLquery.ctxType;

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

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

2994: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
2995:
2996: IF (l_majorVersion > 8 and l_majorVersion < 11) THEN
2997: BEGIN
2998: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
2999: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
3000: l_result := DBMS_XMLQuery.getXML(queryCtx);
3001: DBMS_XMLQuery.closeContext(queryCtx);
3002: l_rows_processed := 1;

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

2995:
2996: IF (l_majorVersion > 8 and l_majorVersion < 11) THEN
2997: BEGIN
2998: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
2999: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
3000: l_result := DBMS_XMLQuery.getXML(queryCtx);
3001: DBMS_XMLQuery.closeContext(queryCtx);
3002: l_rows_processed := 1;
3003: EXCEPTION WHEN OTHERS THEN

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

2996: IF (l_majorVersion > 8 and l_majorVersion < 11) THEN
2997: BEGIN
2998: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
2999: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
3000: l_result := DBMS_XMLQuery.getXML(queryCtx);
3001: DBMS_XMLQuery.closeContext(queryCtx);
3002: l_rows_processed := 1;
3003: EXCEPTION WHEN OTHERS THEN
3004: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);

Line 3001: DBMS_XMLQuery.closeContext(queryCtx);

2997: BEGIN
2998: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
2999: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
3000: l_result := DBMS_XMLQuery.getXML(queryCtx);
3001: DBMS_XMLQuery.closeContext(queryCtx);
3002: l_rows_processed := 1;
3003: EXCEPTION WHEN OTHERS THEN
3004: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
3005: IF l_errNo = 1403 THEN

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

3000: l_result := DBMS_XMLQuery.getXML(queryCtx);
3001: DBMS_XMLQuery.closeContext(queryCtx);
3002: l_rows_processed := 1;
3003: EXCEPTION WHEN OTHERS THEN
3004: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
3005: IF l_errNo = 1403 THEN
3006: l_rows_processed := 0;
3007: END IF;
3008: DBMS_XMLQuery.closeContext(queryCtx);

Line 3008: DBMS_XMLQuery.closeContext(queryCtx);

3004: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
3005: IF l_errNo = 1403 THEN
3006: l_rows_processed := 0;
3007: END IF;
3008: DBMS_XMLQuery.closeContext(queryCtx);
3009: END;
3010:
3011: /*
3012: Bug# 10177944

Line 3013: Starting with 10g DBMS_XMLQUERY package(written java) is deprecated and

3009: END;
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.

Line 3015: to the DBMS_XMLQuery package, except that it is written in C and

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
3019: in such away that all the numbers are formatted using the NLS_NUMERIC_CHARACTERS.

Line 3199: queryCtx DBMS_XMLquery.ctxType;

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

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

3525: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
3526:
3527: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
3528: BEGIN
3529: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
3530: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
3531: l_result := DBMS_XMLQuery.getXML(queryCtx);
3532: DBMS_XMLQuery.closeContext(queryCtx);
3533: l_rows_processed := 1;

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

3526:
3527: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
3528: BEGIN
3529: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
3530: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
3531: l_result := DBMS_XMLQuery.getXML(queryCtx);
3532: DBMS_XMLQuery.closeContext(queryCtx);
3533: l_rows_processed := 1;
3534: EXCEPTION WHEN OTHERS THEN

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

3527: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
3528: BEGIN
3529: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
3530: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
3531: l_result := DBMS_XMLQuery.getXML(queryCtx);
3532: DBMS_XMLQuery.closeContext(queryCtx);
3533: l_rows_processed := 1;
3534: EXCEPTION WHEN OTHERS THEN
3535: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);

Line 3532: DBMS_XMLQuery.closeContext(queryCtx);

3528: BEGIN
3529: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
3530: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
3531: l_result := DBMS_XMLQuery.getXML(queryCtx);
3532: DBMS_XMLQuery.closeContext(queryCtx);
3533: l_rows_processed := 1;
3534: EXCEPTION WHEN OTHERS THEN
3535: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
3536: IF l_errNo = 1403 THEN

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

3531: l_result := DBMS_XMLQuery.getXML(queryCtx);
3532: DBMS_XMLQuery.closeContext(queryCtx);
3533: l_rows_processed := 1;
3534: EXCEPTION WHEN OTHERS THEN
3535: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
3536: IF l_errNo = 1403 THEN
3537: l_rows_processed := 0;
3538: END IF;
3539: DBMS_XMLQuery.closeContext(queryCtx);

Line 3539: DBMS_XMLQuery.closeContext(queryCtx);

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

Line 3671: queryCtx DBMS_XMLquery.ctxType;

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

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

4795: l_majorVersion := to_number(substr(l_version, 1, instr(l_version,'.')-1));
4796:
4797: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
4798: BEGIN
4799: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
4800: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
4801: l_result := DBMS_XMLQuery.getXML(queryCtx);
4802: DBMS_XMLQuery.closeContext(queryCtx);
4803: l_rows_processed := 1;

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

4796:
4797: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
4798: BEGIN
4799: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
4800: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
4801: l_result := DBMS_XMLQuery.getXML(queryCtx);
4802: DBMS_XMLQuery.closeContext(queryCtx);
4803: l_rows_processed := 1;
4804: EXCEPTION WHEN OTHERS THEN

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

4797: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
4798: BEGIN
4799: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
4800: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
4801: l_result := DBMS_XMLQuery.getXML(queryCtx);
4802: DBMS_XMLQuery.closeContext(queryCtx);
4803: l_rows_processed := 1;
4804: EXCEPTION WHEN OTHERS THEN
4805: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);

Line 4802: DBMS_XMLQuery.closeContext(queryCtx);

4798: BEGIN
4799: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
4800: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
4801: l_result := DBMS_XMLQuery.getXML(queryCtx);
4802: DBMS_XMLQuery.closeContext(queryCtx);
4803: l_rows_processed := 1;
4804: EXCEPTION WHEN OTHERS THEN
4805: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
4806: IF l_errNo = 1403 THEN

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

4801: l_result := DBMS_XMLQuery.getXML(queryCtx);
4802: DBMS_XMLQuery.closeContext(queryCtx);
4803: l_rows_processed := 1;
4804: EXCEPTION WHEN OTHERS THEN
4805: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
4806: IF l_errNo = 1403 THEN
4807: l_rows_processed := 0;
4808: END IF;
4809: DBMS_XMLQuery.closeContext(queryCtx);

Line 4809: DBMS_XMLQuery.closeContext(queryCtx);

4805: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
4806: IF l_errNo = 1403 THEN
4807: l_rows_processed := 0;
4808: END IF;
4809: DBMS_XMLQuery.closeContext(queryCtx);
4810: END;
4811:
4812: /*
4813: Bug# 10177944

Line 4814: Starting with 10g DBMS_XMLQUERY package(written java) is deprecated and

4810: END;
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.

Line 4816: to the DBMS_XMLQuery package, except that it is written in C and

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
4820: in such away that all the numbers are formatted using the NLS_NUMERIC_CHARACTERS.