APPS.GR_XML_REPORTS dependencies on DBMS_XMLGEN

Line 22: l_queryctx DBMS_XMLGEN.ctxhandle;

18:
19: p_from_date DATE;
20: p_to_date DATE;
21: l_xml_query VARCHAR2 (32000);
22: l_queryctx DBMS_XMLGEN.ctxhandle;
23: l_xml_result CLOB;
24: BEGIN
25: p_from_date := fnd_date.canonical_to_date(p_from_date_sent);
26: p_to_date := fnd_date.canonical_to_date(p_to_date_sent);

Line 109: l_queryctx := DBMS_XMLGEN.newcontext (l_xml_query);

105: || ' WHERE organization_id = ' || p_organization_id;
106:
107: fnd_file.put_line (fnd_file.LOG, l_xml_query);
108:
109: l_queryctx := DBMS_XMLGEN.newcontext (l_xml_query);
110: l_xml_result := DBMS_XMLGEN.getxml (l_queryctx);
111: xml_transfer (p_xml_clob => l_xml_result);
112: DBMS_XMLGEN.closecontext (l_queryctx);
113:

Line 110: l_xml_result := DBMS_XMLGEN.getxml (l_queryctx);

106:
107: fnd_file.put_line (fnd_file.LOG, l_xml_query);
108:
109: l_queryctx := DBMS_XMLGEN.newcontext (l_xml_query);
110: l_xml_result := DBMS_XMLGEN.getxml (l_queryctx);
111: xml_transfer (p_xml_clob => l_xml_result);
112: DBMS_XMLGEN.closecontext (l_queryctx);
113:
114: EXCEPTION

Line 112: DBMS_XMLGEN.closecontext (l_queryctx);

108:
109: l_queryctx := DBMS_XMLGEN.newcontext (l_xml_query);
110: l_xml_result := DBMS_XMLGEN.getxml (l_queryctx);
111: xml_transfer (p_xml_clob => l_xml_result);
112: DBMS_XMLGEN.closecontext (l_queryctx);
113:
114: EXCEPTION
115: WHEN OTHERS THEN
116: fnd_file.put_line (fnd_file.LOG, 'Exception in procedure DISPATCH_HISTORY_REPORT ' || SQLCODE || ' ' || SQLERRM);