TRIGGER: APPS.FF_FTYPE_CONTEXT_USAGES_BRD

Source

Description

ff_ftype_context_usages_brd
/*
  FF_FTYPE_CONTEXT_USAGES Before Row Delete
  Make sure deleting a context usage doesn't invalidate any compiled
  formulae
*/
before delete
on ff_ftype_context_usages
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.delete_ftcu_check(:OLD.FORMULA_TYPE_ID, :OLD.CONTEXT_ID);
end if;
end ff_ftype_context_usages_brd;