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_CUMULATIVE_BALANCE_REPORT dependencies on DBMS_XMLQUERY

Line 1586: queryCtx DBMS_XMLquery.ctxType;

1582: l_xml_header varchar2(3000);
1583: l_xml_header_length number;
1584: l_errNo NUMBER;
1585: l_errMsg VARCHAR2(200);
1586: queryCtx DBMS_XMLquery.ctxType;
1587: qryCtx DBMS_XMLGEN.ctxHandle;
1588:
1589: l_xml_query VARCHAR2(32767);
1590: l_base_query VARCHAR2(32767);

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

1920:
1921: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
1922:
1923: BEGIN
1924: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
1925: dbms_xmlquery.setRaiseNoRowsException(queryCtx,TRUE);
1926: debug('calling getxml');
1927: l_result := DBMS_XMLQuery.getXML(queryCtx);
1928: debug('returned from getxml');

Line 1925: dbms_xmlquery.setRaiseNoRowsException(queryCtx,TRUE);

1921: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
1922:
1923: BEGIN
1924: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
1925: dbms_xmlquery.setRaiseNoRowsException(queryCtx,TRUE);
1926: debug('calling getxml');
1927: l_result := DBMS_XMLQuery.getXML(queryCtx);
1928: debug('returned from getxml');
1929: dbms_xmlquery.closeContext(queryCtx);

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

1923: BEGIN
1924: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
1925: dbms_xmlquery.setRaiseNoRowsException(queryCtx,TRUE);
1926: debug('calling getxml');
1927: l_result := DBMS_XMLQuery.getXML(queryCtx);
1928: debug('returned from getxml');
1929: dbms_xmlquery.closeContext(queryCtx);
1930: l_rows_processed := 1;
1931:

Line 1929: dbms_xmlquery.closeContext(queryCtx);

1925: dbms_xmlquery.setRaiseNoRowsException(queryCtx,TRUE);
1926: debug('calling getxml');
1927: l_result := DBMS_XMLQuery.getXML(queryCtx);
1928: debug('returned from getxml');
1929: dbms_xmlquery.closeContext(queryCtx);
1930: l_rows_processed := 1;
1931:
1932: EXCEPTION WHEN OTHERS THEN
1933: dbms_xmlquery.getexceptioncontent(queryCtx,l_errNo,l_errMsg);

Line 1933: dbms_xmlquery.getexceptioncontent(queryCtx,l_errNo,l_errMsg);

1929: dbms_xmlquery.closeContext(queryCtx);
1930: l_rows_processed := 1;
1931:
1932: EXCEPTION WHEN OTHERS THEN
1933: dbms_xmlquery.getexceptioncontent(queryCtx,l_errNo,l_errMsg);
1934: IF l_errNo = 1403 THEN
1935: l_rows_processed := 0;
1936: END IF;
1937: dbms_xmlquery.closecontext(queryCtx);

Line 1937: dbms_xmlquery.closecontext(queryCtx);

1933: dbms_xmlquery.getexceptioncontent(queryCtx,l_errNo,l_errMsg);
1934: IF l_errNo = 1403 THEN
1935: l_rows_processed := 0;
1936: END IF;
1937: dbms_xmlquery.closecontext(queryCtx);
1938: END;
1939:
1940: ELSIF (l_majorVersion >= 9 ) THEN
1941: