APPS.OE_DS_PVT dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 837: MTL_TRANSACTION_LOTS_INTERFACE: For every receipt in lot

833: it will be called for every lot.
834:
835: This API will insert records into
836:
837: MTL_TRANSACTION_LOTS_INTERFACE: For every receipt in lot
838: (lot controlled items).
839: MTL_SERIAL_NUMBERS_INTERFACE : For every serial number
840: receipt (serial controlled
841: items.)

Line 1004: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE

1000:
1001: IF l_debug_level > 0 THEN
1002: oe_debug_pub.add( 'Inserting lots' ) ;
1003: END IF;
1004: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE
1005: (
1006: SOURCE_CODE,
1007: SOURCE_LINE_ID,
1008: TRANSACTION_INTERFACE_ID,

Line 1266: UPDATE MTL_TRANSACTION_LOTS_INTERFACE

1262: END IF;
1263:
1264: BEGIN
1265:
1266: UPDATE MTL_TRANSACTION_LOTS_INTERFACE
1267: SET SERIAL_TRANSACTION_TEMP_ID = l_serial_set_id
1268: WHERE TRANSACTION_INTERFACE_ID = l_lot_set_id;
1269:
1270: EXCEPTION