88:
89: /* get routing id sequence */
90: CURSOR Get_routing_id_seq IS
91: SELECT gem5_routing_id_s.NEXTVAL 92: FROM sys.dual; 93:
94: /* B5609637 UOM cursor to find the routing UOM class and the routing class UOM class */
95: CURSOR Cur_uom_class (p_uom_code VARCHAR2) IS
96: SELECT uom_class