set define '^' set verify off prompt ...wwv_flow_svg Rem NAME Rem wwv_flow_svg.sql Rem Arguments: Rem 1: Rem 2: Rem 3: Flow user Rem MODIFIED (MM/DD/YYYY) Rem cbcho 10/08/2002 - Created Rem cbcho 11/07/2002 - Redefined g_axis_interval number type to have decimals Rem cbcho 01/30/2003 - Added set_attributes procedure (Bug 2773774) Rem cbcho 03/12/2003 - Bug 2773774: Added fix to Bug 2773774 again. Somehow it didn't get included 1.3.5 Rem cbcho 04/16/2003 - Bug 2722911: Added LINE and SCATTER charts Rem cbcho 04/17/2003 - Added g_org_chart_width Rem cbcho 04/21/2003 - Added g_x_axis_format, g_y_axis_format Rem cbcho 04/24/2003 - Added g_chart_viewbox_height,g_chart_viewbox_width,g_chart_org_height,g_chart_org_width Rem cbcho 04/25/2003 - Changed set_attributes not to accept p_chart_title parameter Rem msewtz 07/23/2003 - Added g_negative_offset (bug 3040429) Rem msewtz 04/01/2004 - Added Support for stacked and clustered charts Rem cbackstrom 06/02/2004 - Addition of dial charts, new header and footer print out sections for css changes and javascript changes Rem cbackstrom 06/02/2004 - changes to most graphs to disconnect css from from style tags for custom css and font-selection bugs Rem cbcho 01/22/2006 - Added migrate_svg_to_flash create or replace package wwv_flow_svg as -- Copyright (c) Oracle Corporation 2002. All Rights Reserved. -- -- -- DESCRIPTION -- Flow SVG charting engine -- -- NOTES -- -- -- SECURITY -- No grants, must be run as FLOW schema owner. -- -- NOTES -- -- INTERNATIONALIZATION -- unknown -- -- MULTI-CUSTOMER -- unknown -- -- CUSTOMER MAY CUSTOMIZE -- NO -- -- RUNTIME DEPLOYMENT: YES -- d1 varchar2(255); d2 varchar2(255); d3 varchar2(255); d4 varchar2(255); d5 varchar2(255); type values_table is table of wwv_flow_global.vc_arr2 index by binary_integer; empty_vc_arr wwv_flow_global.vc_arr2; -- -- global constants -- g_height_id pls_integer := 30; g_width_id pls_integer := 31; -- -- global variables -- g_region_id number := 0; -- g_max_rows number := 0; g_overall_max_rows number := 0; g_more_data_exist boolean := false; -- g_link_init wwv_flow_global.vc_arr2; g_link wwv_flow_global.vc_arr2; g_label_init wwv_flow_global.vc_arr2; g_label wwv_flow_global.vc_arr2; g_value_init wwv_flow_global.vc_arr2; g_value wwv_flow_global.vc_arr2; g_prev_value wwv_flow_global.vc_arr2; g_colors wwv_flow_global.vc_arr2; g_row_cnt number := 0; g_sValues values_table; g_sLabels values_table; g_sLinks values_table; -- g_total_value number := 0; g_max_label_length number := 0; g_max_value number := 0; g_min_value number := 0; g_max_element number := 0; g_min_element number := 0; -- g_theme varchar2(4000) := null; g_chart_type varchar2(4000) := null; g_chart_title varchar2(32767) := null; g_x_axis_title varchar2(32767) := null; g_y_axis_title varchar2(32767) := null; g_graph_size number := 0; g_chart_height number := 0; g_chart_width number := 0; -- -- original passed chart width and height value -- g_chart_org_height number := 0; g_chart_org_width number := 0; -- -- chart width and height for view box -- g_chart_viewbox_height number := 0; g_chart_viewbox_width number := 0; -- g_bar_width number := 0; g_num_mask varchar2(250); g_gap number := 0; g_data_labels varchar2(4000) := null; g_3d boolean; g_show_legend boolean; g_legend_bg_color varchar2(4000) := null; -- g_grid_visible boolean; g_axis_interval number(30,5) := 0; g_axis_major_unit number := 0; g_axis_min number := 0; g_axis_max number := 0; -- g_title_font_face varchar2(4000) := null; g_title_font_size number := 0; g_title_font_color varchar2(4000) := null; g_label_font_face varchar2(4000) := null; g_label_font_size number := 0; g_label_font_color varchar2(4000) := null; g_value_font_face varchar2(4000) := null; g_value_font_size number := 0; g_value_font_color varchar2(4000) := null; g_legend_font_face varchar2(4000) := null; g_legend_font_size number := 0; g_legend_font_color varchar2(4000) := null; g_x_axis_title_font_face varchar2(4000) := null; g_x_axis_title_font_size number := 0; g_x_axis_title_font_color varchar2(4000) := null; g_y_axis_title_font_face varchar2(4000) := null; g_y_axis_title_font_size number := 0; g_y_axis_title_font_color varchar2(4000) := null; -- g_series_queries wwv_flow_global.vc_arr2; g_series_max_rows wwv_flow_global.vc_arr2; g_series_no_data_found wwv_flow_global.vc_arr2; g_series_colors wwv_flow_global.vc_arr2; g_series_names wwv_flow_global.vc_arr2; g_series_labels wwv_flow_global.vc_arr2; g_series_formats wwv_flow_global.vc_arr2; g_series_orientations wwv_flow_global.vc_arr2; g_series_marker_styles wwv_flow_global.vc_arr2; g_series_marker_sizes wwv_flow_global.vc_arr2; g_series_line_styles wwv_flow_global.vc_arr2; g_series_line_weights wwv_flow_global.vc_arr2; -- g_series_name varchar2(32767) := null; g_series_color varchar2(32767) := null; g_data_format varchar2(32767) := null; g_data_orientation varchar2(32767) := null; g_series_marker_style varchar2(32767) := null; g_series_marker_size varchar2(32767) := null; g_series_line_style varchar2(32767) := null; -- g_x_axis_min_value number := 0; g_y_axis_min_value number := 0; g_x_axis_max_value number := 0; g_y_axis_max_value number := 0; g_x_axis_major_unit number := 0; g_y_axis_major_unit number := 0; g_x_axis_interval number := 0; g_y_axis_interval number := 0; g_x_axis_max number := 0; g_y_axis_max number := 0; g_x_axis_min number := 0; g_y_axis_min number := 0; g_x_axis_format varchar2(4000) := null; g_y_axis_format varchar2(4000) := null; g_series_prev_y wwv_flow_global.vc_arr2; g_negative_offset number := 0; procedure init_colors; procedure set_attributes ( p_region_id in number, p_query in varchar2, p_chart_type in varchar2, p_no_data_found in varchar2 default null ); procedure chart ( p_region_id in number ); function get_shared_styles ( p_type in varchar2, p_x_axis_title_font_face in varchar2 default null, p_x_axis_title_font_size in varchar2 default null, p_x_axis_title_font_color in varchar2 default null, p_y_axis_title_font_face in varchar2 default null, p_y_axis_title_font_size in varchar2 default null, p_y_axis_title_font_color in varchar2 default null, p_label_font_face in varchar2 default null, p_label_font_size in varchar2 default null, p_label_font_color in varchar2 default null, p_value_font_face in varchar2 default null, p_value_font_size in varchar2 default null, p_value_font_color in varchar2 default null ) return varchar2; procedure migrate_svg_to_flash ( p_region_id in number, p_flow_id in number, p_page_id in number); end wwv_flow_svg; / show error;