DBA Data[Home] [Help]

APPS.BIS_GRAPH_REGION_UI SQL Statements

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

Line: 231

	UPDATE
	  bis_user_trend_plugs
	  SET FUNCTION_ID = icx_call.decrypt2(p_function_id,l_session_id)
	  ,   RESPONSIBILITY_ID  = p_responsibility_id
	  ,   CHART_USER_TITLE = p_chart_user_title
--	  ,   PARAMETER_STRING = replace(p_parameter_string,'=','~')||'*]'
	  ,   PARAMETER_STRING = p_parameter_string
      ,   CACHED_GRAPH     = l_img_html
	  ,   LAST_UPDATE_DATE = sysdate
	  ,   LAST_UPDATED_BY  =  l_user_id
	  ,   last_update_login = fnd_global.login_id
	  WHERE user_id = l_user_id
	  and   plug_id = l_plug_id ;
Line: 246

	   insert into BIS_USER_TREND_PLUGS
	     (  plug_id
		, user_id
		, function_id
		, responsibility_id
		, chart_user_title
		, parameter_string
		, graph_sequence
		, cached_graph
		, creation_date
		, created_by
		, last_update_date
		, last_updated_by
		, last_update_login
		)
	     values (l_plug_id
		     , l_user_id
		     , icx_call.decrypt2(p_function_id,l_session_id)
		     , p_responsibility_id
		     , p_chart_user_title
--		     , replace(p_parameter_string,'=','~')||'*]'
		     , p_parameter_string
		     , 1
             , l_img_html
		     , sysdate
		     , l_user_id
		     , sysdate
		     , l_user_id
		     , fnd_global.login_id
		     );