Rem
Rem cwm2hie.pls
Rem
Rem  Copyright (c) Oracle Corporation 1900, 2000. All Rights Reserved.
Rem
Rem    NAME
Rem      cwm2hie.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    awesley     11/06/01 - awesley_txn100587
Rem    awesley     09/11/01 - Created
Rem

create or replace package cwm2_olap_hierarchy as

  procedure Create_Hierarchy(p_Dimension_Owner varchar2
                            ,p_Dimension_Name varchar2
                            ,p_Hierarchy_Name varchar2
                            ,p_Display_Name varchar2
                            ,p_Short_Description varchar2
                            ,p_Description varchar2
                            ,p_Solved_Code varchar2);

  procedure Set_Hierarchy_Name(p_Dimension_Owner varchar2
                              ,p_Dimension_Name varchar2
                              ,p_Hierarchy_Name varchar2
                              ,p_Set_Hierarchy_Name varchar2);

  procedure Set_Display_Name(p_Dimension_Owner varchar2
                            ,p_Dimension_Name varchar2
                            ,p_Hierarchy_Name varchar2
                            ,p_Display_Name varchar2);

  procedure Set_Short_Description(p_Dimension_Owner varchar2
                                 ,p_Dimension_Name varchar2
                                 ,p_Hierarchy_Name varchar2
                                 ,p_Short_Description varchar2);

  procedure Set_Description(p_Dimension_Owner varchar2
                           ,p_Dimension_Name varchar2
                           ,p_Hierarchy_Name varchar2
                           ,p_Description varchar2);

  procedure Set_Solved_Code(p_Dimension_Owner varchar2
                          ,p_Dimension_Name varchar2
                          ,p_Hierarchy_Name varchar2
                          ,p_Solved_Code varchar2);

  procedure Drop_Hierarchy(p_Dimension_Owner varchar2
                          ,p_Dimension_Name varchar2
                          ,p_Hierarchy_Name varchar2);

  procedure Lock_Hierarchy(p_Dimension_Owner varchar2
                          ,p_Dimension_Name varchar2
                          ,p_Hierarchy_Name varchar2
                          ,p_Wait_For_Lock boolean default false);

end cwm2_olap_hierarchy;
/

show errors;