DBA Data[Home] [Help]

APPS.BIS_SETUP_KPI_PKG dependencies on T_BIS_SETUP_KPI_TAB

Line 228: --FUNCTION getKpis(p_page_name IN VARCHAR2) RETURN t_bis_setup_kpi_tab

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

Line 238: v_ret_kpis t_bis_setup_kpi_tab := t_bis_setup_kpi_tab();

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: