APPS.BIS_SETUP_KPI_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 59

      SELECT distinct kpi_funcs.function_id, kpi_funcs.parameters,
	pages.page_name, pages.page_internal_name
	FROM
	(SELECT page_funcs.user_function_name page_name,
	 prop.object_name page_internal_name, menus.menu_id page_menu_id
	 FROM bis_obj_properties prop, fnd_form_functions_vl page_funcs, fnd_menus menus
	 WHERE prop.object_type = 'PAGE'
	 --AND prop.object_name like '%_OA'
	 AND page_funcs.type = 'JSP'
	 AND UPPER(page_funcs.web_html_call) like 'OA.JSP?AKREGIONCODE=BIS_COMPONENT_PAGE'||'&'||'AKREGIONAPPLICATIONID=191%'
	 AND UPPER(page_funcs.parameters) LIKE '%PAGENAME%'
	 --AND page_funcs.FUNCTION_NAME = SUBSTR(prop.object_name, 1, LENGTH(prop.object_name)-3)
	 AND page_funcs.function_name = bis_impl_dev_pkg.get_function_by_page(prop.object_name)
	 AND menus.menu_name = getValue('pageName', page_funcs.parameters)
	 ) pages,
	fnd_form_functions kpi_portlet_funcs,
	fnd_menus kpi_portlet_menus,
	fnd_form_functions kpi_funcs
	WHERE kpi_portlet_funcs.type in ('WEBPORTLET','WEBPORTLETX')
	AND (UPPER(kpi_portlet_funcs.parameters) LIKE '%PMEASUREDEFINITION%'
	     OR UPPER(kpi_portlet_funcs.parameters) LIKE '%PXMLDEFINITION%')
	AND UPPER(kpi_portlet_funcs.web_html_call) LIKE 'OA.JSP?AKREGIONCODE=BIS_PMF_PORTLET_TABLE_LAYOUT'||'&'||'AKREGIONAPPLICATIONID=191%'
	AND kpi_portlet_funcs.function_id IN (SELECT entries.function_id
					      FROM fnd_menu_entries entries
					      START WITH entries.menu_id = pages.page_menu_id
					      CONNECT BY PRIOR entries.sub_menu_id = entries.menu_id)
	AND kpi_portlet_menus.menu_name = Nvl(getValue('pMeasureDefinition', kpi_portlet_funcs.parameters), getValue('pXMLDefinition', kpi_portlet_funcs.parameters))
	AND kpi_funcs.type <> 'DBPORTLET'
	AND kpi_funcs.type <> 'WEBPORTLET'
	and kpi_funcs.type<>'WEBPORTLETX'
	AND UPPER(kpi_funcs.parameters) LIKE '%PTARGETLEVELSHORTNAME%'
	AND kpi_funcs.function_id IN (SELECT entries1.function_id
				      FROM fnd_menu_entries entries1
				      START WITH entries1.menu_id = kpi_portlet_menus.menu_id
				      CONNECT BY PRIOR entries1.sub_menu_id = entries1.menu_id);

Line: 96

        SELECT tl.indicator_id, indicators.name indicator_name
	  FROM bis_target_levels tl, bis_indicators_vl indicators
	  WHERE tl.short_name = getValue('pTargetLevelShortName', p_func_param)
	  AND nvl(Upper(getValue('pHide', p_func_param)), 'NO') <> 'YES'
	  AND tl.indicator_id = indicators.indicator_id;

Line: 112

      execute immediate 'delete from BIS_SETUP_KPI_PAGE';

Line: 114

	-- g_kpis_pages.DELETE;

Line: 136

	 execute immediate 'insert into BIS_SETUP_KPI_PAGE values (:1, :2, :3, :4)'
	   using v_page.page_name, v_page.page_internal_name,
	   v_kpi.indicator_id, v_kpi.indicator_name;

Line: 140

	 --execute immediate 'insert into ywu_debug_bis_setup_kpi_page (:1, :2, :3, :4)'
	 --  using v_page.page_name, v_page.page_internal_name,
	 --  v_kpi.indicator_id, v_kpi.indicator_name;

Line: 167

	SELECT distinct b.IMPLEMENTATION_FLAG, a.page_name
	--FROM TABLE(cast(getKpisAndPages AS t_bis_kpi_page_tab)) a,
	  FROM bis_setup_kpi_page a,
	  bis_obj_properties b
	WHERE a.indicator_id = p_c_kpi_id
	  AND a.page_internal_name = b.object_name
	  AND b.object_type = 'PAGE';

Line: 232

        SELECT DISTINCT indicator_id, indicator_name
	  --FROM TABLE(cast(getKpisAndPages AS t_bis_kpi_page_tab))
	  FROM BIS_SETUP_KPI_PAGE
	  WHERE Upper(page_name) LIKE Upper(p_c_page_name);

Line: 243

   execute immediate 'delete from BIS_SETUP_KPI';

Line: 266

	 execute immediate 'insert into BIS_SETUP_KPI values (:1, :2)'
	   using v_kpi.kpi_id, v_kpi.kpi_name;

Line: 269

	 --execute immediate 'insert into ywu_debug_bis_setup_kpi values (:1, :2)'
	 --  using v_kpi.kpi_id, v_kpi.kpi_name;