The following lines contain the word 'select', 'insert', 'update' or 'delete':
/*-- Bulk insert the lot and serial records records
FORALL i IN 1 .. p_assembly_lot_serial_tbl.COUNT
INSERT INTO MTL_ALLOCATIONS_GTMP
(Lot_number,
serial_number)
VALUES
(p_assembly_lot_serial_tbl(i).lot_number,
p_assembly_lot_serial_tbl(i).serial_number); */
DELETE MTL_ALLOCATIONS_GTMP;
INSERT INTO MTL_ALLOCATIONS_GTMP
(Lot_number,
serial_number)
VALUES
(p_assembly_lot_serial_tbl(i).lot_number,
p_assembly_lot_serial_tbl(i).serial_number);