ff_route_parameters_brud
/*
FF_ROUTE_PARAMETERS Before Row Update/Delete
Make sure changing a route parameter doesn't invalidate any compiled
formulae
*/
before update or delete
on ff_route_parameters
for each row
Type
BEFORE EACH ROW
Event
UPDATE OR DELETE
Column
When
Referencing
REFERENCING NEW AS NEW OLD AS OLD
Body
begin
if hr_general.g_data_migrator_mode <> 'Y' then
ffdict.validate_rcu(:OLD.route_id);
end if;
end ff_route_parameters_brud;