APPS.FND_WEBFILE dependencies on FND_MIME_TYPES_VL

Line 310: from fnd_concurrent_requests fcr, fnd_mime_types_vl fmt,

306: select fcr.outfile_name, fcr.outfile_node_name, fmt.mime_type,
307: fcr.save_output_flag, fcr.ofile_size, fmt.file_format_code,
308: fcp.concurrent_program_name, a.application_short_name
309: into fname, node, mtype, save_out, fsize, ffcode, prog_name,appl_name
310: from fnd_concurrent_requests fcr, fnd_mime_types_vl fmt,
311: fnd_concurrent_programs fcp, fnd_application a
312: where fcr.request_id = id
313: and upper(fcr.output_file_type) = upper(fmt.file_format_code)
314: and fcp.concurrent_program_id = fcr.concurrent_program_id

Line 341: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt

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

Line 374: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt

370: if (fnd_conc_sswa.layout_enabled(appl_name, prog_name)) then
371: begin
372: select file_type,file_name,file_node_name,file_size, fmt.mime_type
373: into ffcode, fname, node, fsize, mtype
374: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt
375: where concurrent_request_id = (select to_number(argument1) from fnd_concurrent_requests where request_id=id)
376: and RO.file_type = fmt.file_format_code
377: and rownum = 1;
378: exception

Line 388: from fnd_concurrent_requests fcr, fnd_mime_types_vl fmt

384: else /* Parent program is not layout enabled*/
385: begin
386: select output_file_type, outfile_name, outfile_node_name, ofile_size, fmt.mime_type
387: into ffcode, fname, node, fsize, mtype
388: from fnd_concurrent_requests fcr, fnd_mime_types_vl fmt
389: where request_id = id
390: and fcr.output_file_type = fmt.file_format_code
391: and rownum = 1;
392: exception

Line 404: from fnd_conc_req_outputs RO, fnd_mime_types_vl fmt

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

Line 724: from fnd_mime_types_vl

720:
721: begin
722: select allow_client_encoding
723: into allow_enc
724: from fnd_mime_types_vl
725: where mime_type = type
726: and ((ftype is not null and upper(file_format_code) = ftype)
727: or (ftype is null and rownum = 1));
728: exception