PACKAGE: OLAPSYS.CWM2_OLAP_LEVEL

Source

1 package cwm2_olap_level as
2 
3   procedure Create_Level(p_Dimension_Owner varchar2
4                         ,p_Dimension_Name varchar2
5                         ,p_Level_Name varchar2
6                         ,p_Display_Name varchar2
7                         ,p_Plural_Name varchar2
8                         ,p_Short_Description varchar2
9                         ,p_Description varchar2);
10 
11   procedure Set_Level_Name(p_Dimension_Owner varchar2
12                           ,p_Dimension_Name varchar2
13                           ,p_Level_Name varchar2
14                           ,p_Set_Level_Name varchar2);
15 
16   procedure Set_Display_Name(p_Dimension_Owner varchar2
17                             ,p_Dimension_Name varchar2
18                             ,p_Level_Name varchar2
19                             ,p_Display_Name varchar2);
20 
21   procedure Set_Plural_Name(p_Dimension_Owner varchar2
22                            ,p_Dimension_Name varchar2
23                            ,p_Level_Name varchar2
24                            ,p_Plural_Name varchar2);
25 
26   procedure Set_Short_Description(p_Dimension_Owner varchar2
27                                  ,p_Dimension_Name varchar2
28                                  ,p_Level_Name varchar2
29                                  ,p_Short_Description varchar2);
30 
31   procedure Set_Description(p_Dimension_Owner varchar2
32                            ,p_Dimension_Name varchar2
33                            ,p_Level_Name varchar2
34                            ,p_Description varchar2);
35 
36   procedure Add_Level_To_Hierarchy(p_Dimension_Owner varchar2
37                                   ,p_Dimension_Name varchar2
38                                   ,p_Hierarchy_Name varchar2
39                                   ,p_Child_Level_Name varchar2
40                                   ,p_Parent_Level_Name varchar2 default null);
41 
42   procedure Remove_Level_From_Hierarchy(p_Dimension_Owner varchar2
43                                        ,p_Dimension_Name varchar2
44                                        ,p_Hierarchy_Name varchar2
45                                        ,p_Child_Level_Name varchar2);
46 
47   procedure Drop_Level(p_Dimension_Owner varchar2
48                       ,p_Dimension_Name varchar2
49                       ,p_Level_Name varchar2);
50 
51   procedure Lock_Level(p_Dimension_Owner varchar2
52                       ,p_Dimension_Name varchar2
53                       ,p_Level_Name varchar2
54                       ,p_Wait_For_Lock boolean default false);
55 
56 end cwm2_olap_level;