APPS.BSC_METADATA dependencies on BSC_DBGEN_UTILS

Line 362: p_agg_formula(i):=bsc_dbgen_utils.get_property_value(l_measures(i).properties,BSC_DBGEN_STD_METADATA.SOURCE_FORMULA);

358: end if;
359: p_data_type(i):=l_measures(i).datatype;
360: --aggregation_method will contain SUM AVG M1/M2
361: --talked to arun. the formula will be in SOURCE_FORMULA. so if formula is not found then then look for agg method
362: p_agg_formula(i):=bsc_dbgen_utils.get_property_value(l_measures(i).properties,BSC_DBGEN_STD_METADATA.SOURCE_FORMULA);
363: if p_agg_formula(i)=BSC_DBGEN_STD_METADATA.BSC_PROPERTY_NOT_FOUND then
364: p_agg_formula(i):=l_measures(i).aggregation_method;
365: end if;
366: if p_agg_formula(i)='AVG' then

Line 369: l_projection:=bsc_dbgen_utils.get_property_value(l_measures(i).properties,BSC_DBGEN_STD_METADATA.PROJECTION_ID);

365: end if;
366: if p_agg_formula(i)='AVG' then
367: p_agg_formula(i):='AVERAGE';
368: end if;
369: l_projection:=bsc_dbgen_utils.get_property_value(l_measures(i).properties,BSC_DBGEN_STD_METADATA.PROJECTION_ID);
370: if l_projection='0' then
371: p_forecast(i):='N';
372: else
373: p_forecast(i):='Y';

Line 414: if bsc_dbgen_utils.get_property_value(l_dimension(i).Hierarchies(j).Levels(k).properties,BSC_DBGEN_STD_METADATA.TARGET_LEVEL)='1' then

410: l_dimension:=bsc_dbgen_metadata_reader.get_dimensions_for_fact(p_kpi,to_number(p_dim_set),false);
411: for i in 1..l_dimension.count loop
412: for j in 1..l_dimension(i).Hierarchies.count loop
413: for k in reverse 1..l_dimension(i).Hierarchies(j).Levels.count loop
414: if bsc_dbgen_utils.get_property_value(l_dimension(i).Hierarchies(j).Levels(k).properties,BSC_DBGEN_STD_METADATA.TARGET_LEVEL)='1' then
415: if bsc_aw_utility.in_array(p_dim_level,l_dimension(i).Hierarchies(j).Levels(k).level_name)=false then
416: p_dim_level(p_dim_level.count+1):=l_dimension(i).Hierarchies(j).Levels(k).level_name;
417: end if;
418: end if;

Line 443: if bsc_dbgen_utils.get_property_value(l_periodicity(i).properties,BSC_DBGEN_STD_METADATA.TARGET_LEVEL)='1' then

439: Begin
440: l_periodicity:=bsc_dbgen_metadata_reader.Get_Periodicities_For_Fact(p_kpi);
441: for i in 1..l_periodicity.count loop
442: --MO will give back all levels with targets. we need to scan and eliminate all periodicities that are not lowest
443: if bsc_dbgen_utils.get_property_value(l_periodicity(i).properties,BSC_DBGEN_STD_METADATA.TARGET_LEVEL)='1' then
444: --if l_periodicity(i).Parent_periods.count=0 then --this is the lowest level
445: --make sure this is the lowest
446: l_flag:=false;
447: --say year and qtr show up. for year, qtr is a src. so qtr will show up as a parent period of year

Line 449: if bsc_dbgen_utils.get_property_value(l_periodicity(j).properties,BSC_DBGEN_STD_METADATA.TARGET_LEVEL)='1' then

445: --make sure this is the lowest
446: l_flag:=false;
447: --say year and qtr show up. for year, qtr is a src. so qtr will show up as a parent period of year
448: for j in 1..l_periodicity.count loop
449: if bsc_dbgen_utils.get_property_value(l_periodicity(j).properties,BSC_DBGEN_STD_METADATA.TARGET_LEVEL)='1' then
450: if bsc_aw_utility.in_array(l_periodicity(i).Parent_periods,to_char(l_periodicity(j).Periodicity_id)) then
451: l_flag:=true;
452: exit;
453: end if;

Line 606: p_bt_formula(i):=bsc_dbgen_utils.get_property_value(l_measures(i).properties,BSC_DBGEN_STD_METADATA.SOURCE_FORMULA);

602: Begin
603: l_measures:=bsc_dbgen_metadata_reader.get_b_table_measures_for_fact(p_kpi,p_dim_set,p_base_table,true);
604: for i in 1..l_measures.count loop
605: p_measures(i):=l_measures(i).Measure_Name;
606: p_bt_formula(i):=bsc_dbgen_utils.get_property_value(l_measures(i).properties,BSC_DBGEN_STD_METADATA.SOURCE_FORMULA);
607: end loop;
608: Exception when others then
609: log_n('Exception in get_base_table_measures '||sqlerrm);
610: raise;