TRIGGER: APPS.HR_ALL_ORGANIZATION_UNITS_OVN

Source

Description

HR_ALL_ORGANIZATION_UNITS_OVN
BEFORE INSERT OR UPDATE ON HR_ALL_ORGANIZATION_UNITS
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 hr_oru_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 HR_ALL_ORGANIZATION_UNITS_OVN;