DBA Data[Home] [Help]

PACKAGE: OLAPSYS.CWM2_OLAP_LEVEL_ATTRIBUTE

Source


1 package cwm2_olap_level_attribute as
2 
3   procedure Create_Level_Attribute(p_Dimension_Owner varchar2
4                                   ,P_Dimension_Name varchar2
5                                   ,p_Dimension_Attribute_Name varchar2
6                                   ,p_Level_Name varchar2
7                                   ,p_Level_Attribute_Name varchar2
8                                   ,p_Display_Name varchar2
9                                   ,p_Short_Description varchar2
10                                   ,p_Description varchar2
11                                   ,p_Type varchar2);
12 
13 
14   procedure Create_Level_Attribute(p_Dimension_Owner varchar2
15                                   ,P_Dimension_Name varchar2
16                                   ,p_Dimension_Attribute_Name varchar2
17                                   ,p_Level_Name varchar2
18                                   ,p_Level_Attribute_Name varchar2
19                                   ,p_Display_Name varchar2
20                                   ,p_Short_Description varchar2
21                                   ,p_Description varchar2
22                                   ,p_Use_Name_As_Type boolean default FALSE);
23 
24 
25   procedure Create_Level_Attribute_2(p_Dimension_Owner varchar2
26                                     ,P_Dimension_Name varchar2
27                                     ,p_Dimension_Attribute_Name varchar2
28                                     ,p_Level_Name varchar2
29                                     ,p_Level_Attribute_Name varchar2
30                                     ,p_Display_Name varchar2
31                                     ,p_Short_Description varchar2
32                                     ,p_Description varchar2
33                                     ,p_Use_Name_As_Type number);
34 
35 
36   procedure Set_Level_Attribute_Name(p_Dimension_Owner varchar2
37                                     ,p_Dimension_Name varchar2
38                                     ,p_Dimension_Attribute_Name varchar2
39                                     ,p_Level_Name varchar2
40                                     ,p_Level_Attribute_Name varchar2
41                                     ,p_Set_Level_Attribute_Name varchar2
42                                     ,p_Type varchar2);
43 
44 
45   procedure Set_Level_Attribute_Name(p_Dimension_Owner varchar2
46                                     ,p_Dimension_Name varchar2
47                                     ,p_Dimension_Attribute_Name varchar2
48                                     ,p_Level_Name varchar2
49                                     ,p_Level_Attribute_Name varchar2
50                                     ,p_Set_Level_Attribute_Name varchar2
51                                     ,p_Use_Name_As_Type boolean default FALSE);
52 
53 
54   procedure Set_Display_Name(p_Dimension_Owner varchar2
55                             ,P_Dimension_Name varchar2
56                             ,p_Dimension_Attribute_Name varchar2
57                             ,p_Level_Name varchar2
58                             ,p_Level_Attribute_Name varchar2
59                             ,p_Display_Name varchar2);
60 
61   procedure Set_Short_Description(p_Dimension_Owner varchar2
62                                  ,p_Dimension_Name varchar2
63                                  ,p_Dimension_Attribute_Name varchar2
64                                  ,p_Level_Name varchar2
65                                  ,p_Level_Attribute_Name varchar2
66                                  ,p_Short_Description varchar2);
67 
68   procedure Set_Description(p_Dimension_Owner varchar2
69                            ,p_Dimension_Name varchar2
70                            ,p_Dimension_Attribute_Name varchar2
71                            ,p_Level_Name varchar2
72                            ,p_Level_Attribute_Name varchar2
73                            ,p_Description varchar2);
74 
75   procedure Drop_Level_Attribute(p_Dimension_Owner varchar2
76                                 ,P_Dimension_Name varchar2
77                                 ,p_Dimension_Attribute_Name varchar2
78                                 ,p_Level_Name varchar2
79                                 ,p_Level_Attribute_Name varchar2);
80 
81   procedure Lock_Level_Attribute(p_Dimension_Owner varchar2
82                                 ,P_Dimension_Name varchar2
83                                 ,p_Dimension_Attribute_Name varchar2
84                                 ,p_Level_Name varchar2
85                                 ,p_Level_Attribute_Name varchar2
86                                 ,p_Wait_For_Lock boolean default false);
87 
88 end cwm2_olap_level_attribute;