DBA Data[Home] [Help]

APPS.FND_APD dependencies on V$SESSION

Line 35: FROM v$session

31:
32: BEGIN
33: SELECT sid
34: INTO session
35: FROM v$session
36: WHERE audsid = userenv('SESSIONID');
37: EXCEPTION
38: when no_data_found then
39: fnd_file.put_line(fnd_file.log,'fnd_apd:Collect:Error while getting session Id ');

Line 135: FROM v$session

131: END;
132: BEGIN
133: SELECT sid
134: INTO session
135: FROM v$session
136: WHERE audsid = userenv('SESSIONID');
137: EXCEPTION
138: when no_data_found then
139: fnd_file.put_line(fnd_file.log,'fnd_apd:store_initial:Error while getting session Id ');

Line 222: FROM v$session

218: p_req_id := fnd_global.conc_request_id;
219: BEGIN
220: SELECT sid
221: INTO session
222: FROM v$session
223: WHERE audsid = userenv('SESSIONID');
224: EXCEPTION
225: when no_data_found then
226: fnd_file.put_line(fnd_file.log,'fnd_apd:store_final:Error while getting session Id ');

Line 327: from v$process p,v$session s

323: EXECUTE IMMEDIATE vsql ;
324: END;
325: BEGIN
326: select spid into vspid
327: from v$process p,v$session s
328: where p.addr = s.paddr
329: and s.audsid = userenv('SESSIONID');
330: EXCEPTION
331: when no_data_found then