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_MD_API dependencies on BSC_AW_ADAPTER_KPI

Line 83: procedure create_kpi(p_kpi bsc_aw_adapter_kpi.kpi_r);

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

Line 84: procedure get_dim_properties(p_dim in out nocopy bsc_aw_adapter_kpi.dim_r);

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

Line 86: p_kpi bsc_aw_adapter_kpi.kpi_r,

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

Line 87: p_dim_set in out nocopy bsc_aw_adapter_kpi.dim_set_r

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;

Line 111: p_measure out nocopy bsc_aw_adapter_kpi.measure_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,

Line 116: p_dimset out nocopy bsc_aw_adapter_kpi.dim_set_r

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,

Line 121: p_dim out nocopy bsc_aw_adapter_kpi.dim_tb,

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,

Line 122: p_std_dim out nocopy bsc_aw_adapter_kpi.dim_tb

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,

Line 127: p_dim in out nocopy bsc_aw_adapter_kpi.dim_r,

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(

Line 134: p_calendar out nocopy bsc_aw_adapter_kpi.calendar_r

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

Line 140: procedure get_calendar_properties(p_calendar in out nocopy bsc_aw_adapter_kpi.calendar_r);

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,

Line 163: p_dim bsc_aw_adapter_kpi.dim_r,

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

Line 166: p_calendar bsc_aw_adapter_kpi.calendar_r,

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,

Line 185: p_partition_template out nocopy bsc_aw_adapter_kpi.partition_template_tb,

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,

Line 186: p_composite out nocopy bsc_aw_adapter_kpi.composite_tb);

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

Line 190: p_cube_set out nocopy bsc_aw_adapter_kpi.cube_set_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,

Line 196: p_cube out nocopy bsc_aw_adapter_kpi.cube_r) ;

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,

Line 231: procedure get_kpi(p_kpi in out nocopy bsc_aw_adapter_kpi.kpi_r);

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,