APPS.FND_CONC dependencies on FND_CONC

Line 1: package body FND_CONC as

1: package body FND_CONC as
2: /* $Header: AFCPDIGB.pls 120.4 2006/03/14 15:16:08 rckalyan ship $ */
3: --
4: -- Private variables
5:

Line 145: from fnd_conc_stat_summary,

141: into avg_mins,
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

Line 146: fnd_concurrent_requests r,

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

Line 147: fnd_concurrent_programs p

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
151: and concurrent_program_name = program_name

Line 229: from fnd_conc_pp_actions

225:
226: -- se if the request has any pp actions
227: select count(*)
228: into pp_cnt
229: from fnd_conc_pp_actions
230: where concurrent_request_id = P_REQUEST_ID
231: and action_type = 6; -- REMOVE FOR PHASE 2
232:
233:

Line 238: from fnd_conc_pp_actions

234: if pp_cnt > 0 then
235:
236: select processor_id, completed
237: into proc_id, complete
238: from fnd_conc_pp_actions
239: where concurrent_request_id = P_REQUEST_ID
240: and action_type = 6; -- REMOVE FOR PHASE 2
241:
242: -- if processor_id has been updated, post-processing has begun

Line 287: from fnd_concurrent_requests

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

Line 347: from fnd_concurrent_requests fcr, fnd_concurrent_programs fcp

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'

Line 444: from fnd_user fu, fnd_concurrent_requests fcr

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:

Line 482: from fnd_concurrent_requests

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:

Line 721: from fnd_concurrent_requests R, fnd_concurrent_programs_vl CP,

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

Line 734: fnd_message.set_token('ROUTINE', 'FND_CONC.DIAGNOSE');

730:
731: exception
732: when no_data_found then
733: fnd_message.set_name('FND','CONC-Missing Request');
734: fnd_message.set_token('ROUTINE', 'FND_CONC.DIAGNOSE');
735: fnd_message.set_token('REQUEST', to_char(request_id));
736: raise diagnose_error;
737: when others then
738: fnd_message.set_name ('FND', 'SQL-Generic error');

Line 742: 'ROUTINE', 'FND_CONC.DIAGNOSE', FALSE);

738: fnd_message.set_name ('FND', 'SQL-Generic error');
739: fnd_message.set_token ('ERRNO', sqlcode, FALSE);
740: fnd_message.set_token ('REASON', sqlerrm, FALSE);
741: fnd_message.set_token (
742: 'ROUTINE', 'FND_CONC.DIAGNOSE', FALSE);
743: raise diagnose_error;
744: end;
745:
746: get_phase_status(

Line 814: from fnd_concurrent_processes

810:
811: begin
812: select queue_application_id, concurrent_queue_id
813: into appl_id, manager_id
814: from fnd_concurrent_processes
815: where concurrent_process_id = pid;
816:
817: --
818: -- Lock PMON method

Line 860: from fnd_concurrent_processes

856:
857: begin
858: select max(concurrent_process_id)
859: into pid
860: from fnd_concurrent_processes
861: where concurrent_process_id in
862: (select concurrent_process_id
863: from fnd_concurrent_processes
864: where queue_application_id = 0

Line 863: from fnd_concurrent_processes

859: into pid
860: from fnd_concurrent_processes
861: where concurrent_process_id in
862: (select concurrent_process_id
863: from fnd_concurrent_processes
864: where queue_application_id = 0
865: and concurrent_queue_id = 1
866: and process_status_code in ('A','M'));
867:

Line 898: from fnd_concurrent_processes

894: app_id in number) return boolean is
895:
896: cursor service_curs(qid number, appid number) is
897: select concurrent_process_id
898: from fnd_concurrent_processes
899: where concurrent_queue_id = qid
900: and queue_application_id = appid
901: and process_status_code in ('A', 'C');
902:

Line 957: from fnd_concurrent_worker_requests

953: 'X','N', -- Aborted
954: 'D','N', -- Deactivate
955: 'E','N', -- Deactivated
956: 'Y') active
957: from fnd_concurrent_worker_requests
958: where request_id = rid
959: and not((queue_application_id = 0)
960: and (concurrent_queue_id in (1,4)));
961:

Line 1057: end FND_CONC;

1053: end;
1054:
1055:
1056:
1057: end FND_CONC;