"APPS"."FF_USER_ENTITIES_BRD"
/*
Set up user entity details for entity being deleted for reference in
DB item deletion validation without hitting mutating table problem
*/
before delete
ON "HR"."FF_USER_ENTITIES#" for each row
Type
BEFORE 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.set_ue_details (:OLD.user_entity_id,
:OLD.business_group_id,
:OLD.legislation_code);
ffdict.pur_brd(:OLD.user_entity_id,
:OLD.business_group_id,
:OLD.legislation_code);
end if;
end ff_user_entities_brd;