APPS.CNDIHY_HIERARCHY_PKG dependencies on CN_HIERARCHY_EDGES

Line 226: FROM cn_hierarchy_edges

222: IF X_value_id IS NULL THEN
223:
224: SELECT value_id
225: INTO X_value_id
226: FROM cn_hierarchy_edges
227: WHERE dim_hierarchy_id = X_hierarchy_id
228: AND parent_value_id is NULL;
229:
230: END IF;

Line 246: INSERT INTO cn_hierarchy_edges (dim_hierarchy_id, value_id)

242:
243: INSERT INTO cn_hierarchy_nodes (dim_hierarchy_id, value_id, name)
244: VALUES (X_hierarchy_id, X_value_id, 'ALL');
245:
246: INSERT INTO cn_hierarchy_edges (dim_hierarchy_id, value_id)
247: VALUES (X_hierarchy_id, X_value_id);
248:
249: END Root_Node;
250:

Line 368: FROM cn_hierarchy_edges

364: X_parent_value_id number,
365: X_dim_hierarchy_id number) IS
366:
367: Cursor Children IS SELECT *
368: FROM cn_hierarchy_edges
369: WHERE parent_value_id = X_value_id
370: AND dim_hierarchy_id = X_dim_hierarchy_id;
371:
372: X_refcount number(15);

Line 384: DELETE cn_hierarchy_edges WHERE value_id = X_value_id

380: --
381:
382: IF X_parent_value_id IS NULL THEN
383:
384: DELETE cn_hierarchy_edges WHERE value_id = X_value_id
385: AND parent_value_id IS NULL
386: AND dim_hierarchy_id = X_dim_hierarchy_id;
387:
388: ELSE

Line 390: DELETE cn_hierarchy_edges WHERE value_id = X_value_id

386: AND dim_hierarchy_id = X_dim_hierarchy_id;
387:
388: ELSE
389:
390: DELETE cn_hierarchy_edges WHERE value_id = X_value_id
391: AND parent_value_id = X_parent_value_id
392: AND dim_hierarchy_id = X_dim_hierarchy_id;
393:
394: END IF;

Line 430: DELETE cn_hierarchy_edges WHERE

426: -- to delete any edges to NULL (which would be made obsolete by the
427: -- occurence of an active edge).
428: --
429:
430: DELETE cn_hierarchy_edges WHERE
431: parent_value_id IS NULL
432: AND value_id = X_value_id
433: AND dim_hierarchy_id = X_dim_hierarchy_id;
434:

Line 435: INSERT INTO cn_hierarchy_edges (value_id, parent_value_id,

431: parent_value_id IS NULL
432: AND value_id = X_value_id
433: AND dim_hierarchy_id = X_dim_hierarchy_id;
434:
435: INSERT INTO cn_hierarchy_edges (value_id, parent_value_id,
436: dim_hierarchy_id)
437: VALUES (X_value_id, X_parent_Value_id,
438: X_dim_hierarchy_id);
439:

Line 452: INSERT INTO cn_hierarchy_edges (value_id, parent_value_id,

448: PROCEDURE Insert_Root(X_value_id number,
449: X_dim_hierarchy_id number) IS
450: BEGIN
451:
452: INSERT INTO cn_hierarchy_edges (value_id, parent_value_id,
453: dim_hierarchy_id)
454: (SELECT X_value_id, NULL, X_dim_hierarchy_id
455: FROM dual
456: WHERE NOT EXISTS (SELECT * FROM cn_hierarchy_edges

Line 456: WHERE NOT EXISTS (SELECT * FROM cn_hierarchy_edges

452: INSERT INTO cn_hierarchy_edges (value_id, parent_value_id,
453: dim_hierarchy_id)
454: (SELECT X_value_id, NULL, X_dim_hierarchy_id
455: FROM dual
456: WHERE NOT EXISTS (SELECT * FROM cn_hierarchy_edges
457: WHERE value_id = X_value_id
458: AND dim_hierarchy_id =
459: X_dim_hierarchy_id));
460:

Line 477: FROM cn_hierarchy_edges

473: X_child_rows IN OUT number) IS
474: BEGIN
475:
476: SELECT count(*) INTO X_parent_rows
477: FROM cn_hierarchy_edges
478: WHERE parent_value_id = X_parent_value_id
479: AND dim_hierarchy_id = X_dim_hierarchy_id;
480:
481: SELECT count(*) INTO X_child_rows

Line 482: FROM cn_hierarchy_edges

478: WHERE parent_value_id = X_parent_value_id
479: AND dim_hierarchy_id = X_dim_hierarchy_id;
480:
481: SELECT count(*) INTO X_child_rows
482: FROM cn_hierarchy_edges
483: WHERE parent_value_id = X_value_id
484: AND dim_hierarchy_id = X_dim_hierarchy_id;
485:
486: END Fetch_Row_counts;