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 1615: queryCtx DBMS_XMLquery.ctxType;

1611: l_xml_header varchar2(3000);
1612: l_xml_header_length number;
1613: l_errNo NUMBER;
1614: l_errMsg VARCHAR2(200);
1615: queryCtx DBMS_XMLquery.ctxType;
1616: qryCtx DBMS_XMLGEN.ctxHandle;
1617:
1618: l_xml_query VARCHAR2(32767);
1619: l_base_query VARCHAR2(32767);

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

1949:
1950: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
1951:
1952: BEGIN
1953: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
1954: dbms_xmlquery.setRaiseNoRowsException(queryCtx,TRUE);
1955: debug('calling getxml');
1956: l_result := DBMS_XMLQuery.getXML(queryCtx);
1957: debug('returned from getxml');

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

1950: IF (l_majorVersion > 8 and l_majorVersion < 9) THEN
1951:
1952: BEGIN
1953: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
1954: dbms_xmlquery.setRaiseNoRowsException(queryCtx,TRUE);
1955: debug('calling getxml');
1956: l_result := DBMS_XMLQuery.getXML(queryCtx);
1957: debug('returned from getxml');
1958: dbms_xmlquery.closeContext(queryCtx);

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

1952: BEGIN
1953: queryCtx := DBMS_XMLQuery.newContext(l_xml_query);
1954: dbms_xmlquery.setRaiseNoRowsException(queryCtx,TRUE);
1955: debug('calling getxml');
1956: l_result := DBMS_XMLQuery.getXML(queryCtx);
1957: debug('returned from getxml');
1958: dbms_xmlquery.closeContext(queryCtx);
1959: l_rows_processed := 1;
1960:

Line 1958: dbms_xmlquery.closeContext(queryCtx);

1954: dbms_xmlquery.setRaiseNoRowsException(queryCtx,TRUE);
1955: debug('calling getxml');
1956: l_result := DBMS_XMLQuery.getXML(queryCtx);
1957: debug('returned from getxml');
1958: dbms_xmlquery.closeContext(queryCtx);
1959: l_rows_processed := 1;
1960:
1961: EXCEPTION WHEN OTHERS THEN
1962: dbms_xmlquery.getexceptioncontent(queryCtx,l_errNo,l_errMsg);

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

1958: dbms_xmlquery.closeContext(queryCtx);
1959: l_rows_processed := 1;
1960:
1961: EXCEPTION WHEN OTHERS THEN
1962: dbms_xmlquery.getexceptioncontent(queryCtx,l_errNo,l_errMsg);
1963: IF l_errNo = 1403 THEN
1964: l_rows_processed := 0;
1965: END IF;
1966: dbms_xmlquery.closecontext(queryCtx);

Line 1966: dbms_xmlquery.closecontext(queryCtx);

1962: dbms_xmlquery.getexceptioncontent(queryCtx,l_errNo,l_errMsg);
1963: IF l_errNo = 1403 THEN
1964: l_rows_processed := 0;
1965: END IF;
1966: dbms_xmlquery.closecontext(queryCtx);
1967: END;
1968:
1969: ELSIF (l_majorVersion >= 9 ) THEN
1970: