TRIGGER: APPS.CN_HIERARCHY_EDGES_T3

Source

Description

"APPS"."CN_HIERARCHY_EDGES_T3" 
BEFORE DELETE
 ON  "CN"."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;