TRIGGER: APPS.FF_CONTEXTS_BRU

Source

Description

ff_contexts_bru
/*
  The FF_CONTEXTS table cannot be updated due to the horrendous validation
  required. Must do a delete and then re-insert
*/
before update
on ff_contexts
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
  hr_utility.set_message (802,'FF73_CANNOT_UPDATE_DETAILS');
  hr_utility.set_message_token(802,'1','FF92_CONTEXT');
  hr_utility.raise_error;
end if;
end ff_contexts_bru;