APPS.FND_CONC_QUEUES_PKG SQL Statements

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

Line: 23

  select 1
    into dummy
    from fnd_concurrent_queues fcq,
         fnd_concurrent_processes fcp
   where ((fcq.application_id = appid and
	   fcq.concurrent_queue_id = qid and
	   fcq.max_processes > 0)
	  or
	  (fcp.queue_application_id = appid and
	   fcp.concurrent_queue_id  = qid and
	   fcp.process_status_code in ('A', 'R', 'T')))
     and rownum = 1;

Line: 42

      fnd_message.set_name ('FND', 'CONC-Cannot update ICM defn');

Line: 45

      fnd_message.set_name ('FND', 'CONC-Cannot delete CRM');

Line: 48

      fnd_message.set_name ('FND', 'CONC-Delete Manager');

Line: 66

    select 1
      into dummy
      from sys.dual
     where not exists (select 1
	  	       from fnd_concurrent_queues_vl
		        where application_id = appid
		          and concurrent_queue_name = qname
		          and (row_id <> chartorowid (ro_id)
			       or ro_id is null));

Line: 88

    select 1
      into dummy
      from sys.dual
     where not exists (select 1
	  	       from fnd_concurrent_queues_vl
		        where application_id = appid
		          and user_concurrent_queue_name = uqname
		          and (row_id <> chartorowid (ro_id)
			       or ro_id is null));

Line: 119

  select 1
    into dummy
    from sys.dual
   where not exists (select 1
		       from fnd_concurrent_queue_size
		      where queue_application_id = appid
			and concurrent_queue_id = qid
			and period_application_id = pappid
			and concurrent_time_period_id = tpid
			and (rowid <> chartorowid (ro_id)
			     or ro_id is null));

Line: 156

  select include_flag
    into conflict_checker
    from fnd_concurrent_queue_content
   where queue_application_id = qappid
     and concurrent_queue_id = qid
     and type_code = tcode
     and (type_application_id = tappid
          or (type_application_id is null
              and tappid is null))
     and (type_id = tid
          or (type_id is null
	      and tid is null))
     and (rowid <> chartorowid (ro_id)
          or ro_id is null);