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.AR_AGING_BUCKETS_PKG dependencies on DBMS_XMLQUERY

Line 2962: queryCtx DBMS_XMLquery.ctxType;

2958: l_resultOffset NUMBER;
2959: l_rows_processed NUMBER;
2960: l_xml_header VARCHAR2(32000);
2961: l_xml_header_length NUMBER;
2962: queryCtx DBMS_XMLquery.ctxType;
2963: qryCtx DBMS_XMLGEN.ctxHandle;
2964: l_errNo NUMBER;
2965: l_errMsg VARCHAR2(200);
2966: l_nls_numeric_char VARCHAR2(5);

Line 2988: queryCtx := DBMS_XMLQuery.newContext( p_extract_query );

2984:
2985: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
2986:
2987: BEGIN
2988: queryCtx := DBMS_XMLQuery.newContext( p_extract_query );
2989: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
2990:
2991: IF PG_DEBUG in ('Y', 'C') THEN
2992: arp_standard.debug( 'Query context set.call to getXML...');

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

2985: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
2986:
2987: BEGIN
2988: queryCtx := DBMS_XMLQuery.newContext( p_extract_query );
2989: DBMS_XMLQuery.setRaiseNoRowsException(queryCtx,TRUE);
2990:
2991: IF PG_DEBUG in ('Y', 'C') THEN
2992: arp_standard.debug( 'Query context set.call to getXML...');
2993: END IF;

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

2991: IF PG_DEBUG in ('Y', 'C') THEN
2992: arp_standard.debug( 'Query context set.call to getXML...');
2993: END IF;
2994:
2995: l_result := DBMS_XMLQuery.getXML(queryCtx);
2996: DBMS_XMLQuery.closeContext(queryCtx);
2997:
2998: l_rows_processed := 1;
2999:

Line 2996: DBMS_XMLQuery.closeContext(queryCtx);

2992: arp_standard.debug( 'Query context set.call to getXML...');
2993: END IF;
2994:
2995: l_result := DBMS_XMLQuery.getXML(queryCtx);
2996: DBMS_XMLQuery.closeContext(queryCtx);
2997:
2998: l_rows_processed := 1;
2999:
3000: EXCEPTION WHEN OTHERS THEN

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

2997:
2998: l_rows_processed := 1;
2999:
3000: EXCEPTION WHEN OTHERS THEN
3001: DBMS_XMLQuery.getExceptionContent(queryCtx,l_errNo,l_errMsg);
3002: IF PG_DEBUG in ('Y', 'C') THEN
3003: arp_standard.debug( 'l_errNo '||l_errNo);
3004: END IF;
3005:

Line 3010: DBMS_XMLQuery.closeContext(queryCtx);

3006: IF l_errNo = 1403 THEN
3007: l_rows_processed := 0;
3008: END IF;
3009:
3010: DBMS_XMLQuery.closeContext(queryCtx);
3011: END;
3012: /*
3013: RVIRIYAL: Bug#9672615
3014: Starting with 10g DBMS_XMLQUERY package(written java) is deprecated and

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

3010: DBMS_XMLQuery.closeContext(queryCtx);
3011: END;
3012: /*
3013: RVIRIYAL: Bug#9672615
3014: Starting with 10g DBMS_XMLQUERY package(written java) is deprecated and
3015: it is recommended to use DBMS_XMLGEN package.DBMS_XMLGEN package is similar
3016: to the DBMS_XMLQuery package, except that it is written in C and
3017: compiled into the database kernel.The issue with the DBMS_XMLGEN package is that
3018: it formats the number based on the preferences set.

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

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