[Home] [Help]
726:
727: /*
728: this procedure gives the period in which there is a mix of forecast and real data
729: we need the following
730: kpi and periodicity : we use this to hit bsc_db_tables that will indicate the current period
731: Req sig
732: procedure get_kpi_current_period(
733: p_kpi varchar2,
734: p_periodicity number,
949:
950:
951: function get_table_properties(p_table_name in VARCHAR2, p_property_list in dbms_sql.VARCHAR2_table) return dbms_sql.VARCHAR2_table IS
952: cursor cProperty is
953: select properties from bsc_db_tables
954: where table_name = p_table_name;
955: l_db_property varchar2(4000);
956: l_index number;
957: