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_BSC_METADATA dependencies on DBMS_SQL

Line 10: p_dim_level_list dbms_sql.varchar2_table,

6: g_count number;
7: g_exception exception;
8: --procedures-------------------------------------------------------
9: procedure get_all_parent_child(
10: p_dim_level_list dbms_sql.varchar2_table,
11: p_dim_parent_child out nocopy BSC_AW_ADAPTER_DIM.dim_parent_child_tb,
12: p_dim_levels out nocopy BSC_AW_ADAPTER_DIM.levels_tv
13: );
14: procedure get_parent_children(

Line 16: p_level_considered in out nocopy dbms_sql.varchar2_table,

12: p_dim_levels out nocopy BSC_AW_ADAPTER_DIM.levels_tv
13: );
14: procedure get_parent_children(
15: p_level varchar2,
16: p_level_considered in out nocopy dbms_sql.varchar2_table,
17: p_dim_parent_child in out nocopy BSC_AW_ADAPTER_DIM.dim_parent_child_tb
18: );
19: procedure get_all_distinct_levels(
20: p_levels dbms_sql.varchar2_table,

Line 20: p_levels dbms_sql.varchar2_table,

16: p_level_considered in out nocopy dbms_sql.varchar2_table,
17: p_dim_parent_child in out nocopy BSC_AW_ADAPTER_DIM.dim_parent_child_tb
18: );
19: procedure get_all_distinct_levels(
20: p_levels dbms_sql.varchar2_table,
21: p_dim_levels out nocopy BSC_AW_ADAPTER_DIM.levels_tv
22: );
23: procedure get_kpi_for_dim(
24: p_dim in out nocopy bsc_aw_adapter_dim.dimension_r

Line 33: p_kpi_list dbms_sql.varchar2_table,

29: procedure create_data_source(
30: p_dimension in out nocopy bsc_aw_adapter_dim.dimension_r
31: );
32: procedure get_dims_for_kpis(
33: p_kpi_list dbms_sql.varchar2_table,
34: p_dim_list out nocopy dbms_sql.varchar2_table
35: );
36: procedure set_dim_recursive(p_dimension in out nocopy bsc_aw_adapter_dim.dimension_r);
37: procedure get_kpi_for_calendar(p_calendar in out nocopy bsc_aw_calendar.calendar_r) ;

Line 34: p_dim_list out nocopy dbms_sql.varchar2_table

30: p_dimension in out nocopy bsc_aw_adapter_dim.dimension_r
31: );
32: procedure get_dims_for_kpis(
33: p_kpi_list dbms_sql.varchar2_table,
34: p_dim_list out nocopy dbms_sql.varchar2_table
35: );
36: procedure set_dim_recursive(p_dimension in out nocopy bsc_aw_adapter_dim.dimension_r);
37: procedure get_kpi_for_calendar(p_calendar in out nocopy bsc_aw_calendar.calendar_r) ;
38: procedure get_kpi_properties(p_kpi in out nocopy bsc_aw_adapter_kpi.kpi_r);

Line 43: p_dim_level out nocopy dbms_sql.varchar2_table,

39: procedure get_kpi_dim_sets(p_kpi in out nocopy bsc_aw_adapter_kpi.kpi_r);
40: procedure get_dim_set_dims(
41: p_kpi varchar2,
42: p_dim_set varchar2,
43: p_dim_level out nocopy dbms_sql.varchar2_table,
44: p_mo_dim_group out nocopy dbms_sql.varchar2_table,
45: p_skip_level out nocopy dbms_sql.varchar2_table
46: );
47: procedure get_dim_set_measures(

Line 44: p_mo_dim_group out nocopy dbms_sql.varchar2_table,

40: procedure get_dim_set_dims(
41: p_kpi varchar2,
42: p_dim_set varchar2,
43: p_dim_level out nocopy dbms_sql.varchar2_table,
44: p_mo_dim_group out nocopy dbms_sql.varchar2_table,
45: p_skip_level out nocopy dbms_sql.varchar2_table
46: );
47: procedure get_dim_set_measures(
48: p_kpi varchar2,

Line 45: p_skip_level out nocopy dbms_sql.varchar2_table

41: p_kpi varchar2,
42: p_dim_set varchar2,
43: p_dim_level out nocopy dbms_sql.varchar2_table,
44: p_mo_dim_group out nocopy dbms_sql.varchar2_table,
45: p_skip_level out nocopy dbms_sql.varchar2_table
46: );
47: procedure get_dim_set_measures(
48: p_kpi varchar2,
49: p_dim_set varchar2,

Line 73: p_kpi out nocopy dbms_sql.varchar2_table,

69: );
70: procedure get_dim_level_filter(p_kpi varchar2,p_level in out nocopy bsc_aw_adapter_kpi.level_r);
71: procedure get_target_dim_periodicity(p_kpi varchar2,p_target_dim_set in out nocopy bsc_aw_adapter_kpi.dim_set_r);
72: procedure get_all_kpi_in_aw(
73: p_kpi out nocopy dbms_sql.varchar2_table,
74: p_kpi_dimset out nocopy dbms_sql.varchar2_table
75: );
76: procedure fill_in_target_periodicity(
77: p_target_calendar in out nocopy bsc_aw_adapter_kpi.calendar_r,

Line 74: p_kpi_dimset out nocopy dbms_sql.varchar2_table

70: procedure get_dim_level_filter(p_kpi varchar2,p_level in out nocopy bsc_aw_adapter_kpi.level_r);
71: procedure get_target_dim_periodicity(p_kpi varchar2,p_target_dim_set in out nocopy bsc_aw_adapter_kpi.dim_set_r);
72: procedure get_all_kpi_in_aw(
73: p_kpi out nocopy dbms_sql.varchar2_table,
74: p_kpi_dimset out nocopy dbms_sql.varchar2_table
75: );
76: procedure fill_in_target_periodicity(
77: p_target_calendar in out nocopy bsc_aw_adapter_kpi.calendar_r,
78: p_source_calendar bsc_aw_adapter_kpi.calendar_r,

Line 82: p_short_name dbms_sql.varchar2_table,

78: p_source_calendar bsc_aw_adapter_kpi.calendar_r,
79: p_periodicity varchar2
80: );
81: procedure get_measures_for_short_names(
82: p_short_name dbms_sql.varchar2_table,
83: p_measure_name out nocopy dbms_sql.varchar2_table
84: );
85: procedure get_dim_levels_for_short_names(
86: p_short_name dbms_sql.varchar2_table,

Line 83: p_measure_name out nocopy dbms_sql.varchar2_table

79: p_periodicity varchar2
80: );
81: procedure get_measures_for_short_names(
82: p_short_name dbms_sql.varchar2_table,
83: p_measure_name out nocopy dbms_sql.varchar2_table
84: );
85: procedure get_dim_levels_for_short_names(
86: p_short_name dbms_sql.varchar2_table,
87: p_dim_level_name out nocopy dbms_sql.varchar2_table

Line 86: p_short_name dbms_sql.varchar2_table,

82: p_short_name dbms_sql.varchar2_table,
83: p_measure_name out nocopy dbms_sql.varchar2_table
84: );
85: procedure get_dim_levels_for_short_names(
86: p_short_name dbms_sql.varchar2_table,
87: p_dim_level_name out nocopy dbms_sql.varchar2_table
88: );
89: function is_level_used_by_aw_kpi(p_level varchar2) return boolean;
90: procedure get_parent_level(p_level varchar2,p_parents out nocopy dbms_sql.varchar2_table);

Line 87: p_dim_level_name out nocopy dbms_sql.varchar2_table

83: p_measure_name out nocopy dbms_sql.varchar2_table
84: );
85: procedure get_dim_levels_for_short_names(
86: p_short_name dbms_sql.varchar2_table,
87: p_dim_level_name out nocopy dbms_sql.varchar2_table
88: );
89: function is_level_used_by_aw_kpi(p_level varchar2) return boolean;
90: procedure get_parent_level(p_level varchar2,p_parents out nocopy dbms_sql.varchar2_table);
91: procedure get_child_level(p_level varchar2,p_children out nocopy dbms_sql.varchar2_table);

Line 90: procedure get_parent_level(p_level varchar2,p_parents out nocopy dbms_sql.varchar2_table);

86: p_short_name dbms_sql.varchar2_table,
87: p_dim_level_name out nocopy dbms_sql.varchar2_table
88: );
89: function is_level_used_by_aw_kpi(p_level varchar2) return boolean;
90: procedure get_parent_level(p_level varchar2,p_parents out nocopy dbms_sql.varchar2_table);
91: procedure get_child_level(p_level varchar2,p_children out nocopy dbms_sql.varchar2_table);
92: procedure get_B_table_feed_periodicity(p_kpi varchar2,p_dim_set varchar2,p_base_table varchar2,p_feed_periodicity out nocopy dbms_sql.number_table);
93: procedure get_ds_relevant_cal_hier(p_calendar in out nocopy bsc_aw_adapter_kpi.calendar_r);
94: procedure set_measure_properties(p_dim_set bsc_aw_adapter_kpi.dim_set_r,p_data_source in out nocopy bsc_aw_adapter_kpi.data_source_r);

Line 91: procedure get_child_level(p_level varchar2,p_children out nocopy dbms_sql.varchar2_table);

87: p_dim_level_name out nocopy dbms_sql.varchar2_table
88: );
89: function is_level_used_by_aw_kpi(p_level varchar2) return boolean;
90: procedure get_parent_level(p_level varchar2,p_parents out nocopy dbms_sql.varchar2_table);
91: procedure get_child_level(p_level varchar2,p_children out nocopy dbms_sql.varchar2_table);
92: procedure get_B_table_feed_periodicity(p_kpi varchar2,p_dim_set varchar2,p_base_table varchar2,p_feed_periodicity out nocopy dbms_sql.number_table);
93: procedure get_ds_relevant_cal_hier(p_calendar in out nocopy bsc_aw_adapter_kpi.calendar_r);
94: procedure set_measure_properties(p_dim_set bsc_aw_adapter_kpi.dim_set_r,p_data_source in out nocopy bsc_aw_adapter_kpi.data_source_r);
95: procedure get_table_current_period(p_table varchar2,p_period out nocopy varchar2);

Line 92: procedure get_B_table_feed_periodicity(p_kpi varchar2,p_dim_set varchar2,p_base_table varchar2,p_feed_periodicity out nocopy dbms_sql.number_table);

88: );
89: function is_level_used_by_aw_kpi(p_level varchar2) return boolean;
90: procedure get_parent_level(p_level varchar2,p_parents out nocopy dbms_sql.varchar2_table);
91: procedure get_child_level(p_level varchar2,p_children out nocopy dbms_sql.varchar2_table);
92: procedure get_B_table_feed_periodicity(p_kpi varchar2,p_dim_set varchar2,p_base_table varchar2,p_feed_periodicity out nocopy dbms_sql.number_table);
93: procedure get_ds_relevant_cal_hier(p_calendar in out nocopy bsc_aw_adapter_kpi.calendar_r);
94: procedure set_measure_properties(p_dim_set bsc_aw_adapter_kpi.dim_set_r,p_data_source in out nocopy bsc_aw_adapter_kpi.data_source_r);
95: procedure get_table_current_period(p_table varchar2,p_period out nocopy varchar2);
96: --procedures-------------------------------------------------------