[Home] [Help]
276: /* Request Log */
277: begin
278: select logfile_name, logfile_node_name
279: into fname, node
280: from fnd_concurrent_requests
281: where request_id = id;
282: req_id := id;
283: exception
284: when no_data_found then
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
315: * 1) YES - case a. whether it is a REPRINT and REPUBLISH - check for output details in fnd_conc_req_outputs
316: * case b. Only REPRINT
317: * Check whether the parent program supports republish
318: * 1) YES - Check for output details in fnd_conc_req_outputs which request id as parent request id.
319: * 2) NO - Check for output details in fnd_concurrent_requests with REPRINT request id.
320: * 2) NO (NOT FNDREPRINT)
321: * case a. If the program is layout enabled - check for output details in fnd_conc_req_outputs
322: * case b. Check for the output details in fnd_concurrent_requests as already done in the above sql.
323: */
318: * 1) YES - Check for output details in fnd_conc_req_outputs which request id as parent request id.
319: * 2) NO - Check for output details in fnd_concurrent_requests with REPRINT request id.
320: * 2) NO (NOT FNDREPRINT)
321: * case a. If the program is layout enabled - check for output details in fnd_conc_req_outputs
322: * case b. Check for the output details in fnd_concurrent_requests as already done in the above sql.
323: */
324:
325: /* Check whether the program is a FNDREPRINT program */
326: if (prog_name = 'FNDREPRINT' and appl_name ='FND') then
346: begin
347: /* Find the parent program for the REPRINT request */
348: select fcp.concurrent_program_name, a.application_short_name
349: into prog_name, appl_name
350: from fnd_concurrent_programs fcp, fnd_application a, fnd_concurrent_requests fcr
351: where fcp.concurrent_program_id = fcr.concurrent_program_id
352: and fcp.application_id = fcr.program_application_id
353: and fcp.application_id = a.application_id
354: and fcr.request_id = (select to_number(argument1) from fnd_concurrent_requests where request_id=id);
350: from fnd_concurrent_programs fcp, fnd_application a, fnd_concurrent_requests fcr
351: where fcp.concurrent_program_id = fcr.concurrent_program_id
352: and fcp.application_id = fcr.program_application_id
353: and fcp.application_id = a.application_id
354: and fcr.request_id = (select to_number(argument1) from fnd_concurrent_requests where request_id=id);
355: exception
356: when no_data_found then
357: fnd_message.set_name('FND', 'CONC-REQUEST MISSING');
358: fnd_message.set_token('ROUTINE','FND_WEBFILE.GET_URL');
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
373: when no_data_found then
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
435: begin
436: select p.logfile_name, p.node_name, r.controlling_manager,
437: p.concurrent_process_id
438: into fname, node, controlling_mgr, cpid
439: from fnd_concurrent_requests r, fnd_concurrent_processes p
440: where r.request_id = id
441: and r.controlling_manager = p.concurrent_process_id(+);
442: /* The outer join makes sure that we don't say that the request
443: row is missing, when the manager row is missing. We know that
681: allow_enc varchar2(1);
682: fs_prefix varchar2(254) := NULL;
683: nmptr number;
684: svc varchar2(254) := NULL;
685: ftype fnd_concurrent_requests.output_file_type%TYPE := NULL;
686:
687:
688: begin
689:
703: if (req_id <> 0) then
704: begin
705: select upper(output_file_type)
706: into ftype
707: from fnd_concurrent_requests
708: where request_id = req_id;
709: exception
710: when others then
711: null;