APPS.FNDCP_CRM SQL Statements

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

Line: 15

  select nvl(max (running_processes), 0)
    into up
    from fnd_concurrent_worker_requests
   where not (queue_application_id = 0
              and concurrent_queue_id in (1,4))
     and request_id = reqid;

Line: 160

	insert_error exception;

Line: 286

	begin -- select block
	  select cd_id
	    into cdid
	    from fnd_conflicts_domain
	   where cd_name = cdname;

Line: 294

	      begin -- insert block
		select fnd_conflicts_domain_s.nextval
		  into cdid
		  from sys.dual;

Line: 299

		insert
		  into fnd_conflicts_domain (
		       cd_id,
		       cd_name,
		       user_cd_name,
		       runalone_flag,
		       last_update_date,
		       last_updated_by,
		       creation_date,
		       created_by,
		       last_update_login,
                       dynamic)
		values (
		       cdid,
		       cdname,
		       cdname,
		       'N',
		       sysdate,
		       user_id,
		       sysdate,
		       user_id,
		       login_id,
		       'Y');

Line: 324

		  raise insert_error;

Line: 333

		  when insert_error then
		    fnd_message.set_name ('FND', 'SQL-Generic error');

Line: 338

			'SUBMIT: conflicts_domain_insert_error', FALSE);

Line: 342

		    select cd_id
	            into cdid
	            from fnd_conflicts_domain
		    where cd_name = cdname;

Line: 350

	      end; -- insert block

Line: 354

	end; -- select block

Line: 377

    delete from fnd_conflicts_domain fcd
    where dynamic = 'Y'
    and not exists (select 'X'
                    from fnd_concurrent_requests fcr
		    where fcr.cd_id = fcd.cd_id
		    and phase_code in ('P', 'R'));