APPS.FND_CONCURRENT dependencies on V$SESSION

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 929: from V$SESSION SH,

925: SH.MACHINE,
926: SH.TERMINAL,
927: SH.PROGRAM
928: into UName, UProcess_ID, UNode, UTerminal, UProgram
929: from V$SESSION SH,
930: V$LOCK LW,
931: V$LOCK LH,
932: V$SESSION SW
933: where LH.SID = SH.SID

Line 932: V$SESSION SW

928: into UName, UProcess_ID, UNode, UTerminal, UProgram
929: from V$SESSION SH,
930: V$LOCK LW,
931: V$LOCK LH,
932: V$SESSION SW
933: where LH.SID = SH.SID
934: and LH.SID <> SW.SID
935: and LH.ID1 = LW.ID1
936: and LH.ID2 = LW.ID2

Line 1062: From V$Session S, V$Process P,

1058: Select P.PID, P.SPID, AUDSID, PROCESS,
1059: substr(userenv('LANGUAGE'),
1060: instr( userenv('LANGUAGE'), '.') + 1)
1061: Into cpid, csspid, csid, cspid, codeset
1062: From V$Session S, V$Process P,
1063: (select distinct sid from v$mystat ) m
1064: Where P.Addr = S.Paddr
1065: and s.sid = m.sid;
1066:

Line 1084: From V$Session S, V$Process P

1080: Select P.PID, P.SPID, AUDSID, PROCESS,
1081: substr(userenv('LANGUAGE'),
1082: instr( userenv('LANGUAGE'), '.') + 1)
1083: Into cpid, csspid, csid, cspid, codeset
1084: From V$Session S, V$Process P
1085: Where P.Addr = S.Paddr
1086: and S.AUDSID = userenv('SESSIONID');
1087:
1088: update fnd_concurrent_requests

Line 2710: lpid v$session.process%type;

2706: cprogid number;
2707: cprireqid number;
2708: counter number := 0;
2709:
2710: lpid v$session.process%type;
2711: lmachine v$session.machine%type;
2712: position number;
2713: begin
2714:

Line 2711: lmachine v$session.machine%type;

2707: cprireqid number;
2708: counter number := 0;
2709:
2710: lpid v$session.process%type;
2711: lmachine v$session.machine%type;
2712: position number;
2713: begin
2714:
2715: -- Select all the information needed for this request from fnd_concurrent_requests,

Line 2719: -- By joining these tables with v$session, we can pull out all the information we need,

2715: -- Select all the information needed for this request from fnd_concurrent_requests,
2716: -- using the fnd_cp_sql_requests table.
2717: -- A row should have been inserted earlier in usdspid, containing the current request id,
2718: -- machine name, and process id.
2719: -- By joining these tables with v$session, we can pull out all the information we need,
2720: -- using only our own session id.
2721: begin
2722:
2723:

Line 2727: from v$session

2723:
2724:
2725: select process, machine
2726: into lpid, lmachine
2727: from v$session
2728: where audsid = userenv('sessionid');
2729:
2730: position := instr(lpid,':');
2731: if ( position>0 ) then