APPS.FND_WEBFILE dependencies on FND_MIME_TYPES_VL

Line 304: from fnd_concurrent_requests fcr, fnd_mime_types_vl fmt,

300: select fcr.outfile_name, fcr.outfile_node_name, fmt.mime_type,
301: fcr.save_output_flag, fcr.ofile_size, fmt.file_format_code,
302: fcp.concurrent_program_name, a.application_short_name
303: into fname, node, mtype, save_out, fsize, ffcode, prog_name,appl_name
304: from fnd_concurrent_requests fcr, fnd_mime_types_vl fmt,
305: fnd_concurrent_programs fcp, fnd_application a
306: where fcr.request_id = id
307: and upper(fcr.output_file_type) = upper(fmt.file_format_code)
308: and fcp.concurrent_program_id = fcr.concurrent_program_id

Line 335: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt

331: if(action_publish_count=1) then /* Check if it is a REPRINT and REPUBLISH request */
332: begin
333: select file_type,file_name,file_node_name,file_size, fmt.mime_type
334: into ffcode, fname, node, fsize, mtype
335: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt
336: where concurrent_request_id = id
337: and RO.file_type = fmt.file_format_code
338: and rownum = 1;
339: exception

Line 368: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt

364: if (fnd_conc_sswa.layout_enabled(appl_name, prog_name)) then
365: begin
366: select file_type,file_name,file_node_name,file_size, fmt.mime_type
367: into ffcode, fname, node, fsize, mtype
368: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt
369: where concurrent_request_id = (select to_number(argument1) from fnd_concurrent_requests where request_id=id)
370: and RO.file_type = fmt.file_format_code
371: and rownum = 1;
372: exception

Line 382: from fnd_concurrent_requests fcr, fnd_mime_types_vl fmt

378: else /* Parent program is not layout enabled*/
379: begin
380: select output_file_type, outfile_name, outfile_node_name, ofile_size, fmt.mime_type
381: into ffcode, fname, node, fsize, mtype
382: from fnd_concurrent_requests fcr, fnd_mime_types_vl fmt
383: where request_id = id
384: and fcr.output_file_type = fmt.file_format_code
385: and rownum = 1;
386: exception

Line 398: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt

394: elsif(fnd_conc_sswa.layout_enabled(appl_name, prog_name) and file_type=request_out) then /* Not a FNDREPRINT request */
395: begin
396: select file_type,file_name,file_node_name,file_size, fmt.mime_type
397: into ffcode, fname, node, fsize, mtype
398: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt
399: where concurrent_request_id = id
400: and RO.file_type = fmt.file_format_code
401: and rownum = 1;
402: exception

Line 718: from fnd_mime_types_vl

714:
715: begin
716: select allow_client_encoding
717: into allow_enc
718: from fnd_mime_types_vl
719: where mime_type = type
720: and ((ftype is not null and upper(file_format_code) = ftype)
721: or (ftype is null and rownum = 1));
722: exception