Line 1220: select msc_net_resource_avail_s.nextval into r3.parent_id from dual;
1216: and parent_id = -1;
1217:
1218: exception
1219: when no_data_found then 1220: select msc_net_resource_avail_s.nextval into r3.parent_id from dual; 1221:
1222: insert into msc_net_resource_avail (
1223: plan_id,
1224: transaction_id,
Line 1253: select msc_net_resource_avail_s.nextval into r3.transaction_id from dual;
1249: end;
1250: end if;
1251:
1252: if (r3.transaction_id = -1) then 1253: select msc_net_resource_avail_s.nextval into r3.transaction_id from dual; 1254:
1255: insert into msc_net_resource_avail (
1256: plan_id,
1257: transaction_id,