APPS.FND_CONC_PRIVATE_UTILS dependencies on FND_CONCURRENT_REQUESTS

Line 66: FROM fnd_concurrent_requests fcr, fnd_mime_types_vl fmt

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

Line 133: from fnd_concurrent_requests

129: begin
130:
131: /* are we wasting our time? */
132: select count(*) into dummy
133: from fnd_concurrent_requests
134: where request_id = req_id;
135:
136: if dummy = 0 then
137: return 'CONC-Request missing';

Line 147: from fnd_concurrent_requests

143: RELEASE_CLASS_ID, RELEASE_CLASS_APP_ID, Resubmit_End_Date, requested_by
144: into resub_time, type_code, req_sdate,
145: unit_code, interval, sysd,
146: class_id, class_app_id,resub_end, requested_by
147: from fnd_concurrent_requests
148: where request_id = req_id;
149:
150:
151: /* get class info */

Line 315: from fnd_concurrent_requests r, fnd_concurrent_programs_vl p,

311: begin
312: select u.user_name, r.description,
313: p.user_concurrent_program_name, u.email_address
314: into user, pdesc, pname, e_addr
315: from fnd_concurrent_requests r, fnd_concurrent_programs_vl p,
316: fnd_user u
317: where r.program_application_id = p.application_id
318: and r.concurrent_program_id = p.concurrent_program_id
319: and r.request_id = req_id

Line 394: from fnd_concurrent_requests

390: -- handling null as zero
391:
392: select decode(ofile_size,NULL,0,ofile_size), save_output_flag
393: into ofilesize, saveoutputflag
394: from fnd_concurrent_requests
395: where request_id = req_id;
396:
397: -- bug453714 ends
398:

Line 494: from fnd_concurrent_requests

490: begin
491:
492: select LOGFILE_NODE_NAME
493: into mynode
494: from fnd_concurrent_requests
495: where request_id = fnd_global.conc_request_id;
496:
497: return mynode;
498: