Line 2049: SELECT fte_lanes_s.NEXTVAL INTO l_lane_id FROM DUAL;
2045: -- For each carrier, create a lane and its associated entities
2046: --+
2047: FOR k IN 1..p_carrier_ids.COUNT LOOP
2048: 2049: SELECT fte_lanes_s.NEXTVAL INTO l_lane_id FROM DUAL; 2050:
2051: -- FTE_LANE_COMMODITIES
2052: FOR m IN 1..p_category_ids.COUNT LOOP
2053: CM_LANE_ID(cm_lane_id.COUNT+1) := l_lane_id;