55: END IF;
56:
57: END IF;
58:
59: INSERT INTO cn_hierarchy_edges
60: (dim_hierarchy_id,
61: value_id,
62: parent_value_id,
63: hierarchy_api_id,
78: fnd_global.user_id,X_org_id);
79:
80: IF (X_parent_value_id IS NOT NULL) THEN
81:
82: DELETE cn_hierarchy_edges
83: WHERE dim_hierarchy_id = X_dim_hierarchy_id
84: AND value_id = X_value_id
85: AND parent_value_id IS NULL
86: --R12 MOAC Changes--Start
88: --R12 MOAC Changes--End
89:
90: ELSE
91:
92: DELETE cn_hierarchy_edges
93: WHERE dim_hierarchy_id = X_dim_hierarchy_id
94: AND value_id = X_value_id
95: AND parent_value_id IS NOT NULL
96: --R12 MOAC Changes--Start
154: X_org_id NUMBER) IS
155: --R12 MOAC Changes--End
156:
157: Cursor Children IS SELECT *
158: FROM cn_hierarchy_edges
159: WHERE parent_value_id = X_value_id
160: AND dim_hierarchy_id = X_dim_hierarchy_id;
161:
162: X_refcount number(15);
170: --+
171:
172: IF X_parent_value_id IS NULL THEN
173:
174: DELETE cn_hierarchy_edges WHERE value_id = X_value_id
175: AND parent_value_id IS NULL
176: AND dim_hierarchy_id = X_dim_hierarchy_id;
177:
178: ELSE
176: AND dim_hierarchy_id = X_dim_hierarchy_id;
177:
178: ELSE
179:
180: DELETE cn_hierarchy_edges WHERE value_id = X_value_id
181: AND parent_value_id = X_parent_value_id
182: AND dim_hierarchy_id = X_dim_hierarchy_id;
183:
184: END IF;