84: l_varchar_test varchar2(4000);
85:
86:
87:
88: l_xml_report XMLTYPE;
89: l_xml_parameter XMLTYPE;
90: l_xml_head XMLTYPE;
91: l_xml_line XMLTYPE;
92: l_xml_item XMLTYPE;
85:
86:
87:
88: l_xml_report XMLTYPE;
89: l_xml_parameter XMLTYPE;
90: l_xml_head XMLTYPE;
91: l_xml_line XMLTYPE;
92: l_xml_item XMLTYPE;
93: l_xml_head_line XMLTYPE;
86:
87:
88: l_xml_report XMLTYPE;
89: l_xml_parameter XMLTYPE;
90: l_xml_head XMLTYPE;
91: l_xml_line XMLTYPE;
92: l_xml_item XMLTYPE;
93: l_xml_head_line XMLTYPE;
94: l_xml_root XMLTYPE;
87:
88: l_xml_report XMLTYPE;
89: l_xml_parameter XMLTYPE;
90: l_xml_head XMLTYPE;
91: l_xml_line XMLTYPE;
92: l_xml_item XMLTYPE;
93: l_xml_head_line XMLTYPE;
94: l_xml_root XMLTYPE;
95: l_characterset varchar(245);
88: l_xml_report XMLTYPE;
89: l_xml_parameter XMLTYPE;
90: l_xml_head XMLTYPE;
91: l_xml_line XMLTYPE;
92: l_xml_item XMLTYPE;
93: l_xml_head_line XMLTYPE;
94: l_xml_root XMLTYPE;
95: l_characterset varchar(245);
96:
89: l_xml_parameter XMLTYPE;
90: l_xml_head XMLTYPE;
91: l_xml_line XMLTYPE;
92: l_xml_item XMLTYPE;
93: l_xml_head_line XMLTYPE;
94: l_xml_root XMLTYPE;
95: l_characterset varchar(245);
96:
97:
90: l_xml_head XMLTYPE;
91: l_xml_line XMLTYPE;
92: l_xml_item XMLTYPE;
93: l_xml_head_line XMLTYPE;
94: l_xml_root XMLTYPE;
95: l_characterset varchar(245);
96:
97:
98: CURSOR c_mapping_headers is