APPS.CN_DIHY_TWO_API_PKG dependencies on CN_HIERARCHY_NODES

Line 25: FROM cn_hierarchy_nodes

21: IF (X_value_id IS NULL) OR (X_value_id = -1) THEN
22:
23: SELECT count(*)
24: INTO Dummy
25: FROM cn_hierarchy_nodes
26: WHERE external_id = X_external_id
27: AND dim_hierarchy_id = X_dim_hierarchy_id;
28:
29: IF (Dummy = 0) THEN

Line 31: SELECT cn_hierarchy_nodes_s.nextval INTO X_value_id

27: AND dim_hierarchy_id = X_dim_hierarchy_id;
28:
29: IF (Dummy = 0) THEN
30:
31: SELECT cn_hierarchy_nodes_s.nextval INTO X_value_id
32: FROM dual;
33:
34: INSERT INTO cn_hierarchy_nodes
35: (value_id, name, dim_hierarchy_id, external_id,

Line 34: INSERT INTO cn_hierarchy_nodes

30:
31: SELECT cn_hierarchy_nodes_s.nextval INTO X_value_id
32: FROM dual;
33:
34: INSERT INTO cn_hierarchy_nodes
35: (value_id, name, dim_hierarchy_id, external_id,
36: CREATED_BY, CREATION_DATE,
37: LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN,ORG_ID)
38: VALUES

Line 47: FROM cn_hierarchy_nodes

43: ELSE
44:
45: SELECT value_id
46: INTO X_value_id
47: FROM cn_hierarchy_nodes
48: WHERE dim_hierarchy_id = X_dim_hierarchy_id
49: AND external_id = X_external_id;
50:
51: UPDATE cn_hierarchy_nodes

Line 51: UPDATE cn_hierarchy_nodes

47: FROM cn_hierarchy_nodes
48: WHERE dim_hierarchy_id = X_dim_hierarchy_id
49: AND external_id = X_external_id;
50:
51: UPDATE cn_hierarchy_nodes
52: SET name = x_name
53: WHERE value_id = x_value_id;
54:
55: END IF;

Line 186: SELECT ref_count INTO X_refcount FROM cn_hierarchy_nodes

182: AND dim_hierarchy_id = X_dim_hierarchy_id;
183:
184: END IF;
185:
186: SELECT ref_count INTO X_refcount FROM cn_hierarchy_nodes
187: WHERE value_id = X_value_id
188: AND dim_hierarchy_id = X_dim_hierarchy_id;
189:
190: IF X_refcount = 0 THEN

Line 205: /* delete cn_hierarchy_nodes WHERE value_id = X_value_id

201: END LOOP;
202:
203: END IF;
204:
205: /* delete cn_hierarchy_nodes WHERE value_id = X_value_id
206: AND dim_hierarchy_id = X_dim_hierarchy_id;*/
207:
208: END Cascade_Delete;
209: