TRIGGER: APPS.PER_ABSENCE_ATTENDANCES_OVN

Source

Description

"APPS"."PER_ABSENCE_ATTENDANCES_OVN" 
before insert or update
 ON  "HR"."PER_ABSENCE_ATTENDANCES#"  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 not per_abs_shd.return_api_dml_status then
    if inserting then
      :NEW.object_version_number := 1;
    else
      :NEW.object_version_number := :OLD.object_version_number + 1;
    end if;
  end if;
end if;
end PER_ABSENCE_ATTENDANCES_OVN;