DBA Data[Home] [Help]

TRIGGER: APPS.PAY_GB_EPS_OVN

Source

Description
PAY_GB_EPS_OVN
BEFORE INSERT OR UPDATE
ON "HR"."PAY_GB_EPS_DETAILS#"
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 inserting then
    :new.object_version_number := 1;
  else
    :new.object_version_number := :old.object_version_number +1;
  end if;
END;