APPS.INV_MATERIAL_STATUS_PUB dependencies on MTL_SERIAL_NUMBERS

Line 204: SELECT status_id INTO l_old_status_id FROM mtl_serial_numbers

200:
201: elsif p_object_type = 'S' THEN
202: --Bug 14028205 Added the select statement
203: BEGIN
204: SELECT status_id INTO l_old_status_id FROM mtl_serial_numbers
205: WHERE inventory_item_id = l_status_rec.inventory_item_id
206: and serial_number = l_status_rec.serial_number;
207: EXCEPTION
208: WHEN OTHERS THEN

Line 223: update mtl_serial_numbers

219: ,p_inventory_item_id => l_status_rec.inventory_item_id);
220:
221:
222: IF ( l_ser_fl ) then
223: update mtl_serial_numbers
224: set status_id = l_status_rec.status_id
225: , last_updated_by = l_status_rec.last_updated_by
226: , last_update_date = l_status_rec.last_update_date
227: , last_update_login = l_status_rec.last_update_login

Line 233: update mtl_serial_numbers

229: and inventory_item_id = l_status_rec.inventory_item_id
230: and serial_number = l_status_rec.serial_number;
231: if l_status_rec.to_serial_number is not null and
232: l_status_rec.serial_number <> l_status_rec.to_serial_number then
233: update mtl_serial_numbers
234: set status_id = l_status_rec.status_id
235: , last_updated_by = l_status_rec.last_updated_by
236: , last_update_date = l_status_rec.last_update_date
237: , last_update_login = l_status_rec.last_update_login