APPS.BNE_USER_SETTINGS_PKG SQL Statements

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

Line: 4

procedure INSERT_ROW (
  X_ROWID in out NOCOPY VARCHAR2,
  X_USER_ID in NUMBER,
  X_SETTING_GROUP in VARCHAR2,
  X_SETTING_NAME in VARCHAR2,
  X_SETTING_VALUE in VARCHAR2,
  X_CREATION_DATE in DATE,
  X_CREATED_BY in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
  cursor C is select ROWID from BNE_USER_SETTINGS
    where USER_ID = X_USER_ID
    and SETTING_GROUP = X_SETTING_GROUP
    and SETTING_NAME = X_SETTING_NAME
    ;

Line: 22

  insert into BNE_USER_SETTINGS (
    USER_ID,
    SETTING_GROUP,
    SETTING_NAME,
    SETTING_VALUE,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    LAST_UPDATE_DATE
  ) values (
    X_USER_ID,
    X_SETTING_GROUP,
    X_SETTING_NAME,
    X_SETTING_VALUE,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_LAST_UPDATE_DATE
  );

Line: 52

end INSERT_ROW;

Line: 60

  cursor c1 is select
      SETTING_VALUE
    from BNE_USER_SETTINGS
    where USER_ID = X_USER_ID
    and SETTING_GROUP = X_SETTING_GROUP
    and SETTING_NAME = X_SETTING_NAME
    for update of USER_ID nowait;

Line: 80

procedure UPDATE_ROW (
  X_USER_ID in NUMBER,
  X_SETTING_GROUP in VARCHAR2,
  X_SETTING_NAME in VARCHAR2,
  X_SETTING_VALUE in VARCHAR2,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update BNE_USER_SETTINGS set
    SETTING_VALUE = X_SETTING_VALUE,
    LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
  where USER_ID = X_USER_ID
  and SETTING_GROUP = X_SETTING_GROUP
  and SETTING_NAME = X_SETTING_NAME;

Line: 102

end UPDATE_ROW;

Line: 104

procedure DELETE_ROW (
  X_USER_ID in NUMBER,
  X_SETTING_GROUP in VARCHAR2,
  X_SETTING_NAME in VARCHAR2
) is
begin
  delete from BNE_USER_SETTINGS
  where USER_ID = X_USER_ID
  and SETTING_GROUP = X_SETTING_GROUP
  and SETTING_NAME = X_SETTING_NAME;

Line: 119

end DELETE_ROW;

Line: 146

  x_last_update_date            in VARCHAR2,
  x_custom_mode                 in VARCHAR2
)
is
  l_user_id                     number;

Line: 153

  f_ludate                      date;    -- entity update date in file

Line: 155

  db_ludate                     date;    -- entity update date in db

Line: 158

  select user_id
  into   l_user_id
  from   fnd_user
  where user_name = x_user_name;

Line: 167

  f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);

Line: 169

    select LAST_UPDATED_BY, LAST_UPDATE_DATE
    into db_luby, db_ludate
    from BNE_USER_SETTINGS
    where USER_ID        = l_user_id
    and   SETTING_GROUP  = x_setting_group
    and   SETTING_NAME   = x_setting_name;

Line: 180

      BNE_USER_SETTINGS_PKG.Update_Row(
        X_USER_ID                      => l_user_id,
        X_SETTING_GROUP                => x_setting_group,
        X_SETTING_NAME                 => x_setting_name,
        X_SETTING_VALUE                => x_setting_value,
        X_LAST_UPDATE_DATE             => f_ludate,
        X_LAST_UPDATED_BY              => f_luby,
        X_LAST_UPDATE_LOGIN            => 0
      );

Line: 193

      BNE_USER_SETTINGS_PKG.Insert_Row(
        X_ROWID                        => l_row_id,
        X_USER_ID                      => l_user_id,
        X_SETTING_GROUP                => x_setting_group,
        X_SETTING_NAME                 => x_setting_name,
        X_SETTING_VALUE                => x_setting_value,
        X_CREATION_DATE                => f_ludate,
        X_CREATED_BY                   => f_luby,
        X_LAST_UPDATE_DATE             => f_ludate,
        X_LAST_UPDATED_BY              => f_luby,
        X_LAST_UPDATE_LOGIN            => 0
      );