APPS.BSC_AW_ADAPTER_KPI dependencies on BSC_AW_UTILITY

Line 137: property bsc_aw_utility.property_tb /*if this is BALANCE LAST VALUE, this can contain balance loaded Y/N column name */

133: cube varchar2(300),
134: countvar_cube varchar2(300),
135: fcst_cube varchar2(300), -- if the measure has forecast
136: display_cube varchar2(300),/*compressed composite and partitions */
137: property bsc_aw_utility.property_tb /*if this is BALANCE LAST VALUE, this can contain balance loaded Y/N column name */
138: );
139: type measure_tb is table of measure_r index by pls_integer;
140: --
141: /*

Line 294: table_partition bsc_aw_utility.object_partition_r,

290: level_status dbms_sql.varchar2_table,--skip or correct or lower etc
291: periodicity periodicity_r, --the periodicity at which the base table is
292: projection_table varchar2(100),
293: current_period varchar2(40),--in period.year format. this field can be null
294: table_partition bsc_aw_utility.object_partition_r,
295: base_table_sql dbms_sql.varchar2_table
296: );
297: type base_table_tb is table of base_table_r index by pls_integer;
298: --

Line 329: property bsc_aw_utility.property_tb --any misc properties

325: data_source_stmt_type dbms_sql.varchar2_table, --dimension= or measure= or limit cube= or 'partition dim'
326: data_source_stmt dbms_sql.varchar2_table, --(select k1,k2,m1,m2 from B)
327: base_tables base_table_tb,
328: data_source_PT data_source_PT_r,
329: property bsc_aw_utility.property_tb --any misc properties
330: );
331: type data_source_tb is table of data_source_r index by pls_integer;
332: --
333: --in s views we need to know what the levels are for each s view. in dim set we are not

Line 409: property bsc_aw_utility.property_tb

405: cube_design varchar2(40), --datacube or single composite or multiple composite
406: number_partitions number, --if 0, no partitions
407: compressed varchar2(10), --Y or N
408: pre_calculated varchar2(10), --higher level aggregates from B tables
409: property bsc_aw_utility.property_tb
410: );
411: type dim_set_tb is table of dim_set_r index by pls_integer;
412: --
413: type kpi_r is record(

Line 641: procedure dmp_table_partition(p_partition bsc_aw_utility.object_partition_r);

637: function get_dim_given_dim_name(p_dim varchar2,p_dim_t dim_tb) return dim_r;
638: function is_dimset_precalculated(p_dim_set dim_set_r) return boolean;
639: procedure set_dim_set_properties(p_dim_set in out nocopy dim_set_r);
640: procedure set_dim_set_properties(p_kpi in out nocopy kpi_r);
641: procedure dmp_table_partition(p_partition bsc_aw_utility.object_partition_r);
642: procedure dmp_partition_set(p_partition_set bsc_aw_utility.partition_set_r);
643: procedure set_dim_set_data_source(p_kpi kpi_r,p_dim_set in out nocopy dim_set_r);
644: procedure get_relevant_cal_hier(p_periodicity periodicity_tb,p_pc cal_parent_child_tb,p_relevant_pc out nocopy cal_parent_child_tb);
645: procedure get_upper_cal_hier(p_pc cal_parent_child_tb,p_child varchar2,p_upper_hier out nocopy cal_parent_child_tb);

Line 642: procedure dmp_partition_set(p_partition_set bsc_aw_utility.partition_set_r);

638: function is_dimset_precalculated(p_dim_set dim_set_r) return boolean;
639: procedure set_dim_set_properties(p_dim_set in out nocopy dim_set_r);
640: procedure set_dim_set_properties(p_kpi in out nocopy kpi_r);
641: procedure dmp_table_partition(p_partition bsc_aw_utility.object_partition_r);
642: procedure dmp_partition_set(p_partition_set bsc_aw_utility.partition_set_r);
643: procedure set_dim_set_data_source(p_kpi kpi_r,p_dim_set in out nocopy dim_set_r);
644: procedure get_relevant_cal_hier(p_periodicity periodicity_tb,p_pc cal_parent_child_tb,p_relevant_pc out nocopy cal_parent_child_tb);
645: procedure get_upper_cal_hier(p_pc cal_parent_child_tb,p_child varchar2,p_upper_hier out nocopy cal_parent_child_tb);
646: procedure create_balance_aggregation(p_dim_set dim_set_r, p_data_source data_source_r,p_measures measure_tb);