APPS.FND_CP_OPP_REQ dependencies on FND_CONC_REQ_OUTPUTS

Line 558: select count(1) into output_exists from fnd_conc_req_outputs

554:
555: select count(1) into action_type from fnd_conc_pp_actions
556: where concurrent_request_id=reqid and action_type=6;
557:
558: select count(1) into output_exists from fnd_conc_req_outputs
559: where concurrent_request_id = decode(action_type, 1, reqid, to_number(parent_req_id))
560: and file_size>0;
561:
562: if (action_type=1 and output_exists=1) then

Line 571: select count(1) into output_exists from fnd_conc_req_outputs

567: pub_req_id := to_number(parent_req_id);
568: end if;
569:
570: else
571: select count(1) into output_exists from fnd_conc_req_outputs
572: where concurrent_request_id = reqid
573: and file_size>0;
574:
575: if ( output_exists=1) then

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