APPS.PER_US_EEO5_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_reporting_year number) is
38:
39: qryCtx DBMS_XMLGEN.ctxHandle;
40: l_result CLOB;
41: l_query varchar2(10000);
42: l_report_date date;
43: l_xml_string varchar2(32000);

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

95: )';
96:
97: FND_FILE.PUT_LINE(FND_FILE.LOG,l_query);
98:
99: qryCtx := dbms_xmlgen.newContext (l_query);
100:
101: l_xml_string := '';
102: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
103: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);

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

106: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
107: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
108:
109: --Load 5 records at a time
110: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
111: LOOP
112: --save the XML into the CLOB field
113: l_result := DBMS_XMLGEN.getXML(qryCtx);
114: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));

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

109: --Load 5 records at a time
110: DBMS_XMLGEN.setMaxRows(qryCtx, 5);
111: LOOP
112: --save the XML into the CLOB field
113: l_result := DBMS_XMLGEN.getXML(qryCtx);
114: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
115: --insert into tab_clob values (to_char(l_xml_string));
116: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
117: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);

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

112: --save the XML into the CLOB field
113: l_result := DBMS_XMLGEN.getXML(qryCtx);
114: l_xml_string := substr( l_result, instr(l_result,'',1),instr(l_result,'',-1) - instr(l_result,'',1));
115: --insert into tab_clob values (to_char(l_xml_string));
116: EXIT WHEN DBMS_XMLGEN.getNumRowsProcessed(qryCtx) = 0;
117: FND_FILE.PUT_LINE(FND_FILE.LOG,l_xml_string);
118: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,l_xml_string);
119:
120: END LOOP;