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 468: lkh FND_CONCURRENT_PROCESSES.Lk_Handle%TYPE;

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

Line 480: From Fnd_Concurrent_Processes

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

Line 504: from gv$session GV, fnd_concurrent_processes P

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

Line 906: from fnd_concurrent_processes cp,

902: --
903: if (C_SessionID is NULL ) then
904: Select Session_ID
905: into C_SessionID
906: from fnd_concurrent_processes cp,
907: fnd_concurrent_queues cq
908: where process_status_code = 'A'
909: and cp.Queue_Application_ID = cq.application_ID
910: and cp.concurrent_queue_id = cq.concurrent_queue_id

Line 1135: From Fnd_Concurrent_Processes P, Fnd_Concurrent_Requests R

1131: end if;
1132:
1133: Select plsql_log, plsql_out, plsql_dir
1134: Into plog, pout, pdir
1135: From Fnd_Concurrent_Processes P, Fnd_Concurrent_Requests R
1136: Where P.Concurrent_Process_ID = R.Controlling_Manager
1137: And R.Request_ID = fnd_global.conc_request_id;
1138:
1139: fnd_file.put_names(plog, pout, pdir);

Line 1159: fnd_concurrent_processes p,

1155: begin
1156: select Q.RESOURCE_CONSUMER_GROUP
1157: into que_rcg
1158: from fnd_concurrent_requests r,
1159: fnd_concurrent_processes p,
1160: fnd_concurrent_queues q
1161: where R.request_id = fnd_global.conc_request_id
1162: and R.controlling_manager = P.concurrent_process_id
1163: and Q.CONCURRENT_QUEUE_ID= P.CONCURRENT_QUEUE_ID

Line 1798: FND_CONCURRENT_PROCESSES fcp,

1794: MEANING c_state,
1795: fcp.NODE_NAME c_node,
1796: fcp.SERVICE_PARAMETERS c_parameters
1797: from FND_CONCURRENT_QUEUES fcq,
1798: FND_CONCURRENT_PROCESSES fcp,
1799: FND_APPLICATION fa,
1800: FND_LOOKUP_VALUES_VL flv
1801: where
1802: fcp.QUEUE_APPLICATION_ID = fcq.APPLICATION_ID