APPS.FND_CONC_PRIVATE_UTILS SQL Statements

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

Line: 64

   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: 132

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

Line: 141

  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, requested_by
  into resub_time, type_code, req_sdate,
	unit_code, interval, sysd,
	class_id, class_app_id,resub_end, requested_by
  from fnd_concurrent_requests
  where request_id = req_id;

Line: 156

    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: 172

    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: 230

    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: 272

    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: 312

	   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: 378

	    select notification_id
	    from wf_notifications
	    where group_id = nid;

Line: 392

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

Line: 492

  select LOGFILE_NODE_NAME
  into mynode
  from fnd_concurrent_requests
  where request_id = fnd_global.conc_request_id;

Line: 502

         select upper(substr (machine, 1, instr(machine, '.')-1 ))
         into mynode
         from v$session
         where audsid=USERENV('SESSIONID');

Line: 521

	update fnd_temp_files
	set REQUEST_ID = decode (req_id, 0, null, req_id),
	    SESSION_ID = sess_id
	where filename =  record_temp_file_use_pvt.filename
	and node = record_temp_file_use_pvt.node
	and type = record_temp_file_use_pvt.type;

Line: 531

	  		   'insert into fnd_temp_files');

Line: 533

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

Line: 539

	  		   'fnd_temp_files updated');

Line: 590

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

Line: 604

     	delete from fnd_temp_files
	where filename =  erase_temp_file_use_pvt.filename
	and upper(node) = upper(erase_temp_file_use_pvt.node)
	and upper(type) = upper(erase_temp_file_use_pvt.type);

Line: 637

/* deletes record of a temp file from fnd_temp_files */

procedure erase_temp_file_use(filename in varchar, node in varchar, type in varchar) is

  mynode varchar2(255);

Line: 670

	  select 1
	  into file_recorded
	  from fnd_temp_files
	  where filename = check_temp_file_use.filename
	  and (node is null or upper(node) = upper(mynode))
	  and upper(type) = upper(check_temp_file_use.type);

Line: 755

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