"APPS"."PAY_ACCRUAL_PLANS_OVN"
before insert or update
ON "HR"."PAY_ACCRUAL_PLANS#" 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 pay_pap_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 pay_accrual_plans_ovn;