DBA Data[Home] [Help]

APPS.FND_CP_OPP_REQ dependencies on FND_CONC_REQ_OUTPUTS

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

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

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

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

Line 634: from fnd_conc_req_outputs fcro

630: if published_request(prev_reqid) then
631: begin
632: select fcro.file_name, fcro.file_node_name, fcro.file_type
633: into outfile, outnode, outtype
634: from fnd_conc_req_outputs fcro
635: where fcro.concurrent_request_id = prev_reqid;
636: exception
637: when no_data_found then
638: errmsg := 'Could not find published output file for previous request';