APPS.BNE_PERF_SET_ITEMS_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_SET_CODE in VARCHAR2,
  X_STATISTIC_CODE in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  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_PERF_SET_ITEMS
    where SET_CODE = X_SET_CODE
    and STATISTIC_CODE = X_STATISTIC_CODE
    ;

Line: 20

  insert into BNE_PERF_SET_ITEMS (
    SET_CODE,
    STATISTIC_CODE,
    OBJECT_VERSION_NUMBER,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    LAST_UPDATE_DATE
  ) values (
    X_SET_CODE,
    X_STATISTIC_CODE,
    X_OBJECT_VERSION_NUMBER,
    X_CREATED_BY,
    X_CREATION_DATE,
    X_LAST_UPDATED_BY,
    X_LAST_UPDATE_LOGIN,
    X_LAST_UPDATE_DATE
  );

Line: 48

end INSERT_ROW;

Line: 55

  cursor c1 is select
      OBJECT_VERSION_NUMBER
    from BNE_PERF_SET_ITEMS
    where SET_CODE = X_SET_CODE
    and STATISTIC_CODE = X_STATISTIC_CODE
    for update of SET_CODE nowait;

Line: 74

procedure UPDATE_ROW (
  X_SET_CODE in VARCHAR2,
  X_STATISTIC_CODE in VARCHAR2,
  X_OBJECT_VERSION_NUMBER in NUMBER,
  X_LAST_UPDATE_DATE in DATE,
  X_LAST_UPDATED_BY in NUMBER,
  X_LAST_UPDATE_LOGIN in NUMBER
) is
begin
  update BNE_PERF_SET_ITEMS set
    OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,
    LAST_UPDATE_DATE      = X_LAST_UPDATE_DATE,
    LAST_UPDATED_BY       = X_LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN     = X_LAST_UPDATE_LOGIN
  where SET_CODE     = X_SET_CODE
  and STATISTIC_CODE = X_STATISTIC_CODE
  ;

Line: 95

end UPDATE_ROW;

Line: 97

procedure DELETE_ROW (
  X_SET_CODE in VARCHAR2,
  X_STATISTIC_CODE in VARCHAR2
) is
begin
  delete from BNE_PERF_SET_ITEMS
  where SET_CODE = X_SET_CODE
  and STATISTIC_CODE = X_STATISTIC_CODE;

Line: 110

end DELETE_ROW;

Line: 136

  x_last_update_date            in VARCHAR2,
  x_custom_mode                 in VARCHAR2
)
is
  l_row_id            varchar2(64);

Line: 142

  f_ludate            date;    -- entity update date in file

Line: 144

  db_ludate           date;    -- entity update date in db

Line: 150

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

Line: 152

    select LAST_UPDATED_BY, LAST_UPDATE_DATE
    into db_luby, db_ludate
    from BNE_PERF_SET_ITEMS
    where SET_CODE        = x_set_code
    and   STATISTIC_CODE  = x_statistic_code
    ;

Line: 163

      BNE_PERF_SET_ITEMS_PKG.Update_Row(
        X_SET_CODE                 => x_set_code,
        X_STATISTIC_CODE           => x_statistic_code,
        X_OBJECT_VERSION_NUMBER    => x_object_version_number,
        X_LAST_UPDATE_DATE         => f_ludate,
        X_LAST_UPDATED_BY          => f_luby,
        X_LAST_UPDATE_LOGIN        => 0
      );

Line: 175

      BNE_PERF_SET_ITEMS_PKG.Insert_Row(
        X_ROWID                    => l_row_id,
        X_SET_CODE                 => x_set_code,
        X_STATISTIC_CODE           => x_statistic_code,
        X_OBJECT_VERSION_NUMBER    => x_object_version_number,
        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
      );