TRIGGER: APPS.PAY_SECURITY_PAYROLLS_OVN

Source

Description

pay_security_payrolls_ovn
before insert or update on pay_security_payrolls for each row

Type

BEFORE EACH ROW

Event

INSERT OR UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

begin
  if not
   pay_spr_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 pay_security_payrolls_ovn;