TRIGGER: APPS.FF_GLOBALS_F_BRU

Source

Description

ff_globals_f_bru
/*
  FF_GLOBALS_F Before Row Update
  Only allow global to be updated if not used in a verified formula
*/
before update
on ff_globals_f
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
  -- disallow update of any significant column (which would require change
  -- to third party records in FF dictionary)
  if :OLD.global_name <> :NEW.global_name or
     :OLD.data_type <> :NEW.data_type or
     :OLD.global_id <> :NEW.global_id
  then
    hr_utility.set_message(802,'FF73_CANNOT_UPDATE_DETAILS');
    hr_utility.set_message_token('1',:OLD.global_name);
    hr_utility.set_message_token(802,'2','FF90_GLOBAL_NAME');
    hr_utility.raise_error;
  end if;
end if;
end ff_globals_f_bru;