create or replace package wmp_report_query as type DriverRecord is record ( query_type char, format_type char, section_name varchar2(100), layout_name varchar2(100), query_name varchar2(100), layout_value varchar2(200), query_statement varchar2(32000) ); type DriverCursor is ref cursor return DriverRecord; function report_type(object_type in varchar2) return varchar2; function report_category(object_type in varchar2) return varchar2; function driver_cursor(p_report_type in varchar2) return DriverCursor; end wmp_report_query;