DBA Data[Home] [Help]

APPS.INV_OA_GEN_PVT dependencies on MTL_ALLOCATIONS_GTMP

Line 13: INSERT INTO MTL_ALLOCATIONS_GTMP

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,

Line 20: DELETE MTL_ALLOCATIONS_GTMP;

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,

Line 23: INSERT INTO MTL_ALLOCATIONS_GTMP

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,