APPS.FND_CONC_PRIVATE_UTILS dependencies on FND_CONCURRENT_REQUESTS

Line 65: FROM fnd_concurrent_requests fcr, fnd_mime_types_vl fmt

61: END IF;
62:
63: SELECT fcr.outfile_name, fcr.outfile_node_name, fmt.mime_type
64: INTO fname, node, mtype
65: FROM fnd_concurrent_requests fcr, fnd_mime_types_vl fmt
66: WHERE fcr.request_id = req_id
67: AND fcr.output_file_type = fmt.file_format_code
68: AND rownum = 1;
69:

Line 128: from fnd_concurrent_requests

124: begin
125:
126: /* are we wasting our time? */
127: select count(*) into dummy
128: from fnd_concurrent_requests
129: where request_id = req_id;
130:
131: if dummy = 0 then
132: return 'CONC-Request missing';

Line 142: from fnd_concurrent_requests

138: RELEASE_CLASS_ID, RELEASE_CLASS_APP_ID, Resubmit_End_Date
139: into resub_time, type_code, req_sdate,
140: unit_code, interval, sysd,
141: class_id, class_app_id,resub_end
142: from fnd_concurrent_requests
143: where request_id = req_id;
144:
145:
146: /* get class info */

Line 284: from fnd_concurrent_requests r, fnd_concurrent_programs_vl p,

280: begin
281: select u.user_name, r.description,
282: p.user_concurrent_program_name, u.email_address
283: into user, pdesc, pname, e_addr
284: from fnd_concurrent_requests r, fnd_concurrent_programs_vl p,
285: fnd_user u
286: where r.program_application_id = p.application_id
287: and r.concurrent_program_id = p.concurrent_program_id
288: and r.request_id = req_id

Line 363: from fnd_concurrent_requests

359: -- handling null as zero
360:
361: select decode(ofile_size,NULL,0,ofile_size), save_output_flag
362: into ofilesize, saveoutputflag
363: from fnd_concurrent_requests
364: where request_id = req_id;
365:
366: -- bug453714 ends
367:

Line 487: from fnd_concurrent_requests

483: /* let's try to guess the node */
484: begin
485: select LOGFILE_NODE_NAME
486: into mynode
487: from fnd_concurrent_requests
488: where request_id = req_id;
489: exception
490: when others then null;
491: end;