APPS.INV_MATERIAL_STATUS_PUB dependencies on MTL_LOT_NUMBERS

Line 166: SELECT status_id INTO l_old_status_id FROM mtl_lot_numbers

162:
163: elsif p_object_type = 'O' THEN
164: --Bug 14028205 Added the select statement
165: BEGIN
166: SELECT status_id INTO l_old_status_id FROM mtl_lot_numbers
167: WHERE organization_id = l_status_rec.organization_id
168: and inventory_item_id = l_status_rec.inventory_item_id
169: and lot_number = l_status_rec.lot_number;
170: EXCEPTION

Line 187: update mtl_lot_numbers

183: ,P_lot_number => l_status_rec.lot_number) ;
184:
185:
186: IF ( l_lot_fl ) then
187: update mtl_lot_numbers
188: set status_id = l_status_rec.status_id
189: , last_updated_by = l_status_rec.last_updated_by
190: , last_update_date = l_status_rec.last_update_date
191: , last_update_login = l_status_rec.last_update_login