APPS.AR_CUMULATIVE_BALANCE_REPORT dependencies on DBMS_XMLGEN

Line 1616: qryCtx DBMS_XMLGEN.ctxHandle;

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

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

1967: END;
1968:
1969: ELSIF (l_majorVersion >= 9 ) THEN
1970:
1971: qryctx := dbms_xmlgen.newcontext(l_xml_query);
1972: debug('calling getxml');
1973: l_result := dbms_xmlgen.getxml(qryctx,dbms_xmlgen.none);
1974: debug('returned from getxml');
1975: l_rows_processed := dbms_xmlgen.getnumrowsprocessed(qryctx);

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

1969: ELSIF (l_majorVersion >= 9 ) THEN
1970:
1971: qryctx := dbms_xmlgen.newcontext(l_xml_query);
1972: debug('calling getxml');
1973: l_result := dbms_xmlgen.getxml(qryctx,dbms_xmlgen.none);
1974: debug('returned from getxml');
1975: l_rows_processed := dbms_xmlgen.getnumrowsprocessed(qryctx);
1976: debug('rows prcessed: ' || l_rows_processed);
1977: dbms_xmlgen.closecontext(qryCtx);

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

1971: qryctx := dbms_xmlgen.newcontext(l_xml_query);
1972: debug('calling getxml');
1973: l_result := dbms_xmlgen.getxml(qryctx,dbms_xmlgen.none);
1974: debug('returned from getxml');
1975: l_rows_processed := dbms_xmlgen.getnumrowsprocessed(qryctx);
1976: debug('rows prcessed: ' || l_rows_processed);
1977: dbms_xmlgen.closecontext(qryCtx);
1978:
1979: END IF;

Line 1977: dbms_xmlgen.closecontext(qryCtx);

1973: l_result := dbms_xmlgen.getxml(qryctx,dbms_xmlgen.none);
1974: debug('returned from getxml');
1975: l_rows_processed := dbms_xmlgen.getnumrowsprocessed(qryctx);
1976: debug('rows prcessed: ' || l_rows_processed);
1977: dbms_xmlgen.closecontext(qryCtx);
1978:
1979: END IF;
1980:
1981: debug('XML generation done: ' || l_rows_processed);