DBA Data[Home] [Help]

APPS.WSH_TRXLOTS_HANDLER_TEST dependencies on MTL_SERIAL_NUMBERS_INTERFACE

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

367: 'Start of procedure DELETE_ROW');
368:
369: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
370: 'START',
371: 'Deleting from mtl_serial_numbers_interface, if any');
372: */
373:
374: --
375: -- Debug Statements

Line 391: DELETE FROM mtl_serial_numbers_interface

387: --
388: WSH_DEBUG_SV.log(l_module_name,'X_ROWID',X_ROWID);
389: END IF;
390: --
391: DELETE FROM mtl_serial_numbers_interface
392: WHERE transaction_interface_id IN
393: ( SELECT serial_transaction_temp_id
394: FROM mtl_transaction_lots_interface
395: WHERE rowid = x_rowid);

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

395: WHERE rowid = x_rowid);
396:
397: /* wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
398: 'END',
399: 'Finish with call to DELETE mtl_serial_numbers_interface');
400:
401: wsh_server_debug.log_event('WSH_TRXLOTS_HANDLER_TEST.DELETE_ROW',
402: 'START',
403: 'Delete from mtl_transaction_lots_interface ');