224:
225:
226: --new implementation
227: -- get rid of 9i dependency
228: --FUNCTION getKpis(p_page_name IN VARCHAR2) RETURN t_bis_setup_kpi_tab
229: PROCEDURE getkpis(p_page_name IN VARCHAR2)
230: IS
231: CURSOR c_kpis(p_c_page_name VARCHAR2) IS
232: SELECT DISTINCT indicator_id, indicator_name
234: FROM BIS_SETUP_KPI_PAGE
235: WHERE Upper(page_name) LIKE Upper(p_c_page_name);
236:
237: v_kpi t_bis_setup_kpi_obj := t_bis_setup_kpi_obj(-1, '');
238: v_ret_kpis t_bis_setup_kpi_tab := t_bis_setup_kpi_tab();
239: v_index INTEGER;
240:
241: BEGIN
242: