27:
28: /*
29: ** Get sequence value for demand_id and parent_demand_id
30: */ 31: select mtl_demand_s.nextval 32: into l_demand_id_dmd
33: from dual;
34:
35: select mtl_demand_s.nextval
Line 35: select mtl_demand_s.nextval
31: select mtl_demand_s.nextval
32: into l_demand_id_dmd
33: from dual;
34: 35: select mtl_demand_s.nextval 36: into l_demand_id_rsv
37: from dual;
38:
39: select demand_source_type_id