DBA Data[Home] [Help]

APPS.BSC_AW_BSC_METADATA dependencies on BSC_AW_CALENDAR

Line 286: procedure get_kpi_for_calendar(p_calendar in out nocopy bsc_aw_calendar.calendar_r) is

282: log_n('Exception in set_dim_recursive '||sqlerrm);
283: raise;
284: End;
285:
286: procedure get_kpi_for_calendar(p_calendar in out nocopy bsc_aw_calendar.calendar_r) is
287: l_kpi_list dbms_sql.varchar2_table;
288: Begin
289: bsc_metadata.get_kpi_for_calendar(p_calendar.calendar_id,l_kpi_list);
290: for i in 1..l_kpi_list.count loop

Line 829: --bsc_aw_calendar.get_calendar_current_year(p_calendar,l_year);

825: --
826: l_year number;
827: l_period number;
828: Begin
829: --bsc_aw_calendar.get_calendar_current_year(p_calendar,l_year);
830: --we do not want to call bsc_aw_calendar.get_calendar_current_year. what if in the future, each kpi has its own
831: --current year?
832: bsc_metadata.get_kpi_current_period(p_kpi,p_periodicity,l_period,l_year);
833: p_period:=l_period||'.'||l_year;

Line 830: --we do not want to call bsc_aw_calendar.get_calendar_current_year. what if in the future, each kpi has its own

826: l_year number;
827: l_period number;
828: Begin
829: --bsc_aw_calendar.get_calendar_current_year(p_calendar,l_year);
830: --we do not want to call bsc_aw_calendar.get_calendar_current_year. what if in the future, each kpi has its own
831: --current year?
832: bsc_metadata.get_kpi_current_period(p_kpi,p_periodicity,l_period,l_year);
833: p_period:=l_period||'.'||l_year;
834: Exception when others then