APPS.FND_CONC_PRIVATE_UTILS SQL Statements

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

Line: 63

   SELECT fcr.outfile_name, fcr.outfile_node_name, fmt.mime_type
     INTO fname, node, mtype
     FROM fnd_concurrent_requests fcr, fnd_mime_types_vl fmt
     WHERE fcr.request_id = req_id
     AND   fcr.output_file_type = fmt.file_format_code
     AND   rownum = 1;

Line: 127

  select count(*) into dummy
  from fnd_concurrent_requests
  where request_id = req_id;

Line: 136

  select Resubmit_Time, Resubmit_Interval_Type_Code, Requested_Start_Date,
         Resubmit_Interval_Unit_Code, Resubmit_Interval, sysdate,
	 RELEASE_CLASS_ID, RELEASE_CLASS_APP_ID, Resubmit_End_Date
  into resub_time, type_code, req_sdate,
	unit_code, interval, sysd,
	class_id, class_app_id,resub_end
  from fnd_concurrent_requests
  where request_id = req_id;

Line: 151

    select C.class_type, C.class_info
    into class_type, class_info
    from fnd_conc_release_classes C
    where RELEASE_CLASS_ID = class_id
    and APPLICATION_ID = class_app_id;

Line: 167

    select to_char(nvl(min(p.PERIOD_START_TIME),sysdate+1),
	'DD-MON-YYYY HH24:MI:SS')
      into my_resub
      from fnd_conc_rel_conj_members cm,
      fnd_conc_rel_disj_members dm,
      fnd_conc_release_periods p
      where cm.DISJUNCTION_ID = dm.DISJUNCTION_ID
      and cm.DISJUNCTION_APPLICATION_ID = dm.DISJUNCTION_APPLICATION_ID
      and cm.release_class_id=class_id
      and cm.class_APPLICATION_ID=class_app_id
      and dm.PERIOD_OR_STATE_FLAG = 'P'
      and dm.PERIOD_APPLICATION_ID = p.APPLICATION_ID
      and dm.PERIOD_ID = p.concurrent_PERIOD_ID
      and  P.PERIOD_START_TIME>sysdate;

Line: 199

    select TO_CHAR(DECODE(resub_time,
                   NULL, DECODE (type_code, 'START', req_sdate, sysd)
			  + DECODE(unit_code,
		/*		'MINUTES', GREATEST(interval, 1)/1440, */
				'MINUTES', interval/1440,
				'HOURS', interval/24,
                                'DAYS', interval,
 				'MONTHS', ADD_MONTHS(
				   DECODE(type_code, 'START', req_sdate, sysd),
					interval) -
			           DECODE(type_code, 'START', req_sdate, sysd)),
                  /*TIME*/ TO_DATE (TO_CHAR (sysd, 'DD-MON-YYYY')
                      || ' ' || resub_time, 'DD-MON-YYYY HH24:MI:SS')
                     + Decode(
                  Sign(To_Date(To_Char(sysd, 'HH24:MI:SS'), 'HH24:MI:SS')
                       - To_Date(resub_time, 'HH24:MI:SS')
                      ), 1, 1, 0)), 'DD-MON-YYYY HH24:MI:SS')
       into my_resub
       from dual;

Line: 241

    select TO_CHAR(TO_DATE(my_resub,
                                  'DD-MON-YYYY HH24:MI:SS') +
   /*  		DECODE(unit_code, 'MINUTES', GREATEST(interval, 1)/1440, */
  		DECODE(unit_code, 'MINUTES', interval/1440,
                                  'HOURS', interval/24,
                                  'DAYS', interval,
                                  'MONTHS', ADD_MONTHS(
                                                To_Date(my_resub,
                                                               'DD-MON-YYYY HH24:MI:SS'),
                                                interval)
                                           -  To_Date(my_resub,
                                                             'DD-MON-YYYY HH24:MI:SS'))
		,'DD-MON-YYYY HH24:MI:SS')
      into my_resub
      from dual;

Line: 281

	   select u.user_name, r.description,
		   p.user_concurrent_program_name, u.email_address
	    into   user, pdesc, pname, e_addr
	    from   fnd_concurrent_requests r, fnd_concurrent_programs_vl p,
		   fnd_user u
	    where  r.program_application_id = p.application_id
	    and    r.concurrent_program_id = p.concurrent_program_id
	    and    r.request_id = req_id
	    and    u.user_id = r.requested_by;

Line: 347

	    select notification_id
	    from wf_notifications
	    where group_id = nid;

Line: 361

    select decode(ofile_size,NULL,0,ofile_size), save_output_flag
      into ofilesize, saveoutputflag
    from fnd_concurrent_requests
    where request_id = req_id;

Line: 459

	insert into fnd_temp_files
	   (FILENAME, TYPE, REQUEST_ID, SESSION_ID, NODE)
	values (filename, type, req_id, sess_id, node);

Line: 485

	     select LOGFILE_NODE_NAME
	     into mynode
             from fnd_concurrent_requests
	     where request_id = req_id;

Line: 496

        select userenv('SESSIONID') into ses_id from dual;

Line: 569

    select nvl(RESOURCE_CONSUMER_GROUP, 'DEFAULT_CONSUMER_GROUP')
    into que_rcg
    from fnd_concurrent_queues
    where CONCURRENT_QUEUE_ID = qid
    and   APPLICATION_ID = qaid;