APPS.CS_KB_SESSION_PKG SQL Statements

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

Line: 4

  procedure INSERT_ROW
  (
    X_ROWID                OUT NOCOPY VARCHAR2,
    X_SESSION_ID           OUT NOCOPY NUMBER,
    P_SOURCE_OBJECT_CODE    in VARCHAR2,
    P_SOURCE_OBJECT_ID      in NUMBER,
    P_CREATION_DATE         in DATE,
    P_CREATED_BY            in NUMBER,
    P_LAST_UPDATE_DATE      in DATE,
    P_LAST_UPDATED_BY       in NUMBER,
    P_LAST_UPDATE_LOGIN     in NUMBER
  )
  is
    cursor getNewSessionIdCsr is
      select cs_kb_sessions_s.nextval
      from dual;

Line: 22

      select ROWID
      from CS_KB_SESSIONS
      where SESSION_ID = X_SESSION_ID;

Line: 32

    insert into cs_kb_sessions
    (
      session_id,
      source_object_id,
      source_object_code,
      creation_date,
      created_by,
      last_update_date,
      last_updated_by,
      last_update_login
    )
    values
    (
      x_session_id,
      p_source_object_id,
      p_source_object_code,
      p_creation_date,
      p_created_by,
      p_last_update_date,
      p_last_updated_by,
      p_last_update_login
    );

Line: 65

  end INSERT_ROW;

Line: 67

  procedure UPDATE_ROW
  (
    P_SESSION_ID            in NUMBER,
    P_SOURCE_OBJECT_CODE    in VARCHAR2,
    P_SOURCE_OBJECT_ID      in NUMBER,
    P_LAST_UPDATE_DATE      in DATE,
    P_LAST_UPDATED_BY       in NUMBER,
    P_LAST_UPDATE_LOGIN     in NUMBER
  )
  is
  begin
    update cs_kb_sessions
    set
      source_object_id    = p_source_object_id,
      source_object_code  = p_source_object_code,
      last_update_date    = p_last_update_date,
      last_updated_by     = p_last_updated_by,
      last_update_login   = p_last_update_login
    where session_id = P_SESSION_ID;

Line: 91

  end UPDATE_ROW;

Line: 93

  procedure DELETE_ROW
  (
    P_SESSION_ID               in NUMBER
  )
  is
  begin
    delete from cs_kb_sessions
    where session_id = P_SESSION_ID;

Line: 104

  end DELETE_ROW;

Line: 125

    update_row
    (
      p_session_id          => p_session_id,
      p_source_object_code  => p_source_object_code,
      p_source_object_id    => p_source_object_id,
      p_last_update_date    => sysdate,
      p_last_updated_by     => l_user_id,
      p_last_update_login   => 0
    );

Line: 138

      insert_row
      (
        x_rowid               => l_rowid,
        x_session_id          => l_session_id,
        p_source_object_code  => p_source_object_code,
        p_source_object_id    => p_source_object_id,
        p_creation_date       => sysdate,
        p_created_by          => l_user_id,
        p_last_update_date    => sysdate,
        p_last_updated_by     => l_user_id,
        p_last_update_login   => 0
      );