PACKAGE: OLAPSYS.CWM2_OLAP_OLAPAPI_ENABLE

Source

1 package cwm2_olap_olapapi_enable authid current_user as
2 
3   procedure aw_dimension_create_access(p_Dimension_Owner varchar2,
4                                        p_Dimension_Name varchar2,
5                                        p_AW_Owner varchar2,
6                                        p_AW_Name varchar2,
7                                        p_Prefix varchar2,
8                                        p_Access_Type varchar2,
9                                        p_Script_Directory varchar2,
10                                        p_Script_Name varchar2,
11                                        p_OpenMode varchar2,
12                                        p_Caller varchar2 default null,
13                                        p_SpreadsheetMode varchar2 default 'YES',
14                                        p_AutoAdtMode varchar2 default 'YES');
15 
16 
17   procedure aw_dimension_create_access(p_runid number,
18                                        p_Dimension_Owner varchar2,
19                                        p_Dimension_Name varchar2,
20                                        p_AW_Owner varchar2,
21                                        p_AW_Name varchar2,
22                                        p_Prefix varchar2,
23                                        p_Access_Type varchar2,
24                                        p_SpreadsheetMode varchar2 default 'YES',
25                                        p_AutoAdtMode varchar2 default 'YES');
26 
27 
28 
29   procedure aw_cube_create_access(p_Cube_Owner varchar2,
30                                   p_Cube_Name varchar2,
31                                   p_AW_Owner varchar2,
32                                   p_AW_Name varchar2,
33                                   p_Prefix varchar2,
34                                   p_Access_Type varchar2,
35                                   p_Script_Directory varchar2,
36                                   p_Script_Name varchar2,
37                                   p_OpenMode varchar2,
38                                   p_Caller varchar2 default null,
39                                   p_SpreadsheetMode varchar2 default 'YES',
40                                   p_AutoAdtMode varchar2 default 'YES');
41 
42 
43   procedure aw_cube_create_access(p_runid number,
44                                   p_Cube_Owner varchar2,
45                                   p_Cube_Name varchar2,
46                                   p_AW_Owner varchar2,
47                                   p_AW_Name varchar2,
48                                   p_Prefix varchar2,
49                                   p_Access_Type varchar2,
50                                   p_SpreadsheetMode varchar2 default 'YES',
51                                   p_AutoAdtMode varchar2 default 'YES');
52 
53 
54 
55   procedure aw_dimension_drop_access(p_Target_Dim_Name varchar2,
56                                      p_AW_Owner varchar2,
57                                      p_AW_Name varchar2,
58                                      p_Access_Type varchar2,
59                                      p_Script_Directory varchar2,
60                                      p_Script_Name varchar2,
61                                      p_OpenMode varchar2);
62 
63 
64   procedure aw_dimension_drop_access(p_runid number,
65                                      p_Target_Dim_Name varchar2,
66                                      p_AW_Owner varchar2,
67                                      p_AW_Name varchar2,
68                                      p_Access_Type varchar2,
69                                      p_caller varchar2 default null);
70 
71 
72   procedure aw_cube_drop_access(p_Target_Cube_Name varchar2,
73                                 p_AW_Owner varchar2,
74                                 p_AW_Name varchar2,
75                                 p_Access_Type varchar2,
76                                 p_Script_Directory varchar2,
77                                 p_Script_Name varchar2,
78                                 p_OpenMode varchar2);
79 
80 
81   procedure aw_cube_drop_access(p_runid number,
82                                 p_Target_Cube_Name varchar2,
83                                 p_AW_Owner varchar2,
84                                 p_AW_Name varchar2,
85                                 p_Access_Type varchar2,
86                                 p_caller varchar2 default null);
87 
88 
89 
90   procedure update_enabled_dim_view(p_AWOwner varchar2,
91                                     p_AWName varchar2,
92                                     p_DimName varchar2,
93                                     p_HierName varchar2,
94                                     p_UserViewName varchar2);
95 
96   procedure update_enabled_cube_view(p_AWOwner varchar2,
97                                      p_AWName varchar2,
98                                      p_CubeName varchar2,
99                                      p_HierComboNum number,
100                                      p_UserViewName varchar2);
101 
102 
103 end cwm2_olap_olapapi_enable;