Line 154: select msd_dp_scenarios_s.nextval into l_scenario_id from dual;
150: end if;
151: exception
152: when no_data_found then
153: 154: select msd_dp_scenarios_s.nextval into l_scenario_id from dual; 155:
156: -- Record doesn't exist - insert in all cases
157: insert into msd_dp_scenarios
158: (DEMAND_PLAN_ID