9: next_hierarchy_id NUMBER;
10: BEGIN
11: SELECT rg_dss_hierarchies_s.nextval
12: INTO next_hierarchy_id
13: FROM dual;
14:
15: RETURN (next_hierarchy_id);
16: END get_new_id;
17:
20: dummy NUMBER;
21: BEGIN
22: SELECT 1
23: INTO dummy
24: FROM dual
25: WHERE NOT EXISTS
26: (SELECT 1
27: FROM rg_dss_hierarchies
28: WHERE hierarchy_id = X_Hierarchy_Id
59: dummy NUMBER;
60: BEGIN
61: SELECT 1
62: INTO dummy
63: FROM dual
64: WHERE NOT EXISTS
65: (SELECT 1
66: FROM rg_dss_hierarchy_details
67: WHERE hierarchy_id = X_Hierarchy_Id);