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

Line 15: dim_set bsc_aw_adapter_kpi.dim_set_tb

11: --both actual and target dimsets are contained in dim_set
12: type aggregation_r is record(
13: kpi varchar2(200),
14: parent_kpi varchar2(200),
15: dim_set bsc_aw_adapter_kpi.dim_set_tb
16: );
17: type aggregation_tb is table of aggregation_r index by pls_integer;
18: --g_aggregation aggregation_r;
19: ----cache--------------------------------------------------------

Line 43: p_dim_set bsc_aw_adapter_kpi.dim_set_r);

39: p_run_id number,p_job_name varchar2,p_options varchar2);
40: procedure aggregate_kpi_dimset(
41: p_kpi varchar2,
42: p_aggregation aggregation_r,
43: p_dim_set bsc_aw_adapter_kpi.dim_set_r);
44: procedure aggregate_kpi_dimset_actuals(p_kpi varchar2,p_dim_set bsc_aw_adapter_kpi.dim_set_r);
45: procedure aggregate_kpi_dimset_targets(
46: p_kpi varchar2,
47: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,

Line 44: procedure aggregate_kpi_dimset_actuals(p_kpi varchar2,p_dim_set bsc_aw_adapter_kpi.dim_set_r);

40: procedure aggregate_kpi_dimset(
41: p_kpi varchar2,
42: p_aggregation aggregation_r,
43: p_dim_set bsc_aw_adapter_kpi.dim_set_r);
44: procedure aggregate_kpi_dimset_actuals(p_kpi varchar2,p_dim_set bsc_aw_adapter_kpi.dim_set_r);
45: procedure aggregate_kpi_dimset_targets(
46: p_kpi varchar2,
47: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
48: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r

Line 47: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,

43: p_dim_set bsc_aw_adapter_kpi.dim_set_r);
44: procedure aggregate_kpi_dimset_actuals(p_kpi varchar2,p_dim_set bsc_aw_adapter_kpi.dim_set_r);
45: procedure aggregate_kpi_dimset_targets(
46: p_kpi varchar2,
47: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
48: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r
49: );
50: procedure aggregate_measure(
51: p_kpi varchar2,

Line 48: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r

44: procedure aggregate_kpi_dimset_actuals(p_kpi varchar2,p_dim_set bsc_aw_adapter_kpi.dim_set_r);
45: procedure aggregate_kpi_dimset_targets(
46: p_kpi varchar2,
47: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
48: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r
49: );
50: procedure aggregate_measure(
51: p_kpi varchar2,
52: p_dim_set bsc_aw_adapter_kpi.dim_set_r,

Line 52: p_dim_set bsc_aw_adapter_kpi.dim_set_r,

48: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r
49: );
50: procedure aggregate_measure(
51: p_kpi varchar2,
52: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
53: p_measures dbms_sql.varchar2_table,
54: p_aggregate_options varchar2
55: );
56: procedure aggregate_measure_formula(

Line 58: p_dim_set bsc_aw_adapter_kpi.dim_set_r,

54: p_aggregate_options varchar2
55: );
56: procedure aggregate_measure_formula(
57: p_kpi varchar2,
58: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
59: p_measures dbms_sql.varchar2_table,
60: p_aggregate_options varchar2
61: );
62: procedure correct_forecast_aggregation(

Line 64: p_dim_set bsc_aw_adapter_kpi.dim_set_r,

60: p_aggregate_options varchar2
61: );
62: procedure correct_forecast_aggregation(
63: p_kpi varchar2,
64: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
65: p_measures bsc_aw_adapter_kpi.measure_tb,
66: p_aggregate_options varchar2
67: );
68: procedure get_forecast_current_period(

Line 65: p_measures bsc_aw_adapter_kpi.measure_tb,

61: );
62: procedure correct_forecast_aggregation(
63: p_kpi varchar2,
64: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
65: p_measures bsc_aw_adapter_kpi.measure_tb,
66: p_aggregate_options varchar2
67: );
68: procedure get_forecast_current_period(
69: p_aggregation in out nocopy aggregation_r);

Line 76: procedure limit_calendar_end_period_rel(p_calendar bsc_aw_adapter_kpi.calendar_r);

72: p_calendar number,
73: p_periodicity number,
74: p_period out nocopy varchar2
75: );
76: procedure limit_calendar_end_period_rel(p_calendar bsc_aw_adapter_kpi.calendar_r);
77: procedure reset_calendar_end_period_rel(p_calendar bsc_aw_adapter_kpi.calendar_r);
78: procedure limit_dim_values(p_dim bsc_aw_adapter_kpi.dim_tb,p_mode varchar2);
79: procedure limit_dim_levels(p_dim bsc_aw_adapter_kpi.dim_tb);
80: procedure limit_dim_ancestors(p_dim bsc_aw_adapter_kpi.dim_tb,p_operator varchar2);

Line 77: procedure reset_calendar_end_period_rel(p_calendar bsc_aw_adapter_kpi.calendar_r);

73: p_periodicity number,
74: p_period out nocopy varchar2
75: );
76: procedure limit_calendar_end_period_rel(p_calendar bsc_aw_adapter_kpi.calendar_r);
77: procedure reset_calendar_end_period_rel(p_calendar bsc_aw_adapter_kpi.calendar_r);
78: procedure limit_dim_values(p_dim bsc_aw_adapter_kpi.dim_tb,p_mode varchar2);
79: procedure limit_dim_levels(p_dim bsc_aw_adapter_kpi.dim_tb);
80: procedure limit_dim_ancestors(p_dim bsc_aw_adapter_kpi.dim_tb,p_operator varchar2);
81: procedure reset_dim_limit_cubes(p_dim bsc_aw_adapter_kpi.dim_tb);

Line 78: procedure limit_dim_values(p_dim bsc_aw_adapter_kpi.dim_tb,p_mode varchar2);

74: p_period out nocopy varchar2
75: );
76: procedure limit_calendar_end_period_rel(p_calendar bsc_aw_adapter_kpi.calendar_r);
77: procedure reset_calendar_end_period_rel(p_calendar bsc_aw_adapter_kpi.calendar_r);
78: procedure limit_dim_values(p_dim bsc_aw_adapter_kpi.dim_tb,p_mode varchar2);
79: procedure limit_dim_levels(p_dim bsc_aw_adapter_kpi.dim_tb);
80: procedure limit_dim_ancestors(p_dim bsc_aw_adapter_kpi.dim_tb,p_operator varchar2);
81: procedure reset_dim_limit_cubes(p_dim bsc_aw_adapter_kpi.dim_tb);
82: procedure limit_calendar_values(p_calendar bsc_aw_adapter_kpi.calendar_r,p_mode varchar2);

Line 79: procedure limit_dim_levels(p_dim bsc_aw_adapter_kpi.dim_tb);

75: );
76: procedure limit_calendar_end_period_rel(p_calendar bsc_aw_adapter_kpi.calendar_r);
77: procedure reset_calendar_end_period_rel(p_calendar bsc_aw_adapter_kpi.calendar_r);
78: procedure limit_dim_values(p_dim bsc_aw_adapter_kpi.dim_tb,p_mode varchar2);
79: procedure limit_dim_levels(p_dim bsc_aw_adapter_kpi.dim_tb);
80: procedure limit_dim_ancestors(p_dim bsc_aw_adapter_kpi.dim_tb,p_operator varchar2);
81: procedure reset_dim_limit_cubes(p_dim bsc_aw_adapter_kpi.dim_tb);
82: procedure limit_calendar_values(p_calendar bsc_aw_adapter_kpi.calendar_r,p_mode varchar2);
83: procedure limit_calendar_levels(p_calendar bsc_aw_adapter_kpi.calendar_r);

Line 80: procedure limit_dim_ancestors(p_dim bsc_aw_adapter_kpi.dim_tb,p_operator varchar2);

76: procedure limit_calendar_end_period_rel(p_calendar bsc_aw_adapter_kpi.calendar_r);
77: procedure reset_calendar_end_period_rel(p_calendar bsc_aw_adapter_kpi.calendar_r);
78: procedure limit_dim_values(p_dim bsc_aw_adapter_kpi.dim_tb,p_mode varchar2);
79: procedure limit_dim_levels(p_dim bsc_aw_adapter_kpi.dim_tb);
80: procedure limit_dim_ancestors(p_dim bsc_aw_adapter_kpi.dim_tb,p_operator varchar2);
81: procedure reset_dim_limit_cubes(p_dim bsc_aw_adapter_kpi.dim_tb);
82: procedure limit_calendar_values(p_calendar bsc_aw_adapter_kpi.calendar_r,p_mode varchar2);
83: procedure limit_calendar_levels(p_calendar bsc_aw_adapter_kpi.calendar_r);
84: procedure limit_calendar_ancestors(p_calendar bsc_aw_adapter_kpi.calendar_r,p_operator varchar2);

Line 81: procedure reset_dim_limit_cubes(p_dim bsc_aw_adapter_kpi.dim_tb);

77: procedure reset_calendar_end_period_rel(p_calendar bsc_aw_adapter_kpi.calendar_r);
78: procedure limit_dim_values(p_dim bsc_aw_adapter_kpi.dim_tb,p_mode varchar2);
79: procedure limit_dim_levels(p_dim bsc_aw_adapter_kpi.dim_tb);
80: procedure limit_dim_ancestors(p_dim bsc_aw_adapter_kpi.dim_tb,p_operator varchar2);
81: procedure reset_dim_limit_cubes(p_dim bsc_aw_adapter_kpi.dim_tb);
82: procedure limit_calendar_values(p_calendar bsc_aw_adapter_kpi.calendar_r,p_mode varchar2);
83: procedure limit_calendar_levels(p_calendar bsc_aw_adapter_kpi.calendar_r);
84: procedure limit_calendar_ancestors(p_calendar bsc_aw_adapter_kpi.calendar_r,p_operator varchar2);
85: procedure reset_calendar_limit_cubes(p_calendar bsc_aw_adapter_kpi.calendar_r);

Line 82: procedure limit_calendar_values(p_calendar bsc_aw_adapter_kpi.calendar_r,p_mode varchar2);

78: procedure limit_dim_values(p_dim bsc_aw_adapter_kpi.dim_tb,p_mode varchar2);
79: procedure limit_dim_levels(p_dim bsc_aw_adapter_kpi.dim_tb);
80: procedure limit_dim_ancestors(p_dim bsc_aw_adapter_kpi.dim_tb,p_operator varchar2);
81: procedure reset_dim_limit_cubes(p_dim bsc_aw_adapter_kpi.dim_tb);
82: procedure limit_calendar_values(p_calendar bsc_aw_adapter_kpi.calendar_r,p_mode varchar2);
83: procedure limit_calendar_levels(p_calendar bsc_aw_adapter_kpi.calendar_r);
84: procedure limit_calendar_ancestors(p_calendar bsc_aw_adapter_kpi.calendar_r,p_operator varchar2);
85: procedure reset_calendar_limit_cubes(p_calendar bsc_aw_adapter_kpi.calendar_r);
86: procedure set_aggregation(p_kpi varchar2,p_aggregation out nocopy aggregation_r);

Line 83: procedure limit_calendar_levels(p_calendar bsc_aw_adapter_kpi.calendar_r);

79: procedure limit_dim_levels(p_dim bsc_aw_adapter_kpi.dim_tb);
80: procedure limit_dim_ancestors(p_dim bsc_aw_adapter_kpi.dim_tb,p_operator varchar2);
81: procedure reset_dim_limit_cubes(p_dim bsc_aw_adapter_kpi.dim_tb);
82: procedure limit_calendar_values(p_calendar bsc_aw_adapter_kpi.calendar_r,p_mode varchar2);
83: procedure limit_calendar_levels(p_calendar bsc_aw_adapter_kpi.calendar_r);
84: procedure limit_calendar_ancestors(p_calendar bsc_aw_adapter_kpi.calendar_r,p_operator varchar2);
85: procedure reset_calendar_limit_cubes(p_calendar bsc_aw_adapter_kpi.calendar_r);
86: procedure set_aggregation(p_kpi varchar2,p_aggregation out nocopy aggregation_r);
87: procedure dmp_aggregation_r(p_aggregation aggregation_r);

Line 84: procedure limit_calendar_ancestors(p_calendar bsc_aw_adapter_kpi.calendar_r,p_operator varchar2);

80: procedure limit_dim_ancestors(p_dim bsc_aw_adapter_kpi.dim_tb,p_operator varchar2);
81: procedure reset_dim_limit_cubes(p_dim bsc_aw_adapter_kpi.dim_tb);
82: procedure limit_calendar_values(p_calendar bsc_aw_adapter_kpi.calendar_r,p_mode varchar2);
83: procedure limit_calendar_levels(p_calendar bsc_aw_adapter_kpi.calendar_r);
84: procedure limit_calendar_ancestors(p_calendar bsc_aw_adapter_kpi.calendar_r,p_operator varchar2);
85: procedure reset_calendar_limit_cubes(p_calendar bsc_aw_adapter_kpi.calendar_r);
86: procedure set_aggregation(p_kpi varchar2,p_aggregation out nocopy aggregation_r);
87: procedure dmp_aggregation_r(p_aggregation aggregation_r);
88: procedure push_dim(p_dim bsc_aw_adapter_kpi.dim_tb);

Line 85: procedure reset_calendar_limit_cubes(p_calendar bsc_aw_adapter_kpi.calendar_r);

81: procedure reset_dim_limit_cubes(p_dim bsc_aw_adapter_kpi.dim_tb);
82: procedure limit_calendar_values(p_calendar bsc_aw_adapter_kpi.calendar_r,p_mode varchar2);
83: procedure limit_calendar_levels(p_calendar bsc_aw_adapter_kpi.calendar_r);
84: procedure limit_calendar_ancestors(p_calendar bsc_aw_adapter_kpi.calendar_r,p_operator varchar2);
85: procedure reset_calendar_limit_cubes(p_calendar bsc_aw_adapter_kpi.calendar_r);
86: procedure set_aggregation(p_kpi varchar2,p_aggregation out nocopy aggregation_r);
87: procedure dmp_aggregation_r(p_aggregation aggregation_r);
88: procedure push_dim(p_dim bsc_aw_adapter_kpi.dim_tb);
89: procedure push_dim(p_dim varchar2);

Line 88: procedure push_dim(p_dim bsc_aw_adapter_kpi.dim_tb);

84: procedure limit_calendar_ancestors(p_calendar bsc_aw_adapter_kpi.calendar_r,p_operator varchar2);
85: procedure reset_calendar_limit_cubes(p_calendar bsc_aw_adapter_kpi.calendar_r);
86: procedure set_aggregation(p_kpi varchar2,p_aggregation out nocopy aggregation_r);
87: procedure dmp_aggregation_r(p_aggregation aggregation_r);
88: procedure push_dim(p_dim bsc_aw_adapter_kpi.dim_tb);
89: procedure push_dim(p_dim varchar2);
90: procedure pop_dim(p_dim bsc_aw_adapter_kpi.dim_tb);
91: procedure pop_dim(p_dim varchar2);
92: procedure push_level(p_marker varchar2);

Line 90: procedure pop_dim(p_dim bsc_aw_adapter_kpi.dim_tb);

86: procedure set_aggregation(p_kpi varchar2,p_aggregation out nocopy aggregation_r);
87: procedure dmp_aggregation_r(p_aggregation aggregation_r);
88: procedure push_dim(p_dim bsc_aw_adapter_kpi.dim_tb);
89: procedure push_dim(p_dim varchar2);
90: procedure pop_dim(p_dim bsc_aw_adapter_kpi.dim_tb);
91: procedure pop_dim(p_dim varchar2);
92: procedure push_level(p_marker varchar2);
93: procedure pop_level(p_marker varchar2);
94: procedure purge_kpi(p_kpi varchar2);

Line 96: p_aggmap_operator bsc_aw_adapter_kpi.aggmap_operator_r,

92: procedure push_level(p_marker varchar2);
93: procedure pop_level(p_marker varchar2);
94: procedure purge_kpi(p_kpi varchar2);
95: procedure limit_measure_dim(
96: p_aggmap_operator bsc_aw_adapter_kpi.aggmap_operator_r,
97: p_cubes dbms_sql.varchar2_table,
98: p_partition_value varchar2
99: );
100: procedure reset_dim_limits(p_dim_set bsc_aw_adapter_kpi.dim_set_r);

Line 100: procedure reset_dim_limits(p_dim_set bsc_aw_adapter_kpi.dim_set_r);

96: p_aggmap_operator bsc_aw_adapter_kpi.aggmap_operator_r,
97: p_cubes dbms_sql.varchar2_table,
98: p_partition_value varchar2
99: );
100: procedure reset_dim_limits(p_dim_set bsc_aw_adapter_kpi.dim_set_r);
101: procedure limit_dim_target_level_only(
102: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
103: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r
104: );

Line 102: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,

98: p_partition_value varchar2
99: );
100: procedure reset_dim_limits(p_dim_set bsc_aw_adapter_kpi.dim_set_r);
101: procedure limit_dim_target_level_only(
102: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
103: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r
104: );
105: procedure limit_dim_limit_cube(
106: p_dim bsc_aw_adapter_kpi.dim_tb,

Line 103: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r

99: );
100: procedure reset_dim_limits(p_dim_set bsc_aw_adapter_kpi.dim_set_r);
101: procedure limit_dim_target_level_only(
102: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
103: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r
104: );
105: procedure limit_dim_limit_cube(
106: p_dim bsc_aw_adapter_kpi.dim_tb,
107: p_value varchar2

Line 106: p_dim bsc_aw_adapter_kpi.dim_tb,

102: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
103: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r
104: );
105: procedure limit_dim_limit_cube(
106: p_dim bsc_aw_adapter_kpi.dim_tb,
107: p_value varchar2
108: );
109: procedure limit_dim_limit_cube(
110: p_limit_cube varchar2,

Line 114: function get_projection_dim(p_dim_set bsc_aw_adapter_kpi.dim_set_r) return varchar2;

110: p_limit_cube varchar2,
111: p_value varchar2,
112: p_composite_name varchar2
113: );
114: function get_projection_dim(p_dim_set bsc_aw_adapter_kpi.dim_set_r) return varchar2;
115: function is_aggregation_on_dim(p_dim bsc_aw_adapter_kpi.dim_r) return boolean ;
116: function is_aggregation_on_time(p_calendar bsc_aw_adapter_kpi.calendar_r) return boolean;
117: function get_dim_index(
118: p_dim bsc_aw_adapter_kpi.dim_tb,

Line 115: function is_aggregation_on_dim(p_dim bsc_aw_adapter_kpi.dim_r) return boolean ;

111: p_value varchar2,
112: p_composite_name varchar2
113: );
114: function get_projection_dim(p_dim_set bsc_aw_adapter_kpi.dim_set_r) return varchar2;
115: function is_aggregation_on_dim(p_dim bsc_aw_adapter_kpi.dim_r) return boolean ;
116: function is_aggregation_on_time(p_calendar bsc_aw_adapter_kpi.calendar_r) return boolean;
117: function get_dim_index(
118: p_dim bsc_aw_adapter_kpi.dim_tb,
119: p_dim_name varchar2

Line 116: function is_aggregation_on_time(p_calendar bsc_aw_adapter_kpi.calendar_r) return boolean;

112: p_composite_name varchar2
113: );
114: function get_projection_dim(p_dim_set bsc_aw_adapter_kpi.dim_set_r) return varchar2;
115: function is_aggregation_on_dim(p_dim bsc_aw_adapter_kpi.dim_r) return boolean ;
116: function is_aggregation_on_time(p_calendar bsc_aw_adapter_kpi.calendar_r) return boolean;
117: function get_dim_index(
118: p_dim bsc_aw_adapter_kpi.dim_tb,
119: p_dim_name varchar2
120: )return number;

Line 118: p_dim bsc_aw_adapter_kpi.dim_tb,

114: function get_projection_dim(p_dim_set bsc_aw_adapter_kpi.dim_set_r) return varchar2;
115: function is_aggregation_on_dim(p_dim bsc_aw_adapter_kpi.dim_r) return boolean ;
116: function is_aggregation_on_time(p_calendar bsc_aw_adapter_kpi.calendar_r) return boolean;
117: function get_dim_index(
118: p_dim bsc_aw_adapter_kpi.dim_tb,
119: p_dim_name varchar2
120: )return number;
121: function get_measure_index(
122: p_measure bsc_aw_adapter_kpi.measure_tb,

Line 122: p_measure bsc_aw_adapter_kpi.measure_tb,

118: p_dim bsc_aw_adapter_kpi.dim_tb,
119: p_dim_name varchar2
120: )return number;
121: function get_measure_index(
122: p_measure bsc_aw_adapter_kpi.measure_tb,
123: p_measure_name varchar2
124: )return number;
125: procedure limit_all_dim(p_dim_set bsc_aw_adapter_kpi.dim_set_r);
126: procedure load_calendar_if_needed(p_kpi varchar2) ;

Line 125: procedure limit_all_dim(p_dim_set bsc_aw_adapter_kpi.dim_set_r);

121: function get_measure_index(
122: p_measure bsc_aw_adapter_kpi.measure_tb,
123: p_measure_name varchar2
124: )return number;
125: procedure limit_all_dim(p_dim_set bsc_aw_adapter_kpi.dim_set_r);
126: procedure load_calendar_if_needed(p_kpi varchar2) ;
127: procedure limit_dim_levels(p_dim bsc_aw_adapter_kpi.dim_r);
128: procedure limit_dim_levels(p_dim bsc_aw_adapter_kpi.dim_r,p_level varchar2);
129: procedure limit_calendar_levels(

Line 127: procedure limit_dim_levels(p_dim bsc_aw_adapter_kpi.dim_r);

123: p_measure_name varchar2
124: )return number;
125: procedure limit_all_dim(p_dim_set bsc_aw_adapter_kpi.dim_set_r);
126: procedure load_calendar_if_needed(p_kpi varchar2) ;
127: procedure limit_dim_levels(p_dim bsc_aw_adapter_kpi.dim_r);
128: procedure limit_dim_levels(p_dim bsc_aw_adapter_kpi.dim_r,p_level varchar2);
129: procedure limit_calendar_levels(
130: p_calendar bsc_aw_adapter_kpi.calendar_r,
131: p_periodicity_dim varchar2);

Line 128: procedure limit_dim_levels(p_dim bsc_aw_adapter_kpi.dim_r,p_level varchar2);

124: )return number;
125: procedure limit_all_dim(p_dim_set bsc_aw_adapter_kpi.dim_set_r);
126: procedure load_calendar_if_needed(p_kpi varchar2) ;
127: procedure limit_dim_levels(p_dim bsc_aw_adapter_kpi.dim_r);
128: procedure limit_dim_levels(p_dim bsc_aw_adapter_kpi.dim_r,p_level varchar2);
129: procedure limit_calendar_levels(
130: p_calendar bsc_aw_adapter_kpi.calendar_r,
131: p_periodicity_dim varchar2);
132: procedure dmp_kpi_cubes_into_table(

Line 130: p_calendar bsc_aw_adapter_kpi.calendar_r,

126: procedure load_calendar_if_needed(p_kpi varchar2) ;
127: procedure limit_dim_levels(p_dim bsc_aw_adapter_kpi.dim_r);
128: procedure limit_dim_levels(p_dim bsc_aw_adapter_kpi.dim_r,p_level varchar2);
129: procedure limit_calendar_levels(
130: p_calendar bsc_aw_adapter_kpi.calendar_r,
131: p_periodicity_dim varchar2);
132: procedure dmp_kpi_cubes_into_table(
133: p_kpi varchar2,
134: p_dimset varchar2,

Line 169: p_dim_set bsc_aw_adapter_kpi.dim_set_r,

165: );
166: procedure aggregate_kpi_dimset_job(p_kpi varchar2,p_dim_set dbms_sql.varchar2_table);
167: function get_dim_set_index(p_aggregation aggregation_r,p_dim_set varchar2) return number;
168: procedure get_measure_objects_to_lock(
169: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
170: p_measures dbms_sql.varchar2_table,
171: p_lock_objects out nocopy dbms_sql.varchar2_table
172: );
173: procedure aggregate_measure_job(

Line 175: p_dim_set bsc_aw_adapter_kpi.dim_set_r,

171: p_lock_objects out nocopy dbms_sql.varchar2_table
172: );
173: procedure aggregate_measure_job(
174: p_kpi varchar2,
175: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
176: p_measures dbms_sql.varchar2_table,
177: p_options varchar2,
178: p_measure_agg_type varchar2 --normal, balance or formula
179: );

Line 188: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,

184: p_measure_agg_type varchar2, --normal, balance or formula
185: p_run_id number,p_job_name varchar2,p_options varchar2);
186: procedure copy_target_to_actual_job(
187: p_kpi varchar2,
188: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
189: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r,
190: p_actual_measures dbms_sql.varchar2_table
191: );
192: procedure copy_target_to_actual_job(

Line 189: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r,

185: p_run_id number,p_job_name varchar2,p_options varchar2);
186: procedure copy_target_to_actual_job(
187: p_kpi varchar2,
188: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
189: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r,
190: p_actual_measures dbms_sql.varchar2_table
191: );
192: procedure copy_target_to_actual_job(
193: p_kpi varchar2,

Line 200: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,

196: p_cubes varchar2,
197: p_aggregate_options varchar2,
198: p_run_id number,p_job_name varchar2,p_options varchar2) ;
199: procedure copy_target_to_actual(
200: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
201: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r,
202: p_actual_cubes dbms_sql.varchar2_table,
203: p_partition_value varchar2,
204: p_partition_dim_value varchar2

Line 201: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r,

197: p_aggregate_options varchar2,
198: p_run_id number,p_job_name varchar2,p_options varchar2) ;
199: procedure copy_target_to_actual(
200: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
201: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r,
202: p_actual_cubes dbms_sql.varchar2_table,
203: p_partition_value varchar2,
204: p_partition_dim_value varchar2
205: );

Line 256: procedure limit_dim_descendents(p_dim bsc_aw_adapter_kpi.dim_tb,p_operator varchar2,p_depth varchar2);

252: p_dimset varchar2,
253: p_measures dbms_sql.varchar2_table,
254: p_lock_objects out nocopy dbms_sql.varchar2_table
255: );
256: procedure limit_dim_descendents(p_dim bsc_aw_adapter_kpi.dim_tb,p_operator varchar2,p_depth varchar2);
257: procedure limit_calendar_descendents(p_calendar bsc_aw_adapter_kpi.calendar_r,p_operator varchar2,p_depth varchar2) ;
258: function can_launch_jobs(p_kpi varchar2,p_dimset bsc_aw_adapter_kpi.dim_set_r,p_measures dbms_sql.varchar2_table) return varchar2;
259: procedure get_cubes_for_measures(
260: p_measures dbms_sql.varchar2_table,

Line 257: procedure limit_calendar_descendents(p_calendar bsc_aw_adapter_kpi.calendar_r,p_operator varchar2,p_depth varchar2) ;

253: p_measures dbms_sql.varchar2_table,
254: p_lock_objects out nocopy dbms_sql.varchar2_table
255: );
256: procedure limit_dim_descendents(p_dim bsc_aw_adapter_kpi.dim_tb,p_operator varchar2,p_depth varchar2);
257: procedure limit_calendar_descendents(p_calendar bsc_aw_adapter_kpi.calendar_r,p_operator varchar2,p_depth varchar2) ;
258: function can_launch_jobs(p_kpi varchar2,p_dimset bsc_aw_adapter_kpi.dim_set_r,p_measures dbms_sql.varchar2_table) return varchar2;
259: procedure get_cubes_for_measures(
260: p_measures dbms_sql.varchar2_table,
261: p_dim_set bsc_aw_adapter_kpi.dim_set_r,

Line 258: function can_launch_jobs(p_kpi varchar2,p_dimset bsc_aw_adapter_kpi.dim_set_r,p_measures dbms_sql.varchar2_table) return varchar2;

254: p_lock_objects out nocopy dbms_sql.varchar2_table
255: );
256: procedure limit_dim_descendents(p_dim bsc_aw_adapter_kpi.dim_tb,p_operator varchar2,p_depth varchar2);
257: procedure limit_calendar_descendents(p_calendar bsc_aw_adapter_kpi.calendar_r,p_operator varchar2,p_depth varchar2) ;
258: function can_launch_jobs(p_kpi varchar2,p_dimset bsc_aw_adapter_kpi.dim_set_r,p_measures dbms_sql.varchar2_table) return varchar2;
259: procedure get_cubes_for_measures(
260: p_measures dbms_sql.varchar2_table,
261: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
262: p_cubes out nocopy dbms_sql.varchar2_table);

Line 261: p_dim_set bsc_aw_adapter_kpi.dim_set_r,

257: procedure limit_calendar_descendents(p_calendar bsc_aw_adapter_kpi.calendar_r,p_operator varchar2,p_depth varchar2) ;
258: function can_launch_jobs(p_kpi varchar2,p_dimset bsc_aw_adapter_kpi.dim_set_r,p_measures dbms_sql.varchar2_table) return varchar2;
259: procedure get_cubes_for_measures(
260: p_measures dbms_sql.varchar2_table,
261: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
262: p_cubes out nocopy dbms_sql.varchar2_table);
263: procedure copy_target_to_actual_serial(
264: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
265: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r,

Line 264: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,

260: p_measures dbms_sql.varchar2_table,
261: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
262: p_cubes out nocopy dbms_sql.varchar2_table);
263: procedure copy_target_to_actual_serial(
264: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
265: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r,
266: p_actual_measures dbms_sql.varchar2_table);
267: procedure dmp_dimset_dim_statlen(p_dim_set bsc_aw_adapter_kpi.dim_set_r);
268: procedure limit_dim(p_dim varchar2,p_value dbms_sql.varchar2_table,p_mode varchar2);

Line 265: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r,

261: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
262: p_cubes out nocopy dbms_sql.varchar2_table);
263: procedure copy_target_to_actual_serial(
264: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
265: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r,
266: p_actual_measures dbms_sql.varchar2_table);
267: procedure dmp_dimset_dim_statlen(p_dim_set bsc_aw_adapter_kpi.dim_set_r);
268: procedure limit_dim(p_dim varchar2,p_value dbms_sql.varchar2_table,p_mode varchar2);
269: procedure get_ds_BT_parameters(

Line 267: procedure dmp_dimset_dim_statlen(p_dim_set bsc_aw_adapter_kpi.dim_set_r);

263: procedure copy_target_to_actual_serial(
264: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
265: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r,
266: p_actual_measures dbms_sql.varchar2_table);
267: procedure dmp_dimset_dim_statlen(p_dim_set bsc_aw_adapter_kpi.dim_set_r);
268: procedure limit_dim(p_dim varchar2,p_value dbms_sql.varchar2_table,p_mode varchar2);
269: procedure get_ds_BT_parameters(
270: p_kpi varchar2,
271: p_dimset varchar2,

Line 278: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,

274: p_ds_parameters out nocopy dbms_sql.varchar2_table);
275: procedure get_dimset_objects(p_kpi varchar2,p_dim_set varchar2,p_oo out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb);
276: procedure load_dim_if_needed(p_kpi varchar2,p_dim_set dbms_sql.varchar2_table);
277: procedure limit_cal_target_level_only(
278: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
279: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r
280: );
281: procedure check_bt_current_period_change(
282: p_kpi varchar2,

Line 279: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r

275: procedure get_dimset_objects(p_kpi varchar2,p_dim_set varchar2,p_oo out nocopy bsc_aw_md_wrapper.bsc_olap_object_tb);
276: procedure load_dim_if_needed(p_kpi varchar2,p_dim_set dbms_sql.varchar2_table);
277: procedure limit_cal_target_level_only(
278: p_actual_dim_set bsc_aw_adapter_kpi.dim_set_r,
279: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r
280: );
281: procedure check_bt_current_period_change(
282: p_kpi varchar2,
283: p_dim_set bsc_aw_adapter_kpi.dim_set_r,

Line 283: p_dim_set bsc_aw_adapter_kpi.dim_set_r,

279: p_target_dim_set bsc_aw_adapter_kpi.dim_set_r
280: );
281: procedure check_bt_current_period_change(
282: p_kpi varchar2,
283: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
284: p_cubes dbms_sql.varchar2_table,
285: p_measures dbms_sql.varchar2_table,
286: p_base_tables dbms_sql.varchar2_table,
287: p_bt_current_period dbms_sql.varchar2_table,

Line 292: p_dim_set bsc_aw_adapter_kpi.dim_set_r,

288: p_options varchar2
289: );
290: procedure check_bt_current_period_change(
291: p_kpi varchar2,
292: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
293: p_cube varchar2,
294: p_measures bsc_aw_adapter_kpi.measure_tb,
295: p_bt_periodicity dbms_sql.number_table, /*p_bt_periodicity,p_start_period and p_end_period match in count*/
296: p_start_period dbms_sql.varchar2_table,

Line 294: p_measures bsc_aw_adapter_kpi.measure_tb,

290: procedure check_bt_current_period_change(
291: p_kpi varchar2,
292: p_dim_set bsc_aw_adapter_kpi.dim_set_r,
293: p_cube varchar2,
294: p_measures bsc_aw_adapter_kpi.measure_tb,
295: p_bt_periodicity dbms_sql.number_table, /*p_bt_periodicity,p_start_period and p_end_period match in count*/
296: p_start_period dbms_sql.varchar2_table,
297: p_end_period dbms_sql.varchar2_table,
298: p_options varchar2 /*contains partition info */

Line 300: function dimset_has_bal_measures(p_dim_set bsc_aw_adapter_kpi.dim_set_r) return boolean;

296: p_start_period dbms_sql.varchar2_table,
297: p_end_period dbms_sql.varchar2_table,
298: p_options varchar2 /*contains partition info */
299: );
300: function dimset_has_bal_measures(p_dim_set bsc_aw_adapter_kpi.dim_set_r) return boolean;
301: procedure dmp_dimset_composite_count(p_dim_set bsc_aw_adapter_kpi.dim_set_r);
302: function is_parallel_load(p_base_tables dbms_sql.varchar2_table,p_cutoff number) return boolean;
303: function is_parallel_load(p_base_tables dbms_sql.varchar2_table,p_change_vector dbms_sql.number_table,p_cutoff number) return boolean;
304: function get_table_load_count(p_table varchar2,p_change_vector number) return number;

Line 301: procedure dmp_dimset_composite_count(p_dim_set bsc_aw_adapter_kpi.dim_set_r);

297: p_end_period dbms_sql.varchar2_table,
298: p_options varchar2 /*contains partition info */
299: );
300: function dimset_has_bal_measures(p_dim_set bsc_aw_adapter_kpi.dim_set_r) return boolean;
301: procedure dmp_dimset_composite_count(p_dim_set bsc_aw_adapter_kpi.dim_set_r);
302: function is_parallel_load(p_base_tables dbms_sql.varchar2_table,p_cutoff number) return boolean;
303: function is_parallel_load(p_base_tables dbms_sql.varchar2_table,p_change_vector dbms_sql.number_table,p_cutoff number) return boolean;
304: function get_table_load_count(p_table varchar2,p_change_vector number) return number;
305: function is_parallel_aggregate(p_dim_set bsc_aw_adapter_kpi.dim_set_tb,p_cutoff number) return boolean ;

Line 305: function is_parallel_aggregate(p_dim_set bsc_aw_adapter_kpi.dim_set_tb,p_cutoff number) return boolean ;

301: procedure dmp_dimset_composite_count(p_dim_set bsc_aw_adapter_kpi.dim_set_r);
302: function is_parallel_load(p_base_tables dbms_sql.varchar2_table,p_cutoff number) return boolean;
303: function is_parallel_load(p_base_tables dbms_sql.varchar2_table,p_change_vector dbms_sql.number_table,p_cutoff number) return boolean;
304: function get_table_load_count(p_table varchar2,p_change_vector number) return number;
305: function is_parallel_aggregate(p_dim_set bsc_aw_adapter_kpi.dim_set_tb,p_cutoff number) return boolean ;
306: function is_parallel_aggregate(p_dim_set bsc_aw_adapter_kpi.dim_set_r,p_cutoff number) return boolean ;
307: function get_dimset_composite_count(p_dim_set bsc_aw_adapter_kpi.dim_set_r) return number;
308: procedure get_base_table_for_dimset(p_kpi varchar2,p_base_table_list dbms_sql.varchar2_table,p_dim_set dbms_sql.varchar2_table,
309: p_dimset_base_tables out nocopy dbms_sql.varchar2_table);

Line 306: function is_parallel_aggregate(p_dim_set bsc_aw_adapter_kpi.dim_set_r,p_cutoff number) return boolean ;

302: function is_parallel_load(p_base_tables dbms_sql.varchar2_table,p_cutoff number) return boolean;
303: function is_parallel_load(p_base_tables dbms_sql.varchar2_table,p_change_vector dbms_sql.number_table,p_cutoff number) return boolean;
304: function get_table_load_count(p_table varchar2,p_change_vector number) return number;
305: function is_parallel_aggregate(p_dim_set bsc_aw_adapter_kpi.dim_set_tb,p_cutoff number) return boolean ;
306: function is_parallel_aggregate(p_dim_set bsc_aw_adapter_kpi.dim_set_r,p_cutoff number) return boolean ;
307: function get_dimset_composite_count(p_dim_set bsc_aw_adapter_kpi.dim_set_r) return number;
308: procedure get_base_table_for_dimset(p_kpi varchar2,p_base_table_list dbms_sql.varchar2_table,p_dim_set dbms_sql.varchar2_table,
309: p_dimset_base_tables out nocopy dbms_sql.varchar2_table);
310: --procedures-------------------------------------------------------

Line 307: function get_dimset_composite_count(p_dim_set bsc_aw_adapter_kpi.dim_set_r) return number;

303: function is_parallel_load(p_base_tables dbms_sql.varchar2_table,p_change_vector dbms_sql.number_table,p_cutoff number) return boolean;
304: function get_table_load_count(p_table varchar2,p_change_vector number) return number;
305: function is_parallel_aggregate(p_dim_set bsc_aw_adapter_kpi.dim_set_tb,p_cutoff number) return boolean ;
306: function is_parallel_aggregate(p_dim_set bsc_aw_adapter_kpi.dim_set_r,p_cutoff number) return boolean ;
307: function get_dimset_composite_count(p_dim_set bsc_aw_adapter_kpi.dim_set_r) return number;
308: procedure get_base_table_for_dimset(p_kpi varchar2,p_base_table_list dbms_sql.varchar2_table,p_dim_set dbms_sql.varchar2_table,
309: p_dimset_base_tables out nocopy dbms_sql.varchar2_table);
310: --procedures-------------------------------------------------------
311: procedure init_all;