353: ssid number;
354: sserial# number;
355: dummy number;
356: begin
357: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
358: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
359: 'fnd.plsql.FND_AMP_PRIVATE.kill_session',
360: 'audsid: ' ||audsid||', inst_id=' ||inst_id);
361: end if;
354: sserial# number;
355: dummy number;
356: begin
357: if( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
358: fnd_log.string(FND_LOG.LEVEL_STATEMENT,
359: 'fnd.plsql.FND_AMP_PRIVATE.kill_session',
360: 'audsid: ' ||audsid||', inst_id=' ||inst_id);
361: end if;
362:
367: where kill_session.audsid = gv$session.audsid
368: and kill_session.inst_id = gv$session.inst_id;
369: exception
370: when no_data_found then
371: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
372: fnd_log.string(FND_LOG.LEVEL_ERROR,
373: 'fnd.plsql.FND_AMP_PRIVATE.kill_session',
374: 'Session (audsid) ' ||audsid||' in instance '||inst_id||' not found');
375: end if;
368: and kill_session.inst_id = gv$session.inst_id;
369: exception
370: when no_data_found then
371: if( FND_LOG.LEVEL_ERROR >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
372: fnd_log.string(FND_LOG.LEVEL_ERROR,
373: 'fnd.plsql.FND_AMP_PRIVATE.kill_session',
374: 'Session (audsid) ' ||audsid||' in instance '||inst_id||' not found');
375: end if;
376: return 1;