306: ssid number;
307: sserial# number;
308: dummy number;
309: begin
310: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
311: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
312: 'fnd.plsql.FND_AMP_PRIVATE.kill_session',
313: 'audsid: ' ||audsid||', inst_id=' ||inst_id);
314: end if;
307: sserial# number;
308: dummy number;
309: begin
310: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
311: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
312: 'fnd.plsql.FND_AMP_PRIVATE.kill_session',
313: 'audsid: ' ||audsid||', inst_id=' ||inst_id);
314: end if;
315:
320: where kill_session.audsid = gv$session.audsid
321: and kill_session.inst_id = gv$session.inst_id;
322: exception
323: when no_data_found then
324: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
325: fnd_log.string(FND_LOG.LEVEL_ERROR,
326: 'fnd.plsql.FND_AMP_PRIVATE.kill_session',
327: 'Session (audsid) ' ||audsid||' in instance '||inst_id||' not found');
328: end if;
321: and kill_session.inst_id = gv$session.inst_id;
322: exception
323: when no_data_found then
324: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
325: fnd_log.string(FND_LOG.LEVEL_ERROR,
326: 'fnd.plsql.FND_AMP_PRIVATE.kill_session',
327: 'Session (audsid) ' ||audsid||' in instance '||inst_id||' not found');
328: end if;
329: return 1;