eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.BSC_AW_MD_API

Source


1 package BSC_AW_MD_API AS
2 /*$Header: BSCAWMAS.pls 120.8 2006/01/30 16:00 vsurendr noship $*/
3 --program runtime parameters
4 g_debug boolean;
5 g_stmt varchar2(32000);
6 g_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;
7 g_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;
8 ----cache--------------------------------------------------------
9 type olap_object_cache_r is record(
10 object varchar2(100),
11 object_type varchar2(100),
12 parent_object varchar2(100),
13 parent_object_type varchar2(100),
14 bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb
15 );
16 type olap_object_cache_tb is table of olap_object_cache_r index by pls_integer;
17 g_oo_cache olap_object_cache_tb;
18 --
19 type olap_object_relation_cache_r is record(
20 object varchar2(100),
21 object_type varchar2(100),
22 relation_type varchar2(100),
23 parent_object varchar2(100),
24 parent_object_type varchar2(100),
25 bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb
26 );
27 type olap_object_relation_cache_tb is table of olap_object_relation_cache_r index by pls_integer;
28 g_oor_cache olap_object_relation_cache_tb;
29 --procedures-------------------------------------------------------
30 function is_dim_present(
31 p_dimension varchar2
32 ) return boolean;
33 procedure get_kpi_for_dim(
34 p_dim_name varchar2,
35 p_kpi_list out nocopy dbms_sql.varchar2_table
36 );
37 procedure mark_kpi_recreate(p_kpi varchar2);
38 procedure get_dim_olap_objects(
39 p_dim_name varchar2,
40 p_objects out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb,
41 p_type varchar2
42 );
43 procedure drop_dim(p_dim_name varchar2);
44 procedure get_ccdim_for_levels(
45 p_dimension bsc_aw_adapter_dim.dimension_r,
46 p_dim_list out nocopy dbms_sql.varchar2_table
47 );
48 procedure create_dim_objects(
49 p_dimension bsc_aw_adapter_dim.dimension_r
50 );
51 function get_level_position(
52 p_dim_level varchar2
53 ) return number;
54 procedure drop_kpi(p_kpi varchar2);
55 procedure get_kpi_olap_objects(
56 p_kpi varchar2,
57 p_objects out nocopy bsc_aw_utility.object_tb,
58 p_type varchar2
59 );
60 procedure delete_calendar(p_calendar bsc_aw_calendar.calendar_r);
61 procedure create_calendar(p_calendar bsc_aw_calendar.calendar_r);
62 procedure get_dim_for_level(p_level varchar2,p_dim out nocopy varchar2);
63 procedure get_dim_parent_child(p_dim varchar2,p_parent_child out nocopy bsc_aw_adapter_dim.dim_parent_child_tb);
64 procedure get_bsc_olap_object(
65 p_object varchar2,
66 p_type varchar2,
67 p_parent_object varchar2,
68 p_parent_type varchar2,
69 p_bsc_olap_object out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb
70 );
71 procedure get_bsc_olap_object_relation(
72 p_object varchar2,
73 p_object_type varchar2,
74 p_relation_type varchar2,
75 p_parent_object varchar2,
76 p_parent_object_type varchar2,
77 p_bsc_olap_object_relation out nocopy bsc_aw_md_wrapper.bsc_olap_object_relation_tb
78 );
79 procedure get_dim_for_kpi(
80 p_kpi varchar2,
81 p_dim_list out nocopy dbms_sql.varchar2_table
82 );
83 procedure create_kpi(p_kpi bsc_aw_adapter_kpi.kpi_r);
84 procedure get_dim_properties(p_dim in out nocopy bsc_aw_adapter_kpi.dim_r);
85 procedure get_dim_set_calendar(
86 p_kpi bsc_aw_adapter_kpi.kpi_r,
87 p_dim_set in out nocopy bsc_aw_adapter_kpi.dim_set_r
88 ) ;
89 function is_kpi_present(
90 p_kpi varchar2
91 )return boolean;
92 procedure get_kpi_dimset(
93 p_kpi varchar2,
94 p_bsc_olap_object out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb
95 );
96 procedure get_dimset_base_table(
97 p_kpi varchar2,
98 p_dimset varchar2,
99 p_base_table_type varchar2,--base table dim set"
100 p_olap_object_relation out nocopy bsc_aw_md_wrapper.bsc_olap_object_relation_tb
101 );
102 procedure get_base_table_dimset(
103 p_kpi varchar2,
104 p_base_table varchar2,
105 p_base_table_type varchar2,--base table dim set"
106 p_olap_object_relation out nocopy bsc_aw_md_wrapper.bsc_olap_object_relation_tb
107 );
108 procedure get_dimset_measure(
109 p_kpi varchar2,
110 p_dimset varchar2,
111 p_measure out nocopy bsc_aw_adapter_kpi.measure_tb
112 );
113 procedure get_kpi_dimset_md(
114 p_kpi varchar2,
115 p_dimset_name varchar2,
116 p_dimset out nocopy bsc_aw_adapter_kpi.dim_set_r
117 );
118 procedure get_kpi_dimset_dim_md(
119 p_kpi varchar2,
120 p_dimset_name varchar2,
121 p_dim out nocopy bsc_aw_adapter_kpi.dim_tb,
122 p_std_dim out nocopy bsc_aw_adapter_kpi.dim_tb
123 );
124 procedure get_kpi_dimset_dim_md(
125 p_kpi varchar2,
126 p_dimset_name varchar2,
127 p_dim in out nocopy bsc_aw_adapter_kpi.dim_r,
128 p_dim_type varchar2,
129 p_level_type varchar2
130 );
131 procedure get_kpi_dimset_calendar_md(
132 p_kpi varchar2,
133 p_dimset_name varchar2,
134 p_calendar out nocopy bsc_aw_adapter_kpi.calendar_r
135 );
136 procedure get_aggregation_r(p_aggregation in out nocopy bsc_aw_load_kpi.aggregation_r);
137 procedure create_workspace(p_name varchar2);
138 procedure drop_workspace(p_name varchar2);
139 function check_workspace(p_workspace_name varchar2) return varchar2;
140 procedure get_calendar_properties(p_calendar in out nocopy bsc_aw_adapter_kpi.calendar_r);
141 procedure update_olap_object(
142 p_object varchar2,
143 p_object_type varchar2,
144 p_parent_object varchar2,
145 p_parent_object_type varchar2,
146 p_match_columns varchar2, --comma separated
147 p_match_values varchar2, --comma separated
148 p_set_columns varchar2, --comma separated
149 p_set_values varchar2 --^ separated
150 );
151 procedure update_olap_object_relation(
152 p_object varchar2,
153 p_object_type varchar2,
154 p_relation_type varchar2,
155 p_parent_object varchar2,
156 p_parent_object_type varchar2,
157 p_match_columns varchar2, --comma separated
158 p_match_values varchar2, --comma separated
159 p_set_columns varchar2, --comma separated
160 p_set_values varchar2 --^ separated
161 );
162 function is_level_in_dim(
163 p_dim bsc_aw_adapter_kpi.dim_r,
164 p_level varchar2) return boolean;
165 function is_periodicity_in_dim(
166 p_calendar bsc_aw_adapter_kpi.calendar_r,
167 p_periodicty_dim varchar2
168 )return boolean;
169 procedure get_kpi_dimset_actual(
170 p_kpi varchar2,
171 p_bsc_olap_object out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb
172 );
173 procedure create_bt_change_vector(p_base_table varchar2);
174 function get_bt_change_vector(p_base_table varchar2) return number;
175 procedure update_bt_change_vector(p_base_table varchar2, p_value number);
176 procedure drop_bt_change_vector(p_base_table varchar2);
177 procedure get_relation_object(
178 p_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb,
179 p_relation_type varchar2,
180 p_relation_object in out nocopy dbms_sql.varchar2_table
181 );
182 procedure get_dimset_comp_PT(
183 p_kpi varchar2,
184 p_dimset_name varchar2,
185 p_partition_template out nocopy bsc_aw_adapter_kpi.partition_template_tb,
186 p_composite out nocopy bsc_aw_adapter_kpi.composite_tb);
187 procedure get_dimset_cube_set(
188 p_kpi varchar2,
189 p_dimset_name varchar2,
190 p_cube_set out nocopy bsc_aw_adapter_kpi.cube_set_tb);
191 procedure get_dimset_cube(
192 p_kpi varchar2,
193 p_dimset_name varchar2,
194 p_cube_set_name varchar2,
195 p_cube_type varchar2,
196 p_cube out nocopy bsc_aw_adapter_kpi.cube_r) ;
197 function get_oo_cache(
198 p_object varchar2,
199 p_type varchar2,
200 p_parent_object varchar2,
201 p_parent_type varchar2,
202 p_bsc_olap_object out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb
203 ) return varchar2;
204 procedure add_oo_cache(
205 p_object varchar2,
206 p_type varchar2,
207 p_parent_object varchar2,
208 p_parent_type varchar2,
209 p_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb
210 );
211 function get_oor_cache(
212 p_object varchar2,
213 p_object_type varchar2,
214 p_relation_type varchar2,
215 p_parent_object varchar2,
216 p_parent_object_type varchar2,
217 p_bsc_olap_object_relation out nocopy bsc_aw_md_wrapper.bsc_olap_object_relation_tb
218 ) return varchar2;
219 procedure add_oor_cache(
220 p_object varchar2,
221 p_object_type varchar2,
222 p_relation_type varchar2,
223 p_parent_object varchar2,
224 p_parent_object_type varchar2,
225 p_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb
226 );
227 procedure clear_all_cache;
228 procedure get_dim_md(p_dim_name varchar2,p_dimension out nocopy bsc_aw_adapter_dim.dimension_r);
229 procedure get_dims_for_level(p_level varchar2,p_dim out nocopy dbms_sql.varchar2_table);
230 procedure analyze_md_tables;
231 procedure get_kpi(p_kpi in out nocopy bsc_aw_adapter_kpi.kpi_r);
232 procedure update_bt_current_period(p_base_table varchar2,p_value varchar2);
233 function get_bt_current_period(p_base_table varchar2) return varchar2;
234 procedure insert_olap_object(
235 p_object varchar2,
236 p_object_type varchar2,
237 p_olap_object varchar2,
238 p_olap_object_type varchar2,
239 p_parent_object varchar2,
240 p_parent_object_type varchar2,
241 p_property1 varchar2
242 );
243 procedure insert_olap_object_relation(
244 p_object varchar2,
245 p_object_type varchar2,
246 p_relation_object varchar2,
247 p_relation_object_type varchar2,
248 p_relation_type varchar2,
249 p_parent_object varchar2,
250 p_parent_object_type varchar2,
251 p_property1 varchar2
252 );
253 procedure set_upgrade_version(p_version number);
254 function get_upgrade_version return number;
255 --procedures-------------------------------------------------------
256 procedure init_all;
257 procedure log(p_message varchar2);
258 procedure log_n(p_message varchar2);
259 -------------------------------------------------------------------
260 
261 END BSC_AW_MD_API;