APPS.FND_CONCURRENT dependencies on FND_CONCURRENT_PROCESSES

Line 22: Fnd_Concurrent_Processes.Lk_Handle%TYPE

18: PHASE_LOOKUP_TYPE constant varchar2(16) := 'CP_PHASE_CODE';
19: STATUS_LOOKUP_TYPE constant varchar2(16) := 'CP_STATUS_CODE';
20:
21: TYpe ConcProcessLocks Is Table of
22: Fnd_Concurrent_Processes.Lk_Handle%TYPE
23: Index By Binary_Integer;
24:
25: CmLkHandles ConcProcessLocks;
26:

Line 45: From Fnd_Concurrent_Processes

41:
42: if ( apid = 0 AND cqid = 1 ) then
43: Select Max(Concurrent_Process_ID)
44: Into icm_cid
45: From Fnd_Concurrent_Processes
46: Where Process_Status_Code = 'A'
47: And (Queue_Application_ID = 0 And
48: Concurrent_Queue_ID = 1);
49:

Line 466: lkh FND_CONCURRENT_PROCESSES.Lk_Handle%TYPE;

462: targetp OUT NOCOPY number,
463: activep OUT NOCOPY number,
464: pmon_method OUT NOCOPY varchar2,
465: callstat OUT NOCOPY number) is
466: lkh FND_CONCURRENT_PROCESSES.Lk_Handle%TYPE;
467: result number; -- result code from DBMS_LOCK.Request_Lock
468: alive number; -- is process alive? 1=TRUE 0=FALSE
469: i number := 0;
470: errflag boolean := FALSE;

Line 478: From Fnd_Concurrent_Processes

474: cur_session_id number;
475:
476: Cursor C1 IS
477: Select Concurrent_Process_Id, Session_Id
478: From Fnd_Concurrent_Processes
479: Where Process_Status_Code in ( 'A', 'C', 'T' )
480: And (Queue_Application_ID = applid and
481: Concurrent_Queue_ID = managerid );
482: begin

Line 502: from gv$session GV, fnd_concurrent_processes P

498: if (mtype>999) then
499: if (CartType = 'AQCART') then
500: select count(*)
501: into ActiveP
502: from gv$session GV, fnd_concurrent_processes P
503: where
504: GV.Inst_id = P.Instance_number
505: And GV.audsid = p.session_id
506: And (Process_Status_Code not in ('S','K','U'))

Line 837: from fnd_concurrent_processes cp,

833: --
834: if (C_SessionID is NULL ) then
835: Select Session_ID
836: into C_SessionID
837: from fnd_concurrent_processes cp,
838: fnd_concurrent_queues cq
839: where process_status_code = 'A'
840: and cp.Queue_Application_ID = cq.application_ID
841: and cp.concurrent_queue_id = cq.concurrent_queue_id

Line 1030: From Fnd_Concurrent_Processes P, Fnd_Concurrent_Requests R

1026: end if;
1027:
1028: Select plsql_log, plsql_out, plsql_dir
1029: Into plog, pout, pdir
1030: From Fnd_Concurrent_Processes P, Fnd_Concurrent_Requests R
1031: Where P.Concurrent_Process_ID = R.Controlling_Manager
1032: And R.Request_ID = fnd_global.conc_request_id;
1033:
1034: fnd_file.put_names(plog, pout, pdir);

Line 1054: fnd_concurrent_processes p,

1050: begin
1051: select Q.RESOURCE_CONSUMER_GROUP
1052: into que_rcg
1053: from fnd_concurrent_requests r,
1054: fnd_concurrent_processes p,
1055: fnd_concurrent_queues q
1056: where R.request_id = fnd_global.conc_request_id
1057: and R.controlling_manager = P.concurrent_process_id
1058: and Q.CONCURRENT_QUEUE_ID= P.CONCURRENT_QUEUE_ID

Line 1689: FND_CONCURRENT_PROCESSES fcp,

1685: MEANING c_state,
1686: fcp.NODE_NAME c_node,
1687: fcp.SERVICE_PARAMETERS c_parameters
1688: from FND_CONCURRENT_QUEUES fcq,
1689: FND_CONCURRENT_PROCESSES fcp,
1690: FND_APPLICATION fa,
1691: FND_LOOKUP_VALUES_VL flv
1692: where
1693: fcp.QUEUE_APPLICATION_ID = fcq.APPLICATION_ID