TRIGGER: APPS.PAY_DEFINED_BALANCES_BRU

Source

Description

pay_defined_balances_bru
   before update
   on     pay_defined_balances
   for    each row

Type

BEFORE EACH ROW

Event

UPDATE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

begin
if hr_general.g_data_migrator_mode <> 'Y' then
--
-- do not allow the SAVE_RUN_BALANCE flag to be altered from 'Y' to 'N' or null
-- if valid run_balances exist for the defined_balance.
--
  pay_defined_balances_pkg.verify_save_run_bal_flag_upd
                          (p_defined_balance_id     => :OLD.defined_balance_id
                          ,p_old_save_run_bal_flag  => :OLD.save_run_balance
                          ,p_new_save_run_bal_flag  => :NEW.save_run_balance);
  --
end if;
end pay_defined_balances_bru;