Rem
Rem cwm2cat.pls
Rem
Rem Copyright (c) 1900, 2003, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      cwm2cat.pls - <one-line expansion of the name>
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    dbardwel    10/06/03 - Add silent error reporting optional parm to drop_catalog
Rem                           This is for the OLAP enabler which will now be creating
Rem                           measure folders.
Rem    awesley     05/14/03 - 
Rem    awesley     05/12/03 - allow parent catalog name to be null in set_parant_catalog
Rem    awesley     11/16/01 - awesley_txn100765
Rem    awesley     11/16/01 - Created
Rem

create or replace package cwm2_olap_catalog as

  procedure Create_Catalog(p_Catalog_Name varchar2
                          ,p_Description varchar2
                          ,p_Parent_Catalog_Name varchar2 default null);

  procedure Set_Catalog_Name(p_Catalog_Name varchar2
                            ,p_Set_Catalog_Name varchar2);

  procedure Set_Description(p_Catalog_Name varchar2
                           ,p_Description varchar2);

  procedure Set_Parent_Catalog(p_Catalog_Name varchar2
                              ,p_Parent_Catalog_Name varchar2 default null);

  procedure Drop_Catalog(p_catalog_Name varchar2,
                         p_Silent varchar2 default null);

  procedure Lock_Catalog(p_Catalog_Name varchar2
                        ,p_Wait_For_Lock boolean default false);

  procedure Add_Catalog_Entity(p_Catalog_Name varchar2
                              ,p_Cube_Owner varchar2
                              ,p_Cube_Name varchar2
                              ,p_Measure_Name varchar2);

  procedure Remove_Catalog_Entity(p_Catalog_Name varchar2
                                 ,p_Cube_Owner varchar2
                                 ,p_Cube_Name varchar2
                                 ,p_Measure_Name varchar2);

end cwm2_olap_catalog;

/

show errors;