APPS.WSH_TRX_HANDLER dependencies on MTL_SERIAL_NUMBERS_INTERFACE

Line 2841: -- delete from mtl_serial_numbers_interface if there are mappings

2837:
2838: -- If column is not NULL, child table exists
2839: IF (l_trx_interface_id is NOT NULL) THEN
2840:
2841: -- delete from mtl_serial_numbers_interface if there are mappings
2842: -- of mtl_transaction_lots_interface to the two other tables
2843: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2844: 'START',
2845: 'Delete mtl_serial_numbers_interface,

Line 2845: 'Delete mtl_serial_numbers_interface,

2841: -- delete from mtl_serial_numbers_interface if there are mappings
2842: -- of mtl_transaction_lots_interface to the two other tables
2843: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2844: 'START',
2845: 'Delete mtl_serial_numbers_interface,
2846: if it is one of two child tables');
2847: wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2848: 'START',
2849: 'interface_id ' || l_trx_interface_id);

Line 2851: DELETE FROM mtl_serial_numbers_interface

2847: wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2848: 'START',
2849: 'interface_id ' || l_trx_interface_id);
2850: */
2851: DELETE FROM mtl_serial_numbers_interface
2852: WHERE transaction_interface_id IN
2853: ( SELECT serial_transaction_temp_id
2854: FROM mtl_transaction_lots_interface
2855: WHERE transaction_interface_id = l_trx_interface_id );

Line 2859: 'Finish delete mtl_serial_numbers_interface, if any');

2855: WHERE transaction_interface_id = l_trx_interface_id );
2856:
2857: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2858: 'END',
2859: 'Finish delete mtl_serial_numbers_interface, if any');
2860: */
2861: -- delete from mtl_transaction_lots_interface, if there is mapping
2862: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2863: 'START',

Line 2879: 'Delete mtl_serial_numbers_interface -- only child');

2875: IF (SQL%NOTFOUND) THEN
2876: -- there is no mapping to mtl_transaction_lots_interface
2877: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2878: 'START',
2879: 'Delete mtl_serial_numbers_interface -- only child');
2880: */
2881:
2882: DELETE FROM mtl_serial_numbers_interface
2883: WHERE transaction_interface_id = l_trx_interface_id;

Line 2882: DELETE FROM mtl_serial_numbers_interface

2878: 'START',
2879: 'Delete mtl_serial_numbers_interface -- only child');
2880: */
2881:
2882: DELETE FROM mtl_serial_numbers_interface
2883: WHERE transaction_interface_id = l_trx_interface_id;
2884: IF l_debug_on THEN
2885: WSH_DEBUG_SV.log(l_module_name,'Rows deleted',SQL%ROWCOUNT);
2886: END IF;

Line 2890: 'Finish delete mtl_serial_numbers_interface');

2886: END IF;
2887:
2888: /* wsh_server_debug.log_event('WSH_TRX_HANDLER.DELETE_ROW',
2889: 'END',
2890: 'Finish delete mtl_serial_numbers_interface');
2891: */
2892: END IF;
2893: END IF;
2894: