APPS.BSC_SECURITY SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 30

        SELECT OBJECT_NAME
        FROM USER_OBJECTS
            WHERE OBJECT_NAME='BSC_USER';

Line: 98

   l_sql_stmt :='SELECT encrypted_user_password,';

Line: 145

   l_sql_stmt :='SELECT ';

Line: 178

   l_sql_stmt := 'SELECT ';

Line: 206

   INSERT INTO bsc_user_info(
    SID,
    USER_ID,
    USER_NAME,
    USER_PWD,
    USER_TYPE,
    OBSC_UN,
    OBSC_PWD,
    UBSC_UN,
    UBSC_PWD
   )
   (
      SELECT
        user_info.sid,
        user_info.user_id,
        user_info.user_name,
        user_info.user_pwd,
        user_info.user_type,
        user_info.obsc_un,
        user_info.obsc_pwd,
        user_info.ubsc_un,
        user_info.ubsc_pwd
      FROM
        dual
   );

Line: 298

   select USERENV('SESSIONID')
   into   h_session_id
   from   dual;

Line: 307

   SELECT COUNT(*)
   INTO   h_count
   FROM   bsc_message_logs
   WHERE
          type              IN (DB_ERR_MSG, APP_ERR_MSG)
   AND    source            = h_current_fn
   AND    Last_Update_Login = h_session_id;

Line: 318

      SELECT
                user_id,
                user_pwd,
                user_type,
                obsc_un,
                obsc_pwd,
                ubsc_un,
                ubsc_pwd
      INTO
                x_user_id,
                x_user_pwd,
                x_user_type,
                x_obsc_un,
                x_obsc_pwd,
                x_ubsc_un,
                x_ubsc_pwd
      FROM
                bsc_user_info
      WHERE
                sid = h_session_id;

Line: 394

        Select
            s.audsid,
            s.sid,
            s.serial#
        From
            v$session s,
            v$session_wait w,
            bsc_current_sessions c
        Where
            s.audsid = c.session_id And
            s.sid = w.sid And
            c.program_id = -600 And
            w.seconds_in_wait > h_time_out;

Line: 455

  DELETE bsc_message_logs
  WHERE last_update_login = h_session_id;

Line: 535

      h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
               ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
               ' WHERE c.session_id = s.audsid'||
               ' AND c.program_id in (-700, -800)'||
               ' AND c.session_id <> :1 '||
               ' AND c.user_id = u.user_id (+)';

Line: 547

      h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
               ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
               ' WHERE c.session_id = s.audsid'||
               ' AND c.program_id in (-100, -101, -200, -700, -800, -802)'||
               ' AND c.session_id <> :1 '||
               ' AND c.user_id = u.user_id (+)';

Line: 560

      h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
               ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
               ' WHERE c.session_id = s.audsid'||
               ' AND c.program_id in (-100, -101, -200, -201, -700, -800, -802)'||
               ' AND c.session_id <> :1 '||
               ' AND c.user_id = u.user_id (+)';

Line: 571

      h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
               ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
               ' WHERE c.session_id = s.audsid'||
               ' AND c.program_id in (-100, -101, -200, -202, -300, -400, -500, -700, -800, -802)'||
               ' AND c.session_id <> :1'||
               ' AND c.user_id = u.user_id (+)';

Line: 583

      h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
               ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
               ' WHERE c.session_id = s.audsid'||
               ' AND c.program_id in (-101, -200, -202, -300, -400, -500, -700, -800, -802)'||
               ' AND c.session_id <> :1'||
               ' AND c.user_id = u.user_id (+)';

Line: 596

      h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
               ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
               ' WHERE c.session_id = s.audsid'||
               ' AND c.program_id in (-100, -101, -200, -201, -202, -300, -400, -500, -700, -800, -802)'||
               ' AND c.session_id <> :1 '||
               ' AND c.user_id = u.user_id (+)';

Line: 610

      h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
               ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
               ' WHERE c.session_id = s.audsid'||
               ' AND c.program_id in (-200, -202, -400, -500, -700, -800, -802)'||
               ' AND c.session_id <> :1 '||
               ' AND c.user_id = u.user_id (+)';

Line: 622

      h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
               ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
               ' WHERE c.session_id = s.audsid'||
               ' AND c.program_id in (-100, -101, -200, -201, -202, -700, -800, -802)'||
               ' AND c.session_id <> :1 '||
               ' AND c.user_id = u.user_id (+)';

Line: 632

      h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
               ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
               ' WHERE c.session_id = s.audsid'||
               ' AND c.program_id in (-700, -800, -801, -802)'||
               ' AND c.session_id <> :1 '||
               ' AND c.user_id = u.user_id (+)';

Line: 642

      h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
               ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
               ' WHERE c.session_id = s.audsid'||
               ' AND c.program_id in (-100, -101, -200, -201, -202, -300, -400, -500, -700, -800, -801)'||
               ' AND c.session_id <> :1 '||
               ' AND c.user_id = u.user_id (+)';

Line: 654

      h_sql := 'SELECT c.program_id, u.user_name, s.machine, s.terminal'||
               ' FROM bsc_current_sessions c, v$session s, bsc_apps_users_v u'||
               ' WHERE c.session_id = s.audsid'||
               ' AND c.program_id in (-100, -101, -200, -201, -202, -300, -400, -500, -600, -700, -800, -801, -802)'||
               ' AND c.session_id <> :1 '||
               ' AND c.user_id = u.user_id (+)';

Line: 701

  select count(session_id)
  into l_count
  from bsc_current_sessions
  where (session_id = h_session_id) and (icx_session_id = x_icx_session_id) and (program_id = x_program_id);

Line: 707

       Insert Into bsc_current_sessions
         (SESSION_ID,PROGRAM_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN,USER_ID, ICX_SESSION_ID)
       Values (h_session_id, x_program_id, h_user_id, SYSDATE, h_user_id, SYSDATE, h_session_id,x_user_id, x_icx_session_id);

Line: 746

    SELECT session_id
    FROM   bsc_current_sessions
    WHERE  program_id IN (-100,-101,-200,-201,-202,-800,-802);

Line: 755

    DELETE BSC_CURRENT_SESSIONS
    WHERE  SESSION_ID NOT IN
           (SELECT VS.AUDSID
            FROM V$SESSION VS);

Line: 761

    DELETE BSC_CURRENT_SESSIONS
    WHERE  ICX_SESSION_ID IN (
            SELECT SESSION_ID
            FROM ICX_SESSIONS
            WHERE (FND_SESSION_MANAGEMENT.CHECK_SESSION(SESSION_ID,NULL,NULL,'N') <> 'VALID'));

Line: 776

       l_sql  := ' DELETE bsc_current_sessions'||
                 ' WHERE session_id IN ('||
                   ' SELECT oracle_session_id '||
                   ' FROM   fnd_concurrent_requests  '||
                   ' WHERE  program_application_id = 271 '||
                   ' AND    oracle_session_id IN ('||l_session_ids ||' )'||
                   ' AND    phase_code=''C'')';

Line: 794

            DELETE BSC_CURRENT_SESSIONS
            WHERE  PROGRAM_ID = -600
            AND    SESSION_ID IN (
                       SELECT s.audsid
                       FROM   v$session s, v$session_wait w
                       WHERE  s.sid = w.sid
                       AND    w.seconds_in_wait > 1200);

Line: 805

    DELETE BSC_CURRENT_SESSIONS
    WHERE  SESSION_ID IN (
           SELECT VS.AUDSID
           FROM V$SESSION VS
           WHERE VS.STATUS = 'KILLED');

Line: 875

  h_sql := 'select s.user#, s.audsid'||
           ' from v$session@'||c_src_db_link||' s'||
           ' where s.process = ('||
           ' select vs.process'||
           ' from v$session vs'||
           ' where vs.audsid = userenv(''SESSIONID'')'||
           ' )';   */

Line: 882

  h_sql := 'select s.user#, s.audsid from bsc_session_v@'||c_src_db_link||' s';

Line: 905

  DELETE bsc_message_logs
  WHERE last_update_login = h_session_id;

Line: 910

  h_sql := 'Delete bsc_current_sessions@'||c_src_db_link||
           ' Where session_id Not In (Select audsid From V$Session@'||c_src_db_link||')';

Line: 917

  h_sql := 'Delete bsc_current_sessions@'||c_src_db_link||
           ' Where  session_id In (Select audsid From V$Session@'||c_src_db_link||
           ' Where status = ''KILLED'')';

Line: 928

  h_sql := 'SELECT c.program_id, s.username, s.machine, s.terminal'||
           ' FROM bsc_current_sessions@'||c_src_db_link||' c, v$session@'||c_src_db_link||' s'||
           ' WHERE c.session_id = s.audsid'||
           ' AND c.program_id in (-100, -101, -200, -201, -202, -300, -400, -500, -600, -700, -800)'||
           ' AND c.session_id <> :1 ';

Line: 961

  h_sql := 'Insert Into bsc_current_sessions@'||c_src_db_link||
       ' (SESSION_ID,PROGRAM_ID,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN)'||
           ' Values ('||h_src_session_id||', -800, '||h_src_user_id||', SYSDATE, '||
           h_src_user_id||', SYSDATE, '||h_src_session_id||')';

Line: 992

PROCEDURE Delete_Bsc_Session IS

    l_calling_fn    Varchar2(80);

Line: 1000

    l_calling_fn := 'BSC_SECURITY.DELETE_BSC_SESSION';

Line: 1002

    DELETE BSC_CURRENT_SESSIONS
    WHERE SESSION_ID = USERENV('SESSIONID');

Line: 1019

END Delete_Bsc_Session;

Line: 1029

PROCEDURE Delete_Bsc_Session_ICX(
        p_icx_session_id        IN              NUMBER
) IS

    BSC_Lock_Error  Exception;

Line: 1040

    l_calling_fn := 'BSC_SECURITY.DELETE_BSC_SESSION_ICX';

Line: 1043

        DELETE BSC_CURRENT_SESSIONS
        WHERE ICX_SESSION_ID = p_icx_session_id;

Line: 1062

END Delete_Bsc_Session_ICX;

Line: 1089

     h_sql :='SELECT count(*) FROM dba_objects A, v$locked_object B'||
             ' WHERE A.OBJECT_ID = B.OBJECT_ID AND A.OWNER = BSC_APPS.get_user_schema AND OBJECT_NAME LIKE ''BSC%'' AND SESSION_ID = :1';

Line: 1132

     h_sql :='SELECT count(B.OBJECT_ID) FROM all_objects A, v$locked_object B'||
             ' WHERE  B.OBJECT_ID = A.OBJECT_ID AND A.OWNER = :1 AND OBJECT_NAME LIKE ''BSC%'' AND  SESSION_ID = :2';

Line: 1172

     h_sql :='SELECT count(*) FROM dba_objects A, v$locked_object B'||
              ' WHERE A.OBJECT_ID = B.OBJECT_ID AND A.OWNER = BSC_APPS.get_user_schema AND OBJECT_NAME LIKE ''BSC%''';

Line: 1208

     h_sql :='SELECT COUNT(*) FROM BSC_CURRENT_SESSIONS C, V$SESSION S, V$SESSION_WAIT W, BSC_APPS_USERS_V U ';

Line: 1214

     h_sql :='SELECT count(*) FROM dba_objects A, v$locked_object B'||
             ' WHERE A.OBJECT_ID = B.OBJECT_ID AND A.OWNER = BSC_APPS.get_user_schema AND OBJECT_NAME LIKE ''BSC%''';