DBA Data[Home] [Help]

APPS.BSC_AW_READ dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 146: p_parameters BIS_PMV_PAGE_PARAMETER_TBL

142: );
143: procedure limit_dimensions(
144: p_kpi varchar2,
145: p_dim_set varchar2,
146: p_parameters BIS_PMV_PAGE_PARAMETER_TBL
147: );
148: procedure load_kpi_metadata(p_kpi varchar2);
149: procedure load_level_lookup(p_dim_set in out nocopy dim_set_r);
150: procedure load_level_lookup(

Line 166: p_parameters BIS_PMV_PAGE_PARAMETER_TBL

162: );
163: procedure load_measures(p_dim_set in out nocopy dim_set_r);
164: procedure find_dimset_dimensions(
165: p_dim_set in out nocopy dim_set_r,
166: p_parameters BIS_PMV_PAGE_PARAMETER_TBL
167: );
168: procedure aggregate_dimset_dimensions(
169: p_dim_set dim_set_r,
170: p_parameters BIS_PMV_PAGE_PARAMETER_TBL

Line 170: p_parameters BIS_PMV_PAGE_PARAMETER_TBL

166: p_parameters BIS_PMV_PAGE_PARAMETER_TBL
167: );
168: procedure aggregate_dimset_dimensions(
169: p_dim_set dim_set_r,
170: p_parameters BIS_PMV_PAGE_PARAMETER_TBL
171: );
172: procedure aggregate_cubes_dim(
173: p_dim_set dim_set_r,
174: p_measures dbms_sql.varchar2_table,

Line 179: p_parameters BIS_PMV_PAGE_PARAMETER_TBL,

175: p_dim varchar2
176: );
177: function check_kpi(p_kpi varchar2) return boolean ;
178: procedure get_measures(
179: p_parameters BIS_PMV_PAGE_PARAMETER_TBL,
180: p_measures out nocopy dbms_sql.varchar2_table
181: );
182: procedure check_limit_track_seq(
183: p_dim_set in out nocopy dim_set_r,

Line 184: p_parameters BIS_PMV_PAGE_PARAMETER_TBL,

180: p_measures out nocopy dbms_sql.varchar2_table
181: );
182: procedure check_limit_track_seq(
183: p_dim_set in out nocopy dim_set_r,
184: p_parameters BIS_PMV_PAGE_PARAMETER_TBL,
185: p_status out nocopy varchar2
186: );
187: procedure limit_dimset(
188: p_dim_set dim_set_r,

Line 189: p_parameters BIS_PMV_PAGE_PARAMETER_TBL

185: p_status out nocopy varchar2
186: );
187: procedure limit_dimset(
188: p_dim_set dim_set_r,
189: p_parameters BIS_PMV_PAGE_PARAMETER_TBL
190: );
191: procedure find_dimset_xtd(
192: p_dim_set in out nocopy dim_set_r,
193: p_parameters BIS_PMV_PAGE_PARAMETER_TBL

Line 193: p_parameters BIS_PMV_PAGE_PARAMETER_TBL

189: p_parameters BIS_PMV_PAGE_PARAMETER_TBL
190: );
191: procedure find_dimset_xtd(
192: p_dim_set in out nocopy dim_set_r,
193: p_parameters BIS_PMV_PAGE_PARAMETER_TBL
194: );
195: procedure dmp_kpi(p_kpi kpi_r);
196: procedure dmp_dimset(p_dimset dim_set_r);
197: procedure dmp_level_dim_r(p_level level_dim_r);

Line 201: p_parameters BIS_PMV_PAGE_PARAMETER_TBL

197: procedure dmp_level_dim_r(p_level level_dim_r);
198: procedure dmp_periodicity_r(p_periodicity periodicity_r);
199: procedure limit_dim_to_composite(
200: p_dim_set dim_set_r,
201: p_parameters BIS_PMV_PAGE_PARAMETER_TBL
202: );
203: function is_zero_specified_for_level(p_dim_set dim_set_r,p_level_name varchar2) return boolean;
204: procedure limit_dimensions_pmv(
205: p_kpi varchar2,

Line 207: p_parameters BIS_PMV_PAGE_PARAMETER_TBL

203: function is_zero_specified_for_level(p_dim_set dim_set_r,p_level_name varchar2) return boolean;
204: procedure limit_dimensions_pmv(
205: p_kpi varchar2,
206: p_dim_set varchar2,
207: p_parameters BIS_PMV_PAGE_PARAMETER_TBL
208: );
209: procedure attach_workspace;
210: procedure dmp_parameters(p_parameters BIS_PMV_PAGE_PARAMETER_TBL);
211: procedure set_viewby_dimensions(

Line 210: procedure dmp_parameters(p_parameters BIS_PMV_PAGE_PARAMETER_TBL);

206: p_dim_set varchar2,
207: p_parameters BIS_PMV_PAGE_PARAMETER_TBL
208: );
209: procedure attach_workspace;
210: procedure dmp_parameters(p_parameters BIS_PMV_PAGE_PARAMETER_TBL);
211: procedure set_viewby_dimensions(
212: p_dim_set in out nocopy dim_set_r,
213: p_parameters BIS_PMV_PAGE_PARAMETER_TBL,
214: p_limit_track in out nocopy limit_track_r

Line 213: p_parameters BIS_PMV_PAGE_PARAMETER_TBL,

209: procedure attach_workspace;
210: procedure dmp_parameters(p_parameters BIS_PMV_PAGE_PARAMETER_TBL);
211: procedure set_viewby_dimensions(
212: p_dim_set in out nocopy dim_set_r,
213: p_parameters BIS_PMV_PAGE_PARAMETER_TBL,
214: p_limit_track in out nocopy limit_track_r
215: );
216: procedure detach_workspace;
217: procedure clear_all_cache;

Line 227: procedure copy_data_display_cubes(p_dim_set dim_set_r,p_parameters BIS_PMV_PAGE_PARAMETER_TBL);

223: procedure aggregate_cubes(p_dim_set dim_set_r,p_std_measures dbms_sql.varchar2_table,p_agg_map varchar2);
224: procedure correct_forecast(p_dim_set dim_set_r,p_measures dbms_sql.varchar2_table,p_periodicity dbms_sql.varchar2_table);
225: procedure aggregate_cubes_calendar(p_dim_set dim_set_r,p_measures dbms_sql.varchar2_table);
226: procedure get_measures_aggregate(p_dim_set dim_set_r,p_measures dbms_sql.varchar2_table,p_agg_measures out nocopy dbms_sql.varchar2_table);
227: procedure copy_data_display_cubes(p_dim_set dim_set_r,p_parameters BIS_PMV_PAGE_PARAMETER_TBL);
228: procedure copy_data_display_cubes(p_dim_set dim_set_r,p_measures dbms_sql.varchar2_table);
229: procedure copy_data_display_cubes(p_dim_set dim_set_r,p_cube varchar2,p_display_cube varchar2);
230: procedure aggregate_formula(p_dim_set dim_set_r,p_measures dbms_sql.varchar2_table);
231: procedure add_relevant_measures(p_dim_set dim_set_r,p_parameters in out nocopy BIS_PMV_PAGE_PARAMETER_TBL);

Line 231: procedure add_relevant_measures(p_dim_set dim_set_r,p_parameters in out nocopy BIS_PMV_PAGE_PARAMETER_TBL);

227: procedure copy_data_display_cubes(p_dim_set dim_set_r,p_parameters BIS_PMV_PAGE_PARAMETER_TBL);
228: procedure copy_data_display_cubes(p_dim_set dim_set_r,p_measures dbms_sql.varchar2_table);
229: procedure copy_data_display_cubes(p_dim_set dim_set_r,p_cube varchar2,p_display_cube varchar2);
230: procedure aggregate_formula(p_dim_set dim_set_r,p_measures dbms_sql.varchar2_table);
231: procedure add_relevant_measures(p_dim_set dim_set_r,p_parameters in out nocopy BIS_PMV_PAGE_PARAMETER_TBL);
232: --procedures-------------------------------------------------------
233: procedure init_all;
234: procedure log(p_message varchar2);
235: procedure log_n(p_message varchar2);

Line 238: procedure validate_limit_range(p_lower_period in out nocopy varchar2,p_upper_period in out nocopy varchar2, p_parameters BIS_PMV_PAGE_PARAMETER_TBL);

234: procedure log(p_message varchar2);
235: procedure log_n(p_message varchar2);
236: -------------------------------------------------------------------
237: --rkumar:bug#5954342
238: procedure validate_limit_range(p_lower_period in out nocopy varchar2,p_upper_period in out nocopy varchar2, p_parameters BIS_PMV_PAGE_PARAMETER_TBL);
239: END BSC_AW_READ;