APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on DBMS_XMLGEN

Line 1587: qryCtx DBMS_XMLGEN.ctxHandle;

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);
1591: l_recent_query VARCHAR2(32767);

Line 1942: qryctx := dbms_xmlgen.newcontext(l_xml_query);

1938: END;
1939:
1940: ELSIF (l_majorVersion >= 9 ) THEN
1941:
1942: qryctx := dbms_xmlgen.newcontext(l_xml_query);
1943: debug('calling getxml');
1944: l_result := dbms_xmlgen.getxml(qryctx,dbms_xmlgen.none);
1945: debug('returned from getxml');
1946: l_rows_processed := dbms_xmlgen.getnumrowsprocessed(qryctx);

Line 1944: l_result := dbms_xmlgen.getxml(qryctx,dbms_xmlgen.none);

1940: ELSIF (l_majorVersion >= 9 ) THEN
1941:
1942: qryctx := dbms_xmlgen.newcontext(l_xml_query);
1943: debug('calling getxml');
1944: l_result := dbms_xmlgen.getxml(qryctx,dbms_xmlgen.none);
1945: debug('returned from getxml');
1946: l_rows_processed := dbms_xmlgen.getnumrowsprocessed(qryctx);
1947: debug('rows prcessed: ' || l_rows_processed);
1948: dbms_xmlgen.closecontext(qryCtx);

Line 1946: l_rows_processed := dbms_xmlgen.getnumrowsprocessed(qryctx);

1942: qryctx := dbms_xmlgen.newcontext(l_xml_query);
1943: debug('calling getxml');
1944: l_result := dbms_xmlgen.getxml(qryctx,dbms_xmlgen.none);
1945: debug('returned from getxml');
1946: l_rows_processed := dbms_xmlgen.getnumrowsprocessed(qryctx);
1947: debug('rows prcessed: ' || l_rows_processed);
1948: dbms_xmlgen.closecontext(qryCtx);
1949:
1950: END IF;

Line 1948: dbms_xmlgen.closecontext(qryCtx);

1944: l_result := dbms_xmlgen.getxml(qryctx,dbms_xmlgen.none);
1945: debug('returned from getxml');
1946: l_rows_processed := dbms_xmlgen.getnumrowsprocessed(qryctx);
1947: debug('rows prcessed: ' || l_rows_processed);
1948: dbms_xmlgen.closecontext(qryCtx);
1949:
1950: END IF;
1951:
1952: debug('XML generation done: ' || l_rows_processed);