Rem
Rem cwm2del.pls
Rem
Rem Copyright (c) 2003, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      cwm2del.pls - delete dimension ,cube ,measure_catalog, olap_catalog
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    awesley     12/05/03 - awesley_txn109857
Rem    awesley     10/07/03 - Created
Rem

create or replace package cwm2_olap_delete as 

  procedure Delete_Dimension(p_Dimension_Owner       varchar2
                            ,p_Dimension_Name        varchar2
                            ,p_Delete_CWM1_Dimension varchar2
                            ,p_Report                varchar2
                            ,p_Delete                varchar2
                            );

  procedure Delete_Cube(p_Cube_Owner varchar2
                       ,p_Cube_Name  varchar2
                       ,p_Report     varchar2
                       ,p_Delete     varchar2
                       );

  procedure Delete_Measure_Catalog(p_Measure_Catalog_Name varchar2 
                                  ,p_Report               varchar2 
                                  ,p_Delete               varchar2 
                                  );
   
  procedure Delete_OLAP_Catalog(p_Delete_CWM1_Dimension varchar2 
                               ,p_Report                varchar2 
                               ,p_Delete                varchar2 
                               );
   
end cwm2_olap_delete;
/  
show errors;