TRIGGER: APPS.HR_ORGANIZATION_INFORMATIO_OVN

Source

Description

HR_ORGANIZATION_INFORMATIO_OVN
BEFORE INSERT OR UPDATE ON HR_ORGANIZATION_INFORMATION
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_ori_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_ORGANIZATION_INFORMATIO_OVN;