[Home] [Help]
2908: --logic taken from BSC_UPDATE_CALC.apply_filters(x_table_name); 115.21 2003/03/25
2909: begin
2910: SELECT indicator, dim_set_id into l_indicator_id,l_dim_set_id
2911: FROM bsc_kpi_data_tables_v WHERE (table_name = p_table OR
2912: table_name = (SELECT DISTINCT table_name FROM bsc_db_calculations WHERE
2913: parameter1 = p_table AND calculation_type = 5)) and rownum=1;
2914: exception when NO_DATA_FOUND then
2915: l_indicator_id:=null;
2916: l_dim_set_id:=null;
3924: l_agg_func BSC_IM_UTILS.varchar_tabletype;
3925: ----------------------------------------------------------
3926: cursor c1 (p_table varchar2)
3927: is select table_name,calculation_type,parameter1,'''0''',upper(parameter3),parameter4,parameter5
3928: from bsc_db_calculations where table_name=p_table
3929: order by upper(parameter3),parameter1;
3930:
3931: cursor c2 (p_table varchar2,p_type number)
3932: is select table_name,calculation_type,parameter1,'''0''',upper(parameter3),parameter4,parameter5
3929: order by upper(parameter3),parameter1;
3930:
3931: cursor c2 (p_table varchar2,p_type number)
3932: is select table_name,calculation_type,parameter1,'''0''',upper(parameter3),parameter4,parameter5
3933: from bsc_db_calculations where table_name=p_table
3934: and calculation_type=p_type
3935: order by upper(parameter3),parameter1;
3936:
3937: -- bug 3866554, dont assume that the datatype in the above sql is always VARCHAR2
3961: Begin
3962: if g_debug then
3963: write_to_log_file_n('IN get_db_calculation'||' '||get_time);
3964: l_stmt:='select table_name,calculation_type,parameter1,0,upper(parameter3),parameter4,parameter5 '||
3965: 'from bsc_db_calculations where table_name=:1 ';
3966: if p_type is not null then
3967: l_stmt:=l_stmt||' and calculation_type='||p_type;
3968: end if;
3969: l_stmt:=l_stmt||' order by upper(parameter3),parameter1';