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.

APPS.BSC_AW_READ dependencies on DBMS_SQL

Line 10: g_std_dim dbms_sql.varchar2_table;

6: g_bsc_owner varchar2(200);
7: g_workspace_attached boolean; --is the workspace attached
8: g_init boolean;
9: g_stmt varchar2(4000);
10: g_std_dim dbms_sql.varchar2_table;
11: g_log_type varchar2(20);--file log or fnd log
12: --------types-------------------------
13: /*
14: given a level name , quickly get the dim name and the position. if this is empty, then we will have to query

Line 32: child_level dbms_sql.varchar2_table,

28: );
29: type level_dim_tv is table of level_dim_r index by varchar2(100);
30: --
31: type child_level_r is record(
32: child_level dbms_sql.varchar2_table,
33: rel_level_name dbms_sql.varchar2_table --holds 'parent.child' that will be used to limit the level name dim
34: );
35: type child_level_tv is table of child_level_r index by varchar2(100);
36: --

Line 33: rel_level_name dbms_sql.varchar2_table --holds 'parent.child' that will be used to limit the level name dim

29: type level_dim_tv is table of level_dim_r index by varchar2(100);
30: --
31: type child_level_r is record(
32: child_level dbms_sql.varchar2_table,
33: rel_level_name dbms_sql.varchar2_table --holds 'parent.child' that will be used to limit the level name dim
34: );
35: type child_level_tv is table of child_level_r index by varchar2(100);
36: --
37: --indexed by periodicity id

Line 110: level_names dbms_sql.varchar2_table, --all the levels

106: rec dim
107: we need level_names so we can find out the missing levels
108: */
109: type dim_set_r is record(
110: level_names dbms_sql.varchar2_table, --all the levels
111: levels level_dim_tv,
112: drill_down_levels child_level_tv,
113: calendar calendar_r,
114: measure measure_tv,

Line 128: dim_set_id dbms_sql.varchar2_table,

124: type kpi_r is record(
125: kpi varchar2(100),
126: status varchar2(40),
127: dim_set dim_set_tv,
128: dim_set_id dbms_sql.varchar2_table,
129: property property_r
130: );
131: type kpi_tv is table of kpi_r index by varchar2(100);
132:

Line 160: p_child_levels in out nocopy dbms_sql.varchar2_table,

156: procedure get_child_level(
157: p_level varchar2,
158: p_level_dim level_dim_tv,
159: p_parent_child bsc_aw_adapter_kpi.parent_child_tb,
160: p_child_levels in out nocopy dbms_sql.varchar2_table,
161: p_rel_level_name in out nocopy dbms_sql.varchar2_table
162: );
163: procedure load_measures(p_dim_set in out nocopy dim_set_r);
164: procedure find_dimset_dimensions(

Line 161: p_rel_level_name in out nocopy dbms_sql.varchar2_table

157: p_level varchar2,
158: p_level_dim level_dim_tv,
159: p_parent_child bsc_aw_adapter_kpi.parent_child_tb,
160: p_child_levels in out nocopy dbms_sql.varchar2_table,
161: p_rel_level_name in out nocopy dbms_sql.varchar2_table
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,

Line 174: p_measures dbms_sql.varchar2_table,

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,
175: p_dim varchar2
176: );
177: function check_kpi(p_kpi varchar2) return boolean ;
178: procedure get_measures(

Line 180: p_measures out nocopy dbms_sql.varchar2_table

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,
184: p_parameters BIS_PMV_PAGE_PARAMETER_TBL,

Line 222: p_child_levels in out nocopy dbms_sql.varchar2_table,p_rel_level_name in out nocopy dbms_sql.varchar2_table);

218: function check_kpi_change(p_kpi varchar2) return boolean;
219: function find_agg_status(p_dim_set dim_set_r) return varchar2;
220: procedure load_periodicity_drilldown(p_dim_set in out nocopy dim_set_r) ;
221: procedure get_child_periodicity(p_periodicity varchar2,p_cal_periodicity periodicity_tv,p_parent_child bsc_aw_adapter_kpi.cal_parent_child_tb,
222: p_child_levels in out nocopy dbms_sql.varchar2_table,p_rel_level_name in out nocopy dbms_sql.varchar2_table);
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);

Line 223: procedure aggregate_cubes(p_dim_set dim_set_r,p_std_measures dbms_sql.varchar2_table,p_agg_map varchar2);

219: function find_agg_status(p_dim_set dim_set_r) return varchar2;
220: procedure load_periodicity_drilldown(p_dim_set in out nocopy dim_set_r) ;
221: procedure get_child_periodicity(p_periodicity varchar2,p_cal_periodicity periodicity_tv,p_parent_child bsc_aw_adapter_kpi.cal_parent_child_tb,
222: p_child_levels in out nocopy dbms_sql.varchar2_table,p_rel_level_name in out nocopy dbms_sql.varchar2_table);
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);

Line 224: procedure correct_forecast(p_dim_set dim_set_r,p_measures dbms_sql.varchar2_table,p_periodicity dbms_sql.varchar2_table);

220: procedure load_periodicity_drilldown(p_dim_set in out nocopy dim_set_r) ;
221: procedure get_child_periodicity(p_periodicity varchar2,p_cal_periodicity periodicity_tv,p_parent_child bsc_aw_adapter_kpi.cal_parent_child_tb,
222: p_child_levels in out nocopy dbms_sql.varchar2_table,p_rel_level_name in out nocopy dbms_sql.varchar2_table);
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);

Line 225: procedure aggregate_cubes_calendar(p_dim_set dim_set_r,p_measures dbms_sql.varchar2_table);

221: procedure get_child_periodicity(p_periodicity varchar2,p_cal_periodicity periodicity_tv,p_parent_child bsc_aw_adapter_kpi.cal_parent_child_tb,
222: p_child_levels in out nocopy dbms_sql.varchar2_table,p_rel_level_name in out nocopy dbms_sql.varchar2_table);
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);

Line 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);

222: p_child_levels in out nocopy dbms_sql.varchar2_table,p_rel_level_name in out nocopy dbms_sql.varchar2_table);
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);

Line 228: procedure copy_data_display_cubes(p_dim_set dim_set_r,p_measures dbms_sql.varchar2_table);

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);
232: --procedures-------------------------------------------------------

Line 230: procedure aggregate_formula(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);
232: --procedures-------------------------------------------------------
233: procedure init_all;
234: procedure log(p_message varchar2);