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 544: from fnd_concurrent_requests fcr,

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

Line 651: from fnd_concurrent_requests

647:
648: begin
649: select outfile_name, outfile_node_name, output_file_type, nls_numeric_characters, nls_codeset
650: into outfile, outnode, outtype, nlschar, codeset
651: from fnd_concurrent_requests
652: where request_id = prev_reqid;
653: exception
654: when no_data_found then
655: errmsg := 'Could not find previous request: ' || prev_reqid;

Line 664: update fnd_concurrent_requests

660: end if;
661:
662: -- Bug 6040814. Update output_file_type from parent request.
663:
664: update fnd_concurrent_requests
665: set outfile_name = outfile,
666: outfile_node_name = outnode,
667: output_file_type = outtype,
668: nls_numeric_characters = nlschar,