Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\core\edit

Edit D:\app\Administrator\product\11.2.0\dbhome_1\apex\core\edit_report.sql

set define '^'

set verify off
prompt ...wwv_flow

--  Copyright (c) Oracle Corporation 2002. All Rights Reserved.
--
--    NAME
--      wwv_flow_edit_query.sql
--
--    DESCRIPTION
--      Facilitates query editing in the builder
--
--    NOTES
--
--    INTERNATIONALIZATION
--      unknown
--
--    RUNTIME DEPLOYMENT: YES
--
--    MODIFIED  (MM/DD/YYYY)
--      msewtz  03/27/2003 - Created
--      msewtz  05/20/2003 - added update_report_column_sequence
--      msewtz  05/23/2003 - added column_headings_javascript
--      msewtz  06/03/2003 - added update_column_display_sequence
--      msewtz  05/14/2004 - added "add_derived_column" procedure to support row select + delete feature
--      msewtz  05/24/2004 - changed "add_derived_column" procedure to function in order to return ID to process
--      msewtz  01/02/2007 - added update_print_column_attributes

create or replace package wwv_flow_edit_report as
 
  type assoc_vc2_arr is table of varchar2(4000) index by varchar2(4000);
  empty_assoc_vc2_arr assoc_vc2_arr;

type assoc_bln_arr is table of boolean index by varchar2(4000);
  empty_assoc_bln_arr assoc_bln_arr;
  
  g_is_query_column  assoc_bln_arr := empty_assoc_bln_arr;

g_col_alias        wwv_flow_global.vc_arr2;
  g_status           varchar(5000);    -- execution status  
  
  g_col_display_seq  assoc_vc2_arr := empty_assoc_vc2_arr;    
  g_col_hidden       assoc_vc2_arr := empty_assoc_vc2_arr;    
  g_col_heading      assoc_vc2_arr := empty_assoc_vc2_arr;
  g_col_alignment    assoc_vc2_arr := empty_assoc_vc2_arr;
  g_hd_alignment     assoc_vc2_arr := empty_assoc_vc2_arr;  
  g_col_sum          assoc_vc2_arr := empty_assoc_vc2_arr;
  g_disable_sort_col assoc_vc2_arr := empty_assoc_vc2_arr;
  g_default_sort_col assoc_vc2_arr := empty_assoc_vc2_arr;    
  
  g_include_in_export assoc_vc2_arr := empty_assoc_vc2_arr;    
  g_print_col_width   assoc_vc2_arr := empty_assoc_vc2_arr;    
  g_print_col_align   assoc_vc2_arr := empty_assoc_vc2_arr;

------------------------------------------------------------------------------------------------------
--

procedure move_cols (
    p_region_id           in number,
    p_column_id           in number,
    p_col_num             in number,
    p_dir                 in varchar2
  );

------------------------------------------------------------------------------------------------------
--
  
  function get_alias_display_name ( 
    p_alias in varchar2
  ) return varchar2;
    
------------------------------------------------------------------------------------------------------
--
  
  function add_derived_column ( 
    p_region_id in number,
    p_col_num   in number,    
    p_type      in varchar2
  ) return number;
  
------------------------------------------------------------------------------------------------------
--

procedure remove_derived_column ( 
      p_region_id in number,
      p_column_id in number
  );  
    
------------------------------------------------------------------------------------------------------
--
  
  procedure update_report_columns (
    p_region_id           in number,
    p_column_heading_type in varchar2,    
    p_column_id           in wwv_flow_global.vc_arr2,
    p_column_alias        in wwv_flow_global.vc_arr2,    
    p_display_seq         in wwv_flow_global.vc_arr2,    
    p_column_heading      in wwv_flow_global.vc_arr2,
    p_column_alignment    in wwv_flow_global.vc_arr2,
    p_heading_alignment   in wwv_flow_global.vc_arr2,                    
    p_hidden_column       in wwv_flow_global.vc_arr2,
    p_sum_column          in wwv_flow_global.vc_arr2,
    p_disable_sort_column in wwv_flow_global.vc_arr2,
    p_default_sort_column in wwv_flow_global.vc_arr2     
  );
  
------------------------------------------------------------------------------------------------------
--
  
  procedure update_print_column_attributes (
    p_region_id           in number,
    p_column_heading_type in varchar2,    
    p_column_id           in wwv_flow_global.vc_arr2,
    p_column_alias        in wwv_flow_global.vc_arr2,    
    p_include_in_export   in wwv_flow_global.vc_arr2,    
    p_print_col_width     in wwv_flow_global.vc_arr2
  );

------------------------------------------------------------------------------------------------------
--
   
  procedure update_column_display_sequence (
    p_region_id           in number
  );
    
------------------------------------------------------------------------------------------------------
--
   
  procedure update_report_column_sequence (
    p_region_id           in number
  );

------------------------------------------------------------------------------------------------------
--
    
  procedure column_headings_javascript (
    p_region_id                number,
    p_plug_query_headings_type varchar2
  );

end wwv_flow_edit_report;
/
show errors

Ms-Dos/Windows Unix Write backup

jsp File Browser version 1.2 by www.vonloesch.de