Line 860: SELECT gem5_lot_id_s.nextval INTO x_ic_lots_mst_row.lot_id FROM dual;
856: x_ic_lots_mst_row := p_ic_lots_mst_row;
857:
858: IF x_ic_lots_mst_row.lot_id IS NULL
859: THEN 860: SELECT gem5_lot_id_s.nextval INTO x_ic_lots_mst_row.lot_id FROM dual; 861: END IF;
862:
863: INSERT INTO ic_lots_mst
864: ( item_id