TRIGGER: APPS.PAY_LEGISLATION_RULES_INSERT

Source

Description

pay_legislation_rules_insert
BEFORE insert or update of rule_type
ON PAY_LEGISLATION_RULES
FOR EACH ROW

Type

BEFORE EACH ROW

Event

INSERT OR UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

DECLARE
 invalid_leg_rule EXCEPTION;
BEGIN
if hr_general.g_data_migrator_mode <> 'Y' then
if (pay_legislation_rules_pkg.check_leg_rule(:new.rule_type)=false)
then
 raise invalid_leg_rule;
end if;
end if;

END;