981: Select P.PID, P.SPID, AUDSID, PROCESS,
982: substr(userenv('LANGUAGE'),
983: instr( userenv('LANGUAGE'), '.') + 1)
984: Into cpid, csspid, csid, cspid, codeset
985: From V$Session S, V$Process P
986: Where P.Addr = S.Paddr
987: and S.AUDSID = userenv('SESSIONID');
988:
989: update fnd_concurrent_requests