[Home] [Help]
328: end if;
329: end if;
330: end loop;
331: bsc_aw_utility.trim_g_commands(g_commands,4,' --');
332: bsc_aw_utility.add_g_commands(g_commands,'from bsc_db_calendar where calendar_id='||p_calendar.calendar_id||' order by calendar_year,calendar_month,calendar_day');
333: bsc_aw_utility.add_g_commands(g_commands,'sql open c1');
334: bsc_aw_utility.add_g_commands(g_commands,'sql fetch c1 loop into --');
335: for i in 1..p_calendar.periodicity.count loop
336: bsc_aw_utility.add_g_commands(g_commands,':append '||p_calendar.periodicity(i).dim_name||' --');
431: for i in 1..p_calendar.periodicity.count loop
432: bsc_aw_utility.add_g_commands(g_commands,p_calendar.periodicity(i).db_column_name||'||\''.\''||year, --');
433: end loop;
434: bsc_aw_utility.trim_g_commands(g_commands,4,' --');
435: bsc_aw_utility.add_g_commands(g_commands,'from (select * from bsc_db_calendar where calendar_id='||p_calendar.calendar_id||
436: ' order by calendar_year desc,calendar_month desc,calendar_day desc) where rownum=1');
437: bsc_aw_utility.add_g_commands(g_commands,'sql open c1');
438: bsc_aw_utility.add_g_commands(g_commands,'sql fetch c1 loop into --');
439: for i in 1..p_calendar.periodicity.count loop
793: --in bsc_aw_load_kpi, we have a call to this procedure from load_calendar_if_needed
794: procedure load_calendar(p_calendar number) is
795: --
796: --4604538 we select min and max of calendar year
797: cursor c1 is select min(calendar_year)-1,max(calendar_year)+1 from bsc_db_calendar where calendar_id=p_calendar;
798: l_min number;
799: l_max number;
800: --
801: l_pgm varchar2(300);