APPS.FND_WEBFILEPUB SQL Statements

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

Line: 14

     select r.nls_language,
            r.nls_territory
       into g_nlslang, g_nlsterr
       from fnd_concurrent_requests r,
            fnd_file_temp t
      where t.request_id = r.request_id
        and t.file_id = id;

Line: 100

	select filename, node_name, mime_type, transfer_mode, request_id,
               destination_file, destination_node, NVL(transfer_type, 'R')
	into name, node, type, x_mode, req_id, dest_file, dest_node, tran_type
	from fnd_file_temp
	where 	file_id = id AND
		sysdate <= expires
        for     update;

Line: 108

	delete from fnd_file_temp
	where 	file_id = id OR
		sysdate > expires;

Line: 136

	select distinct tag
        into charset
        from fnd_lookup_values
        where lookup_code = charset
        and lookup_type = 'FND_ISO_CHARACTER_SET_MAP';

Line: 182

     select substrb(p.user_concurrent_program_name,1,30) || '_' ||
             to_char(r.Actual_Start_Date,'ddmmrr'),
             DECODE(o.file_name, t.filename, o.file_type,
                    DECODE(r.outfile_name, t.filename,
                          NVL(r.output_file_type, 'TEXT'), 'TEXT'))
       into temp_name, file_type
       from fnd_concurrent_programs_vl p,
            fnd_concurrent_requests r,
            fnd_conc_req_outputs o,
            fnd_file_temp t
      where p.concurrent_program_id = r.concurrent_program_id
        and p.application_id = r.program_application_id
        and t.request_id = r.request_id
        and r.request_id = o.concurrent_request_id(+)
        and t.file_id = id;

Line: 203

     select substrb(p.user_concurrent_program_name,1,30) || '_' ||
             to_char(r.Actual_Start_Date,'ddmmrr'),
             DECODE(o.file_name, t.filename, o.file_type,
                    DECODE(r.outfile_name, t.filename,
                          NVL(r.output_file_type, 'TEXT'), 'TEXT'))
       into temp_name, file_type
       from fnd_concurrent_programs_tl p,
            fnd_concurrent_requests r,
            fnd_conc_req_outputs o,
            fnd_file_temp t,
            fnd_languages l
      where p.concurrent_program_id = r.concurrent_program_id
        and p.application_id = r.program_application_id
        and t.request_id = r.request_id
        and r.request_id = o.concurrent_request_id(+)
        and t.file_id = id
        and p.language = l.language_code
        and r.nls_language = l.nls_language;

Line: 222

      select value into database_chrset
      from v$nls_parameters
      where parameter = 'NLS_CHARACTERSET';

Line: 315

    select filename, node_name, mime_type, transfer_mode, request_id,
               destination_file, destination_node,
               NVL(transfer_type, 'R'), NVL(native_client_encoding, 'UNDEF'),
               NVL(enable_logging, 'N')
    into  name, node, type, x_mode, req_id,
          dest_file, dest_node,
          tran_type, ncenc, enable_log
    from  fnd_file_temp
    where file_id = id and
          sysdate <= expires
    for   update;

Line: 331

    delete from fnd_file_temp
	where  sysdate > expires;

Line: 383

	select filename, page_number, page_size
	into   name, pagenum, pagesize
	from   fnd_file_temp
	where  file_id = id
	and    sysdate <= expires
    for    update;

Line: 390

	delete from fnd_file_temp
	where  file_id = id
	or     sysdate > expires;