APPS.WSH_TRXLOTS_HANDLER dependencies on MTL_SERIAL_NUMBERS_INTERFACE

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

481: 'Start of procedure DELETE_ROW');
482:
483: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
484: 'START',
485: 'Deleting from mtl_serial_numbers_interface, if any');
486: */
487:
488: --
489: -- Debug Statements

Line 505: DELETE FROM mtl_serial_numbers_interface

501: --
502: WSH_DEBUG_SV.log(l_module_name,'X_ROWID',X_ROWID);
503: END IF;
504: --
505: DELETE FROM mtl_serial_numbers_interface
506: WHERE transaction_interface_id IN
507: ( SELECT serial_transaction_temp_id
508: FROM mtl_transaction_lots_interface
509: WHERE rowid = x_rowid);

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

509: WHERE rowid = x_rowid);
510:
511: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
512: 'END',
513: 'Finish with call to DELETE mtl_serial_numbers_interface');
514:
515: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER.DELETE_ROW',
516: 'START',
517: 'Delete from mtl_transaction_lots_interface ');