TRIGGER: APPS.FF_ARCHIVE_ITEMS_BRU

Source

Description

FF_ARCHIVE_ITEMS_BRU
before insert or update on FF_ARCHIVE_ITEMS for each row

Type

BEFORE EACH ROW

Event

INSERT OR UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

begin
 if hr_general.g_data_migrator_mode <> 'Y' then
  if inserting then
    :NEW.object_version_number := 1;
  else
    :NEW.object_version_number := :OLD.object_version_number + 1;
  end if;
 end if;
end FF_ARCHIVE_ITEMS_BRU;