APPS.CNDIHY_HIERARCHY_PKG dependencies on CN_HIERARCHY_NODES_S

Line 239: -- X_value_id := cn_hierarchy_nodes_s.nextval;

235: X_value_id := NULL;
236:
237: WHEN NO_DATA_FOUND THEN
238:
239: -- X_value_id := cn_hierarchy_nodes_s.nextval;
240:
241: SELECT cn_hierarchy_nodes_s.nextval INTO X_value_id FROM dual;
242:
243: INSERT INTO cn_hierarchy_nodes (dim_hierarchy_id, value_id, name)

Line 241: SELECT cn_hierarchy_nodes_s.nextval INTO X_value_id FROM dual;

237: WHEN NO_DATA_FOUND THEN
238:
239: -- X_value_id := cn_hierarchy_nodes_s.nextval;
240:
241: SELECT cn_hierarchy_nodes_s.nextval INTO X_value_id FROM dual;
242:
243: INSERT INTO cn_hierarchy_nodes (dim_hierarchy_id, value_id, name)
244: VALUES (X_hierarchy_id, X_value_id, 'ALL');
245:

Line 276: VALUES (cn_hierarchy_nodes_s.nextval,

272: IF Temp = 0 THEN
273:
274: INSERT INTO cn_hierarchy_nodes (value_id, external_id, name,
275: dim_hierarchy_id)
276: VALUES (cn_hierarchy_nodes_s.nextval,
277: X_value_id,
278: X_name,
279: X_dim_hierarchy_id);
280:

Line 281: -- X_value_id := cn_hierarchy_nodes_s.currval;

277: X_value_id,
278: X_name,
279: X_dim_hierarchy_id);
280:
281: -- X_value_id := cn_hierarchy_nodes_s.currval;
282:
283: SELECT cn_hierarchy_nodes_s.currval INTO X_value_id FROM dual;
284:
285: END IF;

Line 283: SELECT cn_hierarchy_nodes_s.currval INTO X_value_id FROM dual;

279: X_dim_hierarchy_id);
280:
281: -- X_value_id := cn_hierarchy_nodes_s.currval;
282:
283: SELECT cn_hierarchy_nodes_s.currval INTO X_value_id FROM dual;
284:
285: END IF;
286:
287: END Synchronize_Node;

Line 499: SELECT cn_hierarchy_nodes_s.nextval

495: X_name varchar2,
496: X_dim_hierarchy_id number) IS
497: BEGIN
498:
499: SELECT cn_hierarchy_nodes_s.nextval
500: INTO X_value_id
501: FROM dual;
502:
503: INSERT INTO cn_hierarchy_nodes