Rem Rem cwm2lat.pls Rem Rem Copyright (c) 1900, 2003, Oracle Corporation. All rights reserved. Rem Rem NAME Rem cwm2lat.pls - Rem Rem DESCRIPTION Rem Rem Rem NOTES Rem Rem Rem MODIFIED (MM/DD/YY) Rem awesley 03/27/03 - Rem awesley 03/24/03 - Rem dbardwel 10/15/02 - dbardwel Adding AWM special call for creating Rem level attributes to work around boolean limitation Rem in JDBC Rem awesley 11/06/01 - awesley_txn100587 Rem awesley 09/11/01 - Created Rem create or replace package cwm2_olap_level_attribute as procedure Create_Level_Attribute(p_Dimension_Owner varchar2 ,P_Dimension_Name varchar2 ,p_Dimension_Attribute_Name varchar2 ,p_Level_Name varchar2 ,p_Level_Attribute_Name varchar2 ,p_Display_Name varchar2 ,p_Short_Description varchar2 ,p_Description varchar2 ,p_Type varchar2); procedure Create_Level_Attribute(p_Dimension_Owner varchar2 ,P_Dimension_Name varchar2 ,p_Dimension_Attribute_Name varchar2 ,p_Level_Name varchar2 ,p_Level_Attribute_Name varchar2 ,p_Display_Name varchar2 ,p_Short_Description varchar2 ,p_Description varchar2 ,p_Use_Name_As_Type boolean default FALSE); procedure Create_Level_Attribute_2(p_Dimension_Owner varchar2 ,P_Dimension_Name varchar2 ,p_Dimension_Attribute_Name varchar2 ,p_Level_Name varchar2 ,p_Level_Attribute_Name varchar2 ,p_Display_Name varchar2 ,p_Short_Description varchar2 ,p_Description varchar2 ,p_Use_Name_As_Type number); procedure Set_Level_Attribute_Name(p_Dimension_Owner varchar2 ,p_Dimension_Name varchar2 ,p_Dimension_Attribute_Name varchar2 ,p_Level_Name varchar2 ,p_Level_Attribute_Name varchar2 ,p_Set_Level_Attribute_Name varchar2 ,p_Type varchar2); procedure Set_Level_Attribute_Name(p_Dimension_Owner varchar2 ,p_Dimension_Name varchar2 ,p_Dimension_Attribute_Name varchar2 ,p_Level_Name varchar2 ,p_Level_Attribute_Name varchar2 ,p_Set_Level_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_Level_Name varchar2 ,p_Level_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_Level_Name varchar2 ,p_Level_Attribute_Name varchar2 ,p_Short_Description varchar2); procedure Set_Description(p_Dimension_Owner varchar2 ,p_Dimension_Name varchar2 ,p_Dimension_Attribute_Name varchar2 ,p_Level_Name varchar2 ,p_Level_Attribute_Name varchar2 ,p_Description varchar2); procedure Drop_Level_Attribute(p_Dimension_Owner varchar2 ,P_Dimension_Name varchar2 ,p_Dimension_Attribute_Name varchar2 ,p_Level_Name varchar2 ,p_Level_Attribute_Name varchar2); procedure Lock_Level_Attribute(p_Dimension_Owner varchar2 ,P_Dimension_Name varchar2 ,p_Dimension_Attribute_Name varchar2 ,p_Level_Name varchar2 ,p_Level_Attribute_Name varchar2 ,p_Wait_For_Lock boolean default false); end cwm2_olap_level_attribute; / show errors;