APPS.CNDIHY_HIERARCHY_PKG dependencies on CN_DIM_HIERARCHIES

Line 45: -- cn_dim_hierarchies with an arbitrarily generated sequence.

41: BEGIN
42:
43: --
44: -- This procedure is used to fill in the Dim_Hierarchy_ID in
45: -- cn_dim_hierarchies with an arbitrarily generated sequence.
46: -- This maintains the uniqueness of primary keys.
47: --
48:
49: IF X_hierarchy_id IS NULL THEN

Line 51: -- X_Hierarchy_ID := cn_dim_hierarchies_s.nextval;

47: --
48:
49: IF X_hierarchy_id IS NULL THEN
50:
51: -- X_Hierarchy_ID := cn_dim_hierarchies_s.nextval;
52:
53: SELECT cn_dim_hierarchies_s.nextval
54: INTO X_hierarchy_id FROM dual;
55:

Line 53: SELECT cn_dim_hierarchies_s.nextval

49: IF X_hierarchy_id IS NULL THEN
50:
51: -- X_Hierarchy_ID := cn_dim_hierarchies_s.nextval;
52:
53: SELECT cn_dim_hierarchies_s.nextval
54: INTO X_hierarchy_id FROM dual;
55:
56: END IF;
57:

Line 75: -- the cn_dim_hierarchies table.

71: BEGIN
72:
73: --
74: -- This matches Period names to the period IDs that are stored in
75: -- the cn_dim_hierarchies table.
76: --
77:
78: IF X_start_period IS NOT NULL THEN
79: SELECT period_name

Line 219: FROM cn_dim_hierarchies

215: --
216:
217: SELECT root_node
218: INTO X_value_id
219: FROM cn_dim_hierarchies
220: WHERE dim_hierarchy_id = X_hierarchy_id;
221:
222: IF X_value_id IS NULL THEN
223: