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_MD_WRAPPER

Line 6: g_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb;

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

Line 7: g_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb;

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

Line 14: bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb

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

Line 25: bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb

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

Line 40: p_objects out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb,

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(

Line 69: p_bsc_olap_object out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb

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,

Line 77: p_bsc_olap_object_relation out nocopy bsc_aw_md_wrapper.bsc_olap_object_relation_tb

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

Line 94: p_bsc_olap_object out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb

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,

Line 100: p_olap_object_relation out nocopy bsc_aw_md_wrapper.bsc_olap_object_relation_tb

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,

Line 106: p_olap_object_relation out nocopy bsc_aw_md_wrapper.bsc_olap_object_relation_tb

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,

Line 171: p_bsc_olap_object out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb

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

Line 178: p_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb,

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(

Line 202: p_bsc_olap_object out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb

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,

Line 209: p_bsc_olap_object bsc_aw_md_wrapper.bsc_olap_object_tb

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,

Line 217: p_bsc_olap_object_relation out nocopy bsc_aw_md_wrapper.bsc_olap_object_relation_tb

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,

Line 225: p_bsc_olap_object_relation bsc_aw_md_wrapper.bsc_olap_object_relation_tb

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