APPS.FND_CP_OPP_REQ dependencies on FND_CONCURRENT_REQUESTS

Line 26: from fnd_concurrent_requests fcr,

22: begin
23:
24: select fcp.concurrent_program_name, a.application_short_name
25: into prog_name, appl_name
26: from fnd_concurrent_requests fcr,
27: fnd_concurrent_programs fcp, fnd_application a
28: where fcr.request_id = reqid
29: and fcp.concurrent_program_id = fcr.concurrent_program_id
30: and fcp.application_id = fcr.program_application_id

Line 192: -- Updates FND_CONCURRENT_REQUESTS with the post-processing start date, end date and status

188: --
189: -- update_req_pp_status
190: --
191: -- Helper procedure for postprocess
192: -- Updates FND_CONCURRENT_REQUESTS with the post-processing start date, end date and status
193: --
194: procedure update_req_pp_status(reqid in number, status in varchar2) is
195:
196:

Line 201: update fnd_concurrent_requests

197: begin
198:
199: if status = PP_PENDING then
200:
201: update fnd_concurrent_requests
202: set pp_start_date = sysdate, post_request_status = status
203: where request_id = reqid;
204:
205: else

Line 207: update fnd_concurrent_requests

203: where request_id = reqid;
204:
205: else
206:
207: update fnd_concurrent_requests
208: set pp_end_date = sysdate, post_request_status = status
209: where request_id = reqid;
210:
211: end if;

Line 314: from fnd_concurrent_requests fcr

310: -- Select our local node
311: begin
312: select fcr.outfile_node_name
313: into node_name
314: from fnd_concurrent_requests fcr
315: where request_id = requestid;
316: exception
317: when no_data_found then
318: opp_name := null;

Line 407: from fnd_concurrent_requests fcr

403: --
404: begin
405: select fcr.controlling_manager
406: into cpid
407: from fnd_concurrent_requests fcr
408: where request_id = reqid;
409: exception
410: when no_data_found then
411: errmsg := fnd_message.get_string('FND', 'CONC-PP CMGR ONLY');

Line 541: from fnd_concurrent_requests fcr,

537: is_published := false;
538:
539: select fcp.concurrent_program_name, a.application_short_name, argument1
540: into prog_name, appl_name, parent_req_id
541: from fnd_concurrent_requests fcr,
542: fnd_concurrent_programs fcp, fnd_application a
543: where fcr.request_id = reqid
544: and fcp.concurrent_program_id = fcr.concurrent_program_id
545: and fcp.application_id = fcr.program_application_id

Line 629: from fnd_conc_req_outputs fcro, fnd_concurrent_requests fcr

625: if published_request(prev_reqid) then
626: begin
627: select fcro.file_name, fcro.file_node_name, fcr.output_file_type
628: into outfile, outnode, outtype
629: from fnd_conc_req_outputs fcro, fnd_concurrent_requests fcr
630: where fcro.concurrent_request_id = prev_reqid
631: and fcro.concurrent_request_id = fcr.request_id;
632: exception
633: when no_data_found then

Line 647: from fnd_concurrent_requests

643:
644: begin
645: select outfile_name, outfile_node_name, output_file_type
646: into outfile, outnode, outtype
647: from fnd_concurrent_requests
648: where request_id = prev_reqid;
649: exception
650: when no_data_found then
651: errmsg := 'Could not find previous request: ' || prev_reqid;

Line 660: update fnd_concurrent_requests

656: end if;
657:
658: -- Bug 6040814. Update output_file_type from parent request.
659:
660: update fnd_concurrent_requests
661: set outfile_name = outfile,
662: outfile_node_name = outnode,
663: output_file_type = outtype
664: where request_id = cur_reqid;