APPS.ICX_SETUP SQL Statements

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

Line: 51

  select query_set,
	 home_url,
	 webmaster_email,
         max_rows
  into v_query_set,
       v_home_url,
       v_webmaster_email,
       v_max_rows
  from icx_parameters;

Line: 111

  htp.p('function update_param(set_req, email_req) {
           if (checkNumber(document.define_param.QuerySet) &&
	       (checkNonZero(document.define_param.QuerySet)) &&
	       (!null_alert(document.define_param.QuerySet.value, set_req)) &&
	       (!null_alert(document.define_param.WebEmail.value, email_req)))
             document.define_param.submit();

Line: 134

  htp.formOpen('icx_setup.update_parameters', 'POST', '','', 'NAME="define_param" ');

Line: 162

  l_save_url := 'javascript:update_param('''||icx_util.replace_onMouseOver_quotes(v_set_req)||''','''||icx_util.replace_onMouseOver_quotes(v_email_req)||''')';

Line: 186

PROCEDURE update_parameters(QuerySet in number,
			    HomeUrl  in varchar2,
			    WebEmail in varchar2,
                            MaxRows  in number,
			    WebUser  in number) is

begin

if (icx_sec.validateSession('ICX_SETUP')) then

  update icx_parameters
  set query_set = QuerySet,
      home_url = HomeUrl,
      webmaster_email = WebEmail,
      max_rows = MaxRows,
      last_updated_by = WebUser,
      last_update_date = sysdate
  ;

Line: 210

end update_parameters;