40: IF ( :new.parent_value_id IS NOT NULL ) THEN
41:
42: cn_debug.print_msg('after update: parent not null', 1);
43:
44: child_exist := cn_dim_hierarchy_utilities.node_exist
45: (:new.dim_hierarchy_id,
46: :new.value_id);
47:
48:
69: END IF;
70:
71: IF :new.parent_value_id IS NOT NULL THEN
72:
73: child_exist := cn_dim_hierarchy_utilities.node_exist
74: (:new.dim_hierarchy_id,
75: :new.parent_value_id);
76:
77: IF ( child_exist = 'N' ) THEN