APPS.CS_KB_SESSION_ATTR_PKG SQL Statements

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

Line: 24

    insert_row
    (
      x_rowid              => l_rowid,
      x_session_attr_id    => x_session_attr_id,
      p_session_id         => p_session_id,
      p_attribute_type     => p_attribute_type,
      p_attribute_name     => p_attribute_name,
      p_value1             => p_value1,
      p_value2             => p_value2,
      p_creation_date      => l_current_date,
      p_created_by         => l_current_user,
      p_last_update_date   => l_current_date,
      p_last_updated_by    => l_current_user,
      p_last_update_login  => l_current_login
    );

Line: 45

  function update_km_session_attr
  (
    P_SESSION_ATTR_ID      in NUMBER,
    P_SESSION_ID           in NUMBER,
    P_ATTRIBUTE_TYPE       in VARCHAR2,
    P_ATTRIBUTE_NAME       in VARCHAR2,
    P_VALUE1               in VARCHAR2,
    P_VALUE2               in VARCHAR2
  ) return number
  is
    l_current_date date;

Line: 62

    update_row
    (
      p_session_attr_id    => p_session_attr_id,
      p_session_id         => p_session_id,
      p_attribute_type     => p_attribute_type,
      p_attribute_name     => p_attribute_name,
      p_value1             => p_value1,
      p_value2             => p_value2,
      p_last_update_date   => l_current_date,
      p_last_updated_by    => l_current_user,
      p_last_update_login  => l_current_login
    );

Line: 92

    delete_row
    (
      p_session_attr_id    => p_session_attr_id
    );

Line: 108

      select session_attr_id
      from cs_kb_session_attrs
      where session_id = c_session_id;

Line: 113

      delete_row
      (
        p_session_attr_id => rec.session_attr_id
      );

Line: 127

  procedure INSERT_ROW
  (
    X_ROWID                OUT NOCOPY VARCHAR2,
    X_SESSION_ATTR_ID      OUT NOCOPY NUMBER,
    P_SESSION_ID            in NUMBER,
    P_ATTRIBUTE_TYPE        in VARCHAR2,
    P_ATTRIBUTE_NAME        in VARCHAR2,
    P_VALUE1                in VARCHAR2,
    P_VALUE2                in VARCHAR2,
    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 getNewSessionAttrIdCsr is
      select cs_kb_session_attrs_s.nextval
      from dual;

Line: 148

      select ROWID
      from CS_KB_SESSION_ATTRS
      where SESSION_ATTR_ID = X_SESSION_ATTR_ID;

Line: 158

    insert into cs_kb_session_attrs
    (
      session_attr_id,
      session_id,
      attribute_type,
      attribute_name,
      value1,
      value2,
      creation_date,
      created_by,
      last_update_date,
      last_updated_by,
      last_update_login
    )
    values
    (
      x_session_attr_id,
      p_session_id,
      p_attribute_type,
      p_attribute_name,
      p_value1,
      p_value2,
      p_creation_date,
      p_created_by,
      p_last_update_date,
      p_last_updated_by,
      p_last_update_login
    );

Line: 197

  end INSERT_ROW;

Line: 199

  procedure UPDATE_ROW
  (
    P_SESSION_ATTR_ID       in NUMBER,
    P_SESSION_ID            in NUMBER,
    P_ATTRIBUTE_TYPE        in VARCHAR2,
    P_ATTRIBUTE_NAME        in VARCHAR2,
    P_VALUE1                in VARCHAR2,
    P_VALUE2                in VARCHAR2,
    P_LAST_UPDATE_DATE      in DATE,
    P_LAST_UPDATED_BY       in NUMBER,
    P_LAST_UPDATE_LOGIN     in NUMBER
  )
  is
  begin
    update cs_kb_session_attrs
    set
      session_id          = p_session_id,
      attribute_type      = p_attribute_type,
      attribute_name      = p_attribute_name,
      value1              = p_value1,
      value2              = p_value2,
      last_update_date    = p_last_update_date,
      last_updated_by     = p_last_updated_by,
      last_update_login   = p_last_update_login
    where session_attr_id = P_SESSION_ATTR_ID;

Line: 229

  end UPDATE_ROW;

Line: 231

  procedure DELETE_ROW
  (
    P_SESSION_ATTR_ID       in NUMBER
  )
  is
  begin
    delete from cs_kb_session_attrs
    where session_attr_id = P_SESSION_ATTR_ID;

Line: 242

  end DELETE_ROW;

Line: 266

    update_row
    (
      p_session_attr_id     => p_session_attr_id,
      p_session_id          => p_session_id,
      p_attribute_type      => p_attribute_type,
      p_attribute_name      => p_attribute_name,
      p_value1              => p_value1,
      p_value2              => p_value2,
      p_last_update_date    => sysdate,
      p_last_updated_by     => l_user_id,
      p_last_update_login   => 0
    );

Line: 282

      insert_row
      (
        x_rowid               => l_rowid,
        x_session_attr_id     => l_session_attr_id,
        p_session_id          => p_session_id,
        p_attribute_type      => p_attribute_type,
        p_attribute_name      => p_attribute_name,
        p_value1              => p_value1,
        p_value2              => p_value2,
        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
      );