1224: -----------------------------------------------------------------------------
1225: FUNCTION get_transaction_id RETURN NUMBER IS
1226: v_transaction_id NUMBER;
1227: BEGIN
1228: select msc_net_resource_avail_s.nextval
1229: into v_transaction_id
1230: from dual;
1231:
1232: return v_transaction_id;
1551: -- we will insert one for each bucket, even the resource_units is 0
1552:
1553: -- if nvl(v_new_capacity_units,0) <>0 then
1554:
1555: select msc_net_resource_avail_s.nextval
1556: into v_transaction_id
1557: from dual;
1558:
1559: -- insert parent record