APPS.CNDIHY_HIERARCHY_PKG dependencies on DUAL

Line 26: INTO X_hierarchy_id FROM dual;

22:
23: -- X_Hierarchy_ID := cn_head_hierarchies_s.nextval;
24:
25: SELECT cn_head_hierarchies_s.nextval
26: INTO X_hierarchy_id FROM dual;
27:
28: END IF;
29:
30: END Default_Row;

Line 54: INTO X_hierarchy_id FROM dual;

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:
58: END Default_Period_Row;

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 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 455: FROM dual

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
457: WHERE value_id = X_value_id
458: AND dim_hierarchy_id =
459: X_dim_hierarchy_id));

Line 501: FROM dual;

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
504: (dim_hierarchy_id, name, value_id)
505: VALUES (X_dim_hierarchy_id, X_name, X_value_id);