APPS.PER_US_IPEDS_EXP_PKG dependencies on DBMS_XMLGEN

Line 39: qryCtx DBMS_XMLGEN.ctxHandle;

35: ,retcode OUT NOCOPY NUMBER
36: ,p_business_group_id varchar2
37: , p_report_date varchar2) is
38:
39: qryCtx DBMS_XMLGEN.ctxHandle;
40: l_result CLOB;
41: l_query varchar2(10000);
42: l_reporting_year number(4);
43: l_xml_string varchar2(32000);

Line 107: qryCtx := dbms_xmlgen.newContext (l_query);

103: )';
104:
105: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query);
106:
107: qryCtx := dbms_xmlgen.newContext (l_query);
108:
109: l_xml_string := '';
110: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

Line 118: DBMS_XMLGEN.setMaxRows(qryCtx, 5);

114: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
115: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
116:
117: --Load 5 records at a time
118: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
119: LOOP
120: --save the XML into the CLOB field
121: l_result := DBMS_XMLGEN.getXML(qryCtx);
122: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));

Line 121: l_result := DBMS_XMLGEN.getXML(qryCtx);

117: --Load 5 records at a time
118: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
119: LOOP
120: --save the XML into the CLOB field
121: l_result := DBMS_XMLGEN.getXML(qryCtx);
122: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
123: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
124: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
125: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

Line 123: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;

119: LOOP
120: --save the XML into the CLOB field
121: l_result := DBMS_XMLGEN.getXML(qryCtx);
122: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
123: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
124: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
125: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
126:
127: END LOOP;