APPS.CN_HIERARCHY_EDGES_T2 dependencies on CN_DIM_HIERARCHY_UTILITIES
Line 25: child_exist := cn_dim_hierarchy_utilities.node_exist
21: AND head.org_id = dim.org_id;
22:
23: BEGIN
24: 25: child_exist := cn_dim_hierarchy_utilities.node_exist 26: (:new.dim_hierarchy_id,
27: :new.value_id);
28:
29:
Line 58: child_exist := cn_dim_hierarchy_utilities.node_exist
54: END IF;
55:
56: IF :new.parent_value_id IS NOT NULL THEN
57: 58: child_exist := cn_dim_hierarchy_utilities.node_exist 59: (:new.dim_hierarchy_id,
60: :new.parent_value_id);
61:
62: IF ( child_exist = 'N' ) THEN