TRIGGER: APPS.CN_HIERARCHY_EDGES_T1

Source

Description

cn_hierarchy_edges_t1
BEFORE INSERT ON CN_HIERARCHY_EDGES_ALL
REFERENCING	NEW as new
		OLD as old
FOR EACH ROW

Type

BEFORE EACH ROW

Event

INSERT

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         = :new.value_id
     AND dim_hierarchy_id = :new.dim_hierarchy_id;

END;