APPS.BSC_PORTLET_UTIL SQL Statements

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

Line: 321

PROCEDURE update_portlet_name(
    p_user_id IN NUMBER,
    p_plug_id      IN pls_integer,
    p_display_name IN VARCHAR2
 ) IS

BEGIN

    UPDATE
	icx_page_plugs
    SET
        DISPLAY_NAME = p_display_name,
        LAST_UPDATE_DATE = SYSDATE,
	LAST_UPDATED_BY = p_user_id

    WHERE
	PLUG_ID = p_plug_id;

Line: 341

END update_portlet_name;

Line: 543

  SELECT count(*) INTO l_count
  FROM v$instance VI
  WHERE VI.instance_role = 'PRIMARY_INSTANCE'
  AND trim(VI.version) like '8.%';