Rem
Rem cwm2dat.pls
Rem
Rem Copyright (c) 1900, 2003, Oracle Corporation.  All rights reserved.  
Rem
Rem    NAME
Rem      cwm2dat.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     03/27/03 - 
Rem    awesley     03/24/03 - 
Rem    dbardwel    10/15/02 - 
Rem    awesley     11/06/01 - awesley_txn100587
Rem    awesley     09/11/01 - Created
Rem

create or replace package cwm2_olap_dimension_attribute as

  procedure Create_Dimension_Attribute(p_Dimension_Owner varchar2
                                      ,p_Dimension_Name varchar2
                                      ,p_Dimension_Attribute_Name varchar2
                                      ,p_Display_Name varchar2
                                      ,p_Short_Description varchar2
                                      ,p_Description varchar2
                                      ,p_Type varchar2);

  procedure Create_Dimension_Attribute(p_Dimension_Owner varchar2
                                      ,p_Dimension_Name varchar2
                                      ,p_Dimension_Attribute_Name varchar2
                                      ,p_Display_Name varchar2
                                      ,p_Short_Description varchar2
                                      ,p_Description varchar2
                                      ,p_Use_Name_As_Type boolean default FALSE);

  procedure Create_Dimension_Attribute_2(p_Dimension_Owner varchar2
                                        ,p_Dimension_Name varchar2
                                        ,p_Dimension_Attribute_Name varchar2
                                        ,p_Display_Name varchar2
                                        ,p_Short_Description varchar2
                                        ,p_Description varchar2
                                        ,p_Use_Name_As_Type number);


  procedure Set_Dimension_Attribute_Name(p_Dimension_Owner varchar2
                                        ,p_Dimension_Name varchar2
                                        ,p_Dimension_Attribute_Name varchar2
                                        ,p_Set_Dimension_Attribute_Name varchar2
                                        ,p_Type varchar2);

  procedure Set_Dimension_Attribute_Name(p_Dimension_Owner varchar2
                                        ,p_Dimension_Name varchar2
                                        ,p_Dimension_Attribute_Name varchar2
                                        ,p_Set_Dimension_Attribute_Name varchar2
                                        ,p_Use_Name_As_Type boolean default FALSE);

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

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

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

  procedure Drop_Dimension_Attribute(p_Dimension_Owner varchar2
                                    ,p_Dimension_Name varchar2
                                    ,p_Dimension_Attribute_Name varchar2);

  procedure Lock_Dimension_Attribute(p_Dimension_Owner varchar2
                                    ,p_Dimension_Name varchar2
                                    ,p_Dimension_Attribute_Name varchar2
                                    ,p_Wait_For_Lock boolean default false);

end cwm2_olap_dimension_attribute;
/

show errors;