9: ) is
10: begin
11: /*-- Bulk insert the lot and serial records records
12: FORALL i IN 1 .. p_assembly_lot_serial_tbl.COUNT
13: INSERT INTO MTL_ALLOCATIONS_GTMP
14: (Lot_number,
15: serial_number)
16: VALUES
17: (p_assembly_lot_serial_tbl(i).lot_number,
16: VALUES
17: (p_assembly_lot_serial_tbl(i).lot_number,
18: p_assembly_lot_serial_tbl(i).serial_number); */
19:
20: DELETE MTL_ALLOCATIONS_GTMP;
21:
22: FOR i IN 1 .. p_assembly_lot_serial_tbl.COUNT LOOP
23: INSERT INTO MTL_ALLOCATIONS_GTMP
24: (Lot_number,
19:
20: DELETE MTL_ALLOCATIONS_GTMP;
21:
22: FOR i IN 1 .. p_assembly_lot_serial_tbl.COUNT LOOP
23: INSERT INTO MTL_ALLOCATIONS_GTMP
24: (Lot_number,
25: serial_number)
26: VALUES
27: (p_assembly_lot_serial_tbl(i).lot_number,