APPS.CN_DIM_HIERARCHIES_PKG dependencies on CN_HIERARCHY_NODES

Line 25: SELECT cn_hierarchy_nodes_s.nextval

21: SELECT cn_dim_hierarchies_s.nextval
22: INTO x_dim_hierarchy_id
23: FROM dual;
24:
25: SELECT cn_hierarchy_nodes_s.nextval
26: INTO x_root_node
27: FROM dual;
28:
29:

Line 60: INSERT INTO cn_hierarchy_nodes

56: fnd_global.user_id,
57: 1);
58:
59: -- create new root node
60: INSERT INTO cn_hierarchy_nodes
61: (dim_hierarchy_id, org_id,value_id, name,
62: created_by, creation_date,
63: last_updated_by, last_update_date, last_update_login)
64: VALUES

Line 138: delete from cn_hierarchy_nodes e where

134: raise fnd_api.g_exc_error;
135: end if;
136:
137: -- remove dangling edges and nodes
138: delete from cn_hierarchy_nodes e where
139: dim_hierarchy_id = x_dim_hierarchy_id;
140: delete from cn_hierarchy_edges e where
141: dim_hierarchy_id = x_dim_hierarchy_id;
142: