DBA Data[Home] [Help]

TRIGGER: APPS.FF_DATABASE_ITEMS_BRU

Source

Description
ff_database_items_bru
/*
  Only allow DB item to be updated if not used in a verified formula
*/
before update
on ff_database_items
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' and
   ff_database_items_pkg.g_disable_triggers <> 'Y' then
  ffdict.delete_dbitem_check (:OLD.user_name, :OLD.user_entity_id);
end if;
end ff_database_items_bru;