[Home] [Help]
142: avg_hrs,
143: avg_days,
144: expctd_finish
145: from fnd_conc_stat_summary,
146: fnd_concurrent_requests r,
147: fnd_concurrent_programs p
148: where request_id = reqid
149: and program_application_id = application_id
150: and p.concurrent_program_id = r.concurrent_program_id
283:
284: -- check to see if it has running children
285: select count(*)
286: into child_count
287: from fnd_concurrent_requests
288: where parent_request_id = P_REQUEST_ID
289: and phase_code in (PHASE_PENDING, PHASE_RUNNING);
290:
291: if (child_count < 1) then
343: begin
344: /* changed query for BUG#5007915 SQLID#14602696 */
345: select request_id
346: into ra_reqid
347: from fnd_concurrent_requests fcr, fnd_concurrent_programs fcp
348: where fcp.run_alone_flag = 'Y'
349: and fcp.concurrent_program_id = fcr.concurrent_program_id
350: and fcp.application_id = fcr.program_application_id
351: and fcr.phase_code = 'R'
440: -- this request will never be released by the CRM.
441: -- Check the user in FND_USER
442: select count(*)
443: into cnt
444: from fnd_user fu, fnd_concurrent_requests fcr
445: where fcr.request_id = P_REQUEST_ID
446: and fu.user_id = fcr.requested_by
447: and (fu.end_date is null or fu.end_date > sysdate);
448:
478:
479: -- check for a running or pending parent request
480: select count(*)
481: into parent_reqid
482: from fnd_concurrent_requests
483: where request_id = P_PARENT_REQUEST_ID
484: and phase_code in ('P', 'R');
485:
486:
717: P_ENABLED, P_CONTROLLING_MANAGER,
718: P_PROGRAM, P_QUEUE_CONTROL_FLAG,
719: P_QUEUE_METHOD_CODE, P_RUN_ALONE_FLAG,
720: P_SINGLE_THREAD_FLAG, P_REQLIMIT_FLAG, P_CD_ID
721: from fnd_concurrent_requests R, fnd_concurrent_programs_vl CP,
722: fnd_user U1, fnd_user U2,
723: fnd_application_vl FA
724: where R.request_id = diagnose.request_id
725: and R.program_application_id = FA.application_id