APPS.OE_DS_PVT dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 812: MTL_TRANSACTION_LOTS_INTERFACE: For every receipt in lot

808: it will be called for every lot.
809:
810: This API will insert records into
811:
812: MTL_TRANSACTION_LOTS_INTERFACE: For every receipt in lot
813: (lot controlled items).
814: MTL_SERIAL_NUMBERS_INTERFACE : For every serial number
815: receipt (serial controlled
816: items.)

Line 979: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE

975:
976: IF l_debug_level > 0 THEN
977: oe_debug_pub.add( 'Inserting lots' ) ;
978: END IF;
979: INSERT INTO MTL_TRANSACTION_LOTS_INTERFACE
980: (
981: SOURCE_CODE,
982: SOURCE_LINE_ID,
983: TRANSACTION_INTERFACE_ID,

Line 1241: UPDATE MTL_TRANSACTION_LOTS_INTERFACE

1237: END IF;
1238:
1239: BEGIN
1240:
1241: UPDATE MTL_TRANSACTION_LOTS_INTERFACE
1242: SET SERIAL_TRANSACTION_TEMP_ID = l_serial_set_id
1243: WHERE TRANSACTION_INTERFACE_ID = l_lot_set_id;
1244:
1245: EXCEPTION