TRIGGER: APPS.FF_DATABASE_ITEMS_BRI

Source

Description

ff_database_items_bri
/*
  FF_DATABASE_ITEMS Before Row Insert
  Checks that new items have legal names
*/
before insert
on ff_database_items
for each row

Type

BEFORE EACH ROW

Event

INSERT

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

declare
  new_user_name ff_database_items.user_name%TYPE;
begin
if hr_general.g_data_migrator_mode <> 'Y' and
   ff_database_items_pkg.g_disable_triggers <> 'Y' then
  -- bug 153833 workaround. Remove in 7.0.14
  new_user_name := :NEW.user_name;
  ffdict.validate_dbitem (new_user_name, :NEW.user_entity_id);
end if;
end ff_database_items_bri;