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

Line 24: p_kpi out nocopy dbms_sql.varchar2_table,

20: p_level_source out nocopy varchar2
21: );
22: procedure get_kpi_for_dim(
23: p_levels varchar2,
24: p_kpi out nocopy dbms_sql.varchar2_table,
25: p_dimset out nocopy dbms_sql.varchar2_table
26: );
27: procedure get_dims_for_kpis(
28: p_kpi_list dbms_sql.varchar2_table,

Line 25: p_dimset out nocopy dbms_sql.varchar2_table

21: );
22: procedure get_kpi_for_dim(
23: p_levels varchar2,
24: p_kpi out nocopy dbms_sql.varchar2_table,
25: p_dimset out nocopy dbms_sql.varchar2_table
26: );
27: procedure get_dims_for_kpis(
28: p_kpi_list dbms_sql.varchar2_table,
29: p_dim_list out nocopy dbms_sql.varchar2_table

Line 28: p_kpi_list dbms_sql.varchar2_table,

24: p_kpi out nocopy dbms_sql.varchar2_table,
25: p_dimset out nocopy dbms_sql.varchar2_table
26: );
27: procedure get_dims_for_kpis(
28: p_kpi_list dbms_sql.varchar2_table,
29: p_dim_list out nocopy dbms_sql.varchar2_table
30: );
31: function is_dim_recursive(p_dim_level varchar2) return varchar2;
32: procedure get_dim_data_source(

Line 29: p_dim_list out nocopy dbms_sql.varchar2_table

25: p_dimset out nocopy dbms_sql.varchar2_table
26: );
27: procedure get_dims_for_kpis(
28: p_kpi_list dbms_sql.varchar2_table,
29: p_dim_list out nocopy dbms_sql.varchar2_table
30: );
31: function is_dim_recursive(p_dim_level varchar2) return varchar2;
32: procedure get_dim_data_source(
33: p_level_list dbms_sql.varchar2_table,

Line 33: p_level_list dbms_sql.varchar2_table,

29: p_dim_list out nocopy dbms_sql.varchar2_table
30: );
31: function is_dim_recursive(p_dim_level varchar2) return varchar2;
32: procedure get_dim_data_source(
33: p_level_list dbms_sql.varchar2_table,
34: p_level_pk_col out nocopy dbms_sql.varchar2_table,
35: p_data_source out nocopy varchar2,
36: p_inc_data_source out nocopy varchar2
37: );

Line 34: p_level_pk_col out nocopy dbms_sql.varchar2_table,

30: );
31: function is_dim_recursive(p_dim_level varchar2) return varchar2;
32: procedure get_dim_data_source(
33: p_level_list dbms_sql.varchar2_table,
34: p_level_pk_col out nocopy dbms_sql.varchar2_table,
35: p_data_source out nocopy varchar2,
36: p_inc_data_source out nocopy varchar2
37: );
38: procedure get_denorm_data_source(

Line 46: procedure get_kpi_for_calendar(p_calendar_id number,p_kpi_list out nocopy dbms_sql.varchar2_table);

42: p_position_col out nocopy varchar2,
43: p_denorm_data_source out nocopy varchar2,
44: p_denorm_change_data_source out nocopy varchar2
45: );
46: procedure get_kpi_for_calendar(p_calendar_id number,p_kpi_list out nocopy dbms_sql.varchar2_table);
47: procedure get_kpi_calendar(p_kpi varchar2,p_calendar out nocopy number) ;
48: procedure get_kpi_dim_sets(
49: p_kpi varchar2,
50: p_dim_set out nocopy dbms_sql.varchar2_table

Line 50: p_dim_set out nocopy dbms_sql.varchar2_table

46: procedure get_kpi_for_calendar(p_calendar_id number,p_kpi_list out nocopy dbms_sql.varchar2_table);
47: procedure get_kpi_calendar(p_kpi varchar2,p_calendar out nocopy number) ;
48: procedure get_kpi_dim_sets(
49: p_kpi varchar2,
50: p_dim_set out nocopy dbms_sql.varchar2_table
51: );
52: procedure get_dim_set_dims(
53: p_kpi varchar2,
54: p_dim_set varchar2,

Line 55: p_dim_level out nocopy dbms_sql.varchar2_table,

51: );
52: procedure get_dim_set_dims(
53: p_kpi varchar2,
54: p_dim_set varchar2,
55: p_dim_level out nocopy dbms_sql.varchar2_table,
56: p_mo_dim_group out nocopy dbms_sql.varchar2_table,
57: p_skip_level out nocopy dbms_sql.varchar2_table
58: );
59: procedure get_dim_set_measures(

Line 56: p_mo_dim_group out nocopy dbms_sql.varchar2_table,

52: procedure get_dim_set_dims(
53: p_kpi varchar2,
54: p_dim_set varchar2,
55: p_dim_level out nocopy dbms_sql.varchar2_table,
56: p_mo_dim_group out nocopy dbms_sql.varchar2_table,
57: p_skip_level out nocopy dbms_sql.varchar2_table
58: );
59: procedure get_dim_set_measures(
60: p_kpi varchar2,

Line 57: p_skip_level out nocopy dbms_sql.varchar2_table

53: p_kpi varchar2,
54: p_dim_set varchar2,
55: p_dim_level out nocopy dbms_sql.varchar2_table,
56: p_mo_dim_group out nocopy dbms_sql.varchar2_table,
57: p_skip_level out nocopy dbms_sql.varchar2_table
58: );
59: procedure get_dim_set_measures(
60: p_kpi varchar2,
61: p_dim_set varchar2,

Line 62: p_measure out nocopy dbms_sql.varchar2_table,

58: );
59: procedure get_dim_set_measures(
60: p_kpi varchar2,
61: p_dim_set varchar2,
62: p_measure out nocopy dbms_sql.varchar2_table,
63: p_measure_type out nocopy dbms_sql.varchar2_table,
64: p_data_type out nocopy dbms_sql.varchar2_table,
65: p_agg_formula out nocopy dbms_sql.varchar2_table,
66: p_forecast out nocopy dbms_sql.varchar2_table,

Line 63: p_measure_type out nocopy dbms_sql.varchar2_table,

59: procedure get_dim_set_measures(
60: p_kpi varchar2,
61: p_dim_set varchar2,
62: p_measure out nocopy dbms_sql.varchar2_table,
63: p_measure_type out nocopy dbms_sql.varchar2_table,
64: p_data_type out nocopy dbms_sql.varchar2_table,
65: p_agg_formula out nocopy dbms_sql.varchar2_table,
66: p_forecast out nocopy dbms_sql.varchar2_table,
67: p_property out nocopy dbms_sql.varchar2_table

Line 64: p_data_type out nocopy dbms_sql.varchar2_table,

60: p_kpi varchar2,
61: p_dim_set varchar2,
62: p_measure out nocopy dbms_sql.varchar2_table,
63: p_measure_type out nocopy dbms_sql.varchar2_table,
64: p_data_type out nocopy dbms_sql.varchar2_table,
65: p_agg_formula out nocopy dbms_sql.varchar2_table,
66: p_forecast out nocopy dbms_sql.varchar2_table,
67: p_property out nocopy dbms_sql.varchar2_table
68: );

Line 65: p_agg_formula out nocopy dbms_sql.varchar2_table,

61: p_dim_set varchar2,
62: p_measure out nocopy dbms_sql.varchar2_table,
63: p_measure_type out nocopy dbms_sql.varchar2_table,
64: p_data_type out nocopy dbms_sql.varchar2_table,
65: p_agg_formula out nocopy dbms_sql.varchar2_table,
66: p_forecast out nocopy dbms_sql.varchar2_table,
67: p_property out nocopy dbms_sql.varchar2_table
68: );
69: function is_target_at_higher_level(p_kpi varchar2,p_dim_set varchar2) return varchar2;

Line 66: p_forecast out nocopy dbms_sql.varchar2_table,

62: p_measure out nocopy dbms_sql.varchar2_table,
63: p_measure_type out nocopy dbms_sql.varchar2_table,
64: p_data_type out nocopy dbms_sql.varchar2_table,
65: p_agg_formula out nocopy dbms_sql.varchar2_table,
66: p_forecast out nocopy dbms_sql.varchar2_table,
67: p_property out nocopy dbms_sql.varchar2_table
68: );
69: function is_target_at_higher_level(p_kpi varchar2,p_dim_set varchar2) return varchar2;
70: procedure get_target_levels(

Line 67: p_property out nocopy dbms_sql.varchar2_table

63: p_measure_type out nocopy dbms_sql.varchar2_table,
64: p_data_type out nocopy dbms_sql.varchar2_table,
65: p_agg_formula out nocopy dbms_sql.varchar2_table,
66: p_forecast out nocopy dbms_sql.varchar2_table,
67: p_property out nocopy dbms_sql.varchar2_table
68: );
69: function is_target_at_higher_level(p_kpi varchar2,p_dim_set varchar2) return varchar2;
70: procedure get_target_levels(
71: p_kpi varchar2,

Line 73: p_dim_level out nocopy dbms_sql.varchar2_table);

69: function is_target_at_higher_level(p_kpi varchar2,p_dim_set varchar2) return varchar2;
70: procedure get_target_levels(
71: p_kpi varchar2,
72: p_dim_set varchar2,
73: p_dim_level out nocopy dbms_sql.varchar2_table);
74: procedure get_dim_level_properties(p_level varchar2,
75: p_pk out nocopy varchar2,
76: p_fk out nocopy varchar2,
77: p_datatype out nocopy varchar2,

Line 82: p_filter out nocopy dbms_sql.varchar2_table);

78: p_level_source out nocopy varchar2);
79: procedure get_dim_level_filter(
80: p_kpi varchar2,
81: p_level varchar2,
82: p_filter out nocopy dbms_sql.varchar2_table);
83: procedure get_s_views(
84: p_kpi varchar2,
85: p_dim_set varchar2,
86: p_s_views out nocopy dbms_sql.varchar2_table);

Line 86: p_s_views out nocopy dbms_sql.varchar2_table);

82: p_filter out nocopy dbms_sql.varchar2_table);
83: procedure get_s_views(
84: p_kpi varchar2,
85: p_dim_set varchar2,
86: p_s_views out nocopy dbms_sql.varchar2_table);
87: procedure get_s_view_levels(
88: p_s_view varchar2,
89: p_levels out nocopy dbms_sql.varchar2_table);
90: procedure get_base_table_levels(p_kpi varchar2,

Line 89: p_levels out nocopy dbms_sql.varchar2_table);

85: p_dim_set varchar2,
86: p_s_views out nocopy dbms_sql.varchar2_table);
87: procedure get_s_view_levels(
88: p_s_view varchar2,
89: p_levels out nocopy dbms_sql.varchar2_table);
90: procedure get_base_table_levels(p_kpi varchar2,
91: p_dim_set varchar2,
92: p_base_table varchar2,
93: p_bt_levels out nocopy dbms_sql.varchar2_table,

Line 93: p_bt_levels out nocopy dbms_sql.varchar2_table,

89: p_levels out nocopy dbms_sql.varchar2_table);
90: procedure get_base_table_levels(p_kpi varchar2,
91: p_dim_set varchar2,
92: p_base_table varchar2,
93: p_bt_levels out nocopy dbms_sql.varchar2_table,
94: p_bt_level_fks out nocopy dbms_sql.varchar2_table,
95: p_bt_level_pks out nocopy dbms_sql.varchar2_table,
96: p_bt_feed_level out nocopy dbms_sql.varchar2_table
97: );

Line 94: p_bt_level_fks out nocopy dbms_sql.varchar2_table,

90: procedure get_base_table_levels(p_kpi varchar2,
91: p_dim_set varchar2,
92: p_base_table varchar2,
93: p_bt_levels out nocopy dbms_sql.varchar2_table,
94: p_bt_level_fks out nocopy dbms_sql.varchar2_table,
95: p_bt_level_pks out nocopy dbms_sql.varchar2_table,
96: p_bt_feed_level out nocopy dbms_sql.varchar2_table
97: );
98: procedure get_base_table_measures(p_kpi varchar2,

Line 95: p_bt_level_pks out nocopy dbms_sql.varchar2_table,

91: p_dim_set varchar2,
92: p_base_table varchar2,
93: p_bt_levels out nocopy dbms_sql.varchar2_table,
94: p_bt_level_fks out nocopy dbms_sql.varchar2_table,
95: p_bt_level_pks out nocopy dbms_sql.varchar2_table,
96: p_bt_feed_level out nocopy dbms_sql.varchar2_table
97: );
98: procedure get_base_table_measures(p_kpi varchar2,
99: p_dim_set varchar2,

Line 96: p_bt_feed_level out nocopy dbms_sql.varchar2_table

92: p_base_table varchar2,
93: p_bt_levels out nocopy dbms_sql.varchar2_table,
94: p_bt_level_fks out nocopy dbms_sql.varchar2_table,
95: p_bt_level_pks out nocopy dbms_sql.varchar2_table,
96: p_bt_feed_level out nocopy dbms_sql.varchar2_table
97: );
98: procedure get_base_table_measures(p_kpi varchar2,
99: p_dim_set varchar2,
100: p_base_table varchar2,

Line 101: p_measures out nocopy dbms_sql.varchar2_table,

97: );
98: procedure get_base_table_measures(p_kpi varchar2,
99: p_dim_set varchar2,
100: p_base_table varchar2,
101: p_measures out nocopy dbms_sql.varchar2_table,
102: p_bt_formula out nocopy dbms_sql.varchar2_table
103: );
104: procedure get_kpi_periodicities(
105: p_kpi varchar2,

Line 102: p_bt_formula out nocopy dbms_sql.varchar2_table

98: procedure get_base_table_measures(p_kpi varchar2,
99: p_dim_set varchar2,
100: p_base_table varchar2,
101: p_measures out nocopy dbms_sql.varchar2_table,
102: p_bt_formula out nocopy dbms_sql.varchar2_table
103: );
104: procedure get_kpi_periodicities(
105: p_kpi varchar2,
106: p_dim_set varchar2,

Line 107: p_periodicity out nocopy dbms_sql.number_table

103: );
104: procedure get_kpi_periodicities(
105: p_kpi varchar2,
106: p_dim_set varchar2,
107: p_periodicity out nocopy dbms_sql.number_table
108: );
109: procedure get_base_table_periodicity(
110: p_base_table varchar2,
111: p_periodicity out nocopy number);

Line 118: p_levels out nocopy dbms_sql.varchar2_table) ;

114: p_periodicity number) return varchar2;
115: procedure get_zero_code_levels(
116: p_kpi varchar2,
117: p_dim_set varchar2,
118: p_levels out nocopy dbms_sql.varchar2_table) ;
119: procedure get_dim_set_base_tables(
120: p_kpi varchar2,
121: p_dim_set varchar2,
122: p_base_tables out nocopy dbms_sql.varchar2_table);

Line 122: p_base_tables out nocopy dbms_sql.varchar2_table);

118: p_levels out nocopy dbms_sql.varchar2_table) ;
119: procedure get_dim_set_base_tables(
120: p_kpi varchar2,
121: p_dim_set varchar2,
122: p_base_tables out nocopy dbms_sql.varchar2_table);
123: procedure get_dim_set_target_base_tables(
124: p_kpi varchar2,
125: p_dim_set varchar2,
126: p_base_tables out nocopy dbms_sql.varchar2_table);

Line 126: p_base_tables out nocopy dbms_sql.varchar2_table);

122: p_base_tables out nocopy dbms_sql.varchar2_table);
123: procedure get_dim_set_target_base_tables(
124: p_kpi varchar2,
125: p_dim_set varchar2,
126: p_base_tables out nocopy dbms_sql.varchar2_table);
127: procedure get_kpi_current_period(
128: p_kpi varchar2,
129: p_periodicity number,
130: p_period out nocopy number,

Line 135: p_periodicities out nocopy dbms_sql.number_table

131: p_year out nocopy number);
132: procedure get_target_periodicity(
133: p_kpi varchar2,
134: p_dim_set varchar2,
135: p_periodicities out nocopy dbms_sql.number_table
136: );
137: procedure get_all_kpi_in_aw(p_kpi_list out nocopy dbms_sql.varchar2_table);
138: --get the z mvs
139: procedure get_z_s_views(

Line 137: procedure get_all_kpi_in_aw(p_kpi_list out nocopy dbms_sql.varchar2_table);

133: p_kpi varchar2,
134: p_dim_set varchar2,
135: p_periodicities out nocopy dbms_sql.number_table
136: );
137: procedure get_all_kpi_in_aw(p_kpi_list out nocopy dbms_sql.varchar2_table);
138: --get the z mvs
139: procedure get_z_s_views(
140: p_kpi varchar2,
141: p_dim_set varchar2,

Line 142: p_s_views out nocopy dbms_sql.varchar2_table);

138: --get the z mvs
139: procedure get_z_s_views(
140: p_kpi varchar2,
141: p_dim_set varchar2,
142: p_s_views out nocopy dbms_sql.varchar2_table);
143: function get_level_short_name(p_level_table_name varchar2) return varchar2;
144: procedure get_measures_for_short_names(
145: p_short_name dbms_sql.varchar2_table,
146: p_measure_name out nocopy dbms_sql.varchar2_table

Line 145: p_short_name dbms_sql.varchar2_table,

141: p_dim_set varchar2,
142: p_s_views out nocopy dbms_sql.varchar2_table);
143: function get_level_short_name(p_level_table_name varchar2) return varchar2;
144: procedure get_measures_for_short_names(
145: p_short_name dbms_sql.varchar2_table,
146: p_measure_name out nocopy dbms_sql.varchar2_table
147: );
148: procedure get_dim_levels_for_short_names(
149: p_short_name dbms_sql.varchar2_table,

Line 146: p_measure_name out nocopy dbms_sql.varchar2_table

142: p_s_views out nocopy dbms_sql.varchar2_table);
143: function get_level_short_name(p_level_table_name varchar2) return varchar2;
144: procedure get_measures_for_short_names(
145: p_short_name dbms_sql.varchar2_table,
146: p_measure_name out nocopy dbms_sql.varchar2_table
147: );
148: procedure get_dim_levels_for_short_names(
149: p_short_name dbms_sql.varchar2_table,
150: p_dim_level_name out nocopy dbms_sql.varchar2_table

Line 149: p_short_name dbms_sql.varchar2_table,

145: p_short_name dbms_sql.varchar2_table,
146: p_measure_name out nocopy dbms_sql.varchar2_table
147: );
148: procedure get_dim_levels_for_short_names(
149: p_short_name dbms_sql.varchar2_table,
150: p_dim_level_name out nocopy dbms_sql.varchar2_table
151: );
152: function is_level_used_by_aw_kpi(p_level varchar2) return boolean ;
153: 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);

Line 150: p_dim_level_name out nocopy dbms_sql.varchar2_table

146: p_measure_name out nocopy dbms_sql.varchar2_table
147: );
148: procedure get_dim_levels_for_short_names(
149: p_short_name dbms_sql.varchar2_table,
150: p_dim_level_name out nocopy dbms_sql.varchar2_table
151: );
152: function is_level_used_by_aw_kpi(p_level varchar2) return boolean ;
153: 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);
154: function get_kpi_LUD(p_kpi varchar2) return date;

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

149: p_short_name dbms_sql.varchar2_table,
150: p_dim_level_name out nocopy dbms_sql.varchar2_table
151: );
152: function is_level_used_by_aw_kpi(p_level varchar2) return boolean ;
153: 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);
154: function get_kpi_LUD(p_kpi varchar2) return date;
155: procedure get_base_table_properties(
156: p_base_table varchar2,
157: p_prj_table out nocopy varchar2,