APPS.WSH_TRXLOTS_HANDLER dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 599: 'Deleting from mtl_serial_numbers_interface, if any');

595: 'Start of procedure DELETE_ROW');
596:
597: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
598: 'START',
599: 'Deleting from mtl_serial_numbers_interface, if any');
600: */
601:
602: --
603: -- Debug Statements

Line 619: DELETE FROM mtl_serial_numbers_interface

615: --
616: WSH_DEBUG_SV.log(l_module_name,'X_ROWID',X_ROWID);
617: END IF;
618: --
619: DELETE FROM mtl_serial_numbers_interface
620: WHERE transaction_interface_id IN
621: ( SELECT serial_transaction_temp_id
622: FROM mtl_transaction_lots_interface
623: WHERE rowid = x_rowid);

Line 627: 'Finish with call to DELETE mtl_serial_numbers_interface');

623: WHERE rowid = x_rowid);
624:
625: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
626: 'END',
627: 'Finish with call to DELETE mtl_serial_numbers_interface');
628:
629: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
630: 'START',
631: 'Delete from mtl_transaction_lots_interface ');