APPS.CN_DIHY_TWO_API_PKG dependencies on CN_HIERARCHY_EDGES

Line 59: INSERT INTO cn_hierarchy_edges

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,

Line 82: DELETE cn_hierarchy_edges

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

Line 92: DELETE cn_hierarchy_edges

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

Line 158: FROM cn_hierarchy_edges

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);

Line 174: DELETE cn_hierarchy_edges WHERE value_id = X_value_id

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

Line 180: DELETE cn_hierarchy_edges WHERE value_id = X_value_id

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;