TRIGGER: APPS.FF_USER_ENTITIES_ARD

Source

Description

ff_user_entities_ard
/*
  Clear user entity details for entity deleted
*/
after delete
on ff_user_entities
for each row

Type

AFTER EACH ROW

Event

DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

begin
if hr_general.g_data_migrator_mode <> 'Y' then
  ffdict.clear_ue_details;
  delete from ff_database_items_tl
  where user_entity_id = :OLD.user_entity_id
  ;
end if;
end ff_user_entities_ard;