TRIGGER: APPS.SSP_MEDICALS_OVN

Source

Description

ssp_medicals_ovn
BEFORE INSERT OR UPDATE
ON SSP_MEDICALS
FOR EACH ROW

Type

BEFORE EACH ROW

Event

INSERT OR UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

DECLARE
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;