TRIGGER: APPS.CN_HIERARCHY_EDGES_T3

Source

Description

cn_hierarchy_edges_t3
BEFORE DELETE ON CN_HIERARCHY_EDGES_ALL
REFERENCING	NEW as new
		OLD as old
FOR EACH ROW

Type

BEFORE EACH ROW

Event

DELETE

Column

When

Referencing

REFERENCING NEW AS NEW OLD AS OLD

Body

BEGIN

  UPDATE cn_hierarchy_nodes
     SET ref_count        = nvl(ref_count, 0) - 1
   WHERE value_id         = :old.value_id
     AND dim_hierarchy_id = :old.dim_hierarchy_id;

END;